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/mssql_schema.sql | 7 +++++++
 1 file changed, 7 insertions(+)

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

diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 804a970013..03c4c4c398 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -293,6 +293,9 @@ GO
 CREATE  INDEX [is_dynamic] ON [phpbb_config]([is_dynamic]) ON [PRIMARY]
 GO
 
+CREATE  INDEX [config_name] ON [phpbb_config]([config_name]) ON [PRIMARY]
+GO
+
 
 /*
 	Table: 'phpbb_confirm'
@@ -530,6 +533,7 @@ CREATE TABLE [phpbb_groups] (
 	[group_type] [int] DEFAULT (1) NOT NULL ,
 	[group_founder_manage] [int] DEFAULT (0) NOT NULL ,
 	[group_name] [varchar] (255) DEFAULT ('') NOT NULL ,
+	[group_name_clean] [varchar] (255) DEFAULT ('') NOT NULL ,
 	[group_desc] [varchar] (4000) DEFAULT ('') NOT NULL ,
 	[group_desc_bitfield] [varchar] (255) DEFAULT ('') NOT NULL ,
 	[group_desc_options] [int] DEFAULT (7) NOT NULL ,
@@ -1703,6 +1707,9 @@ ALTER TABLE [phpbb_zebra] WITH NOCHECK ADD
 	)  ON [PRIMARY] 
 GO
 
+CREATE  INDEX [zebra_user] ON [phpbb_zebra]([zebra_id], [user_id]) ON [PRIMARY]
+GO
+
 
 
 COMMIT
-- 
cgit v1.2.1

