projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
rt 4.2.13 ticket#13852
[freeside.git]
/
rt
/
etc
/
upgrade
/
3.3.0
/
schema.mysql
diff --git
a/rt/etc/upgrade/3.3.0/schema.mysql
b/rt/etc/upgrade/3.3.0/schema.mysql
index
d8b0499
..
539c50b
100644
(file)
--- 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';
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 ,
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 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 ,
CREATE TABLE ObjectCustomFields (
id INTEGER NOT NULL AUTO_INCREMENT,
CustomField int NOT NULL ,