diff options
Diffstat (limited to 'phpBB/install/schemas/mysql_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 15 |
1 files changed, 9 insertions, 6 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index be12faa9ab..54776af947 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -207,15 +207,16 @@ CREATE TABLE phpbb_forums ( forum_parents text, forum_name varchar(150) NOT NULL, forum_desc text, + forum_desc_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL, + forum_desc_uid varchar(5) DEFAULT '' NOT NULL, forum_link varchar(200) DEFAULT '' NOT NULL, forum_password varchar(32) DEFAULT '' NOT NULL, forum_style tinyint(4) UNSIGNED, forum_image varchar(50) DEFAULT '' NOT NULL, forum_rules text DEFAULT '' NOT NULL, forum_rules_link varchar(200) DEFAULT '' NOT NULL, - forum_rules_flags tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, - forum_rules_bbcode_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL, - forum_rules_bbcode_uid varchar(5) DEFAULT '' NOT NULL, + forum_rules_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL, + forum_rules_uid varchar(5) DEFAULT '' NOT NULL, forum_topics_per_page tinyint(4) UNSIGNED DEFAULT '0' NOT NULL, forum_type tinyint(4) DEFAULT '0' NOT NULL, forum_status tinyint(4) DEFAULT '0' NOT NULL, @@ -271,6 +272,9 @@ CREATE TABLE phpbb_groups ( group_id mediumint(8) NOT NULL auto_increment, group_type tinyint(4) DEFAULT '1' NOT NULL, group_name varchar(40) DEFAULT '' NOT NULL, + group_desc text, + group_desc_bitfield int(11) UNSIGNED DEFAULT '0' NOT NULL, + group_desc_uid varchar(5) DEFAULT '' NOT NULL, group_display tinyint(1) DEFAULT '0' NOT NULL, group_avatar varchar(100) DEFAULT '' NOT NULL, group_avatar_type tinyint(4) DEFAULT '0' NOT NULL, @@ -282,7 +286,6 @@ CREATE TABLE phpbb_groups ( group_receive_pm tinyint(1) DEFAULT '0' NOT NULL, group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, group_chgpass smallint(6) DEFAULT '0' NOT NULL, - group_description varchar(255) DEFAULT '' NOT NULL, group_legend tinyint(1) DEFAULT '1' NOT NULL, PRIMARY KEY (group_id), KEY group_legend (group_legend) @@ -606,7 +609,7 @@ CREATE TABLE phpbb_sessions ( session_time int(11) DEFAULT '0' NOT NULL, session_ip varchar(40) DEFAULT '0' NOT NULL, session_browser varchar(150) DEFAULT '' NOT NULL, - session_page varchar(100) DEFAULT '' NOT NULL, + session_page varchar(200) DEFAULT '' NOT NULL, session_viewonline tinyint(1) DEFAULT '1' NOT NULL, session_admin tinyint(1) DEFAULT '0' NOT NULL, PRIMARY KEY (session_id), @@ -880,7 +883,7 @@ CREATE TABLE phpbb_users ( user_lastvisit int(11) DEFAULT '0' NOT NULL, user_lastmark int(11) DEFAULT '0' NOT NULL, user_lastpost_time int(11) DEFAULT '0' NOT NULL, - user_lastpage varchar(100) DEFAULT '' NOT NULL, + user_lastpage varchar(200) DEFAULT '' NOT NULL, user_last_confirm_key varchar(10) DEFAULT '' NOT NULL, user_warnings tinyint(4) DEFAULT '0' NOT NULL, user_last_warning int(11) DEFAULT '0' NOT NULL, |