blob: 6ab5d6581d6ae68c3c518d85b1ac2db53a7d9ded (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
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;
|
