From b5e13c8060288681fb6760da97d65928253fa957 Mon Sep 17 00:00:00 2001
From: Kathy Lussier <klussier@masslnc.org>
Date: Fri, 1 Sep 2017 16:05:08 -0400
Subject: [PATCH 1/1] LP#1638299: Stamping upgrade scripts for authority
 infrastructure work

Signed-off-by: Kathy Lussier <klussier@masslnc.org>
---
 Open-ILS/src/sql/Pg/002.schema.config.sql                       | 2 +-
 .../{XXX1.data.MADS21-xsl.sql => 1068.data.MADS21-xsl.sql}      | 2 ++
 .../{XXX2.schema.authority.sql => 1069.schema.authority.sql}    | 2 ++
 .../{XXX3.schema.thesauri.sql => 1070.schema.thesauri.sql}      | 2 ++
 ...hema.browse_uses_ahf.sql => 1071.schema.browse_uses_ahf.sql} | 2 ++
 ...5.data.add_seealso_cgf.sql => 1072.data.add_seealso_cgf.sql} | 2 ++
 6 files changed, 11 insertions(+), 1 deletion(-)
 rename Open-ILS/src/sql/Pg/upgrade/{XXX1.data.MADS21-xsl.sql => 1068.data.MADS21-xsl.sql} (99%)
 rename Open-ILS/src/sql/Pg/upgrade/{XXX2.schema.authority.sql => 1069.schema.authority.sql} (99%)
 rename Open-ILS/src/sql/Pg/upgrade/{XXX3.schema.thesauri.sql => 1070.schema.thesauri.sql} (99%)
 rename Open-ILS/src/sql/Pg/upgrade/{XXX4.schema.browse_uses_ahf.sql => 1071.schema.browse_uses_ahf.sql} (99%)
 rename Open-ILS/src/sql/Pg/upgrade/{XXX5.data.add_seealso_cgf.sql => 1072.data.add_seealso_cgf.sql} (77%)

diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index ad1dd7c65e..2b1f288a91 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 ('1067', :eg_version); -- berick/gmcharlt/miker
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1072', :eg_version); -- gmcharlt/kmlussier
 
 CREATE TABLE config.bib_source (
 	id		SERIAL	PRIMARY KEY,
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXX1.data.MADS21-xsl.sql b/Open-ILS/src/sql/Pg/upgrade/1068.data.MADS21-xsl.sql
similarity index 99%
rename from Open-ILS/src/sql/Pg/upgrade/XXX1.data.MADS21-xsl.sql
rename to Open-ILS/src/sql/Pg/upgrade/1068.data.MADS21-xsl.sql
index a2e8e8e16b..d51b8ea756 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXX1.data.MADS21-xsl.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/1068.data.MADS21-xsl.sql
@@ -1,5 +1,7 @@
 BEGIN;
 
+SELECT evergreen.upgrade_deps_block_check('1068', :eg_version); --miker/gmcharlt/kmlussier
+
 INSERT INTO config.xml_transform (name,namespace_uri,prefix,xslt) VALUES ('mads21','http://www.loc.gov/mads/v2','mads21',$XSLT$<?xml version="1.0" encoding="UTF-8"?>
 <xsl:stylesheet version="1.0" xmlns:mads="http://www.loc.gov/mads/v2"
 	xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:marc="http://www.loc.gov/MARC21/slim"
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXX2.schema.authority.sql b/Open-ILS/src/sql/Pg/upgrade/1069.schema.authority.sql
similarity index 99%
rename from Open-ILS/src/sql/Pg/upgrade/XXX2.schema.authority.sql
rename to Open-ILS/src/sql/Pg/upgrade/1069.schema.authority.sql
index 584912ee39..8d2c586f82 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXX2.schema.authority.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/1069.schema.authority.sql
@@ -1,5 +1,7 @@
 BEGIN;
 
+SELECT evergreen.upgrade_deps_block_check('1069', :eg_version); --gmcharlt/kmlussier
+
 -- subset of types listed in https://www.loc.gov/marc/authority/ad1xx3xx.html
 -- for now, ignoring subdivisions
 CREATE TYPE authority.heading_type AS ENUM (
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXX3.schema.thesauri.sql b/Open-ILS/src/sql/Pg/upgrade/1070.schema.thesauri.sql
similarity index 99%
rename from Open-ILS/src/sql/Pg/upgrade/XXX3.schema.thesauri.sql
rename to Open-ILS/src/sql/Pg/upgrade/1070.schema.thesauri.sql
index 7b121a61bd..bd8d01c6eb 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXX3.schema.thesauri.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/1070.schema.thesauri.sql
@@ -1,5 +1,7 @@
 BEGIN;
 
+SELECT evergreen.upgrade_deps_block_check('1070', :eg_version); --miker/gmcharlt/kmlussier
+
 CREATE TRIGGER thes_code_tracking_trigger
     AFTER UPDATE ON authority.thesaurus
     FOR EACH ROW EXECUTE PROCEDURE oils_i18n_code_tracking('at');
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXX4.schema.browse_uses_ahf.sql b/Open-ILS/src/sql/Pg/upgrade/1071.schema.browse_uses_ahf.sql
similarity index 99%
rename from Open-ILS/src/sql/Pg/upgrade/XXX4.schema.browse_uses_ahf.sql
rename to Open-ILS/src/sql/Pg/upgrade/1071.schema.browse_uses_ahf.sql
index 7678acde48..b95527a3bb 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXX4.schema.browse_uses_ahf.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/1071.schema.browse_uses_ahf.sql
@@ -1,5 +1,7 @@
 BEGIN;
 
+SELECT evergreen.upgrade_deps_block_check('1071', :eg_version); --gmcharlt/kmlussier
+
 CREATE OR REPLACE FUNCTION metabib.staged_browse(query text, fields integer[], context_org integer, context_locations integer[], staff boolean, browse_superpage_size integer, count_up_from_zero boolean, result_limit integer, next_pivot_pos integer)
  RETURNS SETOF metabib.flat_browse_entry_appearance
 AS $f$
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXX5.data.add_seealso_cgf.sql b/Open-ILS/src/sql/Pg/upgrade/1072.data.add_seealso_cgf.sql
similarity index 77%
rename from Open-ILS/src/sql/Pg/upgrade/XXX5.data.add_seealso_cgf.sql
rename to Open-ILS/src/sql/Pg/upgrade/1072.data.add_seealso_cgf.sql
index f5f6049d68..f877b81a78 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXX5.data.add_seealso_cgf.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/1072.data.add_seealso_cgf.sql
@@ -1,5 +1,7 @@
 BEGIN;
 
+SELECT evergreen.upgrade_deps_block_check('1072', :eg_version); --gmcharlt/kmlussier
+
 INSERT INTO config.global_flag (name, label, enabled) VALUES (
     'opac.show_related_headings_in_browse',
     oils_i18n_gettext(
-- 
2.43.2