diff options
Diffstat (limited to 'rt/etc/schema.Informix')
-rw-r--r-- | rt/etc/schema.Informix | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/rt/etc/schema.Informix b/rt/etc/schema.Informix index ca6173f36..20c607e85 100644 --- a/rt/etc/schema.Informix +++ b/rt/etc/schema.Informix @@ -333,6 +333,25 @@ CREATE TABLE CustomFieldValues ( CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField); +CREATE TABLE Attributes ( + id SERIAL, + Name VARCHAR(255) DEFAULT '' NOT NULL, + Description VARCHAR(255) DEFAULT NULL, + Content BYTE, + ContentType VARCHAR(16), + ObjectType VARCHAR(25) NOT NULL, + ObjectId INTEGER DEFAULT 0 NOT NULL, + Creator INTEGER DEFAULT 0 NOT NULL, + Created DATETIME YEAR TO SECOND, + LastUpdatedBy INTEGER DEFAULT 0 NOT NULL, + LastUpdated DATETIME YEAR TO SECOND, + PRIMARY KEY (id) +); + +CREATE INDEX Attributes1 on Attributes(Name); +CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId); + + CREATE TABLE sessions ( id VARCHAR(32) NOT NULL, a_session BYTE, |