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:11:43 +0000 (20:11 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 1 Oct 2010 20:11:43 +0000 (20:11 +0000)
commit305d19310c2d2bc9c4bea0562fc05bae896e7ffb
tree1a70e402e56db7fd64378c2a58484374c59580a5
parent8b61334eedbf626f54f223344176f09726952244
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/branches/rel_2_0@18127 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/1.6.1-2.0-upgrade-db.sql
Open-ILS/src/sql/Pg/upgrade/0424.schema.circ_due_date_trigger.sql [new file with mode: 0644]