JBAS-1378 Purge user activity ; apply transience
authorBill Erickson <berickxx@gmail.com>
Tue, 19 Apr 2016 17:56:33 +0000 (13:56 -0400)
committerBill Erickson <berickxx@gmail.com>
Thu, 21 Mar 2019 19:46:23 +0000 (15:46 -0400)
commit85d063a283c7fea656f6cd9165fc1d1be6c19292
treec09dc36d657545dc043de9091c40666c50ce4f0a
parent0645cd1cc07558e792a1b50f6028272d7fb3826d
JBAS-1378 Purge user activity ; apply transience

Remove all but the most recent actor.usr_activity row per etype and per
user, except keep all of the lynda and hoopla SIP login events.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
KCLS/sql/schema/deploy/purge-user-activity.sql [new file with mode: 0644]
KCLS/sql/schema/revert/purge-user-activity.sql [new file with mode: 0644]
KCLS/sql/schema/sqitch.plan
KCLS/sql/schema/verify/purge-user-activity.sql [new file with mode: 0644]