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

[phpcompta-dev]

Author: danydb
Date: 2012-01-08 00:38:22 +0100 (Sun, 08 Jan 2012)
New Revision: 4683

Modified:
   phpcompta/trunk/sql/upgrade.sql
Log:
change fk to attr_def

Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql     2012-01-07 05:11:12 UTC (rev 4682)
+++ phpcompta/trunk/sql/upgrade.sql     2012-01-07 23:38:22 UTC (rev 4683)
@@ -1,3 +1,17 @@
 alter table attr_def add ad_extra text ;
 
-insert into attr_def (ad_id,ad_text,ad_type,ad_size) values (33,'Date 
Fin','date',8);
\ No newline at end of file
+insert into attr_def (ad_id,ad_text,ad_type,ad_size) values (33,'Date 
Fin','date',8);
+
+ALTER TABLE fiche_detail DROP CONSTRAINT "$2";
+
+ALTER TABLE fiche_detail
+  ADD CONSTRAINT fiche_detail_attr_def_fk FOREIGN KEY (ad_id)
+      REFERENCES attr_def (ad_id) MATCH SIMPLE
+      ON UPDATE cascade ON DELETE cascade;
+      
+ALTER TABLE jnt_fic_attr DROP CONSTRAINT "$2";
+
+ALTER TABLE jnt_fic_attr
+  ADD CONSTRAINT jnt_fic_attr_attr_def_fk FOREIGN KEY (ad_id)
+      REFERENCES attr_def (ad_id) MATCH SIMPLE
+      ON UPDATE cascade ON DELETE cascade;