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

[Richard Mortimer via KDE Bugzilla]

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

--- Comment #24 from Richard Mortimer <richm+kde at oldelvet.org.uk> ---
Created attachment 95755
  --> https://bugs.kde.org/attachment.cgi?id=95755&action=edit
Move Thumbnail database Settings to ThumbSettings for  MySQL

This allows the thumbnail and main image databases to be contained within the
same MySQL database.

Also ensure that thumbnail MySQL tables use the InnoDB storage engine and not
the older MyISAM engine.

I had to change the longtext fields to varchar(767) to stop MySQL complaining
on upgrade. But also note that those same fields have a 255 character long
unique index so in practice anything over 255 characters is likely to cause
problems.

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