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:18:38 +0000 (20:18 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Fri, 1 Oct 2010 20:18:38 +0000 (20:18 +0000)
commit2f76aa0282bf2fb13a1ac297d14547f04db04f26
treefa931ba8ed83207db72639e6cac7b2ea027400d8
parent1fe0c81feff1588fa408c6dd8065182253dfc6af
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_1_6@18129 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/090.schema.action.sql
Open-ILS/src/sql/Pg/1.6.1-1.6.2-upgrade-db.sql