https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20271
Benjamin Rokseth <benjamin.roks...@deichman.no> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #73759|0 |1 is obsolete| | --- Comment #48 from Benjamin Rokseth <benjamin.roks...@deichman.no> --- Created attachment 74127 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=74127&action=edit Bug 20271: merging delete biblio/items The present bug merges the following tables: deletedbiblio -> biblio deletedbiblioitems -> biblioitems deletedbiblio_metadata -> biblio_metadata deleteditems -> items and adds a column deleted_at to signify time of deletion, if deleted it replaces all occurrences of the mentioned occurences and uses of mentioned deleted* tables upgrade is handled by moving rows from deleted* tables to the live ones. If all rows are moved, the corresponding tables are dropped. If there are duplicates or conflicts (duplicate barcodes e.g.) they reminders are left for scrutiny and table renamed to _deleted* Test plan: 1) Make sure you have a db with at least a few deleted biblios, biblioitems and items. 2) Apply patch and run updatedatabase.pl 3) Make note of the db upgrade messages, if you get a message like: There were x deleteditems that could not be moved, please check _deleteditems you should check the _deleteditems table and verify that they are actual conflicts 4) Click around in the web interface and make sure you can delete items and biblios 5) "Undelete" an item by NULLing the deleted_at column for an item and verify that it returns in interface (Not neccessary really) -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/