X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=rt%2Fetc%2Fschema.Oracle;h=693e75ae571d021ccf0eba44fec69ae584205e08;hb=b4b0c7e72d7eaee2fbfc7022022c9698323203dd;hp=8404ddf71cbb49886ef090eba668ad4a3ddc54c3;hpb=9c68254528b6f2c7d8c1921b452fa56064783782;p=freeside.git

diff --git a/rt/etc/schema.Oracle b/rt/etc/schema.Oracle
index 8404ddf71..693e75ae5 100644
--- a/rt/etc/schema.Oracle
+++ b/rt/etc/schema.Oracle
@@ -36,7 +36,7 @@ CREATE TABLE Queues (
 	LastUpdated		DATE,
 	Disabled 		NUMBER(11,0) DEFAULT 0 NOT NULL
 );
- CREATE  INDEX Queues1 ON Queues (lower(Name));
+ CREATE  INDEX Queues1 ON Queues (LOWER(Name));
 CREATE INDEX Queues2 ON Queues (Disabled);
 
 
@@ -82,8 +82,8 @@ CREATE TABLE Groups (
 	Instance	NUMBER(11,0) DEFAULT 0 -- NOT NULL
 --	Instance	VARCHAR2(64)
 );
-CREATE INDEX Groups1 ON Groups (lower( Domain), Instance, lower(Type), id);
-CREATE INDEX Groups2 ON Groups (lower(Type), Instance, lower(Domain));
+CREATE INDEX Groups1 ON Groups (LOWER(Domain), Instance, LOWER(Type), id);
+CREATE INDEX Groups2 ON Groups (LOWER(Type), Instance, LOWER(Domain));
 
 
 CREATE SEQUENCE SCRIPCONDITIONS_seq;
@@ -182,6 +182,7 @@ CREATE TABLE CachedGroupMembers (
 );
 CREATE INDEX DisGrouMem ON CachedGroupMembers (GroupId, MemberId, Disabled);
 CREATE INDEX GrouMem ON CachedGroupMembers (GroupId, MemberId);
+CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (MemberId, ImmediateParentId);
 
 
 CREATE SEQUENCE USERS_seq;
@@ -225,8 +226,8 @@ CREATE TABLE Users (
 );
 -- CREATE UNIQUE INDEX Users1 ON Users (Name);
 
-CREATE INDEX Users2 ON Users( LOWER(name));
-CREATE INDEX Users4 ON Users (lower(EmailAddress));
+CREATE INDEX Users2 ON Users( LOWER(Name));
+CREATE INDEX Users4 ON Users (LOWER(EmailAddress));
 
 
 CREATE SEQUENCE TICKETS_seq;
@@ -341,7 +342,7 @@ CREATE TABLE CustomFields (
 	Name		VARCHAR2(200),
 	Type		VARCHAR2(200),
 	MaxValues	NUMBER(11,0) DEFAULT 0 NOT NULL,
-	Pattern		VARCHAR2(255),
+	Pattern		CLOB,
         Repeated        NUMBER(11,0) DEFAULT 0 NOT NULL,
 	Description	VARCHAR2(255),
 	SortOrder	NUMBER(11,0) DEFAULT 0 NOT NULL,