projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
Only uses autoload to require validation classes.
[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
1c7630d
..
70c1ea9
100644
(file)
--- 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: