CREATE TABLE `cdr_200802` (
  `recordType` tinyint(2) DEFAULT NULL,
  `callTransactionType` varchar(2) DEFAULT NULL,
  `servedimsi` varchar(15) DEFAULT NULL,
  `servedmsisdn` varchar(15) DEFAULT NULL,
  `servedIMEITAC` varchar(6) DEFAULT NULL,
  `servedIMEIFAC` varchar(2) DEFAULT NULL,
  `servedIMEISNR` varchar(6) DEFAULT NULL,
  `servedIMEISP` varchar(2) DEFAULT NULL,
  `servedMSRN` varchar(15) DEFAULT NULL,
  `servedOtherNumber` varchar(20) DEFAULT NULL,
  `sother_b_2` char(2) DEFAULT NULL,
  `sother_b_3` char(3) DEFAULT NULL,
  `sother_b_5` varchar(5) DEFAULT NULL,
  `sother_e_10` varchar(10) DEFAULT NULL,
  `startOfChargingdate` date NOT NULL DEFAULT '0000-00-00',
  `timeStamp` time NOT NULL DEFAULT '00:00:00',
  `hour` tinyint(1) unsigned DEFAULT NULL,
  `callDuration` smallint(5) unsigned DEFAULT NULL,
  `otherpartylongnumberb` varchar(20) DEFAULT NULL,
  `other_b_2` char(2) DEFAULT NULL,
  `other_b_3` char(3) DEFAULT NULL,
  `other_b_5` varchar(5) DEFAULT NULL,
  `other_e_10` varchar(10) DEFAULT NULL,
  `otherpartySms` varchar(20) DEFAULT NULL,
  `dialledOtherPartyB` varchar(20) DEFAULT NULL,
  `dialled_b_2` char(2) DEFAULT NULL,
  `dialled_b_3` char(3) DEFAULT NULL,
  `dialled_b_5` char(5) DEFAULT NULL,
  `dialled_e_10` char(10) DEFAULT NULL,
  `thirdpartyb` varchar(20) DEFAULT NULL,
  `exchangeId` varchar(15) DEFAULT NULL,
  `tgrpNameIc` varchar(10) DEFAULT NULL,
  `cicIc` varchar(6) DEFAULT NULL,
  `tgrpNameOg` varchar(10) DEFAULT NULL,
  `cicOg` varchar(6) DEFAULT NULL,
  `causeForTermination` char(2) DEFAULT NULL,
  `reasonForTermination` char(2) DEFAULT NULL,
  `callHoldInvocCount` tinyint(1) unsigned DEFAULT NULL,
  `callWaitInvocCount` tinyint(1) unsigned DEFAULT NULL,
  `sSCode` varchar(2) DEFAULT NULL,
  `sSCode1` varchar(2) DEFAULT NULL,
  `sSCode2` varchar(2) DEFAULT NULL,
  `sSCode3` varchar(2) DEFAULT NULL,
  `sSCode4` varchar(2) DEFAULT NULL,
  `sSCode5` varchar(2) DEFAULT NULL,
  `ussdAccessCode` varchar(6) DEFAULT NULL,
  `ussdString` varchar(50) DEFAULT NULL,
  `ussdCodingScheme` varchar(3) DEFAULT NULL,
  `ussdNotifyCounter` varchar(3) DEFAULT NULL,
  `ussdRequestCounter` varchar(3) DEFAULT NULL,
  `sequenceNumber` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `CIDMCC` varchar(3) DEFAULT NULL,
  `CIDMNC` varchar(3) DEFAULT NULL,
  `CIDLAC` varchar(5) DEFAULT NULL,
  `cId` varchar(5) DEFAULT NULL,
  `serviceCentreAddress` varchar(20) DEFAULT NULL,
  `inflag` tinyint(1) unsigned DEFAULT NULL,
  `inservicekey` varchar(8) DEFAULT NULL,
  `defaultcallhandling` tinyint(1) unsigned DEFAULT NULL,
  `intermediateSequenceNumber` tinyint(1) DEFAULT NULL,
  `drcCallId` varchar(16) DEFAULT NULL,
  `drcCallRN` varchar(16) DEFAULT NULL,
  `file` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`sequenceNumber`,`startOfChargingdate`,`timeStamp`),
  KEY `ix_nombre_tabla_msisdn` (`servedmsisdn`),
  KEY `ix_nombre_tabla_ctt` (`callTransactionType`),
  KEY `ix_nombre_tabla_dialled` (`dialledOtherPartyB`),
  KEY `ix_nombre_tabla_hour` (`hour`),
  KEY `ix_nombre_tabla_timestamp` (`timeStamp`),
  KEY `ix_nombre_tabla_drcCallId` (`drcCallId`),
  KEY `ix_nombre_tabla_drcCallRN` (`drcCallRN`),
  KEY `ix_nombre_tabla_tgrpnameic` (`tgrpNameIc`),
  KEY `ix_nombre_tabla_tgrpnameog` (`tgrpNameOg`),
  KEY `ix_nombre_tabla_file` (`file`),
  KEY `ix_nombre_tabla_defaultcallhandling` (`defaultcallhandling`),
  KEY `ix_nombre_tabla_startofchargingdate` (`startOfChargingdate`)
) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 UNION=(`barq_20080201`,`medn_20080201`,`cali_20080201`,`bogt_20080201`,`bgt2_20080201`,`barq_20080202`,`medn_20080202`,`cali_20080202`,`bogt_20080202`,`bgt2_20080202`,`barq_20080203`,`medn_20080203`,`cali_20080203`,`bogt_20080203`,`bgt2_20080203`,`barq_20080204`,`medn_20080204`,`cali_20080204`,`bogt_20080204`,`bgt2_20080204`,`barq_20080205`,`medn_20080205`,`cali_20080205`,`bogt_20080205`,`bgt2_20080205`,`barq_20080206`,`medn_20080206`,`cali_20080206`,`bogt_20080206`,`bgt2_20080206`,`barq_20080207`,`medn_20080207`,`cali_20080207`,`bogt_20080207`,`bgt2_20080207`,`barq_20080208`,`medn_20080208`,`cali_20080208`,`bogt_20080208`,`bgt2_20080208`,`barq_20080209`,`medn_20080209`,`cali_20080209`,`bogt_20080209`,`bgt2_20080209`,`barq_20080210`,`medn_20080210`,`cali_20080210`,`bogt_20080210`,`bgt2_20080210`,`barq_20080211`,`medn_20080211`,`cali_20080211`,`bogt_20080211`,`bgt2_20080211`,`barq_20080212`,`medn_20080212`,`cali_20080212`,`bogt_20080212`,`bgt2_20080212`,`barq_20080213`,`medn_20080213`,`cali_20080213`,`bogt_20080213`,`bgt2_20080213`,`barq_20080214`,`medn_20080214`,`cali_20080214`,`bogt_20080214`,`bgt2_20080214`,`barq_20080215`,`medn_20080215`,`cali_20080215`,`bogt_20080215`,`bgt2_20080215`,`barq_20080216`,`medn_20080216`,`cali_20080216`,`bogt_20080216`,`bgt2_20080216`,`barq_20080217`,`medn_20080217`,`cali_20080217`,`bogt_20080217`,`bgt2_20080217`,`barq_20080218`,`medn_20080218`,`cali_20080218`,`bogt_20080218`,`bgt2_20080218`,`barq_20080219`,`medn_20080219`,`cali_20080219`,`bogt_20080219`,`bgt2_20080219`,`barq_20080220`,`medn_20080220`,`cali_20080220`,`bogt_20080220`,`bgt2_20080220`,`barq_20080221`,`medn_20080221`,`cali_20080221`,`bogt_20080221`,`bgt2_20080221`,`barq_20080222`,`medn_20080222`,`cali_20080222`,`bogt_20080222`,`bgt2_20080222`,`barq_20080223`,`medn_20080223`,`cali_20080223`,`bogt_20080223`,`bgt2_20080223`,`barq_20080224`,`medn_20080224`,`cali_20080224`,`bogt_20080224`,`bgt2_20080224`,`barq_20080225`,`medn_20080225`,`cali_20080225`,`bogt_20080225`,`bgt2_20080225`,`barq_20080226`,`medn_20080226`,`cali_20080226`,`bogt_20080226`,`bgt2_20080226`,`barq_20080227`,`medn_20080227`,`cali_20080227`,`bogt_20080227`,`bgt2_20080227`,`barq_20080228`,`medn_20080228`,`cali_20080228`,`bogt_20080228`,`bgt2_20080228`,`barq_20080229`,`medn_20080229`,`cali_20080229`,`bogt_20080229`,`bgt2_20080229`)


CREATE TABLE `cdr_200802` (
  `record_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `recordType` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `servedIMSI` varchar(18) NOT NULL DEFAULT '',
  `servedIMEI` varchar(18) DEFAULT NULL,
  `servedMSISDN` varchar(20) DEFAULT NULL,
  `callingNumber` varchar(20) DEFAULT NULL,
  `calledNumber` varchar(20) DEFAULT NULL,
  `translatedNumber` varchar(20) DEFAULT NULL,
  `connectedNumber` varchar(20) DEFAULT NULL,
  `roamingNumber` varchar(20) DEFAULT NULL,
  `recordingEntity` varchar(42) DEFAULT NULL,
  `mscIncomingROUTE` varchar(15) DEFAULT NULL,
  `mscOutgoingROUTE` varchar(15) DEFAULT NULL,
  `location` varchar(12) DEFAULT NULL,
  `cid` varchar(5) DEFAULT NULL,
  `changeOfLocation` text,
  `basicService` tinyint(3) unsigned DEFAULT NULL,
  `transparencyIndicator` tinyint(3) unsigned DEFAULT NULL,
  `changeOfService` text,
  `supplServicesUsed` text,
  `aocParameters` text,
  `changeOfAOCParms` text,
  `msClassmark` text,
  `changeOfClassmark` text,
  `seizureTime_date` date DEFAULT NULL,
  `seizureTime_time` time DEFAULT NULL,
  `answerTime_date` date DEFAULT NULL,
  `answerTime_time` time DEFAULT NULL,
  `releaseTime_date` date DEFAULT NULL,
  `releaseTime_time` time DEFAULT NULL,
  `callDuration` int(11) DEFAULT NULL,
  `radioChanRequested` text,
  `radioChanUsed` text,
  `changeOfRadioChan` text,
  `causeForTerm` text,
  `diagnostics` varchar(25) DEFAULT NULL,
  `callReference` varchar(18) NOT NULL DEFAULT '',
  `sequenceNumber` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `additionalChgInfo` text,
  `recordExtensions` text,
  `gsm_SCFAddress` text,
  `serviceKey` tinyint(4) DEFAULT NULL,
  `networkCallReference` varchar(20) DEFAULT NULL,
  `mSCAddress` text,
  `cAMELInitCFIndicator` text,
  `defaultCallHandling` text,
  `fnur` text,
  `aiurRequested` text,
  `speechVersionSupported` text,
  `speechVersionUsed` text,
  `numberOfDPEncountered` text,
  `levelOfCAMELService` text,
  `freeFormatData` text,
  `cAMELCallLegInformation` text,
  `freeFormatDataAppend` text,
  `defaultCallHandling_2` text,
  `gsm_SCFAddress_2` text,
  `serviceKey_2` text,
  `freeFormatData_2` text,
  `freeFormatDataAppend_2` text,
  `systemType` text,
  `rateIndication` text,
  `partialRecordType` text,
  `guaranteedBitRate` text,
  `maximumBitRate` text,
  `modemType` text,
  `classmark3` text,
  `chargedParty` text,
  `originalCalledNumber` text,
  `callingChargeAreaCode` text,
  `calledChargeAreaCode` text,
  `mscOutgoingCircuit` text,
  `orgRNCorBSCId` text,
  `orgMSCId` text,
  `callEmlppPriority` text,
  `callerDefaultEmlppPriority` text,
  `eaSubscriberInfo` text,
  `selectedCIC` text,
  `optimalRoutingFlag` text,
  `optimalRoutingLateForwardFlag` text,
  `optimalRoutingEarlyForwardFlag` text,
  `portedflag` text,
  `calledIMSI` text,
  `globalAreaID` text,
  `changeOfglobalAreaID` text,
  `subscriberCategory` text,
  `firstmccmnc` text,
  `intermediatemccmnc` text,
  `lastmccmnc` text,
  `cUGOutgoingAccessIndicator` text,
  `cUGInterlockCode` text,
  `cUGOutgoingAccessUsed` text,
  `cUGIndex` text,
  `interactionWithIP` text,
  `hotBillingTag` text,
  `setupTime_date` date DEFAULT NULL,
  `setupTime_time` time DEFAULT NULL,
  `alertingTime` text,
  `voiceIndicator` text,
  `bCategory` text,
  `callType` text,
  `initialCallAttemptFlag` text,
  `ussdCallBackFlag` text,
  `mscIncomingCircuit` text,
  `calledDefaultEmlppPriority` text,
  `cUGIncomingAccessUsed` text,
  `redirectingnumber` text,
  `redirectingcounter` text,
  `interrogationTime_date` date DEFAULT NULL,
  `interrogationTime_time` time DEFAULT NULL,
  `destinationRoutingAddress` text,
  `mscServerIndication` text,
  `iSDN_BC` text,
  `lLC` text,
  `hLC` text,
  `mscIncomingRouteAttribute` text,
  `mscOutgoingRouteAttribute` text,
  `isdnBasicService` text,
  `serviceCentre` varchar(20) DEFAULT NULL,
  `messageReference` text,
  `originationTime_date` date DEFAULT NULL,
  `originationTime_time` time DEFAULT NULL,
  `smsResult` text,
  `destinationNumber` varchar(20) DEFAULT NULL,
  `cAMELSMSInformation` text,
  `smsUserDataType` text,
  `smstext` text,
  `maximumNumberOfSMSInTheConcatenatedSMS` text,
  `concatenatedSMSReferenceNumber` text,
  `sequenceNumberOfTheCurrentSMS` text,
  `deliveryTime_date` date DEFAULT NULL,
  `deliveryTime_time` time DEFAULT NULL,
  `origination` varchar(20) DEFAULT NULL,
  `routingNumber` text,
  `numberOfForwarding` text,
  `interrogationResult` text,
  `basicServices` text,
  `supplService` text,
  `ssAction` text,
  `ssActionTime_date` date DEFAULT NULL,
  `ssActionTime_time` time DEFAULT NULL,
  `ssParameters` text,
  `ssActionResult` text,
  `ussdCodingScheme` text,
  `ussdString` text,
  `ussdNotifyCounter` text,
  `ussdRequestCounter` text,
  `equipmentType` text,
  `equipmentId` text,
  `imeiStatus` text,
  `eventTime` text,
  `imeiCheckEvent` text,
  `lcsClientType` text,
  `lcsClientIdentity` text,
  `locationType` text,
  `lcsQos` text,
  `lcsPriority` text,
  `mlc_Number` text,
  `eventTimeStamp` text,
  `measureDuration` text,
  `notificationToMSUser` text,
  `privacyOverride` text,
  `locationEstimate` text,
  `positioningData` text,
  `lcsCause` text,
  `lcsReferenceNumber` text,
  `molr_Type` text,
  `emsDigits` text,
  `emsKey` text,
  `recordNumber` int(10) unsigned DEFAULT NULL,
  `universaldate` date NOT NULL DEFAULT '0000-00-00',
  `universaltime` time NOT NULL DEFAULT '00:00:00',
  `file` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`record_id`,`recordType`,`servedIMSI`,`universaldate`,`universaltime`,`callReference`,`sequenceNumber`,`file`),
  KEY `ix_file` (`file`),
  KEY `ix_msisdn` (`servedMSISDN`),
  KEY `ix_callednumber` (`calledNumber`),
  KEY `ix_universaldate` (`universaldate`),
  KEY `ix_recordType` (`recordType`)
) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 UNION=(`msoftbogt_20080201`,`msoftbarq_20080201`,`msoftbogt_20080202`,`msoftbarq_20080202`,`msoftbogt_20080203`,`msoftbarq_20080203`,`msoftbogt_20080204`,`msoftbarq_20080204`,`msoftbogt_20080205`,`msoftbarq_20080205`,`msoftbogt_20080206`,`msoftbarq_20080206`,`msoftbogt_20080207`,`msoftbarq_20080207`,`msoftbogt_20080208`,`msoftbarq_20080208`,`msoftbogt_20080209`,`msoftbarq_20080209`,`msoftbogt_20080210`,`msoftbarq_20080210`,`msoftbogt_20080211`,`msoftbarq_20080211`,`msoftbogt_20080212`,`msoftbarq_20080212`,`msoftbogt_20080213`,`msoftbarq_20080213`,`msoftbogt_20080214`,`msoftbarq_20080214`,`msoftbogt_20080215`,`msoftbarq_20080215`,`msoftbogt_20080216`,`msoftbarq_20080216`,`msoftbogt_20080217`,`msoftbarq_20080217`,`msoftbogt_20080218`,`msoftbarq_20080218`,`msoftbogt_20080219`,`msoftbarq_20080219`,`msoftbogt_20080220`,`msoftbarq_20080220`,`msoftbogt_20080221`,`msoftbarq_20080221`,`msoftbogt_20080222`,`msoftbarq_20080222`,`msoftbogt_20080223`,`msoftbarq_20080223`,`msoftbogt_20080224`,`msoftbarq_20080224`,`msoftbogt_20080225`,`msoftbarq_20080225`,`msoftbogt_20080226`,`msoftbarq_20080226`,`msoftbogt_20080227`,`msoftbarq_20080227`,`msoftbogt_20080228`,`msoftbarq_20080228`,`msoftbogt_20080229`,`msoftbarq_20080229`)