From 7bdfe9f5a2e8771c481bf8e15ad7da350b654533 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 24 Aug 2016 14:55:29 -0400 Subject: [PATCH] Stamping upgrade script for badge seed data Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ity-badge-seed-data.sql => 0995.data.popularity-badge-seed-data.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.popularity-badge-seed-data.sql => 0995.data.popularity-badge-seed-data.sql} (88%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index d696bf5480..d0fc23aeb2 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 ('0994', :eg_version); -- berick/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0995', :eg_version); -- kmlussier/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.popularity-badge-seed-data.sql b/Open-ILS/src/sql/Pg/upgrade/0995.data.popularity-badge-seed-data.sql similarity index 88% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.popularity-badge-seed-data.sql rename to Open-ILS/src/sql/Pg/upgrade/0995.data.popularity-badge-seed-data.sql index 61f911856f..fe9ea27de1 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.popularity-badge-seed-data.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0995.data.popularity-badge-seed-data.sql @@ -1,6 +1,6 @@ BEGIN; --SELECT evergreen.upgrade_deps_block_check('xxxx', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0995', :eg_version); INSERT INTO rating.badge (name, description, scope, weight, horizon_age, importance_age, importance_interval, importance_scale, recalc_interval, popularity_parameter, percentile) VALUES('Top Holds Over Last 5 Years', 'The top 97th percentile for holds requested over the past five years on all materials. More weight is given to holds requested over the last year, with importance decreasing for every year after that.', 1, 3, '5 years', '5 years', '1 year', 2, '1 day', 2, 97); -- 2.11.0