From 370e189f156730f3ea602052737fb6995c85c23c Mon Sep 17 00:00:00 2001 From: David M Date: Tue, 8 Jan 2008 06:44:05 +0000 Subject: - make viewforum work again - remove the lower case functions, they were stupid anyway - added some indexes - added a group_name_clean column git-svn-id: file:///svn/phpbb/trunk@8315 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/install/schemas/mysql_schema.sql | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) (limited to 'phpBB/install/schemas/mysql_schema.sql') diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 2d91b0259e..2863536e92 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -152,7 +152,8 @@ CREATE TABLE phpbb_config ( config_value varchar(255) DEFAULT '' NOT NULL, is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (config_name), - KEY is_dynamic (is_dynamic) + KEY is_dynamic (is_dynamic), + KEY config_name (config_name) ) CHARACTER SET `utf8` COLLATE `utf8_bin`; @@ -297,6 +298,7 @@ CREATE TABLE phpbb_groups ( group_type tinyint(4) DEFAULT '1' NOT NULL, group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, group_name varchar(255) DEFAULT '' NOT NULL, + group_name_clean varchar(255) DEFAULT '' NOT NULL, group_desc text NOT NULL, group_desc_bitfield varchar(255) DEFAULT '' NOT NULL, group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL, @@ -990,7 +992,8 @@ CREATE TABLE phpbb_zebra ( zebra_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, friend tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, foe tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, - PRIMARY KEY (user_id, zebra_id) + PRIMARY KEY (user_id, zebra_id), + KEY zebra_user (zebra_id, user_id) ) CHARACTER SET `utf8` COLLATE `utf8_bin`; -- cgit v1.2.1