diff options
author | Yorhel <git@yorhel.nl> | 2012-01-09 16:49:50 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2012-01-09 16:52:42 +0100 |
commit | 3ea8eef12df3e84645b59301211cd233b6c27a2d (patch) | |
tree | 23f35504543840a955df6318c3a627e44e5a443c /util/updates | |
parent | f5f3d4d5265d172b7489e58ccd92a02bcc99c157 (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.sql | 33 |
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; |