diff options
Diffstat (limited to 'rt/etc/upgrade/3.3.0')
-rw-r--r-- | rt/etc/upgrade/3.3.0/acl.Informix | 4 | ||||
-rw-r--r-- | rt/etc/upgrade/3.3.0/acl.Oracle | 4 | ||||
-rw-r--r-- | rt/etc/upgrade/3.3.0/acl.Pg | 20 | ||||
-rw-r--r-- | rt/etc/upgrade/3.3.0/acl.SQLite | 4 | ||||
-rw-r--r-- | rt/etc/upgrade/3.3.0/acl.mysql | 4 | ||||
-rw-r--r-- | rt/etc/upgrade/3.3.0/content | 1 | ||||
-rw-r--r-- | rt/etc/upgrade/3.3.0/schema.Oracle | 65 | ||||
-rw-r--r-- | rt/etc/upgrade/3.3.0/schema.Pg | 74 | ||||
-rw-r--r-- | rt/etc/upgrade/3.3.0/schema.mysql | 65 |
9 files changed, 0 insertions, 241 deletions
diff --git a/rt/etc/upgrade/3.3.0/acl.Informix b/rt/etc/upgrade/3.3.0/acl.Informix deleted file mode 100644 index 73c16ae03..000000000 --- a/rt/etc/upgrade/3.3.0/acl.Informix +++ /dev/null @@ -1,4 +0,0 @@ -sub acl { - return (); -} -1; diff --git a/rt/etc/upgrade/3.3.0/acl.Oracle b/rt/etc/upgrade/3.3.0/acl.Oracle deleted file mode 100644 index 73c16ae03..000000000 --- a/rt/etc/upgrade/3.3.0/acl.Oracle +++ /dev/null @@ -1,4 +0,0 @@ -sub acl { - return (); -} -1; diff --git a/rt/etc/upgrade/3.3.0/acl.Pg b/rt/etc/upgrade/3.3.0/acl.Pg deleted file mode 100644 index bd2e36c48..000000000 --- a/rt/etc/upgrade/3.3.0/acl.Pg +++ /dev/null @@ -1,20 +0,0 @@ -sub acl { - my $dbh = shift; - - my @acls; - - my @tables = qw ( - objectcustomfieldvalues - objectcustomfields_id_s - objectcustomfields - ); - - foreach my $table (@tables) { - push @acls, - "GRANT SELECT, INSERT, UPDATE, DELETE ON $table to " - . RT->Config->Get('DatabaseUser') . ";"; - - } - return (@acls); -} -1; diff --git a/rt/etc/upgrade/3.3.0/acl.SQLite b/rt/etc/upgrade/3.3.0/acl.SQLite deleted file mode 100644 index 73c16ae03..000000000 --- a/rt/etc/upgrade/3.3.0/acl.SQLite +++ /dev/null @@ -1,4 +0,0 @@ -sub acl { - return (); -} -1; diff --git a/rt/etc/upgrade/3.3.0/acl.mysql b/rt/etc/upgrade/3.3.0/acl.mysql deleted file mode 100644 index 73c16ae03..000000000 --- a/rt/etc/upgrade/3.3.0/acl.mysql +++ /dev/null @@ -1,4 +0,0 @@ -sub acl { - return (); -} -1; diff --git a/rt/etc/upgrade/3.3.0/content b/rt/etc/upgrade/3.3.0/content deleted file mode 100644 index 0afc6045c..000000000 --- a/rt/etc/upgrade/3.3.0/content +++ /dev/null @@ -1 +0,0 @@ -1; diff --git a/rt/etc/upgrade/3.3.0/schema.Oracle b/rt/etc/upgrade/3.3.0/schema.Oracle deleted file mode 100644 index f81feeb79..000000000 --- a/rt/etc/upgrade/3.3.0/schema.Oracle +++ /dev/null @@ -1,65 +0,0 @@ -alter Table Transactions ADD ObjectType VARCHAR2(64); -UPDATE Transactions set ObjectType = 'RT::Ticket'; -ALTER TABLE Transactions modify ObjectType NOT NULL; -ALTER TABLE Transactions drop column EffectiveTicket; -ALTER TABLE Transactions ADD ReferenceType VARCHAR2(255) NULL; -ALTER TABLE Transactions ADD OldReference NUMBER(11,0) NULL; -ALTER TABLE Transactions ADD NewReference NUMBER(11,0) NULL; -DROP INDEX transactions1; -ALTER TABLE Transactions rename column Ticket to ObjectId; -CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId); - -ALTER TABLE TicketCustomFieldValues rename to ObjectCustomFieldValues; -ALTER TABLE ObjectCustomFieldValues rename column Ticket to ObjectId; -ALTER TABLE ObjectCustomFieldValues ADD ObjectType VARCHAR2(255); -UPDATE ObjectCustomFieldValues set ObjectType = 'RT::Ticket'; -ALTER TABLE ObjectCustomFieldValues MODIFY ObjectType NOT NULL; -ALTER TABLE ObjectCustomFieldValues ADD Disabled NUMBER(11,0); -ALTER TABLE ObjectCustomFieldValues MODIFY Disabled default 0; -UPDATE ObjectCustomFieldValues SET Disabled = 0; -ALTER TABLE ObjectCustomFieldValues MODIFY Disabled NOT NULL; -ALTER TABLE ObjectCustomFieldValues ADD LargeContent CLOB NULL; -ALTER TABLE ObjectCustomFieldValues ADD ContentType VARCHAR2(80) NULL; -ALTER TABLE ObjectCustomFieldValues ADD ContentEncoding VARCHAR2(80) NULL; -ALTER TABLE ObjectCustomFieldValues ADD SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL; - - - -CREATE INDEX ObjectCustomFieldValues1 on ObjectCustomFieldValues (CustomField,ObjectType,ObjectId,Content); -CREATE INDEX ObjectCustomFieldValues2 on ObjectCustomFieldValues (CustomField,ObjectType,ObjectId); - - - -CREATE SEQUENCE OBJECTCUSTOMFIELDS_seq; -CREATE TABLE ObjectCustomFields ( - id NUMBER(11,0) - CONSTRAINT ObjectCustomFields_Key PRIMARY KEY, - CustomField NUMBER(11,0) NOT NULL, - ObjectId NUMBER(11,0) NOT NULL, - SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL, - Creator NUMBER(11,0) DEFAULT 0 NOT NULL, - Created DATE, - LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL, - LastUpdated DATE -); - - -INSERT into ObjectCustomFields (id, CustomField, ObjectId, SortOrder, Creator, LastUpdatedBy) SELECT objectcustomfields_seq.nextval, id, Queue, SortOrder, Creator, LastUpdatedBy from CustomFields; - -ALTER TABLE CustomFields ADD LookupType VARCHAR2(255); -ALTER TABLE CustomFields ADD Repeated NUMBER(11,0); -ALTER TABLE CustomFields ADD Pattern VARCHAR2(255) NULL; -ALTER TABLE CustomFields ADD MaxValues NUMBER(11,0); - -UPDATE CustomFields SET MaxValues = 0 WHERE Type LIKE '%Multiple'; -UPDATE CustomFields SET MaxValues = 1 WHERE Type LIKE '%Single'; -UPDATE CustomFields SET Type = 'Select' WHERE Type LIKE 'Select%'; -UPDATE CustomFields SET Type = 'Freeform' WHERE Type LIKE 'Freeform%'; -UPDATE CustomFields Set LookupType = 'RT::Queue-RT::Ticket'; -ALTER TABLE CustomFields MODIFY LookupType NOT NULL; -UPDATE CustomFields Set Repeated = 0; -ALTER TABLE CustomFields MODIFY Repeated DEFAULT 0; -ALTER TABLE CustomFields MODIFY Repeated NOT NULL; -ALTER TABLE CustomFields drop column Queue; - - diff --git a/rt/etc/upgrade/3.3.0/schema.Pg b/rt/etc/upgrade/3.3.0/schema.Pg deleted file mode 100644 index 427eae798..000000000 --- a/rt/etc/upgrade/3.3.0/schema.Pg +++ /dev/null @@ -1,74 +0,0 @@ -alter Table Transactions ADD Column ObjectType varchar(64); -update Transactions set ObjectType = 'RT::Ticket'; -ALTER TABLE Transactions ALTER COLUMN ObjectType SET NOT NULL; -alter table Transactions drop column EffectiveTicket; -alter table Transactions add column ReferenceType varchar(255) NULL; -alter table Transactions add column OldReference integer NULL; -alter table Transactions add column NewReference integer NULL; -drop index transactions1; -alter table Transactions rename column Ticket to ObjectId; - - -CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId); - -alter table TicketCustomFieldValues rename to ObjectCustomFieldValues; - -alter table ObjectCustomFieldValues rename column Ticket to ObjectId; - -alter table objectcustomfieldvalues add column ObjectType varchar(255); - -update objectcustomfieldvalues set ObjectType = 'RT::Ticket'; - -ALTER TABLE objectcustomfieldvalues ALTER COLUMN ObjectType SET NOT NULL; - -alter table objectcustomfieldvalues add column Current int; - -alter table objectcustomfieldvalues alter column Current SET default 1; - -UPDATE objectcustomfieldvalues SET Current = 1; - -alter table objectcustomfieldvalues add column LargeContent TEXT NULL; - -alter table objectcustomfieldvalues add column ContentType varchar(80) NULL; - -alter table objectcustomfieldvalues add column ContentEncoding varchar(80) NULL; - -create index ObjectCustomFieldValues1 on objectcustomfieldvalues (CustomField,ObjectType,ObjectId,Content); - -create index ObjectCustomFieldValues2 on objectcustomfieldvalues (CustomField,ObjectType,ObjectId); - - -CREATE SEQUENCE objectcustomfields_id_s; - -CREATE TABLE ObjectCustomFields ( - id INTEGER DEFAULT nextval('objectcustomfields_id_s'), - CustomField integer NOT NULL, - ObjectId integer NOT NULL, - SortOrder integer NOT NULL DEFAULT 0 , - - Creator integer NOT NULL DEFAULT 0 , - Created TIMESTAMP NULL , - LastUpdatedBy integer NOT NULL DEFAULT 0 , - LastUpdated TIMESTAMP NULL , - PRIMARY KEY (id) - -); - - -INSERT into ObjectCustomFields (CustomField, ObjectId, SortOrder, Creator, LastUpdatedBy) SELECT id, Queue, SortOrder, Creator, LastUpdatedBy from CustomFields; - -alter table CustomFields add column LookupType varchar(255); -alter table CustomFields add column Repeated int2; -alter table CustomFields add column Pattern varchar(255) NULL; -alter table CustomFields add column MaxValues integer; - -UPDATE CustomFields SET MaxValues = 0 WHERE Type LIKE '%Multiple'; -UPDATE CustomFields SET MaxValues = 1 WHERE Type LIKE '%Single'; -UPDATE CustomFields SET Type = 'Select' WHERE Type LIKE 'Select%'; -UPDATE CustomFields SET Type = 'Freeform' WHERE Type LIKE 'Freeform%'; -UPDATE CustomFields Set LookupType = 'RT::Queue-RT::Ticket'; -ALTER TABLE CustomFields ALTER COLUMN LookupType SET NOT NULL; -UPDATE CustomFields Set Repeated = 0; -ALTER TABLE CustomFields ALTER COLUMN Repeated SET DEFAULT 0; -ALTER TABLE CustomFields ALTER COLUMN Repeated SET NOT NULL; -alter table CustomFields drop column Queue; diff --git a/rt/etc/upgrade/3.3.0/schema.mysql b/rt/etc/upgrade/3.3.0/schema.mysql deleted file mode 100644 index 0e33a2819..000000000 --- a/rt/etc/upgrade/3.3.0/schema.mysql +++ /dev/null @@ -1,65 +0,0 @@ -alter Table Transactions ADD Column (ObjectType varchar(64) not null); -update Transactions set ObjectType = 'RT::Ticket'; -alter table Transactions drop column EffectiveTicket; -alter table Transactions add column ReferenceType varchar(255) NULL; -alter table Transactions add column OldReference integer NULL; -alter table Transactions add column NewReference integer NULL; -alter table Transactions drop index transactions1; -alter table Transactions change Ticket ObjectId integer NOT NULL DEFAULT 0 ; - -CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId); - -alter table TicketCustomFieldValues rename ObjectCustomFieldValues; - -alter table ObjectCustomFieldValues change Ticket ObjectId integer NOT NULL DEFAULT 0 ; - -alter table ObjectCustomFieldValues add column ObjectType varchar(255) not null; - -update ObjectCustomFieldValues set ObjectType = 'RT::Ticket'; - -alter table ObjectCustomFieldValues add column Current bool default 1; - -alter table ObjectCustomFieldValues add column LargeContent LONGTEXT NULL; - -alter table ObjectCustomFieldValues add column ContentType varchar(80) NULL; - -alter table ObjectCustomFieldValues add column ContentEncoding varchar(80) NULL; - -# These could fail if there's no such index and there's no "drop index if exists" syntax -#alter table ObjectCustomFieldValues drop index ticketcustomfieldvalues1; -#alter table ObjectCustomFieldValues drop index ticketcustomfieldvalues2; - -alter table ObjectCustomFieldValues add index ObjectCustomFieldValues1 (Content); - -alter table ObjectCustomFieldValues add index ObjectCustomFieldValues2 (CustomField,ObjectType,ObjectId); - - -CREATE TABLE ObjectCustomFields ( - id INTEGER NOT NULL AUTO_INCREMENT, - CustomField int NOT NULL , - ObjectId integer NOT NULL, - SortOrder integer NOT NULL DEFAULT 0 , - - Creator integer NOT NULL DEFAULT 0 , - Created DATETIME NULL , - LastUpdatedBy integer NOT NULL DEFAULT 0 , - LastUpdated DATETIME NULL , - PRIMARY KEY (id) -) TYPE=InnoDB; - - -INSERT into ObjectCustomFields (id, CustomField, ObjectId, SortOrder, Creator, LastUpdatedBy) SELECT null, id, Queue, SortOrder, Creator, LastUpdatedBy from CustomFields; - -alter table CustomFields add column LookupType varchar(255) NOT NULL; -alter table CustomFields add column Repeated int2 NOT NULL DEFAULT 0 ; -alter table CustomFields add column Pattern varchar(255) NULL; -alter table CustomFields add column MaxValues integer; -# See above -# alter table CustomFields drop index CustomFields1; - -UPDATE CustomFields SET MaxValues = 0 WHERE Type LIKE '%Multiple'; -UPDATE CustomFields SET MaxValues = 1 WHERE Type LIKE '%Single'; -UPDATE CustomFields SET Type = 'Select' WHERE Type LIKE 'Select%'; -UPDATE CustomFields SET Type = 'Freeform' WHERE Type LIKE 'Freeform%'; -UPDATE CustomFields Set LookupType = 'RT::Queue-RT::Ticket'; -alter table CustomFields drop column Queue; |