[Digikam-devel] [Bug 258409] Tags and TagsTree table is empty after DB migration from sqlite to mysql

[Francesco Riosa]

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





--- Comment #14 from Francesco Riosa <francesco pnpitalia it>  2011-05-09 00:57:03 ---
note to self:
ALTER TABLE albumroots DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE albums DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE customidentifiers DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE downloadhistory DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE filepaths DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE imagecomments DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE imagecopyright DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE imagehaarmatrix DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE imagehistory DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE imageinformation DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE imagemetadata DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE imagepositions DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE imageproperties DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE imagerelations DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE images DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE imagetagproperties DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE imagetags DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE searches DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE settings DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE tagproperties DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE tags DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE tagstree DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE thumbnails DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
ALTER TABLE uniquehashes DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
or similar

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.