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