From dddb70dff3d508b673d12b169fb41ca0473c6f9e Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Mon, 29 Aug 2016 15:37:48 -0400 Subject: [PATCH] LP#1618183: Add Spanish to config.i18n_locale Add Spanish to this table so that it is an option for supported translations. Signed-off-by: Ben Shum Signed-off-by: Dan Wells --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 3 +++ .../upgrade/XXXX.data.add-spanish-to-i18n-locale.sql | 11 +++++++++++ 2 files changed, 14 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.add-spanish-to-i18n-locale.sql diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index 2c45a7bc25..e029263de2 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -360,6 +360,9 @@ INSERT INTO config.i18n_locale (code,marc_code,name,description) INSERT INTO config.i18n_locale (code,marc_code,name,description) VALUES ('hy-AM', 'arm', oils_i18n_gettext('hy-AM', 'Armenian', 'i18n_l', 'name'), oils_i18n_gettext('hy-AM', 'Armenian', 'i18n_l', 'description')); +INSERT INTO config.i18n_locale (code,marc_code,name,description) + VALUES ('es-ES', 'spa', oils_i18n_gettext('es-ES', 'Spanish', 'i18n_l', 'name'), + oils_i18n_gettext('es-ES', 'Spanish', 'i18n_l', 'description')); --INSERT INTO config.i18n_locale (code,marc_code,name,description) -- VALUES ('es-US', 'spa', oils_i18n_gettext('es-US', 'Spanish (US)', 'i18n_l', 'name'), -- oils_i18n_gettext('es-US', 'American Spanish', 'i18n_l', 'description')); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.add-spanish-to-i18n-locale.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.add-spanish-to-i18n-locale.sql new file mode 100644 index 0000000000..1263431f08 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.add-spanish-to-i18n-locale.sql @@ -0,0 +1,11 @@ +-- Add Spanish to config.i18n_locale table + +BEGIN; + +--SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT INTO config.i18n_locale (code,marc_code,name,description) + VALUES ('es-ES', 'spa', oils_i18n_gettext('es-ES', 'Spanish', 'i18n_l', 'name'), + oils_i18n_gettext('es-ES', 'Spanish', 'i18n_l', 'description')); + +COMMIT; -- 2.43.2