Commit | Line | Data |
---|---|---|
2074fff5 SJ |
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: |