From 6ae2427affb3e6cb8c5f96b2a21530efd6798a70 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 7 Feb 2019 17:40:15 -0500 Subject: [PATCH] LP#1715767 - stamping upgrade scripts Signed-off-by: Chris Sharp --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ma.actor.privacy_waiver.sql => 1144.schema.actor.privacy_waiver.sql} | 2 +- ...in_purge_data.sql => 1145.function.privacy_waiver_in_purge_data.sql} | 2 +- .../{XXXX.data.privacy_waiver.sql => 1146.data.privacy_waiver.sql} | 2 +- 4 files changed, 4 insertions(+), 4 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.actor.privacy_waiver.sql => 1144.schema.actor.privacy_waiver.sql} (88%) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.function.privacy_waiver_in_purge_data.sql => 1145.function.privacy_waiver_in_purge_data.sql} (99%) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.privacy_waiver.sql => 1146.data.privacy_waiver.sql} (90%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index c9685b5380..ad8335b8f4 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -92,7 +92,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 ('1143', :eg_version); -- sandbergja/berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1146', :eg_version); -- jeffdavis/csharp CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.actor.privacy_waiver.sql b/Open-ILS/src/sql/Pg/upgrade/1144.schema.actor.privacy_waiver.sql similarity index 88% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.actor.privacy_waiver.sql rename to Open-ILS/src/sql/Pg/upgrade/1144.schema.actor.privacy_waiver.sql index e79cbec15d..40d37f010a 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.actor.privacy_waiver.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1144.schema.actor.privacy_waiver.sql @@ -1,6 +1,6 @@ BEGIN; -INSERT INTO config.upgrade_log (version) VALUES ('XXXX'); +INSERT INTO config.upgrade_log (version) VALUES ('1144'); CREATE TABLE actor.usr_privacy_waiver ( id BIGSERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.privacy_waiver_in_purge_data.sql b/Open-ILS/src/sql/Pg/upgrade/1145.function.privacy_waiver_in_purge_data.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.function.privacy_waiver_in_purge_data.sql rename to Open-ILS/src/sql/Pg/upgrade/1145.function.privacy_waiver_in_purge_data.sql index 7ff376d755..2f90d2f6bd 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.privacy_waiver_in_purge_data.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1145.function.privacy_waiver_in_purge_data.sql @@ -1,6 +1,6 @@ BEGIN; -INSERT INTO config.upgrade_log (version) VALUES ('XXXX'); +INSERT INTO config.upgrade_log (version) VALUES ('1145'); CREATE OR REPLACE FUNCTION actor.usr_purge_data( src_usr IN INTEGER, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.privacy_waiver.sql b/Open-ILS/src/sql/Pg/upgrade/1146.data.privacy_waiver.sql similarity index 90% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.privacy_waiver.sql rename to Open-ILS/src/sql/Pg/upgrade/1146.data.privacy_waiver.sql index ab8a6c2a13..0645b38e62 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.privacy_waiver.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1146.data.privacy_waiver.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1146', :eg_version); INSERT INTO config.org_unit_setting_type (name, label, description, grp, datatype) -- 2.11.0