upgrade/1.1.0/xx_01_clean_db.sql

   1 -- Deletes empty mentor expertise.
   2 DELETE FROM profile_mentor WHERE expertise IS NULL OR expertise = '';
   3 -- Deletes empty jobs.
   4 DELETE FROM profile_job WHERE (jobid IS NULL OR jobid = '') AND description = '' AND url = '' AND email = '';
   5 -- Deletes empty educations.
   6 DELETE FROM profile_education WHERE degreeid IS NULL AND eduid IS NULL AND program = '';
   7 -- Deletes empty addresses.
   8 DELETE FROM profile_addresses WHERE text IS NULL OR text = '';
   9
  10 -- vim:set syntax=mysql: