From e3fd5900b8743458c48876a87304087c1d4c025f Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 16 Aug 2011 11:14:58 -0400 Subject: [PATCH] Stamped upgrade scripts for LP#790329 Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/upgrade/0602.schema.lp790329_opac_copy_count.sql | 2 +- ...opac_lasso_counts.sql => 0603.schema.lp790329_opac_lasso_counts.sql} | 2 +- ...asso_counts.sql => 0604.schema.lp790329_staff_opac_lasso_counts.sql} | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.lp790329_opac_lasso_counts.sql => 0603.schema.lp790329_opac_lasso_counts.sql} (95%) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.lp790329_staff_opac_lasso_counts.sql => 0604.schema.lp790329_staff_opac_lasso_counts.sql} (95%) diff --git a/Open-ILS/src/sql/Pg/upgrade/0602.schema.lp790329_opac_copy_count.sql b/Open-ILS/src/sql/Pg/upgrade/0602.schema.lp790329_opac_copy_count.sql index fe805531d7..98782717eb 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0602.schema.lp790329_opac_copy_count.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0602.schema.lp790329_opac_copy_count.sql @@ -1,4 +1,4 @@ -- Placeholder for 2.0-only changes -SELECT evergreen.upgrade_deps_block_check('0601', :eg_version); +INSERT INTO config.upgrade_log (version) VALUES ('0602'); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.lp790329_opac_lasso_counts.sql b/Open-ILS/src/sql/Pg/upgrade/0603.schema.lp790329_opac_lasso_counts.sql similarity index 95% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.lp790329_opac_lasso_counts.sql rename to Open-ILS/src/sql/Pg/upgrade/0603.schema.lp790329_opac_lasso_counts.sql index da3241eac1..ae25bcefd7 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.lp790329_opac_lasso_counts.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0603.schema.lp790329_opac_lasso_counts.sql @@ -7,7 +7,7 @@ BEGIN; -- check whether patch can be applied -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +INSERT INTO config.upgrade_log (version) VALUES ('0603'); -- FIXME: add/check SQL statements to perform the upgrade CREATE OR REPLACE FUNCTION asset.opac_lasso_record_copy_count (i_lasso INT, rid BIGINT) RETURNS TABLE (depth INT, org_unit INT, visible BIGINT, available BIGINT, unshadow BIGINT, transcendant INT) AS $f$ diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.lp790329_staff_opac_lasso_counts.sql b/Open-ILS/src/sql/Pg/upgrade/0604.schema.lp790329_staff_opac_lasso_counts.sql similarity index 95% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.lp790329_staff_opac_lasso_counts.sql rename to Open-ILS/src/sql/Pg/upgrade/0604.schema.lp790329_staff_opac_lasso_counts.sql index 70b81ac232..7053c8c98d 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.lp790329_staff_opac_lasso_counts.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0604.schema.lp790329_staff_opac_lasso_counts.sql @@ -6,7 +6,7 @@ BEGIN; -- check whether patch can be applied -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +INSERT INTO config.upgrade_log (version) VALUES ('0604'); CREATE OR REPLACE FUNCTION asset.staff_lasso_record_copy_count (i_lasso INT, rid BIGINT) RETURNS TABLE (depth INT, org_unit INT, visible BIGINT, available BIGINT, unshadow BIGINT, transcendant INT) AS $f$ DECLARE -- 2.11.0