[platal.git] / upgrade / 1.1.14 / 02_delete_unlinked_rows.sql

DELETE * FROM profile_addresses WHERE pid = 44872 AND jobid = 0 AND groupid = 0 AND type = 'home' AND id = 0;
DELETE * FROM profile_addresses WHERE pid = 16669 AND jobid = 0 AND groupid = 0 AND type = 'job' AND id = 0;
DELETE * FROM profile_addresses WHERE pid = 44872 AND jobid = 0 AND groupid = 0 AND type = 'job' AND id = 0;
DELETE * FROM profile_phones WHERE pid = 16669 AND link_type = 'pro' AND link_id = 0 AND tel_id = 0;
DELETE * FROM profile_phones WHERE pid = 44872 AND link_type = 'pro' AND link_id = 0 AND tel_id = 0;
DELETE * FROM profile_phones WHERE pid = 44872 AND link_type = 'user' AND link_id = 0 AND tel_id = 0;
DELETE * FROM profile_phones WHERE pid = 44872 AND link_type = 'user' AND link_id = 0 AND tel_id = 1;
Commit	Line	Data
5f801551 TM	1	DELETE * FROM profile_addresses WHERE pid = 44872 AND jobid = 0 AND groupid = 0 AND type = 'home' AND id = 0;
	2	DELETE * FROM profile_addresses WHERE pid = 16669 AND jobid = 0 AND groupid = 0 AND type = 'job' AND id = 0;
	3	DELETE * FROM profile_addresses WHERE pid = 44872 AND jobid = 0 AND groupid = 0 AND type = 'job' AND id = 0;
	4	DELETE * FROM profile_phones WHERE pid = 16669 AND link_type = 'pro' AND link_id = 0 AND tel_id = 0;
	5	DELETE * FROM profile_phones WHERE pid = 44872 AND link_type = 'pro' AND link_id = 0 AND tel_id = 0;
	6	DELETE * FROM profile_phones WHERE pid = 44872 AND link_type = 'user' AND link_id = 0 AND tel_id = 0;
	7	DELETE * FROM profile_phones WHERE pid = 44872 AND link_type = 'user' AND link_id = 0 AND tel_id = 1;