[Digikam-devel] [Bug 283323] a new label _Digikam_root_tag_ is created every time

[Dávid Andor]

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





--- Comment #6 from Dávid Andor <david-andor kozpontiagy hu>  2011-10-10 18:05:12 ---
CREATE TABLE `Tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT NULL,
  `name` longtext CHARACTER SET utf8 NOT NULL,
  `icon` int(11) DEFAULT NULL,
  `iconkde` longtext CHARACTER SET utf8,
  `lft` int(11) NOT NULL,
  `rgt` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=latin1


show create table TagsTree;
CREATE ALGORITHM=UNDEFINED DEFINER=`andor`@`localhost` SQL SECURITY DEFINER
VIEW `TagsTree` AS select `Tags`.`id` AS `id`,`Tags`.`pid` AS `pid` from `Tags`

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