[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Noalyss-commit] [noalyss] 99/119: Upgrade DB 147
From: |
Dany De Bontridder |
Subject: |
[Noalyss-commit] [noalyss] 99/119: Upgrade DB 147 |
Date: |
Mon, 26 Oct 2020 18:27:35 -0400 (EDT) |
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;
- [Noalyss-commit] [noalyss] 107/119: Follow-Up : comment optional, (continued)
- [Noalyss-commit] [noalyss] 107/119: Follow-Up : comment optional, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 108/119: fix SQL bug, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 113/119: Bug : create card failed, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 112/119: Cosmetic Follow Up add waiting box for search, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 114/119: Cosmetic & version, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 115/119: Analytic accountancy protect against divide by zero, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 82/119: Follow up search card, add a button to select all , cosmetic add qcode in dialog box for contact option, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 83/119: Bug : from VEN , cannot get the price, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 85/119: Follow-up fix order, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 88/119: Fix bug : follow up option contact are not remove when document type changed, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 99/119: Upgrade DB 147,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 102/119: remove dead code, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 106/119: Filter_Multiselect : make a search on select (multi-row), Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 104/119: Select_Box Add new position : absolute, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 111/119: Follow-Up improve search, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 110/119: Follow Up : an action can have several parents, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 119/119: Tache #0001859: PARAM/CFGDOC : icone fermer + bouton, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 116/119: Modern CheckBox, Dany De Bontridder, 2020/10/26
- [Noalyss-commit] [noalyss] 118/119: Fontello : fix icon-edit, Dany De Bontridder, 2020/10/26