summaryrefslogtreecommitdiff
path: root/rt/etc/upgrade/3.3.11/schema.mysql
diff options
context:
space:
mode:
Diffstat (limited to 'rt/etc/upgrade/3.3.11/schema.mysql')
-rw-r--r--rt/etc/upgrade/3.3.11/schema.mysql5
1 files changed, 5 insertions, 0 deletions
diff --git a/rt/etc/upgrade/3.3.11/schema.mysql b/rt/etc/upgrade/3.3.11/schema.mysql
new file mode 100644
index 000000000..cc35d40f2
--- /dev/null
+++ b/rt/etc/upgrade/3.3.11/schema.mysql
@@ -0,0 +1,5 @@
+ALTER TABLE ObjectCustomFieldValues ADD COLUMN SortOrder INTEGER NOT NULL DEFAULT 0;
+ALTER TABLE ObjectCustomFieldValues ADD COLUMN Disabled int2 NOT NULL DEFAULT 0;
+
+UPDATE ObjectCustomFieldValues SET Disabled = 1 WHERE Current = 0;
+ALTER TABLE ObjectCustomFieldValues DROP COLUMN Current;