Temporarly removes gapps acces to phd and master.

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

diff --git a/upgrade/1.0.1/04_phones.sql b/upgrade/1.0.1/04_phones.sql
index 9dc6fdf..70c1ea9 100644 (file)
--- a/upgrade/1.0.1/04_phones.sql
+++ b/upgrade/1.0.1/04_phones.sql
@@ -1,4 +1,8 @@
 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: