CREATE TABLE `cdrs` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `session_id` VARCHAR(50) NOT NULL COMMENT 'Tropo Session ID',
  `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `caller_id` VARCHAR(20) NOT NULL,
  `called_id` VARCHAR(20) NOT NULL,
  `promo` VARCHAR(25) NOT NULL,
  `transfer_to` VARCHAR(20) NOT NULL,
  `transfer_duration` VARCHAR(10) NOT NULL,
  `last_update` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `session_id` (`session_id`)
) ENGINE=MyISAM AUTO_INCREMENT=140 DEFAULT CHARSET=latin1