rt/etc/upgrade/3.9.5/schema.Pg


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

alter Table CustomFieldValues ADD Column Category varchar(255);

UPDATE CustomFieldValues SET Category = (SELECT Content FROM Attributes WHERE
Name = 'Category' AND  ObjectType = 'RT::CustomFieldValue'
AND CustomFieldValues.id = Attributes.ObjectId);

DELETE FROM Attributes WHERE Name = 'Category' AND ObjectType = 'RT::CustomFieldValue';

ALTER TABLE Groups
    ADD COLUMN Creator integer NOT NULL DEFAULT 0,
    ADD COLUMN Created TIMESTAMP NULL,
    ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
    ADD COLUMN LastUpdated TIMESTAMP NULL;
ALTER TABLE GroupMembers
    ADD COLUMN Creator integer NOT NULL DEFAULT 0,
    ADD COLUMN Created TIMESTAMP NULL,
    ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
    ADD COLUMN LastUpdated TIMESTAMP NULL;
ALTER TABLE ACL
    ADD COLUMN Creator integer NOT NULL DEFAULT 0,
    ADD COLUMN Created TIMESTAMP NULL,
    ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
    ADD COLUMN LastUpdated TIMESTAMP NULL;