X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=rt%2Fetc%2Fschema.Pg;h=a5b68b395175cb531efaec02b92f74dbbba66439;hp=085c61595f2a7b95adfe6fdebf72c7afb6125877;hb=d39d52aac8f38ea9115628039f0df5aa3ac826de;hpb=c582e92888b4a5553e1b4e5214cf35217e4a0cf0

diff --git a/rt/etc/schema.Pg b/rt/etc/schema.Pg
index 085c61595..a5b68b395 100755
--- 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.