summaryrefslogtreecommitdiff
path: root/rt/etc/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/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/schema.SQLite')
-rw-r--r--rt/etc/schema.SQLite21
1 files changed, 21 insertions, 0 deletions
diff --git a/rt/etc/schema.SQLite b/rt/etc/schema.SQLite
index b10ff46d1..174664662 100644
--- a/rt/etc/schema.SQLite
+++ b/rt/etc/schema.SQLite
@@ -388,3 +388,24 @@ CREATE TABLE CustomFieldValues (
CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField);
--- }}}
+
+--- {{{ 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);
+
+--- }}}
+