import rt 3.2.2

[freeside.git] / rt / etc / schema.Informix

diff --git a/rt/etc/schema.Informix b/rt/etc/schema.Informix
index ca6173f..20c607e 100644 (file)
--- 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,