summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2009-07-19 14:44:11 +0200
committerYorhel <git@yorhel.nl>2009-07-19 14:44:11 +0200
commit09869c785d57b20b2ff4346a53476a8f8efac6da (patch)
tree4c75b9212fc61d206bfdaf47a6544feadc5b26ea
parentf5e5f2ce1fd955793420fd62d663d54983e7facc (diff)
Added 1024x600 and 1600x1200 screen resolutions
-rw-r--r--ChangeLog3
-rw-r--r--data/global.pl2
-rw-r--r--util/updates/update_2.6.sql7
3 files changed, 11 insertions, 1 deletions
diff --git a/ChangeLog b/ChangeLog
index 37bce03f..c5e713f2 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,6 @@
+2.6 - ?
+ - New screen resolutions: 1024x600 and 1600x1200
+
2.5 - 2009-07-09
- Hide NSFW images in diff viewer (unless NSFW warnings are disabled)
- Display related boards in recent posts tooltip op homepage
diff --git a/data/global.pl b/data/global.pl
index 92f52e71..83cb42fd 100644
--- a/data/global.pl
+++ b/data/global.pl
@@ -210,7 +210,9 @@ our %S = (%S,
[ '640x480 (480p)', '4:3' ],
[ '800x600', '4:3' ],
[ '1024x768', '4:3' ],
+ [ '1600x1200', '4:3' ],
[ '640x400', 'widescreen' ],
+ [ '1024x600', 'widescreen' ],
[ '1024x640', 'widescreen' ],
[ '1280x720 (720p)', 'widescreen' ],
[ '1920x1080 (1080p)', 'widescreen' ],
diff --git a/util/updates/update_2.6.sql b/util/updates/update_2.6.sql
index 723e7c57..e8f4e9b4 100644
--- a/util/updates/update_2.6.sql
+++ b/util/updates/update_2.6.sql
@@ -43,6 +43,12 @@ ALTER TABLE screenshots ALTER COLUMN processed SET DEFAULT FALSE;
+-- two new resolutions have been added, array indexes have changed
+UPDATE releases_rev SET resolution = resolution + 1 WHERE resolution >= 5;
+UPDATE releases_rev SET resolution = resolution + 1 WHERE resolution >= 7;
+
+
+
-- automatically insert rows into the anime table for unknown aids
-- when inserted into vn_anime
CREATE OR REPLACE FUNCTION vn_anime_aid() RETURNS trigger AS $$
@@ -70,7 +76,6 @@ $$ LANGUAGE plpgsql;
CREATE TRIGGER anime_fetch_notify AFTER INSERT OR UPDATE ON anime FOR EACH ROW EXECUTE PROCEDURE anime_fetch_notify();
-
-- Send a notify when a new cover image is uploaded
CREATE OR REPLACE FUNCTION vn_rev_image_notify() RETURNS trigger AS $$
BEGIN