mysql> SHOW CREATE TABLE Raw_cdr;              
+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table   | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Raw_cdr | CREATE TABLE `Raw_cdr` (
  `pk` int(11) NOT NULL AUTO_INCREMENT,
  `calldate` datetime DEFAULT NULL,
  `clid` varchar(80) DEFAULT NULL,
  `src` varchar(80) DEFAULT NULL,
  `dst` varchar(80) DEFAULT NULL,
  `dcontext` varchar(80) DEFAULT NULL,
  `channel` varchar(80) DEFAULT NULL,
  `dstchannel` varchar(80) DEFAULT NULL,
  `lastapp` varchar(80) DEFAULT NULL,
  `lastdata` varchar(80) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `billsec` int(11) DEFAULT NULL,
  `disposition` varchar(45) DEFAULT NULL,
  `amaflags` int(11) DEFAULT NULL,
  `accountcode` varchar(20) DEFAULT NULL,
  `uniqueid` varchar(32) DEFAULT NULL,
  `userfield` varchar(255) DEFAULT NULL,
  `CostPrice` varchar(100) DEFAULT NULL,
  `mos` varchar(100) DEFAULT NULL,
  `updated` tinyint(1) DEFAULT '0',
  `uploaded` tinyint(1) DEFAULT '0',
  `company_secondary` varchar(12) DEFAULT NULL,
  `branch_secondary` varchar(12) DEFAULT NULL,
  `user_secondary` varchar(12) DEFAULT NULL,
  `PDD` varchar(10) NOT NULL,
  `DialStatus` varchar(100) NOT NULL,
  `retrieved` tinyint(1) DEFAULT NULL,
  `soucepk` int(11) DEFAULT NULL,
  PRIMARY KEY (`pk`),
  KEY `date_index` (`calldate`),
  KEY `updated_index` (`updated`),
  KEY `comp_index` (`company_secondary`),
  KEY `branch_index` (`branch_secondary`),
  KEY `channel_index` (`channel`),
  KEY `src` (`src`),
  KEY `dst` (`dst`),
  KEY `calldate` (`calldate`),
  KEY `disposition` (`disposition`),
  KEY `retrieved` (`retrieved`)
) /*!50100 TABLESPACE tms_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1 | 
+---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+