[platal.git] / upgrade / 0.9.10 / 02_tels.sql

CREATE TABLE `tels` (
  `uid` smallint(5) unsigned NOT NULL default '0',
  `adrid` tinyint(1) unsigned NOT NULL default '0',
  `telid` tinyint(1) unsigned NOT NULL default '0',
  `tel_type` varchar(20) NOT NULL default '',
  `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 = "";
ALTER TABLE `adresses` DROP `tel`, DROP `tel_pub`;
Commit	Line	Data
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`)
	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 = "";
f42813b7	13	ALTER TABLE `adresses` DROP `tel`, DROP `tel_pub`;