[platal.git] / upgrade / 1.1.0 / xx_01_clean_db.sql

-- Deletes empty mentor expertise.
DELETE FROM profile_mentor WHERE expertise IS NULL OR expertise = '';
-- Deletes empty jobs.
DELETE FROM profile_job WHERE (jobid IS NULL OR jobid = '') AND description = '' AND url = '' AND email = '';
-- Deletes empty educations.
DELETE FROM profile_education WHERE degreeid IS NULL AND eduid IS NULL AND program = '';
-- Deletes empty addresses.
DELETE FROM profile_addresses WHERE text IS NULL OR text = '';

-- vim:set syntax=mysql:
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: