summaryrefslogtreecommitdiff
path: root/rt/etc/schema.Informix
diff options
context:
space:
mode:
authorivan <ivan>2004-12-03 20:40:48 +0000
committerivan <ivan>2004-12-03 20:40:48 +0000
commitf7fd2a3e34da751cbc02bbf215e99c6dc89adc15 (patch)
tree495d4c785a1aac113236511cdf8c1e5ce2a4f5ee /rt/etc/schema.Informix
parent2d98f7dcda48d4c38e748d3301cce956cb5e6c06 (diff)
parentd39d52aac8f38ea9115628039f0df5aa3ac826de (diff)
This commit was generated by cvs2svn to compensate for changes in r3921,
which included commits to RCS files with non-trunk default branches.
Diffstat (limited to 'rt/etc/schema.Informix')
-rw-r--r--rt/etc/schema.Informix19
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,