1 DROP TABLE IF EXISTS profile_phones
;
3 CREATE TABLE `profile_phones`
(
4 `pid`
smallint unsigned
NOT NULL,
5 `link_type`
enum('address', 'pro', 'user') NOT NULL DEFAULT 'user' COMMENT 'type of parent element',
6 `link_id` tinyint unsigned
NOT NULL COMMENT 'id of his parent element',
7 `tel_id` tinyint unsigned
NOT NULL COMMENT 'index of this number for the couple (user, parent element)',
8 `tel_type`
enum('fixed', 'mobile', 'fax') NOT NULL DEFAULT 'fixed',
9 `search_tel`
varchar(25) NOT NULL COMMENT 'search number in an international format with only digits and the initial +',
10 `display_tel`
varchar(30) NOT NULL COMMENT 'display number',
11 `pub`
enum('private', 'ax', 'public') NOT NULL DEFAULT 'private',
12 `
comment`
varchar(80) NOT NULL,
13 PRIMARY KEY(`pid`
, `link_type`
, `link_id`
, `tel_id`
),
16 ) ENGINE
=InnoDB
, CHARSET
=utf8
;
19 # vim
:set syntax
=mysql
: