[Phpcompta-dev] r508 - trunk/rapport_avance/sql

[phpcompta-dev]

Author: danydb
Date: 2013-05-24 20:53:19 +0200 (Fri, 24 May 2013)
New Revision: 508

Modified:
   trunk/rapport_avance/sql/upgrade3.sql
Log:
Bug when restore

Modified: trunk/rapport_avance/sql/upgrade3.sql
===================================================================
--- trunk/rapport_avance/sql/upgrade3.sql       2013-05-24 18:22:21 UTC (rev 
507)
+++ trunk/rapport_avance/sql/upgrade3.sql       2013-05-24 18:53:19 UTC (rev 
508)
@@ -42,4 +42,10 @@
 
 insert into rapport_advanced.version  
(version_id,version_note)values(3,'Génération de document');
 
+ALTER TABLE rapport_advanced.restore_formulaire_param_detail drop CONSTRAINT 
formulaire_param_detail_p_id_fkey;
+ALTER TABLE rapport_advanced.restore_formulaire_param_detail  ADD CONSTRAINT 
formulaire_param_fkey FOREIGN KEY (p_id)
+      REFERENCES rapport_advanced.restore_formulaire_param (p_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE;
+
+
 commit;
\ No newline at end of file



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