Commit | Line | Data |
---|---|---|
0b6c8b36 SJ |
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 | ||
f168c014 SJ |
4 | DELETE FROM profile_phones WHERE search_tel = '' OR display_tel = '' OR link_type = 'hq'; |
5 | ||
555a4512 SJ |
6 | UPDATE geoloc_countries SET phoneFormat = '(+p) # ## ## ## ##' WHERE phoneFormat = '0# ## ## ## ##'; |
7 | ||
0b6c8b36 | 8 | -- vim:set syntax=mysql: |