Author: danydb Date: 2014-01-08 22:08:51 +0100 (Wed, 08 Jan 2014) New Revision: 5652
Modified: phpcompta/tags/rel671/html/admin/sql/patch/upgrade112.sql Log: Update SQL script Modified: phpcompta/tags/rel671/html/admin/sql/patch/upgrade112.sql =================================================================== --- phpcompta/tags/rel671/html/admin/sql/patch/upgrade112.sql 2014-01-08 20:51:40 UTC (rev 5651) +++ phpcompta/tags/rel671/html/admin/sql/patch/upgrade112.sql 2014-01-08 21:08:51 UTC (rev 5652) @@ -4,9 +4,10 @@ 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 DEFAULT 'Y'::bpchar; +update operation_analytique set oa_signed='Y'; 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'; update version set val=113; --- 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
