diff options
Diffstat (limited to 'rt/etc/upgrade/3.3.11/schema.mysql')
-rw-r--r-- | rt/etc/upgrade/3.3.11/schema.mysql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/rt/etc/upgrade/3.3.11/schema.mysql b/rt/etc/upgrade/3.3.11/schema.mysql index cc35d40f2..eff84783f 100644 --- a/rt/etc/upgrade/3.3.11/schema.mysql +++ b/rt/etc/upgrade/3.3.11/schema.mysql @@ -1,5 +1,5 @@ -ALTER TABLE ObjectCustomFieldValues ADD COLUMN SortOrder INTEGER NOT NULL DEFAULT 0; -ALTER TABLE ObjectCustomFieldValues ADD COLUMN Disabled int2 NOT NULL DEFAULT 0; +ALTER TABLE ObjectCustomFieldValues ADD COLUMN SortOrder INTEGER NOT NULL DEFAULT 0, + ADD COLUMN Disabled int2 NOT NULL DEFAULT 0; UPDATE ObjectCustomFieldValues SET Disabled = 1 WHERE Current = 0; ALTER TABLE ObjectCustomFieldValues DROP COLUMN Current; |