From ef20b2b6b1feb47ad02b5ff7525f1a0fd11d0fa4 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Thu, 2 Aug 2007 19:56:20 +0000
Subject: import rt 3.6.4

---
 rt/etc/schema.Oracle | 12 +++++-------
 1 file changed, 5 insertions(+), 7 deletions(-)

(limited to 'rt/etc/schema.Oracle')

diff --git a/rt/etc/schema.Oracle b/rt/etc/schema.Oracle
index 40238b526..569d80cc4 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;
@@ -225,8 +225,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;
@@ -320,12 +320,10 @@ CREATE TABLE ObjectCustomFieldValues (
 	ObjectType	VARCHAR2(25) NOT NULL,
 	ObjectId	NUMBER(11,0) DEFAULT 0 NOT NULL,
 	SortOrder	NUMBER(11,0) DEFAULT 0 NOT NULL,
-
 	Content		VARCHAR2(255),
   	LargeContent 	CLOB,
   	ContentType 	VARCHAR2(80),
   	ContentEncoding VARCHAR2(80),
-
 	Creator		NUMBER(11,0) DEFAULT 0 NOT NULL,
 	Created		DATE,
 	LastUpdatedBy	NUMBER(11,0) DEFAULT 0 NOT NULL,
-- 
cgit v1.2.1