https://bugs.kde.org/show_bug.cgi?id=355831
--- Comment #45 from caulier.gil...@gmail.com --- Git commit 801f835f246b2b2a38a886920056c149dd6894c0 by Gilles Caulier. Committed on 02/12/2015 at 11:04. Pushed by cgilles into branch 'master'. apply patch #95861 to remove trigger dependency for MySQL. Add full referential integrity to AlbumRoots, Albums, Images and Tags tables entries. Provide the equivalent behaviour to the triggers using ON DELETE and ON UPDATE in FOREIGN KEY references. Use dbaction to perform database specific preparation for migration. The MySQL schema has a circular dependency and this must be removed before any leftover contents of the database are removed prior to the migration. No actions are required for SQLite Referential integrity in MySQL does not allow the Albums.icon field to be set prior to the Images table being populated. Use a fake AlbumsExtra table to copy over the icons data. Note we use the same procedure for both SQLite and MySQL to ensure that migration is possible between any combination of databases. M +63 -51 data/database/dbconfig.xml.cmake.in M +12 -0 libs/database/coredb/coredbcopymanager.cpp http://commits.kde.org/digikam/801f835f246b2b2a38a886920056c149dd6894c0 -- You are receiving this mail because: You are watching all bug changes.
