import rt 3.2.2

[freeside.git] / rt / etc / schema.Pg

diff --git a/rt/etc/schema.Pg b/rt/etc/schema.Pg
index 085c615..a5b68b3 100755 (executable)
--- a/rt/etc/schema.Pg
+++ b/rt/etc/schema.Pg
@@ -561,6 +561,32 @@ CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField);
 
 -- }}}
 
+
+-- {{{ Attributes
+
+CREATE SEQUENCE attributes_id_seq;
+
+CREATE TABLE Attributes (
+  id INTEGER DEFAULT nextval('attributes_id_seq'),
+  Name varchar(255) NOT NULL  ,
+  Description varchar(255) NULL  ,
+  Content text,
+  ContentType varchar(16),
+  ObjectType varchar(64),
+  ObjectId integer, # foreign key to anything
+  Creator integer NOT NULL DEFAULT 0  ,
+  Created TIMESTAMP NULL  ,
+  LastUpdatedBy integer NOT NULL DEFAULT 0  ,
+  LastUpdated TIMESTAMP NULL  ,
+  PRIMARY KEY (id)
+
+);
+
+CREATE INDEX Attributes1 on Attributes(Name);
+CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);
+
+-- }}}
+
 -- {{{ Sessions
 
 -- sessions is used by Apache::Session to keep sessions in the database.