https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20271
--- Comment #13 from Francesco Rivetti <[email protected]> --- (In reply to Jon Knight from comment #12) > 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; I thought about it, but you most likely need the view for "issues" than "old_issues", which means: RENAME TABLE issues TO all_issues; CREATE VIEW issues AS SELECT * FROM issues WHERE delted_at IS NULL; but then, more code will need to be changed for updates/insert/deletes OTOH, most reports UNION issues with old_issues, might be smart to take this opportunity to simplify them? (note, this applies to deleteditems/biblios as well) -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] 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/
