[Noalyss-commit] [noalyss] 08/21: Convert upgrade.sql to upgrade202.sql

[dwm]

sparkyx pushed a commit to branch unstable
in repository noalyss.

commit 4e7033b3d1ec8585f6c436f8ebf94f9c1d5176f7
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Fri Dec 6 17:43:23 2024 +0100

    Convert upgrade.sql to upgrade202.sql
---
 include/constant.php                               |  2 +-
 .../sql/patch/upgrade202.sql                       |  8 +++++---
 sql/upgrade.sql                                    | 24 ++--------------------
 3 files changed, 8 insertions(+), 26 deletions(-)

diff --git a/include/constant.php b/include/constant.php
index e81d73934..806867ebb 100644
--- a/include/constant.php
+++ b/include/constant.php
@@ -28,7 +28,7 @@ global $version_noalyss;
 define('NOALYSS_VERSION', 9300 );
 
 // Database schema version 
-define("DBVERSION", 202);
+define("DBVERSION", 203);
 
 // version for MONO_DATABASE
 define("MONO_DATABASE", 25);
diff --git a/sql/upgrade.sql b/include/sql/patch/upgrade202.sql
similarity index 83%
copy from sql/upgrade.sql
copy to include/sql/patch/upgrade202.sql
index 59784c8b5..d183afa61 100644
--- a/sql/upgrade.sql
+++ b/include/sql/patch/upgrade202.sql
@@ -1,5 +1,4 @@
--- change color selected menu
-update parm_appearance set a_value='#000074' where a_code='MENU1-SELECTED' and 
a_value='#7191ea';
+begin;
 
 alter table tva_rate add column tva_reverse_account account_type;
 alter table tva_rate add constraint fk_tva_reverse_account foreign key 
(tva_reverse_account) references tmp_pcmn(pcm_val) on delete set null  on 
update cascade ;
@@ -20,4 +19,7 @@ AS SELECT tva_id,
           tva_both_side,
           tva_payment_purchase,
           tva_payment_sale
-   FROM tva_rate;
\ No newline at end of file
+FROM tva_rate;
+
+insert into version (val,v_description) values (203,'C0TVA force accounting 
for autoreverse VAT');
+commit;
diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index 59784c8b5..bfacd4c4d 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -1,23 +1,3 @@
--- change color selected menu
-update parm_appearance set a_value='#000074' where a_code='MENU1-SELECTED' and 
a_value='#7191ea';
-
-alter table tva_rate add column tva_reverse_account account_type;
-alter table tva_rate add constraint fk_tva_reverse_account foreign key 
(tva_reverse_account) references tmp_pcmn(pcm_val) on delete set null  on 
update cascade ;
-
-comment on column tva_rate.tva_reverse_account is 'Accouting for reversed VAT';
 
-drop VIEW public.v_tva_rate;
-
-CREATE OR REPLACE VIEW public.v_tva_rate
-AS SELECT tva_id,
-          tva_rate,
-          tva_code,
-          tva_label,
-          tva_comment,
-          tva_reverse_account,
-          split_part(tva_poste, ','::text, 1) AS tva_purchase,
-          split_part(tva_poste, ','::text, 2) AS tva_sale,
-          tva_both_side,
-          tva_payment_purchase,
-          tva_payment_sale
-   FROM tva_rate;
\ No newline at end of file
+-- change color selected menu
+update parm_appearance set a_value='#000074' where a_code='MENU1-SELECTED' and 
a_value='#7191ea';
\ No newline at end of file