summaryrefslogtreecommitdiff
path: root/util/updates
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2012-01-09 16:49:50 +0100
committerYorhel <git@yorhel.nl>2012-01-09 16:52:42 +0100
commit3ea8eef12df3e84645b59301211cd233b6c27a2d (patch)
tree23f35504543840a955df6318c3a627e44e5a443c /util/updates
parentf5f3d4d5265d172b7489e58ccd92a02bcc99c157 (diff)
Added language for Ukrainian
And added an update_2.23.sql file which now also includes the previously added indices. Currently, this update file can be run as often as you want, it doesn't make any noticable changes when you run it on a database that has already been updated. (i.e. I can update the main site without a new release)
Diffstat (limited to 'util/updates')
-rw-r--r--util/updates/update_2.23.sql33
1 files changed, 33 insertions, 0 deletions
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;