From 29c687bff71c2530adeaaf2bdfbfa1ea565ba5e5 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Wed, 28 Sep 2016 13:18:12 +0100
Subject: [PATCH] Bug 8995: Add IGNORE to the INSERT statement

Signed-off-by: Magnus Enger <magnus@libriotech.no>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
---
 installer/data/mysql/atomicupdate/8995_OpenURL_sysprefs.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/installer/data/mysql/atomicupdate/8995_OpenURL_sysprefs.sql b/installer/data/mysql/atomicupdate/8995_OpenURL_sysprefs.sql
index 262347256f..ff70900e3e 100644
--- a/installer/data/mysql/atomicupdate/8995_OpenURL_sysprefs.sql
+++ b/installer/data/mysql/atomicupdate/8995_OpenURL_sysprefs.sql
@@ -1,4 +1,4 @@
-INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES
+INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES
   ('OpenURLResolverURL', '', 'URL of OpenURL Resolver', NULL, 'Free'),
   ('OpenURLText', '', 'Text of OpenURL links (or image title if OpenURLImageLocation is defined)', NULL, 'Free'),
   ('OpenURLImageLocation', '', 'Location of image for OpenURL links', NULL, 'Free'),
-- 
2.39.5