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; _______________________________________________ Phpcompta-dev mailing list [email protected] https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
