[Noalyss-commit] [noalyss] 11/13: Database upgrade

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 8b8e45c521ea93e7392841f21b93b6bb9b04792f
Author: Dany De Bontridder <address@hidden>
Date:   Sat Jan 12 15:11:35 2019 +0100

    Database upgrade
---
 include/constant.php             |  2 +-
 include/sql/patch/upgrade132.sql | 15 +++++++++++++++
 2 files changed, 16 insertions(+), 1 deletion(-)

diff --git a/include/constant.php b/include/constant.php
index 2eb6daf..d9a458d 100644
--- a/include/constant.php
+++ b/include/constant.php
@@ -108,7 +108,7 @@ if ( !defined ("NOALYSS_PACKAGE_REPOSITORY")) {
 if ( ! defined ("SYSINFO_DISPLAY")) {
     define ("SYSINFO_DISPLAY",TRUE);
 }
-define ("DBVERSION",132);
+define ("DBVERSION",133);
 define ("MONO_DATABASE",25);
 define ("DBVERSIONREPO",18);
 define ('NOTFOUND','--not found--');
diff --git a/include/sql/patch/upgrade132.sql b/include/sql/patch/upgrade132.sql
new file mode 100644
index 0000000..4565200
--- /dev/null
+++ b/include/sql/patch/upgrade132.sql
@@ -0,0 +1,15 @@
+begin;
+insert into "parameter" (pr_id ) values ('MY_DEFAULT_ROUND_ERROR_DEB');
+insert into "parameter" (pr_id ) values ('MY_DEFAULT_ROUND_ERROR_CRED');
+drop view if exists v_all_card_currency;
+
+create or replace view v_all_card_currency as 
+select sum(oc_amount) as sum_oc_amount,sum(oc_vat_amount) as 
sum_oc_vat_amount,f_id,j_id
+from 
+operation_currency
+join jrnx using (j_id)
+group by f_id,j_id;
+
+commit ;
+insert into version (val,v_description) values (133,'Currency : default 
accounting for currency difference  ');
+commit ;
\ No newline at end of file