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);
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;
);
-- 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;