summaryrefslogtreecommitdiff
path: root/util/updates/update_2.12.sql
blob: 4d3dc4a49da0e5512f2105c66a2ef9b3c56ad34b (plain)
1
2
3
4
5
6
7
8
9

-- cache for search
ALTER TABLE vn ADD COLUMN c_search text;

\i util/sql/func.sql

CREATE TRIGGER vn_vnsearch_notify         AFTER  UPDATE           ON vn            FOR EACH ROW EXECUTE PROCEDURE vn_vnsearch_notify();
CREATE TRIGGER vn_vnsearch_notify         AFTER  UPDATE           ON releases      FOR EACH ROW EXECUTE PROCEDURE vn_vnsearch_notify();