'CREATE TABLE `DialerLog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_dt` datetime NOT NULL COMMENT ''timestamped by dialer when initiating a dialout, OR by dialer_log_processor_worker when INSERTING a new record'',
  `number` varchar(15) NOT NULL COMMENT ''this is the number being called by the dialer, OR is the calling party number for callbacks'',
  `origination` datetime DEFAULT NULL COMMENT ''timestamped by AGI script when Asterisk gets the request from dialer'',
  `connected` datetime DEFAULT NULL COMMENT ''timestamped by AGI script when Asterisk makes a connection'',
  `voicemail` datetime DEFAULT NULL COMMENT ''timestamped by AGI script when Asterisk detects an answering machine'',
  `human` datetime DEFAULT NULL COMMENT ''timestamped by AGI script when Asterisk detects a human answer'',
  `ivr` datetime DEFAULT NULL COMMENT ''timestamped by AGI script when called party is handed off to IVR'',
  `queue` datetime DEFAULT NULL COMMENT ''timestamped by dialer_log_processor_worker when an ENTERQUEUE event occurs in queue_log'',
  `abandoned` datetime DEFAULT NULL COMMENT ''timestamped by dialer_log_processor_worker when an ABANDON event occurs in queue_log'',
  `rep` datetime DEFAULT NULL COMMENT ''timestamped by dialer_log_processor_worker when a CONNECT event occurs in queue_log'',
  `repid` int(11) DEFAULT NULL,
  `complete` datetime DEFAULT NULL COMMENT ''timestamped by dialer_log_processor_worker when a COMPLETEAGENT or COMPLETECALLER event occurs in queue_log'',
  `warm_transfer` datetime DEFAULT NULL COMMENT ''dialer_log_rollup script copies this info from DialerLogWarmTransferTemp just before it does the rollup'',
  `warm_transfer_to` varchar(12) DEFAULT NULL COMMENT ''dialer_log_rollup script copies this info from DialerLogWarmTransferTemp just before it does the rollup'',
  `cdr_duration` int(11) DEFAULT NULL COMMENT ''dialer_log_rollup script copies this info from DialerLogWarmTransferTemp just before it does the rollup'',
  `dialerid` int(10) DEFAULT NULL,
  `campaignname` varchar(32) DEFAULT NULL,
  `callerid` varchar(11) DEFAULT NULL,
  `queueid` int(10) DEFAULT NULL,
  `fkentryid` int(16) DEFAULT NULL,
  `hangup` datetime DEFAULT NULL,
  `hangupcause` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `number` (`number`(10)),
  KEY `fkentryid` (`fkentryid`),
  KEY `created_dt` (`created_dt`),
  KEY `repid` (`repid`),
  KEY `origination` (`origination`),
  KEY `voicemail` (`voicemail`),
  KEY `human` (`human`),
  KEY `queue` (`queue`),
  KEY `complete` (`complete`),
  KEY `rep` (`rep`),
  KEY `warm_transfer` (`warm_transfer`)
) ENGINE=MyISAM AUTO_INCREMENT=21814181 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC'