From 0cbc35b72615a56ed8ad9a0dd0dd89261111b0dd Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Tue, 18 Aug 2015 23:06:39 -0400 Subject: [PATCH] LP#1419172: Stamping upgrade script for optimizing full circ count Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ..._circ_count.sql => 0927.schema.optimize_full_circ_count.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.optimize_full_circ_count.sql => 0927.schema.optimize_full_circ_count.sql} (85%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 6110f7d482..3b00fb8949 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 ('0926', :eg_version); -- dpearl/kmlussier/bshum +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0927', :eg_version); -- dbwells/csharp/bshum CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.optimize_full_circ_count.sql b/Open-ILS/src/sql/Pg/upgrade/0927.schema.optimize_full_circ_count.sql similarity index 85% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.optimize_full_circ_count.sql rename to Open-ILS/src/sql/Pg/upgrade/0927.schema.optimize_full_circ_count.sql index 6440dfad37..f1651e09d0 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.optimize_full_circ_count.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0927.schema.optimize_full_circ_count.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0927', :eg_version); CREATE OR REPLACE VIEW extend_reporter.full_circ_count AS SELECT cp.id, -- 2.43.2