[platal.git] / upgrade / 1.0.1 / 04_phones.sql

ALTER TABLE profile_phones MODIFY COLUMN pid INT(6) NOT NULL DEFAULT 0;
ALTER TABLE profile_phones MODIFY COLUMN link_id INT(6) NOT NULL DEFAULT 0;

DELETE FROM profile_phones WHERE search_tel = '' OR display_tel = '' OR link_type = 'hq';

UPDATE geoloc_countries SET phoneFormat = '(+p) # ## ## ## ##' WHERE phoneFormat = '0# ## ## ## ##';

-- vim:set syntax=mysql:
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';
f168c014 SJ	5
555a4512 SJ	6	UPDATE geoloc_countries SET phoneFormat = '(+p) # ## ## ## ##' WHERE phoneFormat = '0# ## ## ## ##';
555a4512 SJ	7
0b6c8b36	8	-- vim:set syntax=mysql: