1 alter Table CustomFieldValues ADD Category varchar2(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';
9 ALTER TABLE Groups ADD(
10 Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
12 LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
15 ALTER TABLE GroupMembers ADD(
16 Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
18 LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,
22 Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
24 LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL,