[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r5651 - phpcompta/tags/rel671/html/admin/sql/patch
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r5651 - phpcompta/tags/rel671/html/admin/sql/patch |
Date: |
Wed, 8 Jan 2014 21:51:40 +0100 (CET) |
Author: danydb
Date: 2014-01-08 21:51:40 +0100 (Wed, 08 Jan 2014)
New Revision: 5651
Modified:
phpcompta/tags/rel671/html/admin/sql/patch/upgrade112.sql
Log:
Task #960 - TVA ND & comptabilit?\195?\169 analytique
TVA ND is now in the Analytic accountancy
The Analytic Accountancy can work with negative amount
Fix problem with update script
Modified: phpcompta/tags/rel671/html/admin/sql/patch/upgrade112.sql
===================================================================
--- phpcompta/tags/rel671/html/admin/sql/patch/upgrade112.sql 2014-01-08
20:48:44 UTC (rev 5650)
+++ phpcompta/tags/rel671/html/admin/sql/patch/upgrade112.sql 2014-01-08
20:51:40 UTC (rev 5651)
@@ -3,6 +3,9 @@
ALTER TABLE operation_analytique ADD COLUMN oa_jrnx_id_source bigint;
COMMENT ON COLUMN operation_analytique.oa_jrnx_id_source IS 'jrnx.j_id source
of this amount, this amount is computed from an amount giving a ND VAT.Normally
NULL is there is no ND VAT.';
+ALTER TABLE operation_analytique ADD COLUMN oa_signed character(1);
+ALTER TABLE operation_analytique ALTER COLUMN oa_signed SET NOT NULL;
+
ALTER TABLE operation_analytique ALTER COLUMN oa_signed SET DEFAULT
'Y'::bpchar;
COMMENT ON COLUMN operation_analytique.oa_signed IS 'Sign of the amount';
---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r5651 - phpcompta/tags/rel671/html/admin/sql/patch,
phpcompta-dev <=