[Phpcompta-dev] r4649 - phpcompta/trunk/html/admin/sql/patch

[phpcompta-dev]

Author: danydb
Date: 2011-12-21 22:33:03 +0100 (Wed, 21 Dec 2011)
New Revision: 4649

Modified:
   phpcompta/trunk/html/admin/sql/patch/upgrade99.sql
Log:
add script for #350

Modified: phpcompta/trunk/html/admin/sql/patch/upgrade99.sql
===================================================================
--- phpcompta/trunk/html/admin/sql/patch/upgrade99.sql  2011-12-21 21:30:09 UTC 
(rev 4648)
+++ phpcompta/trunk/html/admin/sql/patch/upgrade99.sql  2011-12-21 21:33:03 UTC 
(rev 4649)
@@ -37,6 +37,9 @@
  qp_dep_priv=(-1)*qp_dep_priv
 where qp_quantite < 0 and qp_price > 0 and qp_vat >= 0;
 
+update jrnx set j_text = null from jrn where jr_grpt_id=j_grpt and 
j_text=jr_comment;
+insert into parameter (pr_id,pr_value) values ('MY_UPDLAB','N');
+
 update version set val=100;
 
 commit;
\ No newline at end of file