diff options
Diffstat (limited to 'rt/etc/schema.Informix')
| -rw-r--r-- | rt/etc/schema.Informix | 15 |
1 files changed, 6 insertions, 9 deletions
diff --git a/rt/etc/schema.Informix b/rt/etc/schema.Informix index 6a4e5334e..20c607e85 100644 --- a/rt/etc/schema.Informix +++ b/rt/etc/schema.Informix @@ -103,22 +103,20 @@ CREATE TABLE ScripConditions ( CREATE TABLE Transactions ( id SERIAL, - ObjectType VARCHAR(255), - ObjectId INTEGER DEFAULT 0 NOT NULL, + EffectiveTicket INTEGER DEFAULT 0 NOT NULL, + Ticket INTEGER DEFAULT 0 NOT NULL, TimeTaken INTEGER DEFAULT 0 NOT NULL, Type VARCHAR(20), Field VARCHAR(40), OldValue VARCHAR(255), NewValue VARCHAR(255), - ReferenceType VARCHAR(255), - OldReference INTEGER DEFAULT 0, - NewReference INTEGER DEFAULT 0, Data VARCHAR(255), Creator INTEGER DEFAULT 0 NOT NULL, Created DATETIME YEAR TO SECOND, PRIMARY KEY (id) ); -CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId); +CREATE INDEX Transactions1 ON Transactions (Ticket); +CREATE INDEX Transactions2 ON Transactions (EffectiveTicket); CREATE TABLE Scrips ( @@ -307,9 +305,7 @@ CREATE TABLE CustomFields ( id SERIAL, Name VARCHAR(200), Type VARCHAR(200), - MaxValues INTEGER DEFAULT 0 NOT NULL, - Pattern VARCHAR(255), - LookupType VARCHAR(255), + Queue INTEGER DEFAULT 0 NOT NULL, Description VARCHAR(255), SortOrder INTEGER DEFAULT 0 NOT NULL, Creator INTEGER DEFAULT 0 NOT NULL, @@ -319,6 +315,7 @@ CREATE TABLE CustomFields ( Disabled SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY (id) ); +CREATE INDEX CustomFields1 ON CustomFields (Disabled, Queue); CREATE TABLE CustomFieldValues ( |