projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
Update import scripts: create table using InnoDB engine.
[platal.git]
/
upgrade
/
newdirectory-0.0.1
/
04_telephone.sql
diff --git
a/upgrade/newdirectory-0.0.1/04_telephone.sql
b/upgrade/newdirectory-0.0.1/04_telephone.sql
index
bff48ee
..
dc09189
100644
(file)
--- a/
upgrade/newdirectory-0.0.1/04_telephone.sql
+++ b/
upgrade/newdirectory-0.0.1/04_telephone.sql
@@
-11,7
+11,7
@@
CREATE TABLE IF NOT EXISTS `profile_phones` (
PRIMARY KEY(`uid`, `link_type`, `link_id`, `tel_id`),
INDEX (`search_tel`),
INDEX uid (uid)
-);
+)
ENGINE=InnoDB, CHARSET=utf8
;
-- Adds a temporary column to convert phone prefixes from varchar to int