2 `uid`
smallint(5) unsigned
NOT NULL default '0',
3 `adrid`
tinyint(1) unsigned
NOT NULL default '0',
4 `telid`
tinyint(1) unsigned
NOT NULL default '0',
5 `tel_type`
varchar(20) NOT NULL default '',
6 `tel_pub`
enum('private','ax','public') NOT NULL default 'private',
7 `tel`
varchar(30) NOT NULL default '',
8 PRIMARY KEY (`uid`
,`adrid`
,`telid`
)
10 INSERT INTO tels
SELECT uid
, adrid
, 0, 'Tél.', tel_pub
, tel
FROM adresses
;
11 INSERT INTO tels
SELECT uid
, adrid
, 1, 'Fax', tel_pub
, fax
FROM adresses
;
12 DELETE FROM tels
WHERE tel
= "";
13 ALTER TABLE `adresses`
DROP `tel`
, DROP `tel_pub`
;