Stuff

CREATE TABLE `cdr` (
  `id` BIGINT(7) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uniqueid` VARCHAR(23) NOT NULL DEFAULT '',
  `userfield` VARCHAR(25) NOT NULL DEFAULT '',
  `accountcode` VARCHAR(8) NOT NULL DEFAULT '0',
  `src` VARCHAR(80) NOT NULL DEFAULT '',
  `dst` VARCHAR(80) NOT NULL DEFAULT '',
  `dcontext` VARCHAR(80) NOT NULL DEFAULT '',
  `clid` VARCHAR(80) NOT NULL DEFAULT '',
  `channel` VARCHAR(80) NOT NULL DEFAULT '',
  `dstchannel` VARCHAR(80) NOT NULL DEFAULT '',
  `lastapp` VARCHAR(80) NOT NULL DEFAULT '',
  `lastdata` VARCHAR(80) NOT NULL DEFAULT '',
  `calldate` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  `duration` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `billsec` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `disposition` VARCHAR(10) NOT NULL DEFAULT '',
  `amaflags` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `ipAddress` VARCHAR(15) NOT NULL,
  PRIMARY KEY  (`uniqueid`,`id`),
  KEY `userfield` (`userfield`),
  KEY `channel` (`channel`),
  KEY `calldate` (`calldate`),
  KEY `accountcode` (`disposition`,`accountcode`)
) ENGINE=MYISAM AUTO_INCREMENT=876240 DEFAULT CHARSET=latin1