Someone

CREATE TABLE `top_moc` (  `msc` varchar(4) NOT NULL default '',  `servedmsisdn` varchar(15) NOT NULL default '',  `servedimsi` varchar(15) default NULL,  `inflag` smallint(5) unsigned default NULL,  `qt_moc` mediumint(8) unsigned default NULL,  `min_moc` double(10,4) unsigned default NULL,  `cid_moc` mediumint(8) unsigned NOT NULL default '0',  `moc_dest` mediumint(8) unsigned NOT NULL default '0',  `moc_ola` mediumint(8) unsigned NOT NULL default '0',  `dialled_moc_comcel` mediumint(8) unsigned NOT NULL default '0',  `dialled_moc_bellsouth` mediumint(8) unsigned NOT NULL default '0',  `dialled_moc_fijo` mediumint(8) unsigned NOT NULL default '0',  `moc_otro` mediumint(8) unsigned NOT NULL default '0',  `qt_cfw_no_vms` mediumint(8) unsigned default NULL,  `min_cfw_no_vms` double(10,4) unsigned default NULL,  `cfw_dest` mediumint(8) unsigned NOT NULL default '0',  `cfw_ola` mediumint(8) unsigned NOT NULL default '0',  `cfw_comcel` mediumint(8) unsigned NOT NULL default '0',  `cfw_bellsouth` mediumint(8) unsigned NOT NULL default '0',  `cfw_fijo` mediumint(8) unsigned NOT NULL default '0',  `cfw_otro` mediumint(8) unsigned NOT NULL default '0',  `qt_mtc` mediumint(8) unsigned default NULL,  `min_mtc` double(10,4) unsigned default NULL,  `mtc_orig` mediumint(8) unsigned NOT NULL default '0',  `cid_mtc` mediumint(8) unsigned NOT NULL default '0',  `min_moc_cfw` double(10,4) unsigned default NULL,  `rel_ic_og` double(10,4) unsigned default NULL,  `offnet_dest` mediumint(8) unsigned NOT NULL default '0',  `cids_moc` longtext,  `cids_mtc` longtext,  `qt_mocSms` mediumint(8) unsigned default NULL,  `qt_mocSMS_ola` mediumint(8) unsigned NOT NULL default '0',  `qt_mocSMS_comcel` mediumint(8) unsigned NOT NULL default '0',  `qt_mocSMS_movistar` mediumint(8) unsigned NOT NULL default '0',  `qt_mocSMS_otros` mediumint(8) unsigned NOT NULL default '0',  `qt_mtcSMS` mediumint(8) unsigned NOT NULL default '0',  `qt_mtcSMS_ola` mediumint(8) unsigned NOT NULL default '0',  `qt_mtcSMS_comcel` mediumint(8) unsigned NOT NULL default '0',  `qt_mtcSMS_movistar` mediumint(8) unsigned NOT NULL default '0',  `qt_mtcSMS_otros` mediumint(8) unsigned NOT NULL default '0',  `qt_mtcSMS_ndif` mediumint(8) unsigned NOT NULL default '0',  `date` date NOT NULL default '0000-00-00',  PRIMARY KEY  (`msc`,`date`,`servedmsisdn`),  KEY `ix_top_moc_date` (`date`),  KEY `ix_top_moc_msisdn` (`servedmsisdn`),  KEY `ix_top_moc_datemsisdn` (`date`,`servedmsisdn`)) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 UNION=(`top_moc_200704`,`top_moc_200705`,`top_moc_200706`) CREATE TABLE `top_moc_200705_test` (  `msc` varchar(4) NOT NULL default '',  `servedmsisdn` varchar(15) NOT NULL default '',  `servedimsi` varchar(15) default NULL,  `inflag` smallint(5) unsigned default NULL,  `qt_moc` mediumint(8) unsigned default NULL,  `min_moc` double(10,4) unsigned default NULL,  `cid_moc` mediumint(8) unsigned NOT NULL default '0',  `moc_dest` mediumint(8) unsigned NOT NULL default '0',  `moc_ola` mediumint(8) unsigned NOT NULL default '0',  `dialled_moc_comcel` mediumint(8) unsigned NOT NULL default '0',  `dialled_moc_bellsouth` mediumint(8) unsigned NOT NULL default '0',  `dialled_moc_fijo` mediumint(8) unsigned NOT NULL default '0',  `moc_otro` mediumint(8) unsigned NOT NULL default '0',  `qt_cfw_no_vms` mediumint(8) unsigned default NULL,  `min_cfw_no_vms` double(10,4) unsigned default NULL,  `cfw_dest` mediumint(8) unsigned NOT NULL default '0',  `cfw_ola` mediumint(8) unsigned NOT NULL default '0',  `cfw_comcel` mediumint(8) unsigned NOT NULL default '0',  `cfw_bellsouth` mediumint(8) unsigned NOT NULL default '0',  `cfw_fijo` mediumint(8) unsigned NOT NULL default '0',  `cfw_otro` mediumint(8) unsigned NOT NULL default '0',  `qt_mtc` mediumint(8) unsigned default NULL,  `min_mtc` double(10,4) unsigned default NULL,  `mtc_orig` mediumint(8) unsigned NOT NULL default '0',  `cid_mtc` mediumint(8) unsigned NOT NULL default '0',  `min_moc_cfw` double(10,4) unsigned default NULL,  `rel_ic_og` double(10,4) unsigned default NULL,  `offnet_dest` mediumint(8) unsigned NOT NULL default '0',  `cids_moc` longtext,  `cids_mtc` longtext,  `qt_mocSms` mediumint(8) unsigned default NULL,  `qt_mocSMS_ola` mediumint(8) unsigned NOT NULL default '0',  `qt_mocSMS_comcel` mediumint(8) unsigned NOT NULL default '0',  `qt_mocSMS_movistar` mediumint(8) unsigned NOT NULL default '0',  `qt_mocSMS_otros` mediumint(8) unsigned NOT NULL default '0',  `qt_mtcSMS` mediumint(8) unsigned NOT NULL default '0',  `qt_mtcSMS_ola` mediumint(8) unsigned NOT NULL default '0',  `qt_mtcSMS_comcel` mediumint(8) unsigned NOT NULL default '0',  `qt_mtcSMS_movistar` mediumint(8) unsigned NOT NULL default '0',  `qt_mtcSMS_otros` mediumint(8) unsigned NOT NULL default '0',  `qt_mtcSMS_ndif` mediumint(8) unsigned NOT NULL default '0',  `date` date NOT NULL default '0000-00-00',  PRIMARY KEY  (`msc`,`date`,`servedmsisdn`),  KEY `ix_top_moc_200705_msisdn` (`servedmsisdn`),  KEY `ix_top_moc_200705_datemsisdn` (`date`,`servedmsisdn`),  KEY `ix_top_moc_200705_datemsisdn1` (`date`,`servedmsisdn`,`qt_moc`),  KEY `ix_top_moc_200705_datemsisdn2` (`date`,`servedmsisdn`,`qt_mtc`),  KEY `ix_top_moc_200705_datemsisdn3` (`date`,`servedmsisdn`,`qt_cfw_no_vms`),  KEY `ix_top_moc_200705_datemsisdn4` (`date`,`servedmsisdn`,`qt_mocSms`),  KEY `ix_top_moc_200705_datemsisdn5` (`date`,`servedmsisdn`,`qt_mtcSMS`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=100000000 AVG_ROW_LENGTH=120