X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.0.1%2F11_job.sql;h=1a2ac99b0490abf8bd1246ac8a73dc25bdfc0b62;hb=69d311a9e667ba071af1070cfe9a6906a4f0ed32;hp=a01dfbf83f5edb9ac7b7921f18e2d22803b52b04;hpb=245923e335d0da5bec9495991a7846be9f0563ab;p=platal.git

diff --git a/upgrade/1.0.1/11_job.sql b/upgrade/1.0.1/11_job.sql
index a01dfbf..1a2ac99 100644
--- a/upgrade/1.0.1/11_job.sql
+++ b/upgrade/1.0.1/11_job.sql
@@ -33,12 +33,12 @@ CREATE TABLE `profile_job_term_search` (
 
 CREATE TABLE `profile_job_term` (
   `pid` INT(11) UNSIGNED DEFAULT NULL COMMENT 'profile id',
-  `jid` tinyint(1) unsigned NOT NULL COMMENT 'job id in profile',
-  `jtid` int unsigned NOT NULL COMMENT 'term id',
+  `jid` TINYINT(1) UNSIGNED DEFAULT NULL COMMENT 'job id in profile',
+  `jtid` INT UNSIGNED DEFAULT NULL COMMENT 'term id',
   `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 (`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';
 
@@ -47,7 +47,7 @@ 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 (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';
 
@@ -56,7 +56,7 @@ CREATE TABLE `profile_job_entreprise_term` (
   `jtid` int unsigned NOT NULL COMMENT 'term id',
   PRIMARY KEY (`eid`, `jtid`),
   INDEX `jtid` (`jtid`),
-  #FOREIGN KEY (`eid`) REFERENCES `profile_job_enum` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
+  FOREIGN KEY (`eid`) REFERENCES `profile_job_enum` (`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 associated to entreprises';