1 alter Table CustomFieldValues ADD Column Category varchar(255);
3 UPDATE CustomFieldValues SET Category = (SELECT Content FROM Attributes WHERE
4 Name = 'Category' AND ObjectType = 'RT::CustomFieldValue'
5 AND CustomFieldValues.id = Attributes.ObjectId);
7 DELETE FROM Attributes WHERE Name = 'Category' AND ObjectType = 'RT::CustomFieldValue';
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;
14 ALTER 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;
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;