summaryrefslogtreecommitdiff
path: root/rt/etc/schema.SQLite
diff options
context:
space:
mode:
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);
+
+--- }}}
+