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