From 7b69a92ccae933fda13d22709f2ecf424ddb06af Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Tue, 30 Oct 2012 14:58:27 -0400 Subject: [PATCH] SCPL: tweaks to schema upgrade script - keep track of start and end times for the big transaction - no circ grace period Signed-off-by: Galen Charlton --- .../sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql | 6 +++++- 1 files changed, 5 insertions(+), 1 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql index 3638766..d3cb512 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql @@ -1,3 +1,5 @@ +select now(); + -- 0498 -- Rather than polluting the public schema with general Evergreen -- functions, carve out a dedicated schema. It might already exist, @@ -2265,7 +2267,7 @@ UPDATE asset.call_number_class -- Change this to FALSE to disable updating existing circs -- Otherwise will use the fine interval for the grace period -\set CircGrace TRUE +\set CircGrace FALSE -- 0503 -- New Columns @@ -8861,6 +8863,8 @@ INSERT INTO config.upgrade_log (version) VALUES ('0634'); COMMIT; +SELECT NOW(); + --0633 INSERT into config.org_unit_setting_type ( name, grp, label, description, datatype ) VALUES -- 1.7.2.5