From f7b8ed4b61504272c341be57bd2c2771d0d1479d Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 4 Jun 2018 13:44:20 -0400 Subject: [PATCH] Revert "LP#1764542 - Update older sites to MODS 3.3" This reverts commit 1f4123fbcfc1285f2914ea7ec8bafa34accc572a. --- .../sql/Pg/upgrade/XXXX.schema.lp1764542-mods33-update.sql | 11 ----------- 1 file changed, 11 deletions(-) delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1764542-mods33-update.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1764542-mods33-update.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1764542-mods33-update.sql deleted file mode 100644 index 106407bfcf..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1764542-mods33-update.sql +++ /dev/null @@ -1,11 +0,0 @@ -BEGIN; - -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); - --- Thanks to Bill Ott for sharing his update -UPDATE config.metabib_field SET xpath=regexp_replace(xpath,'mods32','mods33','g') WHERE xpath ~ 'mods32'; -UPDATE config.metabib_field SET format = 'mods33' WHERE format = 'mods32'; -ALTER TABLE config.metabib_field ALTER COLUMN format SET DEFAULT 'mods33'::text; - -COMMIT; - -- 2.11.0