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/oracle_schema.sql | 11 ++++++++---
 1 file changed, 8 insertions(+), 3 deletions(-)

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

diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 275de3d488..dd1f45f530 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -329,6 +329,8 @@ CREATE TABLE phpbb_config (
 
 CREATE INDEX phpbb_config_is_dynamic ON phpbb_config (is_dynamic)
 /
+CREATE INDEX phpbb_config_config_name ON phpbb_config (config_name)
+/
 
 /*
 	Table: 'phpbb_confirm'
@@ -586,7 +588,8 @@ CREATE TABLE phpbb_groups (
 	group_id number(8) NOT NULL,
 	group_type number(4) DEFAULT '1' NOT NULL,
 	group_founder_manage number(1) DEFAULT '0' NOT NULL,
-	group_name varchar2(255) DEFAULT '' ,
+	group_name varchar2(765) DEFAULT '' ,
+	group_name_clean varchar2(765) DEFAULT '' ,
 	group_desc clob DEFAULT '' ,
 	group_desc_bitfield varchar2(255) DEFAULT '' ,
 	group_desc_options number(11) DEFAULT '7' NOT NULL,
@@ -1707,8 +1710,8 @@ CREATE TABLE phpbb_users (
 	user_perm_from number(8) DEFAULT '0' NOT NULL,
 	user_ip varchar2(40) DEFAULT '' ,
 	user_regdate number(11) DEFAULT '0' NOT NULL,
-	username varchar2(255) DEFAULT '' ,
-	username_clean varchar2(255) DEFAULT '' ,
+	username varchar2(765) DEFAULT '' ,
+	username_clean varchar2(765) DEFAULT '' ,
 	user_password varchar2(120) DEFAULT '' ,
 	user_passchg number(11) DEFAULT '0' NOT NULL,
 	user_pass_convert number(1) DEFAULT '0' NOT NULL,
@@ -1871,4 +1874,6 @@ CREATE TABLE phpbb_zebra (
 )
 /
 
+CREATE INDEX phpbb_zebra_zebra_user ON phpbb_zebra (zebra_id, user_id)
+/
 
-- 
cgit v1.2.1

