diff options
Diffstat (limited to 'phpBB/install/schemas/sqlite_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 19 |
1 files changed, 14 insertions, 5 deletions
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql index ee61fa6be0..e4339d8a64 100644 --- a/phpBB/install/schemas/sqlite_schema.sql +++ b/phpBB/install/schemas/sqlite_schema.sql @@ -35,7 +35,8 @@ CREATE INDEX filesize_phpbb_attachments on phpbb_attachments (filesize); CREATE TABLE phpbb_auth_groups ( group_id mediumint(8) NOT NULL DEFAULT '0', forum_id mediumint(8) NOT NULL DEFAULT '0', - auth_option_id smallint(5) NOT NULL DEFAULT '0', + auth_option_id mediumint(8) NOT NULL DEFAULT '0', + auth_preset_id mediumint(8) NOT NULL DEFAULT '0', auth_setting tinyint(4) NOT NULL DEFAULT '0' ); @@ -57,18 +58,26 @@ CREATE INDEX auth_option_phpbb_auth_options on phpbb_auth_options (auth_option); CREATE TABLE phpbb_auth_presets ( preset_id INTEGER PRIMARY KEY NOT NULL, preset_name varchar(50) NOT NULL DEFAULT '', - preset_user_id mediumint(5) NOT NULL DEFAULT '0', - preset_type varchar(2) NOT NULL DEFAULT '', - preset_data text(65535) NOT NULL DEFAULT '' + preset_type varchar(10) NOT NULL DEFAULT '', + preset_group_id mediumint(8) NOT NULL DEFAULT '0' ); CREATE INDEX preset_type_phpbb_auth_presets on phpbb_auth_presets (preset_type); +# Table: phpbb_auth_preset_data +CREATE TABLE phpbb_auth_preset_data ( + preset_id mediumint(8) NOT NULL DEFAULT '0', + auth_option_id mediumint(8) NOT NULL DEFAULT '0', + auth_setting tinyint(2) NOT NULL DEFAULT '0', + PRIMARY KEY (preset_id, auth_option_id) +); + # Table: phpbb_auth_users CREATE TABLE phpbb_auth_users ( user_id mediumint(8) NOT NULL DEFAULT '0', forum_id mediumint(8) NOT NULL DEFAULT '0', - auth_option_id smallint(5) NOT NULL DEFAULT '0', + auth_option_id mediumint(8) NOT NULL DEFAULT '0', + auth_preset_id mediumint(8) NOT NULL DEFAULT '0', auth_setting tinyint(4) NOT NULL DEFAULT '0' ); |