[Noalyss-commit] [noalyss] 99/119: Upgrade DB 147

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 410699d8f3f5f94b9b4e6167ec56050d435d058e
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Tue Oct 13 13:35:27 2020 +0200

    Upgrade DB 147
---
 include/constant.php             |  2 +-
 include/sql/patch/upgrade147.sql | 21 +++++++++++++++++++++
 2 files changed, 22 insertions(+), 1 deletion(-)

diff --git a/include/constant.php b/include/constant.php
index 8168e6b..07b2dce 100644
--- a/include/constant.php
+++ b/include/constant.php
@@ -107,7 +107,7 @@ if ( !defined ("NOALYSS_PACKAGE_REPOSITORY")) {
 if ( ! defined ("SYSINFO_DISPLAY")) {
     define ("SYSINFO_DISPLAY",TRUE);
 }
-define ("DBVERSION",147);
+define ("DBVERSION",148);
 define ("MONO_DATABASE",25);
 define ("DBVERSIONREPO",18);
 define ('NOTFOUND','--not found--');
diff --git a/include/sql/patch/upgrade147.sql b/include/sql/patch/upgrade147.sql
new file mode 100644
index 0000000..b2fc79c
--- /dev/null
+++ b/include/sql/patch/upgrade147.sql
@@ -0,0 +1,21 @@
+begin;
+INSERT INTO public.document_option (do_code, document_type_id, do_enable, 
do_option) select 'detail_operation', dt_id, 1, 
+case when dt_id in (2,3,4,5,21) then 'VEN' else 'ACH' end  do_option
+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='detail_operation' )
+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' );
+
+INSERT INTO public.document_option (do_code, document_type_id, do_enable, 
do_option) select 'make_invoice', dt_id, 1, NULL
+from document_type 
+where 
+not exists (select 1 from document_option where document_type_id in (2,4) and 
do_code='make_invoice' )
+and dt_id in (2,4);
+
+insert into version (val,v_description) values (148,'Default values for 
document_option');
+commit;