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

[phpcompta-dev]

Author: danydb
Date: 2011-12-01 01:46:27 +0100 (Thu, 01 Dec 2011)
New Revision: 4532

Modified:
   phpcompta/trunk/html/admin/sql/patch/upgrade97.sql
Log:
remove mod_paiement for inexisting ledger

Modified: phpcompta/trunk/html/admin/sql/patch/upgrade97.sql
===================================================================
--- phpcompta/trunk/html/admin/sql/patch/upgrade97.sql  2011-12-01 00:37:17 UTC 
(rev 4531)
+++ phpcompta/trunk/html/admin/sql/patch/upgrade97.sql  2011-12-01 00:46:27 UTC 
(rev 4532)
@@ -792,6 +792,8 @@
 
 alter table mod_payment drop mp_type;
 
+delete from mod_payment where jrn_def_id not in (select jrn_def_id from 
jrn_def);
+
 alter table mod_payment add constraint mod_payment_jrn_def_id_fk foreign key 
(jrn_def_id) references jrn_def(jrn_def_id) on delete cascade on update cascade;
 
 comment on column mod_payment.jrn_def_id is 'Ledger using this payment method';