Commit | Line | Data |
---|---|---|
b235d980 | 1 | CREATE TABLE IF NOT EXISTS `profile_phones` ( |
de15699b GB |
2 | `uid` smallint unsigned NOT NULL, |
3 | `link_type` enum('address', 'pro', 'user') NOT NULL DEFAULT 'user' COMMENT 'type of parent element', | |
4 | `link_id` tinyint unsigned NOT NULL COMMENT 'id of his parent element', | |
5 | `tel_id` tinyint unsigned NOT NULL COMMENT 'index of this number for the couple (user, parent element)', | |
6 | `tel_type` enum('fixed', 'mobile', 'fax') NOT NULL DEFAULT 'fixed', | |
7 | `search_tel` varchar(25) NOT NULL COMMENT 'search number in an international format with only digits and the initial +', | |
8 | `display_tel` varchar(30) NOT NULL COMMENT 'display number', | |
9 | `pub` enum('private', 'ax', 'public') NOT NULL DEFAULT 'private', | |
bde2be3b | 10 | `comment` varchar(80) NOT NULL, |
de15699b GB |
11 | PRIMARY KEY(`uid`, `link_type`, `link_id`, `tel_id`), |
12 | INDEX (`search_tel`) | |
13 | ); | |
14 | ||
de15699b | 15 | |
b235d980 GB |
16 | -- Adds a temporary column to convert phone prefixes from varchar to int |
17 | ALTER TABLE `geoloc_pays` ADD COLUMN `tmp_phoneprf` smallint unsigned NULL; | |
18 | ||
19 | -- Adds phone format column | |
20 | ALTER TABLE `geoloc_pays` ADD COLUMN `phoneformat` varchar(25) NOT NULL AFTER `nat`; | |
de15699b | 21 |