1 UPDATE profile_phones
AS pp
2 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')
4 WHERE pp.pub
!= pa.pub
AND pa.pub
= 'ax' AND pp.pub
= 'public';
5 UPDATE profile_phones
AS pp
6 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')
7 SET pp.pub
= 'private' WHERE pp.pub
!= pa.pub
AND pa.pub
= 'private';
9 UPDATE profile_phones
AS pp
10 INNER JOIN profile_job
AS pj
ON (pp.pid
= pj.pid
AND pp.link_id
= pj.
id AND pp.link_type
= 'pro')
12 WHERE pp.pub
!= pj.pub
AND pj.pub
= 'ax' AND pp.pub
= 'public';
13 UPDATE profile_phones
AS pp
14 INNER JOIN profile_job
AS pj
ON (pp.pid
= pj.pid
AND pp.link_id
= pj.
id AND pp.link_type
= 'pro')
15 SET pp.pub
= 'private'
16 WHERE pp.pub
!= pj.pub
AND pj.pub
= 'private';
18 UPDATE profile_addresses
AS pa
19 INNER JOIN profile_job
AS pj
ON (pa.pid
= pj.pid
AND pa.
id = pj.
id AND pa.
type = 'job')
21 WHERE pa.pub
!= pj.pub
AND pj.pub
= 'ax' AND pa.pub
= 'public';
22 UPDATE profile_addresses
AS pa
23 INNER JOIN profile_job
AS pj
ON (pa.pid
= pj.pid
AND pa.
id = pj.
id AND pa.
type = 'job')
24 SET pa.pub
= 'private'
25 WHERE pa.pub
!= pj.pub
AND pj.pub
= 'private';
29 WHERE pub
!= email_pub
AND pub
= 'ax' AND email_pub
= 'public';
31 SET email_pub
= 'private'
32 WHERE pub
= 'private';
34 -- vim:set syntax=mysql: