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 INDEX DisGrouMem ON CachedGroupMembers (GroupId, MemberId, Disabled);
CREATE INDEX GrouMem ON CachedGroupMembers (GroupId, MemberId);
+CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (MemberId, ImmediateParentId);
CREATE SEQUENCE USERS_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;
Name VARCHAR2(200),
Type VARCHAR2(200),
MaxValues NUMBER(11,0) DEFAULT 0 NOT NULL,
- Pattern VARCHAR2(255),
+ Pattern CLOB,
Repeated NUMBER(11,0) DEFAULT 0 NOT NULL,
Description VARCHAR2(255),
SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL,