[Phpcompta-dev] r5262 - phpcompta/trunk/sql

[phpcompta-dev]

Author: danydb
Date: 2013-05-15 19:51:34 +0200 (Wed, 15 May 2013)
New Revision: 5262

Modified:
   phpcompta/trunk/sql/upgrade.sql
Log:
Bug #842 : effacement de journal et moyen de paiement

Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql     2013-05-14 20:53:30 UTC (rev 5261)
+++ phpcompta/trunk/sql/upgrade.sql     2013-05-15 17:51:34 UTC (rev 5262)
@@ -1 +1,5 @@
 update attr_def set ad_text='Compte bancaire' where ad_id=3;
+ALTER TABLE mod_payment  DROP CONSTRAINT mod_payment_mp_fd_id_fkey ;
+ALTER TABLE mod_payment  ADD CONSTRAINT mod_payment_mp_fd_id_fkey FOREIGN KEY 
(mp_fd_id)      REFERENCES fiche_def (fd_id) MATCH SIMPLE      ON UPDATE 
cascade ON DELETE cascade;
+ALTER TABLE mod_payment  DROP CONSTRAINT mod_payment_mp_jrn_def_id_fkey ;
+ALTER TABLE mod_payment  ADD CONSTRAINT mod_payment_mp_jrn_def_id_fkey FOREIGN 
KEY (mp_jrn_def_id)      REFERENCES jrn_def (jrn_def_id) MATCH SIMPLE ON UPDATE 
        CASCADE ON DELETE CASCADE;



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu