`tel_pub` enum('private','ax','public') NOT NULL default 'private',
`tel` varchar(30) NOT NULL default '',
PRIMARY KEY (`uid`,`adrid`,`telid`)
`tel_pub` enum('private','ax','public') NOT NULL default 'private',
`tel` varchar(30) NOT NULL default '',
PRIMARY KEY (`uid`,`adrid`,`telid`)
INSERT INTO tels SELECT uid, adrid, 0, 'Tél.', tel_pub, tel FROM adresses;
INSERT INTO tels SELECT uid, adrid, 1, 'Fax', tel_pub, fax FROM adresses;
DELETE FROM tels WHERE tel = "";
INSERT INTO tels SELECT uid, adrid, 0, 'Tél.', tel_pub, tel FROM adresses;
INSERT INTO tels SELECT uid, adrid, 1, 'Fax', tel_pub, fax FROM adresses;
DELETE FROM tels WHERE tel = "";