Master to 4.2.8
[usit-rt.git] / etc / upgrade / 3.9.5 / schema.mysql
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
c33a4027
MKG
9ALTER TABLE Groups
10 ADD COLUMN Creator integer NOT NULL DEFAULT 0,
01e3b242
MKG
11 ADD COLUMN Created DATETIME NULL,
12 ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
13 ADD COLUMN LastUpdated DATETIME NULL;
c33a4027
MKG
14ALTER TABLE GroupMembers
15 ADD COLUMN Creator integer NOT NULL DEFAULT 0,
01e3b242
MKG
16 ADD COLUMN Created DATETIME NULL,
17 ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
18 ADD COLUMN LastUpdated DATETIME NULL;
c33a4027
MKG
19ALTER TABLE ACL
20 ADD COLUMN Creator integer NOT NULL DEFAULT 0,
01e3b242
MKG
21 ADD COLUMN Created DATETIME NULL,
22 ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
23 ADD COLUMN LastUpdated DATETIME NULL;