[Noalyss-commit] [noalyss] 108/119: fix SQL bug

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 46c253706892d24f0233a6c55ed1cc2c0a8dbd7b
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Wed Oct 14 17:38:05 2020 +0200

    fix SQL bug
---
 include/sql/patch/upgrade147.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/include/sql/patch/upgrade147.sql b/include/sql/patch/upgrade147.sql
index b2fc79c..5828d3e 100644
--- a/include/sql/patch/upgrade147.sql
+++ b/include/sql/patch/upgrade147.sql
@@ -9,7 +9,8 @@ and dt_id in (2,3,4,5,10,20,21);
 
 INSERT INTO public.document_option (do_code, document_type_id, do_enable, 
do_option) select  'contact_multiple',dt_id , 1, NULL
 from document_type where 
-not exists (select 1 from document_option where document_type_id in 
(2,3,4,5,10,20) and do_code='contact_multiple' );
+not exists (select 1 from document_option where document_type_id in 
(2,3,4,5,10,20) and do_code='contact_multiple' )
+and dt_id in (2,3,4,5,10,20) ;
 
 INSERT INTO public.document_option (do_code, document_type_id, do_enable, 
do_option) select 'make_invoice', dt_id, 1, NULL
 from document_type