From 2074fff55be0b0299dd30e99fb25daa0d7981846 Mon Sep 17 00:00:00 2001 From: =?utf8?q?St=C3=A9phane=20Jacob?= Date: Wed, 8 Dec 2010 19:35:35 +0100 Subject: [PATCH] Decreases publicity in databse according to previous commits. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Stéphane Jacob --- upgrade/1.0.2/04_publicity.sql | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 upgrade/1.0.2/04_publicity.sql diff --git a/upgrade/1.0.2/04_publicity.sql b/upgrade/1.0.2/04_publicity.sql new file mode 100644 index 0000000..299e625 --- /dev/null +++ b/upgrade/1.0.2/04_publicity.sql @@ -0,0 +1,34 @@ + UPDATE profile_phones AS pp +INNER JOIN profile_addresses AS pa ON (pp.pid = pa.pid AND pp.link_id = pa.id AND pa.type = 'home' AND pp.tel_type = 'address') + SET pp.pub = 'ax' + WHERE pp.pub != pa.pub AND pa.pub = 'ax' AND pp.pub = 'public'; + UPDATE profile_phones AS pp +INNER JOIN profile_addresses AS pa ON (pp.pid = pa.pid AND pp.link_id = pa.id AND pa.type = 'home' AND pp.tel_type = 'address') + SET pp.pub = 'private' WHERE pp.pub != pa.pub AND pa.pub = 'private'; + + UPDATE profile_phones AS pp +INNER JOIN profile_job AS pj ON (pp.pid = pj.pid AND pp.link_id = pj.id AND pp.link_type = 'pro') + SET pp.pub = 'ax' + WHERE pp.pub != pj.pub AND pj.pub = 'ax' AND pp.pub = 'public'; + UPDATE profile_phones AS pp +INNER JOIN profile_job AS pj ON (pp.pid = pj.pid AND pp.link_id = pj.id AND pp.link_type = 'pro') + SET pp.pub = 'private' + WHERE pp.pub != pj.pub AND pj.pub = 'private'; + + UPDATE profile_addresses AS pa +INNER JOIN profile_job AS pj ON (pa.pid = pj.pid AND pa.id = pj.id AND pa.type = 'job') + SET pa.pub = 'ax' + WHERE pa.pub != pj.pub AND pj.pub = 'ax' AND pa.pub = 'public'; + UPDATE profile_addresses AS pa +INNER JOIN profile_job AS pj ON (pa.pid = pj.pid AND pa.id = pj.id AND pa.type = 'job') + SET pa.pub = 'private' + WHERE pa.pub != pj.pub AND pj.pub = 'private'; + +UPDATE profile_job + SET email_pub = 'ax' + WHERE pub != email_pub AND pub = 'ax' AND email_pub = 'public'; +UPDATE profile_job + SET email_pub = 'private' + WHERE pub = 'private'; + +-- vim:set syntax=mysql: -- 2.1.4