diff options
Diffstat (limited to 'phpBB/install/schemas/sqlite_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 15 |
1 files changed, 9 insertions, 6 deletions
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql index 39f12d16a7..366e42305c 100644 --- a/phpBB/install/schemas/sqlite_schema.sql +++ b/phpBB/install/schemas/sqlite_schema.sql @@ -209,15 +209,16 @@ CREATE TABLE phpbb_forums ( forum_parents text(65535), forum_name varchar(150) NOT NULL, forum_desc text(65535), + forum_desc_bitfield int(11) NOT NULL DEFAULT '0', + forum_desc_uid varchar(5) NOT NULL DEFAULT '', forum_link varchar(200) NOT NULL DEFAULT '', forum_password varchar(32) NOT NULL DEFAULT '', forum_style tinyint(4), forum_image varchar(50) NOT NULL DEFAULT '', forum_rules text(65535) NOT NULL DEFAULT '', forum_rules_link varchar(200) NOT NULL DEFAULT '', - forum_rules_flags tinyint(4) NOT NULL DEFAULT '0', - forum_rules_bbcode_bitfield int(11) NOT NULL DEFAULT '0', - forum_rules_bbcode_uid varchar(5) NOT NULL DEFAULT '', + forum_rules_bitfield int(11) NOT NULL DEFAULT '0', + forum_rules_uid varchar(5) NOT NULL DEFAULT '', forum_topics_per_page tinyint(4) NOT NULL DEFAULT '0', forum_type tinyint(4) NOT NULL DEFAULT '0', forum_status tinyint(4) NOT NULL DEFAULT '0', @@ -274,6 +275,9 @@ CREATE TABLE phpbb_groups ( group_id INTEGER PRIMARY KEY NOT NULL, group_type tinyint(4) NOT NULL DEFAULT '1', group_name varchar(40) NOT NULL DEFAULT '', + group_desc text(65535), + group_desc_bitfield int(11) NOT NULL DEFAULT '0', + group_desc_uid varchar(5) NOT NULL DEFAULT '', group_display tinyint(1) NOT NULL DEFAULT '0', group_avatar varchar(100) NOT NULL DEFAULT '', group_avatar_type tinyint(4) NOT NULL DEFAULT '0', @@ -285,7 +289,6 @@ CREATE TABLE phpbb_groups ( group_receive_pm tinyint(1) NOT NULL DEFAULT '0', group_message_limit mediumint(8) NOT NULL DEFAULT '0', group_chgpass smallint(6) NOT NULL DEFAULT '0', - group_description varchar(255) NOT NULL DEFAULT '', group_legend tinyint(1) NOT NULL DEFAULT '1' ); @@ -608,7 +611,7 @@ CREATE TABLE phpbb_sessions ( session_time int(11) NOT NULL DEFAULT '0', session_ip varchar(40) NOT NULL DEFAULT '0', session_browser varchar(150) NOT NULL DEFAULT '', - session_page varchar(100) NOT NULL DEFAULT '', + session_page varchar(200) NOT NULL DEFAULT '', session_viewonline tinyint(1) NOT NULL DEFAULT '1', session_admin tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (session_id) @@ -884,7 +887,7 @@ CREATE TABLE phpbb_users ( user_lastvisit int(11) NOT NULL DEFAULT '0', user_lastmark int(11) NOT NULL DEFAULT '0', user_lastpost_time int(11) NOT NULL DEFAULT '0', - user_lastpage varchar(100) NOT NULL DEFAULT '', + user_lastpage varchar(200) NOT NULL DEFAULT '', user_last_confirm_key varchar(10) NOT NULL DEFAULT '', user_warnings tinyint(4) NOT NULL DEFAULT '0', user_last_warning int(11) NOT NULL DEFAULT '0', |