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'; _______________________________________________ Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
