CREATE TABLE `abd123` (
  `cdrRecordType` tinyint(1) unsigned NOT NULL,
  `globalCallID_callManagerId` tinyint(3) unsigned NOT NULL,
  `globalCallID_callId` mediumint(8) unsigned NOT NULL,
  `origLegCallIdentifier` mediumint(8) unsigned NOT NULL,
  `dateTimeOrigination` int(10) unsigned NOT NULL,
  `origNodeId` tinyint(1) unsigned NOT NULL,
  `origSpan` int(10) unsigned NOT NULL,
  `origIpAddr` int(11) NOT NULL,
  `callingPartyNumber` varchar(150) default NULL,
  `callingPartyUnicodeLoginUserID` varchar(150) default NULL,
  `origCause_location` tinyint(3) unsigned NOT NULL,
  `origCause_value` tinyint(3) unsigned NOT NULL,
  `origPrecedenceLevel` tinyint(3) unsigned NOT NULL,
  `origMediaTransportAddress_IP` int(11) NOT NULL,
  `origMediaTransportAddress_Port` int(10) unsigned NOT NULL,
  `origMediaCap_payloadCapability` int(10) unsigned NOT NULL,
  `origMediaCap_maxFramesPerPacket` int(10) unsigned NOT NULL,
  `origMediaCap_g723BitRate` tinyint(1) unsigned NOT NULL,
  `origVideoCap_Codec` tinyint(3) unsigned NOT NULL,
  `origVideoCap_Bandwidth` int(10) unsigned NOT NULL,
  `origVideoCap_Resolution` tinyint(3) unsigned NOT NULL,
  `origVideoTransportAddress_IP` int(10) unsigned NOT NULL,
  `origVideoTransportAddress_Port` int(10) unsigned NOT NULL,
  `destLegIdentifier` int(10) unsigned NOT NULL,
  `destNodeId` int(10) unsigned NOT NULL,
  `destSpan` int(10) unsigned NOT NULL,
  `destIpAddr` int(11) NOT NULL,
  `originalCalledPartyNumber` varchar(150) NOT NULL,
  `finalCalledPartyNumber` varchar(150) NOT NULL,
  `finalCalledPartyUnicodeLoginUserID` varchar(150) NOT NULL,
  `destCause_location` tinyint(3) unsigned NOT NULL,
  `destCause_value` tinyint(3) unsigned NOT NULL,
  `destPrecedenceLevel` tinyint(3) unsigned NOT NULL,
  `destMediaTransportAddress_IP` int(11) NOT NULL,
  `destMediaTransportAddress_Port` int(10) unsigned NOT NULL,
  `destMediaCap_payloadCapability` int(10) unsigned NOT NULL,
  `destMediaCap_maxFramesPerPacket` int(10) unsigned NOT NULL,
  `destMediaCap_g723BitRate` tinyint(1) unsigned NOT NULL,
  `destVideoCap_Codec` tinyint(3) unsigned NOT NULL,
  `destVideoCap_Bandwidth` int(10) unsigned NOT NULL,
  `destVideoCap_Resolution` tinyint(3) unsigned NOT NULL,
  `destVideoTransportAddress _IP` int(11) NOT NULL,
  `destVideoTransportAddress_Port` int(10) unsigned NOT NULL,
  `dateTimeConnect` int(10) default NULL,
  `dateTimeDisconnect` int(10) default NULL,
  `lastRedirectDn` varchar(150) NOT NULL,
  `pkid` varchar(150) NOT NULL,
  `originalCalledPartyNumberPartition` varchar(150) default NULL,
  `callingPartyNumberPartition` varchar(150) default NULL,
  `finalCalledPartyNumberPartition` varchar(150) default NULL,
  `lastRedirectDnPartition` varchar(150) default NULL,
  `duration` int(10) unsigned NOT NULL,
  `origDeviceName` varchar(150) NOT NULL,
  `destDeviceName` varchar(150) default NULL,
  `origCallTerminationOnBehalfOf` int(10) unsigned NOT NULL,
  `destCallTerminationOnBehalfOf` int(10) unsigned NOT NULL,
  `origCalledPartyRedirectOnBehalfOf` int(10) unsigned NOT NULL,
  `lastRedirectRedirectOnBehalfOf` int(11) NOT NULL,
  `origCalledPartyRedirectReason` int(11) NOT NULL,
  `lastRedirectRedirectReason` int(11) NOT NULL,
  `destConversationID` int(11) NOT NULL,
  `globalCallId_ClusterId` varchar(150) NOT NULL,
  `joinOnBehalfOf` int(11) NOT NULL,
  `Comment` varchar(150) default NULL,
  `authCodeDescription` varchar(150) default NULL,
  `authorizationLevel` int(11) NOT NULL,
  `clientMatterCode` varchar(150) default NULL,
  `callSecuredStatus` int(10) unsigned NOT NULL,
  `origConversationID` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
