diff options
Diffstat (limited to 'util/updates/update_20190626.sql')
-rw-r--r-- | util/updates/update_20190626.sql | 7 |
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 |