upgrade/1.0.2/04_publicity.sql

   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: