upgrade/0.9.10/02_tels.sql

   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 = "";