1
0
mirror of https://github.com/delight-im/PHP-Auth.git synced 2025-07-10 02:56:22 +02:00

35 Commits

Author SHA1 Message Date
1fc2a87232 Add database structure for audit log for SQLite 2025-05-26 19:48:44 +02:00
f4514372f6 Add database structure for audit log for PostgreSQL 2025-05-26 19:44:12 +02:00
5249a75fcd Add database structure for audit log for MySQL 2025-05-26 19:41:29 +02:00
233640502c Add length constraints to SQLite text columns to match MySQL/Postgres 2025-04-24 09:04:10 +02:00
ea6cbf6089 Improve DDL for SQLite 2025-03-20 14:28:20 +01:00
e771398527 Drop 'UNSIGNED' for 'FLOAT' in DDL for MySQL 2025-03-17 09:20:37 +01:00
3defd87461 Drop integer display widths in DDL for MySQL 2025-03-16 16:13:36 +01:00
c0a289c352 Improve DDL for PostgreSQL 2025-03-15 16:05:33 +01:00
5609c80af0 Remove trailing commas (syntax errors) in PostgreSQL
Thanks, @hauke-97 and @jgmamxmn !
2025-03-12 15:42:41 +01:00
efae015004 Do not use 'IF NOT EXISTS' with 'CREATE TABLE' for MySQL 2025-03-12 15:34:49 +01:00
4d92ca24c2 Add SQLite schema for new tables 'users_2fa' and 'users_otps' 2024-04-04 18:48:51 +02:00
8f249d0080 Add PostgreSQL schema for new tables 'users_2fa' and 'users_otps' 2024-04-04 17:47:08 +02:00
96b72f0be9 Add MySQL schema for new tables 'users_2fa' and 'users_otps' 2024-04-02 18:57:57 +02:00
ade63d07df Add 'force_logout' column to 'users' table in database schema 2018-03-24 17:49:35 +01:00
8f35cc9965 Optimize spacing in PostgreSQL schema 2018-03-12 18:44:32 +01:00
62d9e44aa4 Add check constraints for unsigned integers in PostgreSQL schema 2018-03-12 01:51:33 +01:00
1121685cef Improve database schema for PostgreSQL 2018-03-12 01:51:15 +01:00
2f9bab4779 Add database schema for PostgreSQL 2018-03-12 00:32:53 +01:00
8ff3776e75 Completely rewrite SQLite schema for table 'users_throttling' 2017-08-07 23:19:51 +02:00
30b2f30aec Completely rewrite MySQL schema for table 'users_throttling' 2017-08-07 23:17:12 +02:00
381e05f102 Update SQLite schema to index on 'user_id' in 'users_confirmations' 2017-08-07 19:28:49 +02:00
d86d7ffd25 Update MySQL schema to index on 'user_id' in 'users_confirmations' 2017-08-07 19:23:58 +02:00
d14d929bc3 Update SQLite schema to include 'user_id' in 'users_confirmations' 2017-07-30 19:36:29 +02:00
ec8e9eab4e Update MySQL schema to include 'user_id' in 'users_confirmations' 2017-07-30 19:34:30 +02:00
e73f29eec0 Update SQLite schema to include 'resettable' column in 'users' table 2017-07-30 14:41:53 +02:00
0e969ccd8d Update MySQL schema to include 'resettable' column in 'users' table 2017-07-30 14:40:11 +02:00
b577322939 Update SQLite schema to include 'roles_mask' column in 'users' table 2017-07-29 18:01:04 +02:00
8c2c32f9dc Update MySQL schema to include 'roles_mask' column in 'users' table 2017-07-29 17:50:43 +02:00
8fc0b98493 Remove superfluous blank line 2017-06-12 20:28:47 +02:00
45553afaea Add database schema for SQLite 2017-06-12 20:26:14 +02:00
d9dccf8100 Add 'status' column to 'users' table 2017-02-25 18:13:55 +01:00
e0b69ee33c Update database schema 2016-08-20 20:51:38 +02:00
227c37e2b5 Update MySQL database schema to ensure full Unicode support 2016-02-24 00:59:50 +01:00
2f8aaec42a Remove unnecessary code from MySQL data structure file 2016-02-22 18:53:52 +01:00
4b1df6e291 Initial commit 2015-10-20 14:26:38 +02:00