[Digikam-devel] [Bug 300920] tags are stored multiple times

Marcel Wiesweg marcel.wiesweg at gmx.de
Thu May 31 19:04:15 BST 2012


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

--- Comment #9 from Marcel Wiesweg <marcel.wiesweg at gmx.de> ---
CREATE TABLE ImageTags
 (imageid INTEGER NOT NULL,
  tagid INTEGER NOT NULL,
  UNIQUE (imageid, tagid));

Any duplicate entry in the database would be violating the table definition.
How do you check the entries? MySQL or SQLite?

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



More information about the Digikam-devel mailing list