| 1 | CREATE TABLE `tels` ( |
| 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`) |
| 9 | ); |
| 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`; |