From e8857f2ae267956136b9f4ee3f3263c11ea2c7ae Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 8 Feb 2012 10:32:44 -0500 Subject: [PATCH] Stamping upgrade for LP#928896 Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...imates.sql => 0675.schema.usr_visible_circ_copies_row_estimates.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.usr_visible_circ_copies_row_estimates.sql => 0675.schema.usr_visible_circ_copies_row_estimates.sql} (84%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 9914d607b8..f596fa28ba 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 ('0674', :eg_version); -- phasefx/Dyrcona/senator +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0675', :eg_version); -- gmc/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.usr_visible_circ_copies_row_estimates.sql b/Open-ILS/src/sql/Pg/upgrade/0675.schema.usr_visible_circ_copies_row_estimates.sql similarity index 84% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.usr_visible_circ_copies_row_estimates.sql rename to Open-ILS/src/sql/Pg/upgrade/0675.schema.usr_visible_circ_copies_row_estimates.sql index a191fb498f..0c7c8e37ed 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.usr_visible_circ_copies_row_estimates.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0675.schema.usr_visible_circ_copies_row_estimates.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0675', :eg_version); + -- set expected row count to low value to avoid problem -- where use of this function by the circ tagging feature -- results in full scans of asset.call_number -- 2.11.0