blob: 288d1c33a3638375a90697254dc8e447cf2e9080 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
-- 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();
-- two new resolutions have been added, array indexes have changed
UPDATE releases_rev SET resolution = resolution + 1 WHERE resolution >= 7;
UPDATE releases_rev SET resolution = resolution + 1 WHERE resolution >= 11;
|