summaryrefslogtreecommitdiff
path: root/util/updates/update_20190626.sql
diff options
context:
space:
mode:
Diffstat (limited to 'util/updates/update_20190626.sql')
-rw-r--r--util/updates/update_20190626.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/util/updates/update_20190626.sql b/util/updates/update_20190626.sql
index fea09ac0..cab7a8a7 100644
--- a/util/updates/update_20190626.sql
+++ b/util/updates/update_20190626.sql
@@ -2,3 +2,10 @@ ALTER TABLE tags ADD COLUMN searchable boolean NOT NULL DEFAULT TRUE;
ALTER TABLE tags ADD COLUMN applicable boolean NOT NULL DEFAULT TRUE;
UPDATE tags SET searchable = NOT meta, applicable = NOT meta;
ALTER TABLE tags DROP COLUMN meta;
+
+ALTER TABLE traits ADD COLUMN searchable boolean NOT NULL DEFAULT TRUE;
+ALTER TABLE traits ADD COLUMN applicable boolean NOT NULL DEFAULT TRUE;
+UPDATE traits SET searchable = NOT meta, applicable = NOT meta;
+ALTER TABLE traits DROP COLUMN meta;
+
+-- NOTE: Be sure to run util/sql/func.sql