https://bugs.kde.org/show_bug.cgi?id=355831
swatilodh...@gmail.com changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |swatilodh...@gmail.com --- Comment #63 from swatilodh...@gmail.com --- Hello Richard. I'm Swati, currently working on digiKam MySQL database support project. I read this open bug for MySQL Schema improvements and thought of a plausible solution to handle the tags (rename, move or delete) An image can have many tags and a tag can belong to multiple image. So to handle this many-many relationship between the two, we could take use of the following tables: Table: Image Columns: Image_ID, Image_Title Table: Tag Columns: Tag_ID, Tag_Title Table: Image_Tag Columns: Tag_ID, Image_ID Setting the Image_ID and Tag_ID as foreign keys would help in linking the tables. Maybe this will help. Regards Swati -- You are receiving this mail because: You are watching all bug changes.