X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=rt%2Fetc%2Fschema.Informix;h=6a4e5334e163fd80ba66aa68f32b611845d326fe;hb=8d6987f81d3d5667b00b428580a05e7ac973279a;hp=ca6173f36f785ff0c6bceeb7465cbf2176a544fa;hpb=2041a9143fac20b79ead4a1ae01224dedf5b27c2;p=freeside.git

diff --git a/rt/etc/schema.Informix b/rt/etc/schema.Informix
index ca6173f36..6a4e5334e 100644
--- a/rt/etc/schema.Informix
+++ b/rt/etc/schema.Informix
@@ -103,20 +103,22 @@ CREATE TABLE ScripConditions (
 
 CREATE TABLE Transactions (
   	id 			SERIAL,
-  	EffectiveTicket 	INTEGER DEFAULT 0 NOT NULL,
-  	Ticket 			INTEGER DEFAULT 0 NOT NULL,
+  	ObjectType 		VARCHAR(255),
+  	ObjectId 		INTEGER DEFAULT 0 NOT NULL,
   	TimeTaken 		INTEGER DEFAULT 0 NOT NULL,
   	Type 			VARCHAR(20),
   	Field 			VARCHAR(40),
   	OldValue 		VARCHAR(255),
   	NewValue 		VARCHAR(255),
+  	ReferenceType 		VARCHAR(255),
+	OldReference		INTEGER DEFAULT 0,
+	NewReference		INTEGER DEFAULT 0,
   	Data 			VARCHAR(255),
   	Creator 		INTEGER DEFAULT 0 NOT NULL,
   	Created 		DATETIME YEAR TO SECOND,
         PRIMARY KEY (id)
 );
-CREATE INDEX Transactions1 ON Transactions (Ticket);
-CREATE INDEX Transactions2 ON Transactions (EffectiveTicket);
+CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId);
 
 
 CREATE TABLE Scrips (
@@ -305,7 +307,9 @@ CREATE TABLE CustomFields (
 	id		SERIAL,
 	Name		VARCHAR(200),
 	Type		VARCHAR(200),
-	Queue		INTEGER DEFAULT 0 NOT NULL,
+	MaxValues	INTEGER DEFAULT 0 NOT NULL,
+	Pattern		VARCHAR(255),
+	LookupType	VARCHAR(255),
 	Description	VARCHAR(255),
 	SortOrder	INTEGER DEFAULT 0 NOT NULL,
 	Creator		INTEGER DEFAULT 0 NOT NULL,
@@ -315,7 +319,6 @@ CREATE TABLE CustomFields (
 	Disabled	SMALLINT DEFAULT 0 NOT NULL,
         PRIMARY KEY (id)
 );
-CREATE INDEX CustomFields1 ON CustomFields (Disabled, Queue);
 
 
 CREATE TABLE CustomFieldValues (
@@ -333,6 +336,25 @@ CREATE TABLE CustomFieldValues (
 
 CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField);
 
+CREATE TABLE Attributes (
+  	id 		SERIAL,
+	Name 			VARCHAR(255) DEFAULT '' NOT NULL,
+	Description 		VARCHAR(255) DEFAULT NULL,
+  	Content 	BYTE,
+	ContentType	VARCHAR(16),
+	ObjectType	VARCHAR(25) NOT NULL,
+	ObjectId	INTEGER DEFAULT 0 NOT NULL,
+	Creator 	INTEGER DEFAULT 0 NOT NULL,
+  	Created 	DATETIME YEAR TO SECOND,
+	LastUpdatedBy	INTEGER DEFAULT 0 NOT NULL,
+	LastUpdated	DATETIME YEAR TO SECOND,
+        PRIMARY KEY (id)
+); 
+
+CREATE INDEX Attributes1 on Attributes(Name);
+CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);
+
+
 CREATE TABLE sessions (
 	id		VARCHAR(32) NOT NULL,
 	a_session	BYTE,