From 6c8398db5c57a550e7b14f48a0701b28f0eca840 Mon Sep 17 00:00:00 2001 From: Maik Qualmann Date: Mon, 15 Jan 2018 22:57:11 +0100 Subject: [PATCH 05/32] small fix for the schema update --- data/database/dbconfig.xml.cmake.in | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/data/database/dbconfig.xml.cmake.in b/data/database/dbconfig.xml.cmake.in index 2c5008fe38..a1cd69f487 100644 --- a/data/database/dbconfig.xml.cmake.in +++ b/data/database/dbconfig.xml.cmake.in @@ -2147,7 +2147,7 @@ ADD CONSTRAINT Tags_Images FOREIGN KEY (icon) REFERENCES Images (id) ON DELETE SET NULL ON UPDATE CASCADE, ADD UNIQUE(pid, name(100)), ENGINE InnoDB; - INSERT IGNORE INTO Tags SELECT * FROM Tags_old; + REPLACE INTO Tags SELECT * FROM Tags_old; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'; REPLACE INTO Tags (id, pid, name, icon, iconkde, lft, rgt) VALUES (0, -1, '_Digikam_root_tag_', NULL, NULL, (SELECT MIN(tl.lft) FROM Tags AS tl), -- 2.14.3