[usit-rt.git] / etc / upgrade / 3.9.5 / schema.mysql

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 DATETIME NULL,
    ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
    ADD COLUMN LastUpdated DATETIME NULL;
ALTER TABLE GroupMembers ADD COLUMN Creator integer NOT NULL DEFAULT 0,
    ADD COLUMN Created DATETIME NULL,
    ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
    ADD COLUMN LastUpdated DATETIME NULL;
ALTER TABLE ACL ADD COLUMN Creator integer NOT NULL DEFAULT 0,
    ADD COLUMN Created DATETIME NULL,
    ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
    ADD COLUMN LastUpdated DATETIME NULL;
Commit	Line	Data
01e3b242 MKG	1	alter Table CustomFieldValues ADD Column Category varchar(255);
	2
	3	UPDATE CustomFieldValues SET Category = (SELECT Content FROM Attributes WHERE
	4	Name = 'Category' AND ObjectType = 'RT::CustomFieldValue'
	5	AND CustomFieldValues.id = Attributes.ObjectId);
	6
	7	DELETE FROM Attributes WHERE Name = 'Category' AND ObjectType = 'RT::CustomFieldValue';
	8
	9	ALTER TABLE Groups ADD COLUMN Creator integer NOT NULL DEFAULT 0,
	10	ADD COLUMN Created DATETIME NULL,
	11	ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
	12	ADD COLUMN LastUpdated DATETIME NULL;
	13	ALTER TABLE GroupMembers ADD COLUMN Creator integer NOT NULL DEFAULT 0,
	14	ADD COLUMN Created DATETIME NULL,
	15	ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
	16	ADD COLUMN LastUpdated DATETIME NULL;
	17	ALTER TABLE ACL ADD COLUMN Creator integer NOT NULL DEFAULT 0,
	18	ADD COLUMN Created DATETIME NULL,
	19	ADD COLUMN LastUpdatedBy integer NOT NULL DEFAULT 0,
	20	ADD COLUMN LastUpdated DATETIME NULL;