Merge branch 'master' into kcls_dcl53

[evergreen-equinox.git] / Open-ILS / src / sql / Pg / upgrade / 0494.data.search_indexes.sql

diff --git a/Open-ILS/src/sql/Pg/upgrade/0494.data.search_indexes.sql b/Open-ILS/src/sql/Pg/upgrade/0494.data.search_indexes.sql
new file mode 100644 (file)
index 0000000..79ebb44
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/0494.data.search_indexes.sql
@@ -0,0 +1,13 @@
+BEGIN;
+
+INSERT INTO config.upgrade_log (version) VALUES ('0494'); -- dbs
+
+UPDATE config.metabib_field
+    SET xpath = $$//mods32:mods/mods32:subject$$
+    WHERE field_class = 'subject' AND name = 'complete';
+
+UPDATE config.metabib_field
+    SET xpath = $$//marc:datafield[@tag='099']$$
+    WHERE field_class = 'identifier' AND name = 'bibcn';
+
+COMMIT;