diff options
Diffstat (limited to 'rt/etc/upgrade/3.3.11/schema.Pg')
-rw-r--r-- | rt/etc/upgrade/3.3.11/schema.Pg | 11 |
1 files changed, 0 insertions, 11 deletions
diff --git a/rt/etc/upgrade/3.3.11/schema.Pg b/rt/etc/upgrade/3.3.11/schema.Pg deleted file mode 100644 index 6ab5d6581..000000000 --- a/rt/etc/upgrade/3.3.11/schema.Pg +++ /dev/null @@ -1,11 +0,0 @@ -ALTER TABLE ObjectCustomFieldValues ADD COLUMN SortOrder INTEGER; -UPDATE ObjectCustomFieldValues SET SortOrder = 0; -ALTER TABLE ObjectCustomFieldValues ALTER COLUMN SortOrder SET DEFAULT 0; -ALTER TABLE ObjectCustomFieldValues ALTER COLUMN SortOrder SET NOT NULL; -ALTER TABLE ObjectCustomFieldValues ADD COLUMN Disabled INTEGER; -UPDATE ObjectCustomFieldValues SET Disabled = 1 WHERE Current = 0; -UPDATE ObjectCustomFieldValues SET Disabled = 0 WHERE Current != 0; -ALTER TABLE ObjectCustomFieldValues ALTER COLUMN Disabled SET DEFAULT 0; -ALTER TABLE ObjectCustomFieldValues ALTER COLUMN Disabled SET NOT NULL; - -ALTER TABLE ObjectCustomFieldValues DROP COLUMN Current; |