[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r5262 - phpcompta/trunk/sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r5262 - phpcompta/trunk/sql |
Date: |
Wed, 15 May 2013 19:51:35 +0200 (CEST) |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r5262 - phpcompta/trunk/sql,
phpcompta-dev <=