[Digikam-devel] [digikam] [Bug 364131] SCAN : same picture with different file extensions : database scan only finds one variant of the file [patch]

[Richard Mortimer via KDE Bugzilla]

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

--- Comment #14 from Richard Mortimer <richm+kde at oldelvet.org.uk> ---
Changing the collation is the correct thing to do.

Regarding the patch the schema update is required but the v7 to v8 patch needs
to perform an "alter table" command. The update has to assume that the v7
schema is intact and any changes are as specified.

That said before 5.0 is released we need to update the MySQL v7 schema. Whilst
MySQL has never been a stable/supported database the existing 4.x series uses a
base v7 and the existing new database v7 schema has the changes for referential
integrity included. IMHO the v7 to v8 updater should convert the 4.x schema to
the latest schema. Anyone who has been using the 5.x beta series will be able
to "fixup" their schema with a simple version update command. I will dig out my
notes and generate update commands to include in Swati's patch so that the
schema update gets done in a single commit.

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