[Digikam-devel] [digikam] [Bug 355831] MySQL Schema Improvements

[Richard Mortimer via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=355831

--- Comment #67 from Richard Mortimer <richm+kde at oldelvet.org.uk> ---
Apart from testing and fixing issues I am aware of the following tasks that
need completing for MySQL support.

1) Test and refine the "Experiment with TagsTree tables" patch to ensure that
it maintains the tags tree correctly.
2) Add a migration script to upgrade existing MySQL databases with the
referential integrity patches.
3) Look at image, album and tag rename, move and delete. The existing SQL
assumes too many magic "0" values and intermediate steps where referential
integrity would be broken.
4) Write unit tests for the various database operations. This should help with
the above steps.

-- 
You are receiving this mail because:
You are the assignee for the bug.