From 999711d690ed868e65e66615575df3f74deb106a Mon Sep 17 00:00:00 2001 From: dbs Date: Fri, 1 Oct 2010 20:13:10 +0000 Subject: [PATCH] Bring the 1.6.1-2.0 upgrade script up to date for the push_due_date_tgr git-svn-id: svn://svn.open-ils.org/ILS/trunk@18128 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql index b263f2c926..043e66abb3 100644 --- a/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.6.1-2.0-upgrade-db.sql @@ -18598,6 +18598,10 @@ ALTER TABLE vandelay.queued_bib_record ALTER TABLE action.hold_copy_map ALTER COLUMN id SET DATA TYPE bigint; +-- Make due times get pushed to 23:59:59 on insert OR update +DROP TRIGGER push_due_date_tgr ON action.circulation; +CREATE TRIGGER push_due_date_tgr BEFORE INSERT OR UPDATE ON action.circulation FOR EACH ROW EXECUTE PROCEDURE action.push_circ_due_time(); + COMMIT; -- Some operations go outside of the transaction, because they may -- 2.11.0