[Koha-bugs] [Bug 20271] Merge deletedbiblio* and deleteitems tables with their "alive" cousins

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20271

Jon Knight <J.P.Knight at lboro.ac.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |J.P.Knight at lboro.ac.uk

--- Comment #12 from Jon Knight <J.P.Knight at lboro.ac.uk> ---
Just a random thought to throw into this: would it be worth creating database
views to replicate the old tables based on the new ones?  That way if any
installations have pre-existing reports that use the old tables in their
queries, they will still continue to work.

For example something like this:

CREATE VIEW old_issues AS SELECT * FROM issues WHERE deleted_at IS NOT NULL;

-- 
You are receiving this mail because:
You are watching all bug changes.