From 6d94067f076785499a1ffaf60dce193aa57f0a41 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 25 May 2017 09:24:24 -0400 Subject: [PATCH] LP#1498155: stamp DB update Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...T_CIRC_MISSING.sql => 1041.data.remove_SET_CIRC_MISSING.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.remove_SET_CIRC_MISSING.sql => 1041.data.remove_SET_CIRC_MISSING.sql} (80%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index c8f34197ac..f8091f09e3 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -90,7 +90,7 @@ CREATE TRIGGER no_overlapping_deps BEFORE INSERT OR UPDATE ON config.db_patch_dependencies FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates'); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1040', :eg_version); --gmcharlt/berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1041', :eg_version); -- stompro/csharp/gmcharlt CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.sql b/Open-ILS/src/sql/Pg/upgrade/1041.data.remove_SET_CIRC_MISSING.sql similarity index 80% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.sql rename to Open-ILS/src/sql/Pg/upgrade/1041.data.remove_SET_CIRC_MISSING.sql index faa2a6bbcd..8113f89ee0 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1041.data.remove_SET_CIRC_MISSING.sql @@ -1,5 +1,7 @@ BEGIN; +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1041', :eg_version); -- stompro/csharp/gmcharlt + --delete all instances from permission.grp_perm_map first DELETE FROM permission.grp_perm_map where perm in (select id from permission.perm_list where code='SET_CIRC_MISSING'); -- 2.43.2