summaryrefslogtreecommitdiff
path: root/rt/etc/upgrade/3.1.0/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/upgrade/3.1.0/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/upgrade/3.1.0/schema.Informix')
-rw-r--r--rt/etc/upgrade/3.1.0/schema.Informix17
1 files changed, 17 insertions, 0 deletions
diff --git a/rt/etc/upgrade/3.1.0/schema.Informix b/rt/etc/upgrade/3.1.0/schema.Informix
new file mode 100644
index 000000000..722eb70b3
--- /dev/null
+++ b/rt/etc/upgrade/3.1.0/schema.Informix
@@ -0,0 +1,17 @@
+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);