upgrade/1.0.1/04_phones.sql

   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;
   3
   4 DELETE FROM profile_phones WHERE search_tel = '' OR display_tel = '' OR link_type = 'hq';
   5
   6 -- vim:set syntax=mysql: