[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    [digikam] data/database: polish dbconfig.xml
From:       Maik Qualmann <null () kde ! org>
Date:       2017-12-31 16:12:06
Message-ID: E1eVgDW-0003Uy-Ba () code ! kde ! org
[Download RAW message or body]

Git commit 43c793a45c141b3db67b0257a009d1cc2fbf38eb by Maik Qualmann.
Committed on 31/12/2017 at 16:11.
Pushed by mqualmann into branch 'master'.

polish dbconfig.xml

M  +16   -14   data/database/dbconfig.xml.cmake.in

https://commits.kde.org/digikam/43c793a45c141b3db67b0257a009d1cc2fbf38eb

diff --git a/data/database/dbconfig.xml.cmake.in \
b/data/database/dbconfig.xml.cmake.in index 36a07250bb..b58cbf6d2d 100644
--- a/data/database/dbconfig.xml.cmake.in
+++ b/data/database/dbconfig.xml.cmake.in
@@ -1237,22 +1237,24 @@
 
             <dbaction name="CreateTriggers" mode="transaction">
 <!-- Note move_tagstree does not exist for mysql
-            <statement mode="plain">DROP TRIGGER IF EXISTS \
move_tagstree;</statement> +                <statement mode="plain">DROP TRIGGER IF \
                EXISTS move_tagstree;</statement>
 -->
 
-            <statement mode="plain">SELECT 
-                    @minLeft := IF(ISNULL(MIN(lft)), 1, MIN(lft)-1),
-                    @maxRight := IF(ISNULL(MAX(rgt)), 2, MAX(rgt)+1)
-                FROM Tags 
-                WHERE id >= 0 AND pid>=0;
-            </statement>
-            <statement mode="plain">SET @OLD_SQL_MODE=@@SQL_MODE, \
                SQL_MODE='NO_AUTO_VALUE_ON_ZERO';</statement>
-            <statement mode="plain">REPLACE INTO Tags
-                (id, pid, name, icon, iconkde, lft, rgt)
-                VALUES
-                (0, -1, '_Digikam_root_tag_', NULL, NULL, @minLeft, @maxRight )
-            </statement>
-            <statement mode="plain">SET SQL_MODE=@OLD_SQL_MODE;</statement>
+                <statement mode="plain">
+                    SELECT
+                        @minLeft := IF(ISNULL(MIN(lft)), 1, MIN(lft)-1),
+                        @maxRight := IF(ISNULL(MAX(rgt)), 2, MAX(rgt)+1)
+                    FROM Tags
+                    WHERE id >= 0 AND pid >= 0;
+                </statement>
+                <statement mode="plain">SET @OLD_SQL_MODE=@@SQL_MODE, \
SQL_MODE='NO_AUTO_VALUE_ON_ZERO';</statement> +                <statement \
mode="plain"> +                    REPLACE INTO Tags
+                    (id, pid, name, icon, iconkde, lft, rgt)
+                    VALUES
+                    (0, -1, '_Digikam_root_tag_', NULL, NULL, @minLeft, @maxRight);
+                </statement>
+                <statement mode="plain">SET SQL_MODE=@OLD_SQL_MODE;</statement>
             </dbaction>
 
             <dbaction name="checkIfDatabaseExists">


[prev in list] [next in list] [prev in thread] [next in thread]