summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
Diffstat (limited to 'util')
-rw-r--r--util/updates/update_2.12.sql5
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;
+