[Noalyss-commit] [noalyss] 04/28: Task #0001762: TVA France Erreur dans script SQL

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 20601e053f11c11f710d280b5f499a20f602f641
Author: Dany De Bontridder <address@hidden>
Date:   Tue Nov 12 21:23:24 2019 +0100

    Task #0001762: TVA France
    Erreur dans script SQL
---
 include/sql/patch/upgrade138.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/include/sql/patch/upgrade138.sql b/include/sql/patch/upgrade138.sql
index f7e341f..39e5b31 100644
--- a/include/sql/patch/upgrade138.sql
+++ b/include/sql/patch/upgrade138.sql
@@ -1,13 +1,13 @@
 begin;
 ALTER TABLE public.tva_rate ADD tva_payment_sale char(1) NULL DEFAULT 'O';
 update public.tva_rate set tva_payment_sale='O';
-ALTER TABLE public.tva_rate ADD CONSTRAINT tva_rate_sale_check CHECK 
(tva_payment in ('O','P'));
+ALTER TABLE public.tva_rate ADD CONSTRAINT tva_rate_sale_check CHECK 
(tva_payment_sale in ('O','P'));
 comment on column public.tva_rate.tva_payment_sale is 'Check if the VAT on 
Sale  must be declared when at the date of payment (P) or the date of operation 
(O)';
 
 
 ALTER TABLE public.tva_rate ADD tva_payment_purchase char(1) NULL DEFAULT 'O';
 update public.tva_rate set tva_payment_purchase='O';
-ALTER TABLE public.tva_rate ADD CONSTRAINT tva_rate_purchase_check CHECK 
(tva_payment in ('O','P'));
+ALTER TABLE public.tva_rate ADD CONSTRAINT tva_rate_purchase_check CHECK 
(tva_payment_purchase in ('O','P'));
 comment on column public.tva_rate.tva_payment_purchase is 'Check if the VAT on 
Purchase must be declared when at the date of payment (P) or the date of 
operation (O)';