| 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') |
| 3 | SET pp.pub = 'ax' |
| 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'; |
| 8 | |
| 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') |
| 11 | SET pp.pub = 'ax' |
| 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'; |
| 17 | |
| 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') |
| 20 | SET pa.pub = 'ax' |
| 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'; |
| 26 | |
| 27 | UPDATE profile_job |
| 28 | SET email_pub = 'ax' |
| 29 | WHERE pub != email_pub AND pub = 'ax' AND email_pub = 'public'; |
| 30 | UPDATE profile_job |
| 31 | SET email_pub = 'private' |
| 32 | WHERE pub = 'private'; |
| 33 | |
| 34 | -- vim:set syntax=mysql: |