[Phpcompta-dev] r5652 - phpcompta/tags/rel671/html/admin/sql/patch

[phpcompta-dev]

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