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

diff --git a/upgrade/1.0.1/00_job.sql b/upgrade/1.0.1/00_job.sql
index 79c721b..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 (`pid`, `jid`) REFERENCES `profile_job` (`pid`, `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';
 
@@ -46,7 +45,6 @@ CREATE TABLE `profile_mentor_term` (
   `jtid` int unsigned NOT NULL COMMENT 'term id',
   PRIMARY KEY (`pid`, `jtid`),
   INDEX `jtid` (`jtid`),
-  FOREIGN KEY (`pid`) REFERENCES `profiles` (`pid`) 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 mentorship in profiles';