bce75fb7b2efb6b058414b202c5a70449a19750e
1 -- Deletes empty mentor expertise.
2 DELETE FROM profile_mentor
WHERE expertise
IS NULL OR expertise
= '';
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 = '';
10 -- vim:set syntax=mysql: