From 7c1cb9a04b4b9b9ff8d372126daf587b28142f95 Mon Sep 17 00:00:00 2001 From: Steven Callender Date: Wed, 27 Feb 2013 16:42:18 -0500 Subject: [PATCH] Added a second no attempt to code to the authority thesaurus for spaces. Signed-off-by: Steven Callender Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 3 ++- .../upgrade/xxxx.data.authority_thesaurus_update.sql | 12 ++++++++++++ 2 files changed, 14 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/xxxx.data.authority_thesaurus_update.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 04fd4e0754..d43f4b9fcd 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -10299,7 +10299,8 @@ INSERT INTO authority.thesaurus (code, name, control_set) VALUES ('s', oils_i18n_gettext('s','Sears List of Subject Headings','at','name'), 1), ('v', oils_i18n_gettext('v','Repertoire de vedettes-matiere','at','name'), 1), ('z', oils_i18n_gettext('z','Other','at','name'), 1), - ('|', oils_i18n_gettext('|','No attempt to code','at','name'), NULL); + ('|', oils_i18n_gettext('|','No attempt to code','at','name'), NULL), + (' ', oils_i18n_gettext(' ','Alternate no attempt to code','at','name'), NULL); INSERT INTO action_trigger.hook ( key, core_type, description, passive ) VALUES ( 'reservation.available', diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.data.authority_thesaurus_update.sql b/Open-ILS/src/sql/Pg/upgrade/xxxx.data.authority_thesaurus_update.sql new file mode 100644 index 0000000000..e5486e7766 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/xxxx.data.authority_thesaurus_update.sql @@ -0,0 +1,12 @@ +-- Evergreen DB patch xxxx.data.authority_thesaurus_update.sql +-- +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('xxxx', :eg_version); + + +INSERT INTO authority.thesaurus (code, name, control_set) VALUES + (' ', oils_i18n_gettext(' ','Alternate no attempt to code','at','name'), NULL); + +COMMIT; -- 2.43.2