diff options
Diffstat (limited to 'rt/etc/schema.Oracle')
| -rw-r--r-- | rt/etc/schema.Oracle | 12 |
1 files changed, 5 insertions, 7 deletions
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, |