LP#1570909 User activity purge function
authorBill Erickson <berickxx@gmail.com>
Fri, 15 Apr 2016 20:26:57 +0000 (16:26 -0400)
committerBill Erickson <berickxx@gmail.com>
Fri, 15 Apr 2016 20:26:59 +0000 (16:26 -0400)
commit325ab171dee3508476e6c9b9aecdec26a6297513
tree9f29a17c8cd1acd1fb2ecc826e9f86f76a1b7db9
parent5f5a6b785076cd97c10b43bf717b8bf8bd49c1e7
LP#1570909 User activity purge function

Utility function for removing all activity entries by activity type,
except for the most recent entry per user.  This is primarily useful
when cleaning up rows prior to setting the transient flag on an
activity type to true.  It allows for immediate cleanup of data (e.g.
for patron privacy) and lets admins control when the data is deleted,
which could be useful for huge activity tables.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.usr_activity_transient.sql