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.Pg
diff --git
a/rt/etc/upgrade/3.3.0/schema.Pg
b/rt/etc/upgrade/3.3.0/schema.Pg
index
427eae7
..
0c2ad54
100644
(file)
--- 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;
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 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;
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 SEQUENCE objectcustomfields_id_s;