From f08e20eed06e82ea31294e3d1d0940548129c950 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 10 Feb 2017 11:45:12 -0500 Subject: [PATCH] LP#1663663: seed data upgrade script This patch attempts to repair the Full Overlay merge profile in 2.11 and 2.12-masterish databases. Signed-off-by: Galen Charlton Signed-off-by: Kathy Lussier --- .../Pg/upgrade/XXXX.data.fix_full_overlay_vmp.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix_full_overlay_vmp.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix_full_overlay_vmp.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix_full_overlay_vmp.sql new file mode 100644 index 0000000000..cd3537b04c --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix_full_overlay_vmp.sql @@ -0,0 +1,14 @@ +BEGIN; + +-- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +UPDATE vandelay.merge_profile +SET preserve_spec = '901c', + replace_spec = NULL +WHERE id = 2 +AND name = oils_i18n_gettext(2, 'Full Overlay', 'vmp', 'name') +AND preserve_spec IS NULL +AND add_spec IS NULL +AND strip_spec IS NULL +AND replace_spec = '901c'; + +COMMIT; -- 2.43.2