From e298f94d450bece05e7ccfde220768f8ffdc95b5 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Tue, 1 Jun 2010 14:33:13 +0200 Subject: [PATCH] Fixes empty publicity flags in jobs tables. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/newdirectory-0.0.1/11_jobs.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/upgrade/newdirectory-0.0.1/11_jobs.sql b/upgrade/newdirectory-0.0.1/11_jobs.sql index 76113ae..b2f787d 100644 --- a/upgrade/newdirectory-0.0.1/11_jobs.sql +++ b/upgrade/newdirectory-0.0.1/11_jobs.sql @@ -37,7 +37,7 @@ INSERT IGNORE INTO profile_job_enum (name, url) WHERE entreprise != ''; INSERT INTO profile_job (id, pid, jobid, email, pub, email_pub, description) - SELECT e.entrid, e.uid, j.id, e.email, e.pub, e.email_pub, + SELECT e.entrid, e.uid, j.id, e.email, IF(e.pub = '', 'private', e.pub), IF(e.email_pub = '', 'private', e.email_pub), CONCAT_WS(', ', IF(e.poste = '', NULL, e.poste), IF(e.fonction = 0, NULL, f.fonction_fr), IF(e.ss_secteur IS NULL , IF(e.secteur IS NULL, NULL, s.label), ss.label)) FROM #x4dat#.entreprises AS e -- 2.1.4