Set due times for durations measured in days to 23:59:59 after inserts OR updates
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 1 Oct 2010 20:07:59 +0000 (20:07 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 1 Oct 2010 20:07:59 +0000 (20:07 +0000)
commit6e7f1503b9d72e658927974a034f9e1cbf56af18
treecc775109e117225b46f8480093362738e6472a53
parent48035900f3fe1394c36be523bfcb899f859fcca9
Set due times for durations measured in days to 23:59:59 after inserts OR updates

The existing trigger acted only on the initial insert of a circulation
transaction for duration intervals perfectly divisible by 24 hours.
If updates to those due dates were subsequently issued, then the due
time would revert to 00:00:00 - which could cause surprising overdue
fines to be generated on the due date, rather than after the due date.

This commit makes the trigger take effect on both INSERT and UPDATE
to the action.circulation table.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@18126 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/090.schema.action.sql
Open-ILS/src/sql/Pg/upgrade/0424.schema.circ_due_date_trigger.sql [new file with mode: 0644]