From 80352dab5f33c691017b555fcf48323eb69b73bc Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Wed, 5 Jul 2017 11:36:32 +0200 Subject: use if not exists clause to not error if the index was already there --- install/update.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install/update.php') diff --git a/install/update.php b/install/update.php index 1406f2d1b..d3a726f6b 100644 --- a/install/update.php +++ b/install/update.php @@ -2920,7 +2920,7 @@ function update_r1191() { ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;" ); - $r14 = q("CREATE UNIQUE INDEX path_property ON propertystorage (path(600), name(100));"); + $r14 = q("CREATE UNIQUE INDEX if not exists path_property ON propertystorage (path(600), name(100));"); $r15 = q("CREATE TABLE if not exists users ( id INTEGER UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, -- cgit v1.2.3