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 _______________________________________________ Phpcompta est un logiciel libre de comptabilité en ligne (http://www.phpcompta.eu) Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
