diff options
| -rw-r--r-- | Makefile | 4 | ||||
| -rw-r--r-- | data/global.pl | 2 | ||||
| -rw-r--r-- | data/lang.txt | 8 | ||||
| -rw-r--r-- | data/style.css | 1 | ||||
| -rw-r--r-- | static/f/icons.png | bin | 12719 -> 12770 bytes | |||
| -rw-r--r-- | util/sql/all.sql | 2 | ||||
| -rw-r--r-- | util/updates/update_2.23.sql | 33 |
7 files changed, 48 insertions, 2 deletions
@@ -195,3 +195,7 @@ update-2.22: all ${runpsql} < util/updates/update_2.22.sql $(multi-start) +update-2.23: all + $(multi-stop) + ${runpsql} < util/updates/update_2.23.sql + $(multi-start) diff --git a/data/global.pl b/data/global.pl index 2d838ec2..ab293dd3 100644 --- a/data/global.pl +++ b/data/global.pl @@ -33,7 +33,7 @@ our %S = (%S, cv_size => [ 256, 400 ], # max. w*h of cover images # bit flags (TODO: completely merge charedit into edit) permissions => {qw| board 1 boardmod 2 edit 4 charedit 4 tag 16 dbmod 32 tagmod 64 usermod 128 affiliate 256 |}, - languages => [qw|cs da de en es fi fr hu it ja ko nl no pl pt-br pt-pt ru sk sv tr vi zh|], + languages => [qw|cs da de en es fi fr hu it ja ko nl no pl pt-br pt-pt ru sk sv tr uk vi zh|], producer_types => [qw|co in ng|], discussion_boards => [qw|an db ge v p u|], # <- note that some properties of these boards are hard-coded vn_lengths => [ 0..5 ], diff --git a/data/lang.txt b/data/lang.txt index f8b0f2f3..e238e352 100644 --- a/data/lang.txt +++ b/data/lang.txt @@ -266,6 +266,14 @@ hu : Török nl : Turks de : Türkisch +:_lang_uk +en : Ukrainian +ru*: +cs*: +hu*: +nl : Oekraïens +de*: + :_lang_vi en : Vietnamese ru : Вьетнамский diff --git a/data/style.css b/data/style.css index ecb8bb42..6d9c1c53 100644 --- a/data/style.css +++ b/data/style.css @@ -844,6 +844,7 @@ a .icons { cursor: pointer } .icons.ja { background-position: -48px -88px; } .icons.hu { background-position: -48px -99px; } .icons.pt-br { background-position: -48px -110px; } +.icons.uk { background-position: -48px -121px; } .icons.nl { background-position: -61px 0px; } .icons.no { background-position: -61px -11px; } diff --git a/static/f/icons.png b/static/f/icons.png Binary files differindex ad3dec18..8c3c1135 100644 --- a/static/f/icons.png +++ b/static/f/icons.png diff --git a/util/sql/all.sql b/util/sql/all.sql index bb5829f7..ce1ab914 100644 --- a/util/sql/all.sql +++ b/util/sql/all.sql @@ -9,7 +9,7 @@ CREATE TYPE char_role AS ENUM ('main', 'primary', 'side', 'appears'); CREATE TYPE dbentry_type AS ENUM ('v', 'r', 'p', 'c'); CREATE TYPE edit_rettype AS (iid integer, cid integer, rev integer); CREATE TYPE gender AS ENUM ('unknown', 'm', 'f', 'b'); -CREATE TYPE language AS ENUM ('cs', 'da', 'de', 'en', 'es', 'fi', 'fr', 'hu', 'it', 'ja', 'ko', 'nl', 'no', 'pl', 'pt-pt', 'pt-br', 'ru', 'sk', 'sv', 'tr', 'vi', 'zh'); +CREATE TYPE language AS ENUM ('cs', 'da', 'de', 'en', 'es', 'fi', 'fr', 'hu', 'it', 'ja', 'ko', 'nl', 'no', 'pl', 'pt-pt', 'pt-br', 'ru', 'sk', 'sv', 'tr', 'uk', 'vi', 'zh'); CREATE TYPE medium AS ENUM ('cd', 'dvd', 'gdr', 'blr', 'flp', 'mrt', 'mem', 'umd', 'nod', 'in', 'otc'); CREATE TYPE notification_ntype AS ENUM ('pm', 'dbdel', 'listdel', 'dbedit', 'announce'); CREATE TYPE notification_ltype AS ENUM ('v', 'r', 'p', 'c', 't'); diff --git a/util/updates/update_2.23.sql b/util/updates/update_2.23.sql new file mode 100644 index 00000000..ed419d16 --- /dev/null +++ b/util/updates/update_2.23.sql @@ -0,0 +1,33 @@ +-- Two extra indices for performance + +CREATE INDEX releases_producers_rid ON releases_producers (rid); +CREATE INDEX tags_vn_vid ON tags_vn (vid); + + + +-- Extra language for ukrainian + +ALTER TYPE language RENAME TO language_old; +CREATE TYPE language AS ENUM ('cs', 'da', 'de', 'en', 'es', 'fi', 'fr', 'hu', 'it', 'ja', 'ko', 'nl', 'no', 'pl', 'pt-pt', 'pt-br', 'ru', 'sk', 'sv', 'tr', 'uk', 'vi', 'zh'); +ALTER TABLE producers_rev ALTER COLUMN lang DROP DEFAULT; +ALTER TABLE producers_rev ALTER COLUMN lang TYPE language USING lang::text::language; +ALTER TABLE producers_rev ALTER COLUMN lang SET DEFAULT 'ja'; + +ALTER TABLE releases_lang ALTER COLUMN lang TYPE language USING lang::text::language; + +ALTER TABLE vn ALTER COLUMN c_languages DROP DEFAULT; +DROP TRIGGER vn_relgraph_notify ON vn; +ALTER TABLE vn ALTER COLUMN c_languages TYPE language[] USING c_languages::text[]::language[]; +CREATE TRIGGER vn_relgraph_notify AFTER UPDATE ON vn FOR EACH ROW + WHEN (OLD.rgraph IS DISTINCT FROM NEW.rgraph + OR OLD.latest IS DISTINCT FROM NEW.latest + OR OLD.c_released IS DISTINCT FROM NEW.c_released + OR OLD.c_languages IS DISTINCT FROM NEW.c_languages + ) EXECUTE PROCEDURE vn_relgraph_notify(); +ALTER TABLE vn ALTER COLUMN c_languages SET DEFAULT '{}'; + +ALTER TABLE vn ALTER COLUMN c_olang DROP DEFAULT; +ALTER TABLE vn ALTER COLUMN c_olang TYPE language[] USING c_olang::text[]::language[]; +ALTER TABLE vn ALTER COLUMN c_olang SET DEFAULT '{}'; + +DROP TYPE language_old; |
