mysql> SHOW CREATE TABLE cdr\G
*************************** 1. row ***************************
       Table: cdr
Create Table: CREATE TABLE `cdr` (
  `userfield` varchar(255) NOT NULL default '',
  `accountcode` varchar(20) NOT NULL default '',
  `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` int(11) NOT NULL default '0',
  `billsec` int(11) NOT NULL default '0',
  `disposition` varchar(45) NOT NULL default '',
  `amaflags` int(11) NOT NULL default '0',
  `needs_note` tinyint(4) NOT NULL default '1',
  `note` text NOT NULL,
  `uniqueid` int(32) NOT NULL auto_increment,
  PRIMARY KEY  (`uniqueid`),
  KEY `needs_note` (`needs_note`)
) ENGINE=MyISAM AUTO_INCREMENT=1205613599 DEFAULT CHARSET=latin1