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