X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=rt%2Fetc%2Fupgrade%2F3.9.5%2Fschema.mysql;h=83f2f4087febc4ca0672fc407d1df47987d2f510;hb=9aee669886202be7035e6c6049fc71bc99dd3013;hp=fe5018c78f09144d94c69065c1b58b7786d074e7;hpb=0bff2e665b3a6389b47510e4c04a5a454f6dd7d4;p=freeside.git diff --git a/rt/etc/upgrade/3.9.5/schema.mysql b/rt/etc/upgrade/3.9.5/schema.mysql index fe5018c78..83f2f4087 100644 --- a/rt/etc/upgrade/3.9.5/schema.mysql +++ b/rt/etc/upgrade/3.9.5/schema.mysql @@ -6,15 +6,18 @@ 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, +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, +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, +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;