X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.0.1%2F04_phones.sql;h=70c1ea94a3223dcd20269220f06994cf0deeb8e3;hb=d058a28521a1d2004eda0f64127cbc8a27f02c0e;hp=1c7630dc60912ce0f0d1b61e23086f56859dcb87;hpb=ed92ea696e042eb9b2d0efcc4731fdf89fb17924;p=platal.git

diff --git a/upgrade/1.0.1/04_phones.sql b/upgrade/1.0.1/04_phones.sql
index 1c7630d..70c1ea9 100644
--- a/upgrade/1.0.1/04_phones.sql
+++ b/upgrade/1.0.1/04_phones.sql
@@ -3,4 +3,6 @@ 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: