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

[e.longuemare at laposte.net]

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

--- Comment #33 from e.longuemare at laposte.net ---
Diff between /usr/share/kde4/apps/database/dbconfig.xml in my digikam database
conf file and the dbconfig.xml given by Francesco :
1 / /usr/share/kde4/apps/database/dbconfig.xml
2 /  dbconfig.xml given by Francesco 

line 908 :
1 / CREATE PROCEDURE create_index_if_not_exists(table_name_vc varchar(50),
index_name_vc varchar(50), field_list_vc varchar(1024))
2 / CREATE PROCEDURE create_index_if_not_exists(table_name_vc varchar(50),
index_name_vc varchar(50), field_list_vc varchar(1024), is_unique int)
line 924 :
1 / CONVERT( ' ADD INDEX ' USING latin1),
2 /  CONVERT( IF(is_unique = 0, ' ADD INDEX ', ' ADD UNIQUE INDEX ') USING
latin1),
line 936 to 950 :
1/
<statement mode="plain">CALL
create_index_if_not_exists('Images','dir_index','album');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('Images','hash_index','uniqueHash');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageTags','tag_index','tagid');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageTags','tag_id_index','imageid');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('Images','image_name_index','name(996)');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageInformation','creationdate_index','creationDate');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageComments','comments_imageid_index','imageid');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageCopyright','copyright_imageid_index','imageid');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageHistory','uuid_index','uuid');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageRelations','subject_relations_index','subject');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageRelations','object_relations_index','object');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('TagProperties','tagproperties_index','tagid');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageTagProperties','imagetagproperties_index','imageid,
tagid');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageTagProperties','imagetagproperties_imageid_index','imageid');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageTagProperties','imagetagproperties_tagid_index','tagid');</statement>
2 / 
<statement mode="plain">CALL
create_index_if_not_exists('Images','dir_index','album', 0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('Images','hash_index','uniqueHash', 0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageTags','tag_index','tagid', 0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageTags','tag_id_index','imageid',
0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('Images','image_name_index','name(996)',
0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageInformation','creationdate_index','creationDate',
0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageComments','comments_imageid_index','imageid',
0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageCopyright','copyright_imageid_index','imageid',
0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageHistory','uuid_index','uuid', 0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageRelations','subject_relations_index','subject',
0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageRelations','object_relations_index','object',
0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('TagProperties','tagproperties_index','tagid',
0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageTagProperties','imagetagproperties_index','imageid,
tagid', 0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageTagProperties','imagetagproperties_imageid_index','imageid',
0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('ImageTagProperties','imagetagproperties_tagid_index','tagid',
0);</statement>

line 989  + one more line for 2 (not in 1):
1 /  <statement mode="plain">SET @OLD_SQL_MODE=@@SQL_MODE,
SQL_MODE='NO_AUTO_VALUE_ON_ZERO';</statement>
2 / <statement mode="plain">SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO';</statement>
            <statement mode="plain">UPDATE tags SET pid = 0 WHERE pid < 0
AND id > 0;</statement>

line 995 :
1 / <statement mode="plain">SET SQL_MODE=@OLD_SQL_MODE;</statement>
2 / not in Francesco File

line 1236 :
1 /CREATE PROCEDURE create_index_if_not_exists(table_name_vc varchar(50),
index_name_vc varchar(50), field_list_vc varchar(1024))
2 / CREATE PROCEDURE create_index_if_not_exists(table_name_vc varchar(50),
index_name_vc varchar(50), field_list_vc varchar(1024), is_unique int)

line 1252 :
1 / CONVERT( ' ADD INDEX ' USING latin1),
2 / CONVERT( IF(is_unique = 0, ' ADD INDEX ', ' ADD UNIQUE INDEX ') USING
latin1),

line 1264 to 1266 :
1 /
<statement mode="plain">CALL
create_index_if_not_exists('UniqueHashes','id_uniqueHashes','thumbId');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('FilePaths','id_filePaths','thumbId');</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('CustomIdentifiers','id_customIdentifiers','thumbId');</statement>
2 /
<statement mode="plain">CALL
create_index_if_not_exists('UniqueHashes','id_uniqueHashes','thumbId',
0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('FilePaths','id_filePaths','thumbId',
0);</statement>
                <statement mode="plain">CALL
create_index_if_not_exists('CustomIdentifiers','id_customIdentifiers','thumbId',
0);</statement>

line 1493 :
1 / not in file
2 / <statement mode="plain">CALL
create_index_if_not_exists('Tags','name_pid_index','name(128), pid',
1);</statement>

Greatings,
Eric

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