-CREATE TABLE IF NOT EXISTS `profile_phones` (
- `uid` smallint unsigned NOT NULL,
+DROP TABLE IF EXISTS profile_phones;
+
+CREATE TABLE `profile_phones` (
+ `pid` smallint unsigned NOT NULL,
`link_type` enum('address', 'pro', 'user') NOT NULL DEFAULT 'user' COMMENT 'type of parent element',
`link_id` tinyint unsigned NOT NULL COMMENT 'id of his parent element',
`tel_id` tinyint unsigned NOT NULL COMMENT 'index of this number for the couple (user, parent element)',
`display_tel` varchar(30) NOT NULL COMMENT 'display number',
`pub` enum('private', 'ax', 'public') NOT NULL DEFAULT 'private',
`comment` varchar(80) NOT NULL,
- PRIMARY KEY(`uid`, `link_type`, `link_id`, `tel_id`),
+ PRIMARY KEY(`pid`, `link_type`, `link_id`, `tel_id`),
INDEX (`search_tel`),
- INDEX uid (uid)
-);
-
-
--- Adds a temporary column to convert phone prefixes from varchar to int
-ALTER TABLE `geoloc_pays` ADD COLUMN `tmp_phoneprf` smallint unsigned NULL;
+ INDEX pid (pid)
+) ENGINE=InnoDB, CHARSET=utf8;
--- Adds phone format column
-ALTER TABLE `geoloc_pays` ADD COLUMN `phoneformat` varchar(25) NOT NULL AFTER `nat`;
# vim:set syntax=mysql: