diff options
author | ivan <ivan> | 2008-03-02 04:11:51 +0000 |
---|---|---|
committer | ivan <ivan> | 2008-03-02 04:11:51 +0000 |
commit | 8103c1fc1b2c27a6855feadf26f91b980a54bc52 (patch) | |
tree | 631dd45606c37c00d9026e14ecc3ee3700b4b51c /rt/etc/schema.Oracle | |
parent | 9c68254528b6f2c7d8c1921b452fa56064783782 (diff) |
import rt 3.6.6
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 8404ddf71..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; |