diff options
Diffstat (limited to 'rt/etc/schema.Oracle')
| -rw-r--r-- | rt/etc/schema.Oracle | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/rt/etc/schema.Oracle b/rt/etc/schema.Oracle index 8404ddf..569d80c 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; |