From 4d5c6ada5a3dbca18e3abfc6dbbafc62df1d09ef Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 28 Feb 2012 14:36:37 -0500 Subject: [PATCH] Stamping circ limits upgrade script Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../{XXXX.circ_limits.sql => 0677.schema.circ_limits.sql} | 14 ++++++++++++++ 2 files changed, 15 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.circ_limits.sql => 0677.schema.circ_limits.sql} (98%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 9e56f3d04d..739754f143 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -86,7 +86,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 ('0676', :eg_version); -- senator/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0677', :eg_version); -- tsbere/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.circ_limits.sql b/Open-ILS/src/sql/Pg/upgrade/0677.schema.circ_limits.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.circ_limits.sql rename to Open-ILS/src/sql/Pg/upgrade/0677.schema.circ_limits.sql index 59b38f6d0d..c692549570 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.circ_limits.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0677.schema.circ_limits.sql @@ -1,3 +1,14 @@ +-- Evergreen DB patch 0677.schema.circ_limits.sql +-- +-- FIXME: insert description of change, if needed +-- +BEGIN; + + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0677', :eg_version); + +-- FIXME: add/check SQL statements to perform the upgrade -- Limit groups for circ counting CREATE TABLE config.circ_limit_group ( id SERIAL PRIMARY KEY, @@ -315,3 +326,6 @@ DROP FUNCTION evergreen.temp_migrate_circ_mod_limits(); --Drop the old tables --Not sure we want to do this. Keeping them may help "something went wrong" correction. --DROP TABLE IF EXISTS config.circ_matrix_circ_mod_test_map, config.circ_matrix_circ_mod_test; + + +COMMIT; -- 2.11.0