summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-10-31 16:15:30 +0100
committerYorhel <git@yorhel.nl>2010-10-31 16:15:30 +0100
commitb4b9284ddd4d5e4b1829b87612fbb77e8e6c5d7c (patch)
treeaab2f6608f5b1a194f50f787fdf87ec46a07edfa /util
parentf386ea11c7f7e7250ee68f0e2271d9c2eaa10605 (diff)
Added 1024x576 and 1280x800 screen resolutions
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;
+