From a3a7f12c626fd999a2ca0ab8f8dcec28a23dca0a Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 6 Mar 2013 13:54:35 -0500 Subject: [PATCH] Upgrade script for LP#1105225: LOC z39.50 seed data Signed-off-by: Bill Erickson Signed-off-by: Ben Shum --- .../src/sql/Pg/upgrade/XXXX.data.loc_z39_settings.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.loc_z39_settings.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.loc_z39_settings.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.loc_z39_settings.sql new file mode 100644 index 0000000000..20a39b7086 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.loc_z39_settings.sql @@ -0,0 +1,18 @@ + +BEGIN; + +UPDATE config.z3950_source + SET host = 'lx2.loc.gov', port = 210, db = 'LCDB' + WHERE name = 'loc' + AND host = 'z3950.loc.gov' + AND port = 7090 + AND db = 'Voyager'; + +UPDATE config.z3950_attr + SET format = 6 + WHERE source = 'loc' + AND name = 'lccn' + AND format = 1; + +COMMIT; + -- 2.11.0