summaryrefslogtreecommitdiff
path: root/util/updates/update_20190626.sql
blob: cab7a8a7977c84b594f92f3e885556cf0e917dc8 (plain)
1
2
3
4
5
6
7
8
9
10
11
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