From 2888b409b32cfe541247cc2e39ba23d0e19170c6 Mon Sep 17 00:00:00 2001 From: Kathy Lussier Date: Mon, 22 Aug 2016 14:02:58 -0400 Subject: [PATCH] LP#1613730: Stamping upgrade script for copy count badge Signed-off-by: Kathy Lussier --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../{XXXX.data.copy-count-badge.sql => 0990.data.copy-count-badge.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.copy-count-badge.sql => 0990.data.copy-count-badge.sql} (93%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 3c897abbdd..976361cf6f 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -91,7 +91,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 ('0989', :eg_version); -- berick/miker/gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0990', :eg_version); -- miker/kmlussier CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.copy-count-badge.sql b/Open-ILS/src/sql/Pg/upgrade/0990.data.copy-count-badge.sql similarity index 93% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.copy-count-badge.sql rename to Open-ILS/src/sql/Pg/upgrade/0990.data.copy-count-badge.sql index 84d36da040..ce9d8f0767 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.copy-count-badge.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0990.data.copy-count-badge.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0990', :eg_version); + CREATE OR REPLACE FUNCTION rating.copy_count(badge_id INT) RETURNS TABLE (record INT, value NUMERIC) AS $f$ DECLARE -- 2.11.0