From 60db728a2709b1ee2d53fd3162644eb8dc184a7d Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Thu, 21 Oct 2010 09:50:52 +0200 Subject: [PATCH] Uncomment foreign keys. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/1.0.1/11_job.sql | 10 +++++----- upgrade/1.0.1/12_profiles.sql | 4 ++-- 2 files changed, 7 insertions(+), 7 deletions(-) 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'; diff --git a/upgrade/1.0.1/12_profiles.sql b/upgrade/1.0.1/12_profiles.sql index 1c5a8d5..4a792f0 100644 --- a/upgrade/1.0.1/12_profiles.sql +++ b/upgrade/1.0.1/12_profiles.sql @@ -8,8 +8,8 @@ CREATE TABLE profile_modifications ( newText TEXT NOT NULL, pub ENUM('private', 'ax', 'public') NOT NULL DEFAULT 'private', PRIMARY KEY(pid, uid, field) - #FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE, - #FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE + FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE, + FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB, CHARSET=utf8; -- vim:set syntax=mysql: -- 2.1.4