Mine

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`)