diff options
Diffstat (limited to 'rt/etc/upgrade')
21 files changed, 19 insertions, 39 deletions
diff --git a/rt/etc/upgrade/3.3.0/schema.Oracle b/rt/etc/upgrade/3.3.0/schema.Oracle index f81feeb79..9d77a12c9 100644 --- a/rt/etc/upgrade/3.3.0/schema.Oracle +++ b/rt/etc/upgrade/3.3.0/schema.Oracle @@ -7,7 +7,6 @@ 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; @@ -24,12 +23,6 @@ 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) diff --git a/rt/etc/upgrade/3.3.0/schema.Pg b/rt/etc/upgrade/3.3.0/schema.Pg index 427eae798..0c2ad543d 100644 --- a/rt/etc/upgrade/3.3.0/schema.Pg +++ b/rt/etc/upgrade/3.3.0/schema.Pg @@ -9,8 +9,6 @@ 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; @@ -33,10 +31,6 @@ 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; diff --git a/rt/etc/upgrade/3.3.0/schema.mysql b/rt/etc/upgrade/3.3.0/schema.mysql index d8b04991e..539c50bce 100644 --- a/rt/etc/upgrade/3.3.0/schema.mysql +++ b/rt/etc/upgrade/3.3.0/schema.mysql @@ -9,7 +9,6 @@ alter Table Transactions CHANGE Ticket ObjectId integer NOT NULL DEFAULT 0; UPDATE Transactions set ObjectType = 'RT::Ticket'; -CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId); alter table TicketCustomFieldValues rename ObjectCustomFieldValues, change Ticket ObjectId integer NOT NULL DEFAULT 0 , @@ -25,10 +24,6 @@ update ObjectCustomFieldValues set ObjectType = 'RT::Ticket'; #alter table ObjectCustomFieldValues drop index ticketcustomfieldvalues1; #alter table ObjectCustomFieldValues drop index ticketcustomfieldvalues2; -alter table ObjectCustomFieldValues add index ObjectCustomFieldValues1 (Content), - add index ObjectCustomFieldValues2 (CustomField,ObjectType,ObjectId); - - CREATE TABLE ObjectCustomFields ( id INTEGER NOT NULL AUTO_INCREMENT, CustomField int NOT NULL , diff --git a/rt/etc/upgrade/3.7.81/schema.Oracle b/rt/etc/upgrade/3.7.81/schema.Oracle deleted file mode 100644 index 02da4ece9..000000000 --- a/rt/etc/upgrade/3.7.81/schema.Oracle +++ /dev/null @@ -1,2 +0,0 @@ -CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (MemberId, ImmediateParentId); - diff --git a/rt/etc/upgrade/3.7.81/schema.mysql b/rt/etc/upgrade/3.7.81/schema.mysql deleted file mode 100644 index 02da4ece9..000000000 --- a/rt/etc/upgrade/3.7.81/schema.mysql +++ /dev/null @@ -1,2 +0,0 @@ -CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (MemberId, ImmediateParentId); - diff --git a/rt/etc/upgrade/3.8-ical-extension.in b/rt/etc/upgrade/3.8-ical-extension.in index 928888fa2..f4df8ec55 100644 --- a/rt/etc/upgrade/3.8-ical-extension.in +++ b/rt/etc/upgrade/3.8-ical-extension.in @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) diff --git a/rt/etc/upgrade/3.8.3/schema.Pg b/rt/etc/upgrade/3.8.3/schema.Pg deleted file mode 100644 index bbe55365d..000000000 --- a/rt/etc/upgrade/3.8.3/schema.Pg +++ /dev/null @@ -1,3 +0,0 @@ - -CREATE UNIQUE INDEX GroupMembers1 ON GroupMembers(GroupId, MemberId); - diff --git a/rt/etc/upgrade/4.0-customfield-checkbox-extension b/rt/etc/upgrade/4.0-customfield-checkbox-extension index a83ac3e14..abd85306a 100755 --- a/rt/etc/upgrade/4.0-customfield-checkbox-extension +++ b/rt/etc/upgrade/4.0-customfield-checkbox-extension @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) diff --git a/rt/etc/upgrade/4.0-customfield-checkbox-extension.in b/rt/etc/upgrade/4.0-customfield-checkbox-extension.in index b3d466e73..8ca22c81f 100644 --- a/rt/etc/upgrade/4.0-customfield-checkbox-extension.in +++ b/rt/etc/upgrade/4.0-customfield-checkbox-extension.in @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) diff --git a/rt/etc/upgrade/4.0.1/content b/rt/etc/upgrade/4.0.1/content index cc3b5f14a..851c50291 100644 --- a/rt/etc/upgrade/4.0.1/content +++ b/rt/etc/upgrade/4.0.1/content @@ -50,6 +50,11 @@ our @Initial = ( sub { RT->Logger->debug('Removing all Delegate and PersonalGroup rights'); + # this temporarily tells the system that the rights exist so it can properly canonicalize them + RT::System->AddRight(Admin => AdminOwnPersonalGroups => 'Add right for 4.0.1 upgrade steps'); + RT::System->AddRight(Admin => AdminAllPersonalGroups => 'Add right for 4.0.1 upgrade steps'); + RT::System->AddRight(Admin => DelegateRights => 'Add right for 4.0.1 upgrade steps'); + my $acl = RT::ACL->new(RT->SystemUser); for my $right (qw/AdminOwnPersonalGroups AdminAllPersonalGroups DelegateRights/) { $acl->Limit( FIELD => 'RightName', VALUE => $right ); diff --git a/rt/etc/upgrade/generate-rtaddressregexp.in b/rt/etc/upgrade/generate-rtaddressregexp.in index 3cdd5a60e..043b21af5 100644 --- a/rt/etc/upgrade/generate-rtaddressregexp.in +++ b/rt/etc/upgrade/generate-rtaddressregexp.in @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) diff --git a/rt/etc/upgrade/sanity-check-stylesheets.in b/rt/etc/upgrade/sanity-check-stylesheets.in index 510abf7db..5fe128826 100644 --- a/rt/etc/upgrade/sanity-check-stylesheets.in +++ b/rt/etc/upgrade/sanity-check-stylesheets.in @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) diff --git a/rt/etc/upgrade/shrink-cgm-table.in b/rt/etc/upgrade/shrink-cgm-table.in index 8654271b9..172a40ac5 100644 --- a/rt/etc/upgrade/shrink-cgm-table.in +++ b/rt/etc/upgrade/shrink-cgm-table.in @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) diff --git a/rt/etc/upgrade/shrink-transactions-table.in b/rt/etc/upgrade/shrink-transactions-table.in index 8eea6edcd..c16795723 100644 --- a/rt/etc/upgrade/shrink-transactions-table.in +++ b/rt/etc/upgrade/shrink-transactions-table.in @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) diff --git a/rt/etc/upgrade/split-out-cf-categories.in b/rt/etc/upgrade/split-out-cf-categories.in index 6faf29c9e..800274c60 100644 --- a/rt/etc/upgrade/split-out-cf-categories.in +++ b/rt/etc/upgrade/split-out-cf-categories.in @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) diff --git a/rt/etc/upgrade/switch-templates-to.in b/rt/etc/upgrade/switch-templates-to.in index 384d8f710..e745223ce 100644 --- a/rt/etc/upgrade/switch-templates-to.in +++ b/rt/etc/upgrade/switch-templates-to.in @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) diff --git a/rt/etc/upgrade/time-worked-history.in b/rt/etc/upgrade/time-worked-history.in index fe216fa22..c9c4ebdc1 100644 --- a/rt/etc/upgrade/time-worked-history.in +++ b/rt/etc/upgrade/time-worked-history.in @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) diff --git a/rt/etc/upgrade/upgrade-articles b/rt/etc/upgrade/upgrade-articles index a3852dfb3..1b430cb35 100755 --- a/rt/etc/upgrade/upgrade-articles +++ b/rt/etc/upgrade/upgrade-articles @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) diff --git a/rt/etc/upgrade/upgrade-articles.in b/rt/etc/upgrade/upgrade-articles.in index 742fd17dc..837e20f2c 100644 --- a/rt/etc/upgrade/upgrade-articles.in +++ b/rt/etc/upgrade/upgrade-articles.in @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) diff --git a/rt/etc/upgrade/upgrade-mysql-schema.pl b/rt/etc/upgrade/upgrade-mysql-schema.pl index 92d18e358..690ec01e9 100755 --- a/rt/etc/upgrade/upgrade-mysql-schema.pl +++ b/rt/etc/upgrade/upgrade-mysql-schema.pl @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) diff --git a/rt/etc/upgrade/vulnerable-passwords.in b/rt/etc/upgrade/vulnerable-passwords.in index 1ccf0a180..39c3483cb 100755 --- a/rt/etc/upgrade/vulnerable-passwords.in +++ b/rt/etc/upgrade/vulnerable-passwords.in @@ -3,7 +3,7 @@ # # COPYRIGHT: # -# This software is Copyright (c) 1996-2015 Best Practical Solutions, LLC +# This software is Copyright (c) 1996-2016 Best Practical Solutions, LLC # <sales@bestpractical.com> # # (Except where explicitly superseded by other copyright notices) |