From 370e189f156730f3ea602052737fb6995c85c23c Mon Sep 17 00:00:00 2001
From: David M <davidmj@users.sourceforge.net>
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/db2_schema.sql | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'phpBB/install/schemas/db2_schema.sql')

diff --git a/phpBB/install/schemas/db2_schema.sql b/phpBB/install/schemas/db2_schema.sql
index 3e1482be47..247551ceb7 100644
--- a/phpBB/install/schemas/db2_schema.sql
+++ b/phpBB/install/schemas/db2_schema.sql
@@ -179,6 +179,7 @@ CREATE TABLE phpbb_config (
 );
 
 CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic) PCTFREE 10 MINPCTUSED 10 ALLOW REVERSE SCANS  PAGE SPLIT SYMMETRIC COLLECT  SAMPLED DETAILED  STATISTICS;
+CREATE INDEX phpbb_config_config_name ON phpbb_config (config_name) PCTFREE 10 MINPCTUSED 10 ALLOW REVERSE SCANS  PAGE SPLIT SYMMETRIC COLLECT  SAMPLED DETAILED  STATISTICS;
 
 /*
 	Table: 'phpbb_confirm'
@@ -341,6 +342,7 @@ CREATE TABLE phpbb_groups (
 	group_type smallint NOT NULL DEFAULT 1,
 	group_founder_manage smallint NOT NULL DEFAULT 0,
 	group_name varchar(255) NOT NULL DEFAULT '',
+	group_name_clean varchar(255) NOT NULL DEFAULT '',
 	group_desc clob(65K) NOT NULL DEFAULT '',
 	group_desc_bitfield varchar(255) NOT NULL DEFAULT '',
 	group_desc_options integer NOT NULL DEFAULT 7,
@@ -1119,4 +1121,5 @@ CREATE TABLE phpbb_zebra (
 	PRIMARY KEY (user_id, zebra_id)
 );
 
+CREATE INDEX phpbb_zebra_zebra_user ON phpbb_zebra (zebra_id, user_id) PCTFREE 10 MINPCTUSED 10 ALLOW REVERSE SCANS  PAGE SPLIT SYMMETRIC COLLECT  SAMPLED DETAILED  STATISTICS;
 
-- 
cgit v1.2.1

