X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.0.1%2F00_job.sql;h=d7e5365515e03daecc791167df80f6d6d9e36ae9;hb=c76545c351fae4e2298624ff9ee5bf854dc5a5b6;hp=fa7b4ecaee852290bf4d97292798d6532aa844ed;hpb=f74509fbb4f06820dc3d028e3ffd2145f151b013;p=platal.git

diff --git a/upgrade/1.0.1/00_job.sql b/upgrade/1.0.1/00_job.sql
index fa7b4ec..d7e5365 100644
--- a/upgrade/1.0.1/00_job.sql
+++ b/upgrade/1.0.1/00_job.sql
@@ -37,7 +37,6 @@ CREATE TABLE `profile_job_term` (
   `computed` enum('original','computed') NOT NULL DEFAULT 'original' COMMENT 'terms can be added by user or computed from entreprise',
   PRIMARY KEY (`pid`, `jid`, `jtid`),
   INDEX `jtid` (`jtid`),
-  FOREIGN KEY (`jid`) REFERENCES `profile_job` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
   FOREIGN KEY (`jtid`) REFERENCES `profile_job_term_enum` (`jtid`) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB, CHARSET=utf8, COMMENT='job terms for jobs in profiles';