Bug 13667

Summary: Provide script to regularly clean deletedborrowers table
Product: Koha Reporter: Katrin Fischer <katrin.fischer>
Component: DatabaseAssignee: Jonathan Druart <jonathan.druart>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: fiona.borthwick, fridolin.somers, george, jonathan.druart, magnus, nick
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19008
Change sponsored?: Sponsored Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Bug Depends on:    
Bug Blocks: 18081    

Description Katrin Fischer 2015-02-04 17:10:22 UTC
Currently when a patron record is deleted in Koha the information in the table borrowers is moved to the table deletedborrowers. 

But Koha currently provides no way to clean up the table deletedborrowers regularly. The data is kept forever or has to be deleted via SQL.

We should provide a script that checks for a timestamp (see bug 8926) and deletes data older than x days. It might also be desirable to offer an option to never save data into the deletedborrowers table.
Comment 1 Katrin Fischer 2018-01-12 11:52:28 UTC
This is quite a big privacy issue. If a patron asks for his data to be deleted, it should be deleted. Keeping it might even be against law in some contexts.
Comment 2 Fridolin Somers 2018-04-16 10:40:49 UTC
Bug 19008 adds an option on cron job cleanup_database.pl
Comment 3 Jonathan Druart 2020-02-14 10:51:38 UTC
Done on bug 19008.

*** This bug has been marked as a duplicate of bug 19008 ***