diff options
author | Yorhel <git@yorhel.nl> | 2009-07-19 14:44:11 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-07-19 14:44:11 +0200 |
commit | 09869c785d57b20b2ff4346a53476a8f8efac6da (patch) | |
tree | 4c75b9212fc61d206bfdaf47a6544feadc5b26ea | |
parent | f5e5f2ce1fd955793420fd62d663d54983e7facc (diff) |
Added 1024x600 and 1600x1200 screen resolutions
-rw-r--r-- | ChangeLog | 3 | ||||
-rw-r--r-- | data/global.pl | 2 | ||||
-rw-r--r-- | util/updates/update_2.6.sql | 7 |
3 files changed, 11 insertions, 1 deletions
@@ -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 |