1 ALTER TABLE profile_phones
MODIFY COLUMN pid
INT(6) NOT NULL DEFAULT 0;
2 ALTER TABLE profile_phones
MODIFY COLUMN link_id
INT(6) NOT NULL DEFAULT 0;
4 DELETE FROM profile_phones
WHERE search_tel
= '' OR display_tel
= '' OR link_type
= 'hq';
6 -- vim:set syntax=mysql: