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

[phpcompta-dev]

Author: danydb
Date: 2012-06-18 21:15:20 +0200 (Mon, 18 Jun 2012)
New Revision: 4937

Modified:
   phpcompta/trunk/sql/upgrade.sql
Log:
ajout contrainte FK

Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql     2012-06-18 19:15:06 UTC (rev 4936)
+++ phpcompta/trunk/sql/upgrade.sql     2012-06-18 19:15:20 UTC (rev 4937)
@@ -390,3 +390,5 @@
 );
 
 ALTER TABLE stock_goods ADD COLUMN c_id bigint;
+ALTER TABLE stock_goods   ADD CONSTRAINT stock_goods_c_id_fkey FOREIGN KEY 
(c_id)        REFERENCES stock_change (c_id) MATCH SIMPLE
+      ON UPDATE CASCADE ON DELETE CASCADE;
\ No newline at end of file



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