70c1ea94a3223dcd20269220f06994cf0deeb8e3
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 UPDATE geoloc_countries
SET phoneFormat
= '(+p) # ## ## ## ##' WHERE phoneFormat
= '0# ## ## ## ##';
8 -- vim:set syntax=mysql: