diff options
Diffstat (limited to 'phpBB/install/schemas/mysql_40_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_40_schema.sql | 30 |
1 files changed, 15 insertions, 15 deletions
diff --git a/phpBB/install/schemas/mysql_40_schema.sql b/phpBB/install/schemas/mysql_40_schema.sql index 54b569e9f7..5fee2fc54c 100644 --- a/phpBB/install/schemas/mysql_40_schema.sql +++ b/phpBB/install/schemas/mysql_40_schema.sql @@ -102,7 +102,7 @@ CREATE TABLE phpbb_banlist ( PRIMARY KEY (ban_id), KEY ban_end (ban_end), KEY ban_user (ban_userid, ban_exclude), - KEY ban_email (ban_email, ban_exclude), + KEY ban_email (ban_email(255), ban_exclude), KEY ban_ip (ban_ip, ban_exclude) ); @@ -149,7 +149,7 @@ CREATE TABLE phpbb_bots ( # Table: 'phpbb_config' CREATE TABLE phpbb_config ( - config_name varchar(252) DEFAULT '' NOT NULL, + config_name varchar(255) DEFAULT '' NOT NULL, config_value varchar(255) DEFAULT '' NOT NULL, is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (config_name), @@ -223,7 +223,7 @@ CREATE TABLE phpbb_forums ( forum_parents mediumtext DEFAULT '' NOT NULL, forum_name text DEFAULT '' NOT NULL, forum_desc text DEFAULT '' NOT NULL, - forum_desc_bitfield varchar(252) DEFAULT '' NOT NULL, + forum_desc_bitfield varchar(255) DEFAULT '' NOT NULL, forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL, forum_desc_uid varchar(5) DEFAULT '' NOT NULL, forum_link text DEFAULT '' NOT NULL, @@ -232,7 +232,7 @@ CREATE TABLE phpbb_forums ( forum_image varchar(255) DEFAULT '' NOT NULL, forum_rules text DEFAULT '' NOT NULL, forum_rules_link text DEFAULT '' NOT NULL, - forum_rules_bitfield varchar(252) DEFAULT '' NOT NULL, + forum_rules_bitfield varchar(255) DEFAULT '' NOT NULL, forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL, forum_rules_uid varchar(5) DEFAULT '' NOT NULL, forum_topics_per_page tinyint(4) DEFAULT '0' NOT NULL, @@ -297,7 +297,7 @@ CREATE TABLE phpbb_groups ( group_type tinyint(4) DEFAULT '1' NOT NULL, group_name text DEFAULT '' NOT NULL, group_desc text DEFAULT '' NOT NULL, - group_desc_bitfield varchar(252) DEFAULT '' NOT NULL, + group_desc_bitfield varchar(255) DEFAULT '' NOT NULL, group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL, group_desc_uid varchar(5) DEFAULT '' NOT NULL, group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, @@ -439,7 +439,7 @@ CREATE TABLE phpbb_posts ( post_text mediumtext DEFAULT '' NOT NULL, post_checksum varchar(32) DEFAULT '' NOT NULL, post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - bbcode_bitfield varchar(252) DEFAULT '' NOT NULL, + bbcode_bitfield varchar(255) DEFAULT '' NOT NULL, bbcode_uid varchar(5) DEFAULT '' NOT NULL, post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL, post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL, @@ -453,8 +453,7 @@ CREATE TABLE phpbb_posts ( KEY poster_ip (poster_ip), KEY poster_id (poster_id), KEY post_approved (post_approved), - KEY post_postcount (post_postcount), - KEY post_time (post_time) + KEY tid_post_time (topic_id, post_time) ); @@ -475,7 +474,7 @@ CREATE TABLE phpbb_privmsgs ( message_edit_reason text DEFAULT '' NOT NULL, message_edit_user mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - bbcode_bitfield varchar(252) DEFAULT '' NOT NULL, + bbcode_bitfield varchar(255) DEFAULT '' NOT NULL, bbcode_uid varchar(5) DEFAULT '' NOT NULL, message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL, message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL, @@ -717,7 +716,7 @@ CREATE TABLE phpbb_styles ( theme_id tinyint(4) DEFAULT '0' NOT NULL, imageset_id tinyint(4) DEFAULT '0' NOT NULL, PRIMARY KEY (style_id), - UNIQUE style_name (style_name), + UNIQUE style_name (style_name(255)), KEY template_id (template_id), KEY theme_id (theme_id), KEY imageset_id (imageset_id) @@ -730,10 +729,10 @@ CREATE TABLE phpbb_styles_template ( template_name text DEFAULT '' NOT NULL, template_copyright text DEFAULT '' NOT NULL, template_path varchar(100) DEFAULT '' NOT NULL, - bbcode_bitfield varchar(252) DEFAULT 'kNg=' NOT NULL, + bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL, template_storedb tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (template_id), - UNIQUE tmplte_nm (template_name) + UNIQUE tmplte_nm (template_name(255)) ); @@ -759,7 +758,7 @@ CREATE TABLE phpbb_styles_theme ( theme_mtime int(11) UNSIGNED DEFAULT '0' NOT NULL, theme_data mediumtext DEFAULT '' NOT NULL, PRIMARY KEY (theme_id), - UNIQUE theme_name (theme_name) + UNIQUE theme_name (theme_name(255)) ); @@ -864,7 +863,7 @@ CREATE TABLE phpbb_styles_imageset ( user_icon9 varchar(200) DEFAULT '' NOT NULL, user_icon10 varchar(200) DEFAULT '' NOT NULL, PRIMARY KEY (imageset_id), - UNIQUE imgset_nm (imageset_name) + UNIQUE imgset_nm (imageset_name(255)) ); @@ -908,6 +907,7 @@ CREATE TABLE phpbb_topics ( KEY forum_id (forum_id), KEY forum_id_type (forum_id, topic_type), KEY last_post_time (topic_last_post_time), + KEY topic_approved (topic_approved), KEY fid_time_moved (forum_id, topic_last_post_time, topic_moved_id) ); @@ -1016,7 +1016,7 @@ CREATE TABLE phpbb_users ( user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL, user_sig mediumtext DEFAULT '' NOT NULL, user_sig_bbcode_uid varchar(5) DEFAULT '' NOT NULL, - user_sig_bbcode_bitfield varchar(252) DEFAULT '' NOT NULL, + user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL, user_from text DEFAULT '' NOT NULL, user_icq varchar(15) DEFAULT '' NOT NULL, user_aim text DEFAULT '' NOT NULL, |