79a5acea |
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`) |
014c8464 |
9 | ); |
79a5acea |
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 = ""; |
014c8464 |
13 | ALTER TABLE `adresses` DROP `tel`, DROP `tel_pub`; |