diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/updates/update_2.12.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/update_2.12.sql b/util/updates/update_2.12.sql index 4d3dc4a4..febb508b 100644 --- a/util/updates/update_2.12.sql +++ b/util/updates/update_2.12.sql @@ -7,3 +7,8 @@ ALTER TABLE vn ADD COLUMN c_search text; 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; + |