Mailing List Archive

Author: autrijus
Date: Sun Nov 7 09:16:15 2004
New Revision: 1723

Modified:
rt/ (props changed)
rt/branches/3.3-TESTING/etc/schema.Oracle
rt/branches/3.3-TESTING/etc/schema.Pg
rt/branches/3.3-TESTING/etc/schema.SQLite
rt/branches/3.3-TESTING/etc/schema.mysql
Log:
r10242@not: autrijus | 2004-11-06T06:59:58.274625Z
* Schema changes for Pg, SQLite, mysql and Oracle.



Modified: rt/branches/3.3-TESTING/etc/schema.Oracle
==============================================================================
--- rt/branches/3.3-TESTING/etc/schema.Oracle (original)
+++ rt/branches/3.3-TESTING/etc/schema.Oracle Sun Nov 7 09:16:15 2004
@@ -297,21 +297,29 @@
);


-CREATE SEQUENCE TICKETCUSTOMFIELDVALUES_seq;
-CREATE TABLE TicketCustomFieldValues (
+CREATE SEQUENCE OBJECTCUSTOMFIELDVALUES_seq;
+CREATE TABLE ObjectCustomFieldValues (
id NUMBER(11,0)
- CONSTRAINT TicketCustomFieldValues_Key PRIMARY KEY,
- Ticket NUMBER(11,0),
+ CONSTRAINT ObjectCustomFieldValues_Key PRIMARY KEY,
CustomField NUMBER(11,0) NOT NULL,
+ ObjectType VARCHAR2(25) NOT NULL,
+ ObjectId NUMBER(11,0) DEFAULT 0 NOT NULL,
+ SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL,
+
Content VARCHAR2(255),
+ LargeContent CLOB,
+ ContentType VARCHAR2(80),
+ ContentEncoding VARCHAR2(80),
+
Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
Created DATE,
LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
- LastUpdated DATE
+ LastUpdated DATE,
+ Disabled NUMBER(11,0) DEFAULT 0 NOT NULL
);

-CREATE INDEX TicketCustomFieldValues1 ON TicketCustomFieldValues (CustomField,Ticket,Content);
-CREATE INDEX TicketCustomFieldValues2 ON TicketCustomFieldValues (CustomField,Ticket);
+CREATE INDEX ObjectCustomFieldValues1 ON ObjectCustomFieldValues (Content);
+CREATE INDEX ObjectCustomFieldValues2 ON ObjectCustomFieldValues (CustomField,ObjectType,ObjectId);

CREATE SEQUENCE CUSTOMFIELDS_seq;
CREATE TABLE CustomFields (

Modified: rt/branches/3.3-TESTING/etc/schema.Pg
==============================================================================
--- rt/branches/3.3-TESTING/etc/schema.Pg (original)
+++ rt/branches/3.3-TESTING/etc/schema.Pg Sun Nov 7 09:16:15 2004
@@ -491,7 +491,8 @@
CustomField int NOT NULL ,
ObjectType varchar(255) NULL ,
ObjectId int NOT NULL ,
- Current int DEFAULT 1,
+ SortOrder integer NOT NULL DEFAULT 0 ,
+
Content varchar(255) NULL ,
LargeContent text NULL,
ContentType varchar(80) NULL,
@@ -501,6 +502,7 @@
Created TIMESTAMP NULL ,
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated TIMESTAMP NULL ,
+ Disabled integer NOT NULL DEFAULT 0 ,
PRIMARY KEY (id)

);

Modified: rt/branches/3.3-TESTING/etc/schema.SQLite
==============================================================================
--- rt/branches/3.3-TESTING/etc/schema.SQLite (original)
+++ rt/branches/3.3-TESTING/etc/schema.SQLite Sun Nov 7 09:16:15 2004
@@ -340,8 +340,8 @@
CustomField int NOT NULL ,
ObjectType varchar(255) NOT NULL, # Final target of the Object
ObjectId int NOT NULL , # New -- Replaces Ticket
+ SortOrder integer NOT NULL DEFAULT 0 ,

- Current BOOL DEFAULT 1, # New -- whether the value was current
Content varchar(255) NULL ,
LargeContent LONGTEXT NULL, # New -- to hold 255+ strings
ContentType varchar(80) NULL, # New -- only text/* gets searched
@@ -351,6 +351,7 @@
Created DATETIME NULL ,
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
+ Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id)
) ;


Modified: rt/branches/3.3-TESTING/etc/schema.mysql
==============================================================================
--- rt/branches/3.3-TESTING/etc/schema.mysql (original)
+++ rt/branches/3.3-TESTING/etc/schema.mysql Sun Nov 7 09:16:15 2004
@@ -346,8 +346,8 @@
CustomField int NOT NULL ,
ObjectType varchar(255) NOT NULL, # Final target of the Object
ObjectId int NOT NULL , # New -- Replaces Ticket
+ SortOrder integer NOT NULL DEFAULT 0 , # New -- ordering for multiple values

- Current BOOL DEFAULT 1, # New -- whether the value was current
Content varchar(255) NULL ,
LargeContent LONGTEXT NULL, # New -- to hold 255+ strings
ContentType varchar(80) NULL, # New -- only text/* gets searched
@@ -357,6 +357,7 @@
Created DATETIME NULL ,
LastUpdatedBy integer NOT NULL DEFAULT 0 ,
LastUpdated DATETIME NULL ,
+ Disabled int2 NOT NULL DEFAULT 0 , # New -- whether the value was current
PRIMARY KEY (id)
) TYPE=InnoDB;

_______________________________________________
Rt-commit mailing list
Rt-commit@lists.bestpractical.com
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-commit