summaryrefslogtreecommitdiff
path: root/rt/etc/upgrade/3.1.0/schema.SQLite
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.SQLite
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.SQLite')
-rw-r--r--rt/etc/upgrade/3.1.0/schema.SQLite20
1 files changed, 20 insertions, 0 deletions
diff --git a/rt/etc/upgrade/3.1.0/schema.SQLite b/rt/etc/upgrade/3.1.0/schema.SQLite
new file mode 100644
index 000000000..87a1cc47f
--- /dev/null
+++ b/rt/etc/upgrade/3.1.0/schema.SQLite
@@ -0,0 +1,20 @@
+--- {{{ Attributes
+CREATE TABLE Attributes (
+ id INTEGER PRIMARY KEY ,
+ Name varchar(255) NOT NULL ,
+ Description varchar(255) NULL ,
+ Content LONGTEXT NULL ,
+ ContentType varchar(16),
+ ObjectType varchar(25) NOT NULL ,
+ ObjectId INTEGER default 0,
+ Creator integer NULL ,
+ Created DATETIME NULL ,
+ LastUpdatedBy integer NULL ,
+ LastUpdated DATETIME NULL
+
+) ;
+CREATE INDEX Attributes1 on Attributes(Name)
+CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);
+
+--- }}}
+