Added a second no attempt to code to the authority thesaurus for spaces.

Signed-off-by: Steven Callender <stevecallender@esilibrary.com>
Signed-off-by: Bill Erickson <berick@esilibrary.com>

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 04fd4e0..d43f4b9 100644 (file)
--- 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 (file)
index 0000000..e5486e7
--- /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;