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