Upgrade to 4.2.8
[usit-rt.git] / etc / upgrade / 3.9.5 / schema.Pg
CommitLineData
01e3b242
MKG
1alter Table CustomFieldValues ADD Column Category varchar(255);
2
3UPDATE CustomFieldValues SET Category = (SELECT Content FROM Attributes WHERE
4Name = 'Category' AND ObjectType = 'RT::CustomFieldValue'
5AND CustomFieldValues.id = Attributes.ObjectId);
6
7DELETE FROM Attributes WHERE Name = 'Category' AND ObjectType = 'RT::CustomFieldValue';
8
3ffc5f4f
MKG
9ALTER TABLE Groups
10 ADD COLUMN Creator integer NOT NULL DEFAULT 0,
11 ADD COLUMN Created TIMESTAMP NULL,
12 ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
13 ADD COLUMN LastUpdated TIMESTAMP NULL;
14ALTER TABLE GroupMembers
15 ADD COLUMN Creator integer NOT NULL DEFAULT 0,
16 ADD COLUMN Created TIMESTAMP NULL,
17 ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
18 ADD COLUMN LastUpdated TIMESTAMP NULL;
19ALTER TABLE ACL
20 ADD COLUMN Creator integer NOT NULL DEFAULT 0,
21 ADD COLUMN Created TIMESTAMP NULL,
22 ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
23 ADD COLUMN LastUpdated TIMESTAMP NULL;