---------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------- mysql> show create table tblDataSentSMS\G *************************** 1. row *************************** Table: tblDataSentSMS Create Table: CREATE TABLE `tblDataSentSMS` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `ESN` char(20) DEFAULT NULL, `SMSMethod` enum('HTTP','SMTP','SMPP') NOT NULL, `DateSent` datetime NOT NULL, `ICCID` char(22) DEFAULT NULL, `MSISDN` char(10) NOT NULL, `RatePlan` char(4) DEFAULT NULL, `Bytes` mediumint(9) NOT NULL, `Msg` varchar(255) DEFAULT NULL, PRIMARY KEY (`ID`,`DateSent`), KEY `ESN` (`ESN`), KEY `ICCID` (`ICCID`), KEY `MSISDN` (`MSISDN`), KEY `Msg` (`Msg`) ) ENGINE=InnoDB AUTO_INCREMENT=40075202 DEFAULT CHARSET=latin1 COMMENT='Record of SMS messages sent to units' /*!50100 PARTITION BY RANGE ( TO_DAYS(DateSent)) (PARTITION P21Nov2012 VALUES LESS THAN (735193) ENGINE = InnoDB, PARTITION P22Nov2012 VALUES LESS THAN (735194) ENGINE = InnoDB, PARTITION P23Nov2012 VALUES LESS THAN (735195) ENGINE = InnoDB, PARTITION P24Nov2012 VALUES LESS THAN (735196) ENGINE = InnoDB, PARTITION P25Nov2012 VALUES LESS THAN (735197) ENGINE = InnoDB, PARTITION P26Nov2012 VALUES LESS THAN (735198) ENGINE = InnoDB, PARTITION P27Nov2012 VALUES LESS THAN (735199) ENGINE = InnoDB, PARTITION P28Nov2012 VALUES LESS THAN (735200) ENGINE = InnoDB, PARTITION P29Nov2012 VALUES LESS THAN (735201) ENGINE = InnoDB, PARTITION P30Nov2012 VALUES LESS THAN (735202) ENGINE = InnoDB, PARTITION P01Dec2012 VALUES LESS THAN (735203) ENGINE = InnoDB, PARTITION P02Dec2012 VALUES LESS THAN (735204) ENGINE = InnoDB, PARTITION P03Dec2012 VALUES LESS THAN (735205) ENGINE = InnoDB, PARTITION P04Dec2012 VALUES LESS THAN (735206) ENGINE = InnoDB, PARTITION P05Dec2012 VALUES LESS THAN (735207) ENGINE = InnoDB, PARTITION P06Dec2012 VALUES LESS THAN (735208) ENGINE = InnoDB, PARTITION P07Dec2012 VALUES LESS THAN (735209) ENGINE = InnoDB, PARTITION P08Dec2012 VALUES LESS THAN (735210) ENGINE = InnoDB, PARTITION P09Dec2012 VALUES LESS THAN (735211) ENGINE = InnoDB, PARTITION P10Dec2012 VALUES LESS THAN (735212) ENGINE = InnoDB, PARTITION P11Dec2012 VALUES LESS THAN (735213) ENGINE = InnoDB, PARTITION P12Dec2012 VALUES LESS THAN (735214) ENGINE = InnoDB, PARTITION P13Dec2012 VALUES LESS THAN (735215) ENGINE = InnoDB, PARTITION P14Dec2012 VALUES LESS THAN (735216) ENGINE = InnoDB, PARTITION P15Dec2012 VALUES LESS THAN (735217) ENGINE = InnoDB, PARTITION P16Dec2012 VALUES LESS THAN (735218) ENGINE = InnoDB, PARTITION P17Dec2012 VALUES LESS THAN (735219) ENGINE = InnoDB, PARTITION P18Dec2012 VALUES LESS THAN (735220) ENGINE = InnoDB, PARTITION P19Dec2012 VALUES LESS THAN (735221) ENGINE = InnoDB, PARTITION P20Dec2012 VALUES LESS THAN (735222) ENGINE = InnoDB, PARTITION P21Dec2012 VALUES LESS THAN (735223) ENGINE = InnoDB, PARTITION P22Dec2012 VALUES LESS THAN (735224) ENGINE = InnoDB, PARTITION P23Dec2012 VALUES LESS THAN (735225) ENGINE = InnoDB, PARTITION P24Dec2012 VALUES LESS THAN (735226) ENGINE = InnoDB, PARTITION P25Dec2012 VALUES LESS THAN (735227) ENGINE = InnoDB, PARTITION P26Dec2012 VALUES LESS THAN (735228) ENGINE = InnoDB, PARTITION P27Dec2012 VALUES LESS THAN (735229) ENGINE = InnoDB, PARTITION P28Dec2012 VALUES LESS THAN (735230) ENGINE = InnoDB, PARTITION P29Dec2012 VALUES LESS THAN (735231) ENGINE = InnoDB, PARTITION P30Dec2012 VALUES LESS THAN (735232) ENGINE = InnoDB, PARTITION P31Dec2012 VALUES LESS THAN (735233) ENGINE = InnoDB, PARTITION P01Jan2013 VALUES LESS THAN (735234) ENGINE = InnoDB, PARTITION P02Jan2013 VALUES LESS THAN (735235) ENGINE = InnoDB, PARTITION P03Jan2013 VALUES LESS THAN (735236) ENGINE = InnoDB, PARTITION P04Jan2013 VALUES LESS THAN (735237) ENGINE = InnoDB, PARTITION P05Jan2013 VALUES LESS THAN (735238) ENGINE = InnoDB, PARTITION P06Jan2013 VALUES LESS THAN (735239) ENGINE = InnoDB, PARTITION P07Jan2013 VALUES LESS THAN (735240) ENGINE = InnoDB, PARTITION P08Jan2013 VALUES LESS THAN (735241) ENGINE = InnoDB, PARTITION P09Jan2013 VALUES LESS THAN (735242) ENGINE = InnoDB, PARTITION P10Jan2013 VALUES LESS THAN (735243) ENGINE = InnoDB, PARTITION P11Jan2013 VALUES LESS THAN (735244) ENGINE = InnoDB, PARTITION P12Jan2013 VALUES LESS THAN (735245) ENGINE = InnoDB, PARTITION P13Jan2013 VALUES LESS THAN (735246) ENGINE = InnoDB, PARTITION P14Jan2013 VALUES LESS THAN (735247) ENGINE = InnoDB, PARTITION P15Jan2013 VALUES LESS THAN (735248) ENGINE = InnoDB, PARTITION P16Jan2013 VALUES LESS THAN (735249) ENGINE = InnoDB, PARTITION P17Jan2013 VALUES LESS THAN (735250) ENGINE = InnoDB, PARTITION P18Jan2013 VALUES LESS THAN (735251) ENGINE = InnoDB, PARTITION P19Jan2013 VALUES LESS THAN (735252) ENGINE = InnoDB, PARTITION P20Jan2013 VALUES LESS THAN (735253) ENGINE = InnoDB, PARTITION P21Jan2013 VALUES LESS THAN (735254) ENGINE = InnoDB, PARTITION P22Jan2013 VALUES LESS THAN (735255) ENGINE = InnoDB, PARTITION P23Jan2013 VALUES LESS THAN (735256) ENGINE = InnoDB, PARTITION P24Jan2013 VALUES LESS THAN (735257) ENGINE = InnoDB, PARTITION P25Jan2013 VALUES LESS THAN (735258) ENGINE = InnoDB, PARTITION P26Jan2013 VALUES LESS THAN (735259) ENGINE = InnoDB, PARTITION P27Jan2013 VALUES LESS THAN (735260) ENGINE = InnoDB, PARTITION P28Jan2013 VALUES LESS THAN (735261) ENGINE = InnoDB, PARTITION P29Jan2013 VALUES LESS THAN (735262) ENGINE = InnoDB, PARTITION P30Jan2013 VALUES LESS THAN (735263) ENGINE = InnoDB, PARTITION P31Jan2013 VALUES LESS THAN (735264) ENGINE = InnoDB, PARTITION P01Feb2013 VALUES LESS THAN (735265) ENGINE = InnoDB, PARTITION P02Feb2013 VALUES LESS THAN (735266) ENGINE = InnoDB, PARTITION P03Feb2013 VALUES LESS THAN (735267) ENGINE = InnoDB, PARTITION P04Feb2013 VALUES LESS THAN (735268) ENGINE = InnoDB, PARTITION P05Feb2013 VALUES LESS THAN (735269) ENGINE = InnoDB, PARTITION P06Feb2013 VALUES LESS THAN (735270) ENGINE = InnoDB, PARTITION P07Feb2013 VALUES LESS THAN (735271) ENGINE = InnoDB, PARTITION P08Feb2013 VALUES LESS THAN (735272) ENGINE = InnoDB, PARTITION P09Feb2013 VALUES LESS THAN (735273) ENGINE = InnoDB, PARTITION P10Feb2013 VALUES LESS THAN (735274) ENGINE = InnoDB, PARTITION P11Feb2013 VALUES LESS THAN (735275) ENGINE = InnoDB, PARTITION P12Feb2013 VALUES LESS THAN (735276) ENGINE = InnoDB, PARTITION P13Feb2013 VALUES LESS THAN (735277) ENGINE = InnoDB, PARTITION P14Feb2013 VALUES LESS THAN (735278) ENGINE = InnoDB, PARTITION P15Feb2013 VALUES LESS THAN (735279) ENGINE = InnoDB, PARTITION P16Feb2013 VALUES LESS THAN (735280) ENGINE = InnoDB, PARTITION P17Feb2013 VALUES LESS THAN (735281) ENGINE = InnoDB, PARTITION P18Feb2013 VALUES LESS THAN (735282) ENGINE = InnoDB, PARTITION P19Feb2013 VALUES LESS THAN (735283) ENGINE = InnoDB, PARTITION P20Feb2013 VALUES LESS THAN (735284) ENGINE = InnoDB, PARTITION P21Feb2013 VALUES LESS THAN (735285) ENGINE = InnoDB, PARTITION P22Feb2013 VALUES LESS THAN (735286) ENGINE = InnoDB, PARTITION P23Feb2013 VALUES LESS THAN (735287) ENGINE = InnoDB, PARTITION P24Feb2013 VALUES LESS THAN (735288) ENGINE = InnoDB, PARTITION P25Feb2013 VALUES LESS THAN (735289) ENGINE = InnoDB, PARTITION P26Feb2013 VALUES LESS THAN (735290) ENGINE = InnoDB, PARTITION P27Feb2013 VALUES LESS THAN (735291) ENGINE = InnoDB, PARTITION P28Feb2013 VALUES LESS THAN (735292) ENGINE = InnoDB, PARTITION P01Mar2013 VALUES LESS THAN (735293) ENGINE = InnoDB, PARTITION P02Mar2013 VALUES LESS THAN (735294) ENGINE = InnoDB, PARTITION P03Mar2013 VALUES LESS THAN (735295) ENGINE = InnoDB, PARTITION P04Mar2013 VALUES LESS THAN (735296) ENGINE = InnoDB, PARTITION P05Mar2013 VALUES LESS THAN (735297) ENGINE = InnoDB, PARTITION P06Mar2013 VALUES LESS THAN (735298) ENGINE = InnoDB, PARTITION P07Mar2013 VALUES LESS THAN (735299) ENGINE = InnoDB, PARTITION P08Mar2013 VALUES LESS THAN (735300) ENGINE = InnoDB, PARTITION P09Mar2013 VALUES LESS THAN (735301) ENGINE = InnoDB, PARTITION P10Mar2013 VALUES LESS THAN (735302) ENGINE = InnoDB, PARTITION P11Mar2013 VALUES LESS THAN (735303) ENGINE = InnoDB, PARTITION P12Mar2013 VALUES LESS THAN (735304) ENGINE = InnoDB, PARTITION P13Mar2013 VALUES LESS THAN (735305) ENGINE = InnoDB, PARTITION P14Mar2013 VALUES LESS THAN (735306) ENGINE = InnoDB, PARTITION P15Mar2013 VALUES LESS THAN (735307) ENGINE = InnoDB, PARTITION P16Mar2013 VALUES LESS THAN (735308) ENGINE = InnoDB, PARTITION P17Mar2013 VALUES LESS THAN (735309) ENGINE = InnoDB, PARTITION P18Mar2013 VALUES LESS THAN (735310) ENGINE = InnoDB, PARTITION P19Mar2013 VALUES LESS THAN (735311) ENGINE = InnoDB, PARTITION P20Mar2013 VALUES LESS THAN (735312) ENGINE = InnoDB, PARTITION P21Mar2013 VALUES LESS THAN (735313) ENGINE = InnoDB, PARTITION P22Mar2013 VALUES LESS THAN (735314) ENGINE = InnoDB, PARTITION P23Mar2013 VALUES LESS THAN (735315) ENGINE = InnoDB, PARTITION P24Mar2013 VALUES LESS THAN (735316) ENGINE = InnoDB, PARTITION P25Mar2013 VALUES LESS THAN (735317) ENGINE = InnoDB, PARTITION P26Mar2013 VALUES LESS THAN (735318) ENGINE = InnoDB, PARTITION P27Mar2013 VALUES LESS THAN (735319) ENGINE = InnoDB, PARTITION P28Mar2013 VALUES LESS THAN (735320) ENGINE = InnoDB, PARTITION P29Mar2013 VALUES LESS THAN (735321) ENGINE = InnoDB, PARTITION P30Mar2013 VALUES LESS THAN (735322) ENGINE = InnoDB, PARTITION P31Mar2013 VALUES LESS THAN (735323) ENGINE = InnoDB, PARTITION P01Apr2013 VALUES LESS THAN (735324) ENGINE = InnoDB, PARTITION P02Apr2013 VALUES LESS THAN (735325) ENGINE = InnoDB, PARTITION P03Apr2013 VALUES LESS THAN (735326) ENGINE = InnoDB, PARTITION P04Apr2013 VALUES LESS THAN (735327) ENGINE = InnoDB, PARTITION P05Apr2013 VALUES LESS THAN (735328) ENGINE = InnoDB, PARTITION P06Apr2013 VALUES LESS THAN (735329) ENGINE = InnoDB, PARTITION P07Apr2013 VALUES LESS THAN (735330) ENGINE = InnoDB, PARTITION P08Apr2013 VALUES LESS THAN (735331) ENGINE = InnoDB, PARTITION P09Apr2013 VALUES LESS THAN (735332) ENGINE = InnoDB, PARTITION P10Apr2013 VALUES LESS THAN (735333) ENGINE = InnoDB, PARTITION P11Apr2013 VALUES LESS THAN (735334) ENGINE = InnoDB, PARTITION P12Apr2013 VALUES LESS THAN (735335) ENGINE = InnoDB, PARTITION P13Apr2013 VALUES LESS THAN (735336) ENGINE = InnoDB, PARTITION P14Apr2013 VALUES LESS THAN (735337) ENGINE = InnoDB, PARTITION P15Apr2013 VALUES LESS THAN (735338) ENGINE = InnoDB, PARTITION P16Apr2013 VALUES LESS THAN (735339) ENGINE = InnoDB, PARTITION P17Apr2013 VALUES LESS THAN (735340) ENGINE = InnoDB, PARTITION P18Apr2013 VALUES LESS THAN (735341) ENGINE = InnoDB, PARTITION P19Apr2013 VALUES LESS THAN (735342) ENGINE = InnoDB, PARTITION P20Apr2013 VALUES LESS THAN (735343) ENGINE = InnoDB, PARTITION P21Apr2013 VALUES LESS THAN (735344) ENGINE = InnoDB, PARTITION P22Apr2013 VALUES LESS THAN (735345) ENGINE = InnoDB, PARTITION P23Apr2013 VALUES LESS THAN (735346) ENGINE = InnoDB, PARTITION P24Apr2013 VALUES LESS THAN (735347) ENGINE = InnoDB, PARTITION P25Apr2013 VALUES LESS THAN (735348) ENGINE = InnoDB, PARTITION P26Apr2013 VALUES LESS THAN (735349) ENGINE = InnoDB, PARTITION P27Apr2013 VALUES LESS THAN (735350) ENGINE = InnoDB, PARTITION P28Apr2013 VALUES LESS THAN (735351) ENGINE = InnoDB, PARTITION P29Apr2013 VALUES LESS THAN (735352) ENGINE = InnoDB, PARTITION P30Apr2013 VALUES LESS THAN (735353) ENGINE = InnoDB, PARTITION P01May2013 VALUES LESS THAN (735354) ENGINE = InnoDB, PARTITION P02May2013 VALUES LESS THAN (735355) ENGINE = InnoDB, PARTITION P03May2013 VALUES LESS THAN (735356) ENGINE = InnoDB, PARTITION P04May2013 VALUES LESS THAN (735357) ENGINE = InnoDB, PARTITION P05May2013 VALUES LESS THAN (735358) ENGINE = InnoDB, PARTITION P06May2013 VALUES LESS THAN (735359) ENGINE = InnoDB, PARTITION P07May2013 VALUES LESS THAN (735360) ENGINE = InnoDB, PARTITION P08May2013 VALUES LESS THAN (735361) ENGINE = InnoDB, PARTITION P09May2013 VALUES LESS THAN (735362) ENGINE = InnoDB, PARTITION P10May2013 VALUES LESS THAN (735363) ENGINE = InnoDB, PARTITION P11May2013 VALUES LESS THAN (735364) ENGINE = InnoDB, PARTITION P12May2013 VALUES LESS THAN (735365) ENGINE = InnoDB, PARTITION P13May2013 VALUES LESS THAN (735366) ENGINE = InnoDB, PARTITION P14May2013 VALUES LESS THAN (735367) ENGINE = InnoDB, PARTITION P15May2013 VALUES LESS THAN (735368) ENGINE = InnoDB, PARTITION P16May2013 VALUES LESS THAN (735369) ENGINE = InnoDB, PARTITION P17May2013 VALUES LESS THAN (735370) ENGINE = InnoDB, PARTITION P18May2013 VALUES LESS THAN (735371) ENGINE = InnoDB, PARTITION P19May2013 VALUES LESS THAN (735372) ENGINE = InnoDB, PARTITION P20May2013 VALUES LESS THAN (735373) ENGINE = InnoDB, PARTITION P21May2013 VALUES LESS THAN (735374) ENGINE = InnoDB, PARTITION P22May2013 VALUES LESS THAN (735375) ENGINE = InnoDB, PARTITION P23May2013 VALUES LESS THAN (735376) ENGINE = InnoDB, PARTITION P24May2013 VALUES LESS THAN (735377) ENGINE = InnoDB, PARTITION P25May2013 VALUES LESS THAN (735378) ENGINE = InnoDB, PARTITION P26May2013 VALUES LESS THAN (735379) ENGINE = InnoDB, PARTITION P27May2013 VALUES LESS THAN (735380) ENGINE = InnoDB, PARTITION P28May2013 VALUES LESS THAN (735381) ENGINE = InnoDB, PARTITION P29May2013 VALUES LESS THAN (735382) ENGINE = InnoDB, PARTITION P30May2013 VALUES LESS THAN (735383) ENGINE = InnoDB, PARTITION P31May2013 VALUES LESS THAN (735384) ENGINE = InnoDB, PARTITION P01Jun2013 VALUES LESS THAN (735385) ENGINE = InnoDB, PARTITION P02Jun2013 VALUES LESS THAN (735386) ENGINE = InnoDB, PARTITION P03Jun2013 VALUES LESS THAN (735387) ENGINE = InnoDB, PARTITION P04Jun2013 VALUES LESS THAN (735388) ENGINE = InnoDB, PARTITION P05Jun2013 VALUES LESS THAN (735389) ENGINE = InnoDB, PARTITION P06Jun2013 VALUES LESS THAN (735390) ENGINE = InnoDB, PARTITION P07Jun2013 VALUES LESS THAN (735391) ENGINE = InnoDB, PARTITION P08Jun2013 VALUES LESS THAN (735392) ENGINE = InnoDB, PARTITION P09Jun2013 VALUES LESS THAN (735393) ENGINE = InnoDB, PARTITION P10Jun2013 VALUES LESS THAN (735394) ENGINE = InnoDB, PARTITION P11Jun2013 VALUES LESS THAN (735395) ENGINE = InnoDB, PARTITION P12Jun2013 VALUES LESS THAN (735396) ENGINE = InnoDB, PARTITION P13Jun2013 VALUES LESS THAN (735397) ENGINE = InnoDB, PARTITION P14Jun2013 VALUES LESS THAN (735398) ENGINE = InnoDB, PARTITION P15Jun2013 VALUES LESS THAN (735399) ENGINE = InnoDB, PARTITION P16Jun2013 VALUES LESS THAN (735400) ENGINE = InnoDB, PARTITION P17Jun2013 VALUES LESS THAN (735401) ENGINE = InnoDB, PARTITION P18Jun2013 VALUES LESS THAN (735402) ENGINE = InnoDB, PARTITION P19Jun2013 VALUES LESS THAN (735403) ENGINE = InnoDB, PARTITION P20Jun2013 VALUES LESS THAN (735404) ENGINE = InnoDB, PARTITION P21Jun2013 VALUES LESS THAN (735405) ENGINE = InnoDB, PARTITION P22Jun2013 VALUES LESS THAN (735406) ENGINE = InnoDB, PARTITION P23Jun2013 VALUES LESS THAN (735407) ENGINE = InnoDB, PARTITION P24Jun2013 VALUES LESS THAN (735408) ENGINE = InnoDB, PARTITION P25Jun2013 VALUES LESS THAN (735409) ENGINE = InnoDB, PARTITION P26Jun2013 VALUES LESS THAN (735410) ENGINE = InnoDB, PARTITION P27Jun2013 VALUES LESS THAN (735411) ENGINE = InnoDB, PARTITION P28Jun2013 VALUES LESS THAN (735412) ENGINE = InnoDB, PARTITION P29Jun2013 VALUES LESS THAN (735413) ENGINE = InnoDB, PARTITION P30Jun2013 VALUES LESS THAN (735414) ENGINE = InnoDB, PARTITION P01Jul2013 VALUES LESS THAN (735415) ENGINE = InnoDB, PARTITION P02Jul2013 VALUES LESS THAN (735416) ENGINE = InnoDB, PARTITION P03Jul2013 VALUES LESS THAN (735417) ENGINE = InnoDB, PARTITION P04Jul2013 VALUES LESS THAN (735418) ENGINE = InnoDB, PARTITION P05Jul2013 VALUES LESS THAN (735419) ENGINE = InnoDB, PARTITION P06Jul2013 VALUES LESS THAN (735420) ENGINE = InnoDB, PARTITION P07Jul2013 VALUES LESS THAN (735421) ENGINE = InnoDB, PARTITION P08Jul2013 VALUES LESS THAN (735422) ENGINE = InnoDB, PARTITION P09Jul2013 VALUES LESS THAN (735423) ENGINE = InnoDB, PARTITION P10Jul2013 VALUES LESS THAN (735424) ENGINE = InnoDB, PARTITION P11Jul2013 VALUES LESS THAN (735425) ENGINE = InnoDB, PARTITION P12Jul2013 VALUES LESS THAN (735426) ENGINE = InnoDB, PARTITION P13Jul2013 VALUES LESS THAN (735427) ENGINE = InnoDB, PARTITION P14Jul2013 VALUES LESS THAN (735428) ENGINE = InnoDB, PARTITION P15Jul2013 VALUES LESS THAN (735429) ENGINE = InnoDB, PARTITION P16Jul2013 VALUES LESS THAN (735430) ENGINE = InnoDB, PARTITION P17Jul2013 VALUES LESS THAN (735431) ENGINE = InnoDB, PARTITION P18Jul2013 VALUES LESS THAN (735432) ENGINE = InnoDB, PARTITION P19Jul2013 VALUES LESS THAN (735433) ENGINE = InnoDB, PARTITION P20Jul2013 VALUES LESS THAN (735434) ENGINE = InnoDB, PARTITION P21Jul2013 VALUES LESS THAN (735435) ENGINE = InnoDB, PARTITION P22Jul2013 VALUES LESS THAN (735436) ENGINE = InnoDB, PARTITION P23Jul2013 VALUES LESS THAN (735437) ENGINE = InnoDB, PARTITION P24Jul2013 VALUES LESS THAN (735438) ENGINE = InnoDB, PARTITION P25Jul2013 VALUES LESS THAN (735439) ENGINE = InnoDB, PARTITION P26Jul2013 VALUES LESS THAN (735440) ENGINE = InnoDB, PARTITION P27Jul2013 VALUES LESS THAN (735441) ENGINE = InnoDB, PARTITION P28Jul2013 VALUES LESS THAN (735442) ENGINE = InnoDB, PARTITION P29Jul2013 VALUES LESS THAN (735443) ENGINE = InnoDB, PARTITION P30Jul2013 VALUES LESS THAN (735444) ENGINE = InnoDB, PARTITION P31Jul2013 VALUES LESS THAN (735445) ENGINE = InnoDB, PARTITION P01Aug2013 VALUES LESS THAN (735446) ENGINE = InnoDB, PARTITION P02Aug2013 VALUES LESS THAN (735447) ENGINE = InnoDB, PARTITION P03Aug2013 VALUES LESS THAN (735448) ENGINE = InnoDB, PARTITION P04Aug2013 VALUES LESS THAN (735449) ENGINE = InnoDB, PARTITION P05Aug2013 VALUES LESS THAN (735450) ENGINE = InnoDB, PARTITION P06Aug2013 VALUES LESS THAN (735451) ENGINE = InnoDB, PARTITION P07Aug2013 VALUES LESS THAN (735452) ENGINE = InnoDB, PARTITION P08Aug2013 VALUES LESS THAN (735453) ENGINE = InnoDB, PARTITION P09Aug2013 VALUES LESS THAN (735454) ENGINE = InnoDB, PARTITION P10Aug2013 VALUES LESS THAN (735455) ENGINE = InnoDB, PARTITION P11Aug2013 VALUES LESS THAN (735456) ENGINE = InnoDB, PARTITION P12Aug2013 VALUES LESS THAN (735457) ENGINE = InnoDB, PARTITION P13Aug2013 VALUES LESS THAN (735458) ENGINE = InnoDB, PARTITION P14Aug2013 VALUES LESS THAN (735459) ENGINE = InnoDB, PARTITION P15Aug2013 VALUES LESS THAN (735460) ENGINE = InnoDB, PARTITION P16Aug2013 VALUES LESS THAN (735461) ENGINE = InnoDB, PARTITION P17Aug2013 VALUES LESS THAN (735462) ENGINE = InnoDB, PARTITION P18Aug2013 VALUES LESS THAN (735463) ENGINE = InnoDB, PARTITION P19Aug2013 VALUES LESS THAN (735464) ENGINE = InnoDB, PARTITION P20Aug2013 VALUES LESS THAN (735465) ENGINE = InnoDB, PARTITION P21Aug2013 VALUES LESS THAN (735466) ENGINE = InnoDB, PARTITION P22Aug2013 VALUES LESS THAN (735467) ENGINE = InnoDB, PARTITION P23Aug2013 VALUES LESS THAN (735468) ENGINE = InnoDB, PARTITION P24Aug2013 VALUES LESS THAN (735469) ENGINE = InnoDB, PARTITION P25Aug2013 VALUES LESS THAN (735470) ENGINE = InnoDB, PARTITION P26Aug2013 VALUES LESS THAN (735471) ENGINE = InnoDB, PARTITION P27Aug2013 VALUES LESS THAN (735472) ENGINE = InnoDB, PARTITION P28Aug2013 VALUES LESS THAN (735473) ENGINE = InnoDB, PARTITION P29Aug2013 VALUES LESS THAN (735474) ENGINE = InnoDB, PARTITION P30Aug2013 VALUES LESS THAN (735475) ENGINE = InnoDB, PARTITION P31Aug2013 VALUES LESS THAN (735476) ENGINE = InnoDB, PARTITION P01Sep2013 VALUES LESS THAN (735477) ENGINE = InnoDB, PARTITION P02Sep2013 VALUES LESS THAN (735478) ENGINE = InnoDB, PARTITION P03Sep2013 VALUES LESS THAN (735479) ENGINE = InnoDB, PARTITION P04Sep2013 VALUES LESS THAN (735480) ENGINE = InnoDB, PARTITION P05Sep2013 VALUES LESS THAN (735481) ENGINE = InnoDB, PARTITION P06Sep2013 VALUES LESS THAN (735482) ENGINE = InnoDB, PARTITION P07Sep2013 VALUES LESS THAN (735483) ENGINE = InnoDB, PARTITION P08Sep2013 VALUES LESS THAN (735484) ENGINE = InnoDB, PARTITION P09Sep2013 VALUES LESS THAN (735485) ENGINE = InnoDB, PARTITION P10Sep2013 VALUES LESS THAN (735486) ENGINE = InnoDB, PARTITION P11Sep2013 VALUES LESS THAN (735487) ENGINE = InnoDB, PARTITION P12Sep2013 VALUES LESS THAN (735488) ENGINE = InnoDB, PARTITION P13Sep2013 VALUES LESS THAN (735489) ENGINE = InnoDB, PARTITION P14Sep2013 VALUES LESS THAN (735490) ENGINE = InnoDB, PARTITION P15Sep2013 VALUES LESS THAN (735491) ENGINE = InnoDB, PARTITION P16Sep2013 VALUES LESS THAN (735492) ENGINE = InnoDB, PARTITION P17Sep2013 VALUES LESS THAN (735493) ENGINE = InnoDB, PARTITION P18Sep2013 VALUES LESS THAN (735494) ENGINE = InnoDB, PARTITION P19Sep2013 VALUES LESS THAN (735495) ENGINE = InnoDB, PARTITION P20Sep2013 VALUES LESS THAN (735496) ENGINE = InnoDB, PARTITION P21Sep2013 VALUES LESS THAN (735497) ENGINE = InnoDB, PARTITION P22Sep2013 VALUES LESS THAN (735498) ENGINE = InnoDB, PARTITION P23Sep2013 VALUES LESS THAN (735499) ENGINE = InnoDB, PARTITION P24Sep2013 VALUES LESS THAN (735500) ENGINE = InnoDB, PARTITION P25Sep2013 VALUES LESS THAN (735501) ENGINE = InnoDB, PARTITION P26Sep2013 VALUES LESS THAN (735502) ENGINE = InnoDB, PARTITION P27Sep2013 VALUES LESS THAN (735503) ENGINE = InnoDB, PARTITION P28Sep2013 VALUES LESS THAN (735504) ENGINE = InnoDB, PARTITION P29Sep2013 VALUES LESS THAN (735505) ENGINE = InnoDB, PARTITION P30Sep2013 VALUES LESS THAN (735506) ENGINE = InnoDB, PARTITION P01Oct2013 VALUES LESS THAN (735507) ENGINE = InnoDB, PARTITION P02Oct2013 VALUES LESS THAN (735508) ENGINE = InnoDB, PARTITION P03Oct2013 VALUES LESS THAN (735509) ENGINE = InnoDB, PARTITION P04Oct2013 VALUES LESS THAN (735510) ENGINE = InnoDB, PARTITION P05Oct2013 VALUES LESS THAN (735511) ENGINE = InnoDB, PARTITION P06Oct2013 VALUES LESS THAN (735512) ENGINE = InnoDB, PARTITION P07Oct2013 VALUES LESS THAN (735513) ENGINE = InnoDB, PARTITION P08Oct2013 VALUES LESS THAN (735514) ENGINE = InnoDB, PARTITION P09Oct2013 VALUES LESS THAN (735515) ENGINE = InnoDB, PARTITION P10Oct2013 VALUES LESS THAN (735516) ENGINE = InnoDB, PARTITION P11Oct2013 VALUES LESS THAN (735517) ENGINE = InnoDB, PARTITION P12Oct2013 VALUES LESS THAN (735518) ENGINE = InnoDB, PARTITION P13Oct2013 VALUES LESS THAN (735519) ENGINE = InnoDB, PARTITION P14Oct2013 VALUES LESS THAN (735520) ENGINE = InnoDB, PARTITION P15Oct2013 VALUES LESS THAN (735521) ENGINE = InnoDB, PARTITION P16Oct2013 VALUES LESS THAN (735522) ENGINE = InnoDB, PARTITION P17Oct2013 VALUES LESS THAN (735523) ENGINE = InnoDB, PARTITION P18Oct2013 VALUES LESS THAN (735524) ENGINE = InnoDB, PARTITION P19Oct2013 VALUES LESS THAN (735525) ENGINE = InnoDB, PARTITION P20Oct2013 VALUES LESS THAN (735526) ENGINE = InnoDB, PARTITION P21Oct2013 VALUES LESS THAN (735527) ENGINE = InnoDB, PARTITION P22Oct2013 VALUES LESS THAN (735528) ENGINE = InnoDB, PARTITION P23Oct2013 VALUES LESS THAN (735529) ENGINE = InnoDB, PARTITION P24Oct2013 VALUES LESS THAN (735530) ENGINE = InnoDB, PARTITION P25Oct2013 VALUES LESS THAN (735531) ENGINE = InnoDB, PARTITION P26Oct2013 VALUES LESS THAN (735532) ENGINE = InnoDB, PARTITION P27Oct2013 VALUES LESS THAN (735533) ENGINE = InnoDB, PARTITION P28Oct2013 VALUES LESS THAN (735534) ENGINE = InnoDB, PARTITION P29Oct2013 VALUES LESS THAN (735535) ENGINE = InnoDB, PARTITION P30Oct2013 VALUES LESS THAN (735536) ENGINE = InnoDB, PARTITION P31Oct2013 VALUES LESS THAN (735537) ENGINE = InnoDB, PARTITION P01Nov2013 VALUES LESS THAN (735538) ENGINE = InnoDB, PARTITION P02Nov2013 VALUES LESS THAN (735539) ENGINE = InnoDB, PARTITION P03Nov2013 VALUES LESS THAN (735540) ENGINE = InnoDB, PARTITION P04Nov2013 VALUES LESS THAN (735541) ENGINE = InnoDB, PARTITION P05Nov2013 VALUES LESS THAN (735542) ENGINE = InnoDB, PARTITION P06Nov2013 VALUES LESS THAN (735543) ENGINE = InnoDB, PARTITION P07Nov2013 VALUES LESS THAN (735544) ENGINE = InnoDB, PARTITION P08Nov2013 VALUES LESS THAN (735545) ENGINE = InnoDB, PARTITION P09Nov2013 VALUES LESS THAN (735546) ENGINE = InnoDB, PARTITION P10Nov2013 VALUES LESS THAN (735547) ENGINE = InnoDB, PARTITION P11Nov2013 VALUES LESS THAN (735548) ENGINE = InnoDB, PARTITION P12Nov2013 VALUES LESS THAN (735549) ENGINE = InnoDB, PARTITION P13Nov2013 VALUES LESS THAN (735550) ENGINE = InnoDB, PARTITION P14Nov2013 VALUES LESS THAN (735551) ENGINE = InnoDB, PARTITION P15Nov2013 VALUES LESS THAN (735552) ENGINE = InnoDB, PARTITION P16Nov2013 VALUES LESS THAN (735553) ENGINE = InnoDB, PARTITION P17Nov2013 VALUES LESS THAN (735554) ENGINE = InnoDB, PARTITION P18Nov2013 VALUES LESS THAN (735555) ENGINE = InnoDB, PARTITION P19Nov2013 VALUES LESS THAN (735556) ENGINE = InnoDB, PARTITION P20Nov2013 VALUES LESS THAN (735557) ENGINE = InnoDB, PARTITION P21Nov2013 VALUES LESS THAN (735558) ENGINE = InnoDB, PARTITION P22Nov2013 VALUES LESS THAN (735559) ENGINE = InnoDB, PARTITION P23Nov2013 VALUES LESS THAN (735560) ENGINE = InnoDB, PARTITION P24Nov2013 VALUES LESS THAN (735561) ENGINE = InnoDB, PARTITION P25Nov2013 VALUES LESS THAN (735562) ENGINE = InnoDB, PARTITION P26Nov2013 VALUES LESS THAN (735563) ENGINE = InnoDB, PARTITION P27Nov2013 VALUES LESS THAN (735564) ENGINE = InnoDB, PARTITION P28Nov2013 VALUES LESS THAN (735565) ENGINE = InnoDB, PARTITION P29Nov2013 VALUES LESS THAN (735566) ENGINE = InnoDB, PARTITION P30Nov2013 VALUES LESS THAN (735567) ENGINE = InnoDB, PARTITION P01Dec2013 VALUES LESS THAN (735568) ENGINE = InnoDB, PARTITION P02Dec2013 VALUES LESS THAN (735569) ENGINE = InnoDB, PARTITION P03Dec2013 VALUES LESS THAN (735570) ENGINE = InnoDB, PARTITION P04Dec2013 VALUES LESS THAN (735571) ENGINE = InnoDB, PARTITION P05Dec2013 VALUES LESS THAN (735572) ENGINE = InnoDB, PARTITION P06Dec2013 VALUES LESS THAN (735573) ENGINE = InnoDB, PARTITION P07Dec2013 VALUES LESS THAN (735574) ENGINE = InnoDB, PARTITION P08Dec2013 VALUES LESS THAN (735575) ENGINE = InnoDB, PARTITION P09Dec2013 VALUES LESS THAN (735576) ENGINE = InnoDB, PARTITION P10Dec2013 VALUES LESS THAN (735577) ENGINE = InnoDB, PARTITION P11Dec2013 VALUES LESS THAN (735578) ENGINE = InnoDB, PARTITION P12Dec2013 VALUES LESS THAN (735579) ENGINE = InnoDB, PARTITION P13Dec2013 VALUES LESS THAN (735580) ENGINE = InnoDB, PARTITION P14Dec2013 VALUES LESS THAN (735581) ENGINE = InnoDB, PARTITION P15Dec2013 VALUES LESS THAN (735582) ENGINE = InnoDB, PARTITION P16Dec2013 VALUES LESS THAN (735583) ENGINE = InnoDB, PARTITION P17Dec2013 VALUES LESS THAN (735584) ENGINE = InnoDB, PARTITION P18Dec2013 VALUES LESS THAN (735585) ENGINE = InnoDB, PARTITION P19Dec2013 VALUES LESS THAN (735586) ENGINE = InnoDB, PARTITION P20Dec2013 VALUES LESS THAN (735587) ENGINE = InnoDB, PARTITION P21Dec2013 VALUES LESS THAN (735588) ENGINE = InnoDB, PARTITION P22Dec2013 VALUES LESS THAN (735589) ENGINE = InnoDB, PARTITION P23Dec2013 VALUES LESS THAN (735590) ENGINE = InnoDB, PARTITION P24Dec2013 VALUES LESS THAN (735591) ENGINE = InnoDB, PARTITION P25Dec2013 VALUES LESS THAN (735592) ENGINE = InnoDB, PARTITION P26Dec2013 VALUES LESS THAN (735593) ENGINE = InnoDB, PARTITION P27Dec2013 VALUES LESS THAN (735594) ENGINE = InnoDB, PARTITION P28Dec2013 VALUES LESS THAN (735595) ENGINE = InnoDB, PARTITION P29Dec2013 VALUES LESS THAN (735596) ENGINE = InnoDB, PARTITION P30Dec2013 VALUES LESS THAN (735597) ENGINE = InnoDB, PARTITION P31Dec2013 VALUES LESS THAN (735598) ENGINE = InnoDB, PARTITION P01Jan2014 VALUES LESS THAN (735599) ENGINE = InnoDB, PARTITION P02Jan2014 VALUES LESS THAN (735600) ENGINE = InnoDB, PARTITION P03Jan2014 VALUES LESS THAN (735601) ENGINE = InnoDB, PARTITION P04Jan2014 VALUES LESS THAN (735602) ENGINE = InnoDB, PARTITION P05Jan2014 VALUES LESS THAN (735603) ENGINE = InnoDB, PARTITION P06Jan2014 VALUES LESS THAN (735604) ENGINE = InnoDB, PARTITION P07Jan2014 VALUES LESS THAN (735605) ENGINE = InnoDB, PARTITION P08Jan2014 VALUES LESS THAN (735606) ENGINE = InnoDB, PARTITION P09Jan2014 VALUES LESS THAN (735607) ENGINE = InnoDB, PARTITION P10Jan2014 VALUES LESS THAN (735608) ENGINE = InnoDB, PARTITION P11Jan2014 VALUES LESS THAN (735609) ENGINE = InnoDB, PARTITION P12Jan2014 VALUES LESS THAN (735610) ENGINE = InnoDB, PARTITION P13Jan2014 VALUES LESS THAN (735611) ENGINE = InnoDB, PARTITION P14Jan2014 VALUES LESS THAN (735612) ENGINE = InnoDB, PARTITION P15Jan2014 VALUES LESS THAN (735613) ENGINE = InnoDB, PARTITION P16Jan2014 VALUES LESS THAN (735614) ENGINE = InnoDB, PARTITION P17Jan2014 VALUES LESS THAN (735615) ENGINE = InnoDB, PARTITION P18Jan2014 VALUES LESS THAN (735616) ENGINE = InnoDB, PARTITION P19Jan2014 VALUES LESS THAN (735617) ENGINE = InnoDB, PARTITION P20Jan2014 VALUES LESS THAN (735618) ENGINE = InnoDB, PARTITION P21Jan2014 VALUES LESS THAN (735619) ENGINE = InnoDB, PARTITION P22Jan2014 VALUES LESS THAN (735620) ENGINE = InnoDB, PARTITION P23Jan2014 VALUES LESS THAN (735621) ENGINE = InnoDB, PARTITION P24Jan2014 VALUES LESS THAN (735622) ENGINE = InnoDB, PARTITION P25Jan2014 VALUES LESS THAN (735623) ENGINE = InnoDB, PARTITION P26Jan2014 VALUES LESS THAN (735624) ENGINE = InnoDB, PARTITION P27Jan2014 VALUES LESS THAN (735625) ENGINE = InnoDB, PARTITION P28Jan2014 VALUES LESS THAN (735626) ENGINE = InnoDB, PARTITION P29Jan2014 VALUES LESS THAN (735627) ENGINE = InnoDB, PARTITION P30Jan2014 VALUES LESS THAN (735628) ENGINE = InnoDB, PARTITION P31Jan2014 VALUES LESS THAN (735629) ENGINE = InnoDB, PARTITION P01Feb2014 VALUES LESS THAN (735630) ENGINE = InnoDB, PARTITION P02Feb2014 VALUES LESS THAN (735631) ENGINE = InnoDB, PARTITION P03Feb2014 VALUES LESS THAN (735632) ENGINE = InnoDB, PARTITION P04Feb2014 VALUES LESS THAN (735633) ENGINE = InnoDB, PARTITION P05Feb2014 VALUES LESS THAN (735634) ENGINE = InnoDB, PARTITION P06Feb2014 VALUES LESS THAN (735635) ENGINE = InnoDB, PARTITION P07Feb2014 VALUES LESS THAN (735636) ENGINE = InnoDB, PARTITION P08Feb2014 VALUES LESS THAN (735637) ENGINE = InnoDB, PARTITION P09Feb2014 VALUES LESS THAN (735638) ENGINE = InnoDB, PARTITION P10Feb2014 VALUES LESS THAN (735639) ENGINE = InnoDB, PARTITION P11Feb2014 VALUES LESS THAN (735640) ENGINE = InnoDB, PARTITION P12Feb2014 VALUES LESS THAN (735641) ENGINE = InnoDB, PARTITION P13Feb2014 VALUES LESS THAN (735642) ENGINE = InnoDB, PARTITION P14Feb2014 VALUES LESS THAN (735643) ENGINE = InnoDB, PARTITION P15Feb2014 VALUES LESS THAN (735644) ENGINE = InnoDB, PARTITION P16Feb2014 VALUES LESS THAN (735645) ENGINE = InnoDB, PARTITION P17Feb2014 VALUES LESS THAN (735646) ENGINE = InnoDB, PARTITION P18Feb2014 VALUES LESS THAN (735647) ENGINE = InnoDB, PARTITION P19Feb2014 VALUES LESS THAN (735648) ENGINE = InnoDB, PARTITION P20Feb2014 VALUES LESS THAN (735649) ENGINE = InnoDB, PARTITION P21Feb2014 VALUES LESS THAN (735650) ENGINE = InnoDB, PARTITION P22Feb2014 VALUES LESS THAN (735651) ENGINE = InnoDB, PARTITION P23Feb2014 VALUES LESS THAN (735652) ENGINE = InnoDB, PARTITION P24Feb2014 VALUES LESS THAN (735653) ENGINE = InnoDB, PARTITION P25Feb2014 VALUES LESS THAN (735654) ENGINE = InnoDB, PARTITION P26Feb2014 VALUES LESS THAN (735655) ENGINE = InnoDB, PARTITION P27Feb2014 VALUES LESS THAN (735656) ENGINE = InnoDB, PARTITION P28Feb2014 VALUES LESS THAN (735657) ENGINE = InnoDB, PARTITION P01Mar2014 VALUES LESS THAN (735658) ENGINE = InnoDB, PARTITION P02Mar2014 VALUES LESS THAN (735659) ENGINE = InnoDB, PARTITION P03Mar2014 VALUES LESS THAN (735660) ENGINE = InnoDB, PARTITION P04Mar2014 VALUES LESS THAN (735661) ENGINE = InnoDB, PARTITION P05Mar2014 VALUES LESS THAN (735662) ENGINE = InnoDB, PARTITION P06Mar2014 VALUES LESS THAN (735663) ENGINE = InnoDB, PARTITION P07Mar2014 VALUES LESS THAN (735664) ENGINE = InnoDB, PARTITION P08Mar2014 VALUES LESS THAN (735665) ENGINE = InnoDB, PARTITION P09Mar2014 VALUES LESS THAN (735666) ENGINE = InnoDB, PARTITION P10Mar2014 VALUES LESS THAN (735667) ENGINE = InnoDB, PARTITION P11Mar2014 VALUES LESS THAN (735668) ENGINE = InnoDB, PARTITION P12Mar2014 VALUES LESS THAN (735669) ENGINE = InnoDB, PARTITION P13Mar2014 VALUES LESS THAN (735670) ENGINE = InnoDB, PARTITION P14Mar2014 VALUES LESS THAN (735671) ENGINE = InnoDB, PARTITION P15Mar2014 VALUES LESS THAN (735672) ENGINE = InnoDB, PARTITION P16Mar2014 VALUES LESS THAN (735673) ENGINE = InnoDB, PARTITION P17Mar2014 VALUES LESS THAN (735674) ENGINE = InnoDB, PARTITION P18Mar2014 VALUES LESS THAN (735675) ENGINE = InnoDB, PARTITION P19Mar2014 VALUES LESS THAN (735676) ENGINE = InnoDB, PARTITION P20Mar2014 VALUES LESS THAN (735677) ENGINE = InnoDB, PARTITION P21Mar2014 VALUES LESS THAN (735678) ENGINE = InnoDB, PARTITION P22Mar2014 VALUES LESS THAN (735679) ENGINE = InnoDB, PARTITION P23Mar2014 VALUES LESS THAN (735680) ENGINE = InnoDB, PARTITION P24Mar2014 VALUES LESS THAN (735681) ENGINE = InnoDB, PARTITION P25Mar2014 VALUES LESS THAN (735682) ENGINE = InnoDB, PARTITION P26Mar2014 VALUES LESS THAN (735683) ENGINE = InnoDB, PARTITION P27Mar2014 VALUES LESS THAN (735684) ENGINE = InnoDB, PARTITION P28Mar2014 VALUES LESS THAN (735685) ENGINE = InnoDB, PARTITION P29Mar2014 VALUES LESS THAN (735686) ENGINE = InnoDB, PARTITION P30Mar2014 VALUES LESS THAN (735687) ENGINE = InnoDB, PARTITION P31Mar2014 VALUES LESS THAN (735688) ENGINE = InnoDB, PARTITION P01Apr2014 VALUES LESS THAN (735689) ENGINE = InnoDB, PARTITION P02Apr2014 VALUES LESS THAN (735690) ENGINE = InnoDB, PARTITION P03Apr2014 VALUES LESS THAN (735691) ENGINE = InnoDB, PARTITION P04Apr2014 VALUES LESS THAN (735692) ENGINE = InnoDB, PARTITION P05Apr2014 VALUES LESS THAN (735693) ENGINE = InnoDB, PARTITION P06Apr2014 VALUES LESS THAN (735694) ENGINE = InnoDB, PARTITION P07Apr2014 VALUES LESS THAN (735695) ENGINE = InnoDB, PARTITION P08Apr2014 VALUES LESS THAN (735696) ENGINE = InnoDB, PARTITION P09Apr2014 VALUES LESS THAN (735697) ENGINE = InnoDB, PARTITION P10Apr2014 VALUES LESS THAN (735698) ENGINE = InnoDB, PARTITION P11Apr2014 VALUES LESS THAN (735699) ENGINE = InnoDB, PARTITION P12Apr2014 VALUES LESS THAN (735700) ENGINE = InnoDB, PARTITION P13Apr2014 VALUES LESS THAN (735701) ENGINE = InnoDB, PARTITION P14Apr2014 VALUES LESS THAN (735702) ENGINE = InnoDB, PARTITION P15Apr2014 VALUES LESS THAN (735703) ENGINE = InnoDB, PARTITION P16Apr2014 VALUES LESS THAN (735704) ENGINE = InnoDB, PARTITION P17Apr2014 VALUES LESS THAN (735705) ENGINE = InnoDB, PARTITION P18Apr2014 VALUES LESS THAN (735706) ENGINE = InnoDB, PARTITION P19Apr2014 VALUES LESS THAN (735707) ENGINE = InnoDB, PARTITION P20Apr2014 VALUES LESS THAN (735708) ENGINE = InnoDB, PARTITION P21Apr2014 VALUES LESS THAN (735709) ENGINE = InnoDB, PARTITION P22Apr2014 VALUES LESS THAN (735710) ENGINE = InnoDB, PARTITION P23Apr2014 VALUES LESS THAN (735711) ENGINE = InnoDB, PARTITION P24Apr2014 VALUES LESS THAN (735712) ENGINE = InnoDB, PARTITION P25Apr2014 VALUES LESS THAN (735713) ENGINE = InnoDB, PARTITION P26Apr2014 VALUES LESS THAN (735714) ENGINE = InnoDB, PARTITION P27Apr2014 VALUES LESS THAN (735715) ENGINE = InnoDB, PARTITION P28Apr2014 VALUES LESS THAN (735716) ENGINE = InnoDB, PARTITION P29Apr2014 VALUES LESS THAN (735717) ENGINE = InnoDB, PARTITION P30Apr2014 VALUES LESS THAN (735718) ENGINE = InnoDB, PARTITION P01May2014 VALUES LESS THAN (735719) ENGINE = InnoDB, PARTITION P02May2014 VALUES LESS THAN (735720) ENGINE = InnoDB, PARTITION P03May2014 VALUES LESS THAN (735721) ENGINE = InnoDB, PARTITION P04May2014 VALUES LESS THAN (735722) ENGINE = InnoDB, PARTITION P05May2014 VALUES LESS THAN (735723) ENGINE = InnoDB, PARTITION P06May2014 VALUES LESS THAN (735724) ENGINE = InnoDB, PARTITION P07May2014 VALUES LESS THAN (735725) ENGINE = InnoDB, PARTITION P08May2014 VALUES LESS THAN (735726) ENGINE = InnoDB, PARTITION P09May2014 VALUES LESS THAN (735727) ENGINE = InnoDB, PARTITION P10May2014 VALUES LESS THAN (735728) ENGINE = InnoDB, PARTITION P11May2014 VALUES LESS THAN (735729) ENGINE = InnoDB, PARTITION P12May2014 VALUES LESS THAN (735730) ENGINE = InnoDB, PARTITION P13May2014 VALUES LESS THAN (735731) ENGINE = InnoDB, PARTITION P14May2014 VALUES LESS THAN (735732) ENGINE = InnoDB, PARTITION P15May2014 VALUES LESS THAN (735733) ENGINE = InnoDB, PARTITION P16May2014 VALUES LESS THAN (735734) ENGINE = InnoDB, PARTITION P17May2014 VALUES LESS THAN (735735) ENGINE = InnoDB, PARTITION P18May2014 VALUES LESS THAN (735736) ENGINE = InnoDB, PARTITION P19May2014 VALUES LESS THAN (735737) ENGINE = InnoDB, PARTITION P20May2014 VALUES LESS THAN (735738) ENGINE = InnoDB, PARTITION P21May2014 VALUES LESS THAN (735739) ENGINE = InnoDB, PARTITION P22May2014 VALUES LESS THAN (735740) ENGINE = InnoDB, PARTITION P23May2014 VALUES LESS THAN (735741) ENGINE = InnoDB, PARTITION P24May2014 VALUES LESS THAN (735742) ENGINE = InnoDB, PARTITION P25May2014 VALUES LESS THAN (735743) ENGINE = InnoDB, PARTITION P26May2014 VALUES LESS THAN (735744) ENGINE = InnoDB, PARTITION P27May2014 VALUES LESS THAN (735745) ENGINE = InnoDB, PARTITION P28May2014 VALUES LESS THAN (735746) ENGINE = InnoDB, PARTITION P29May2014 VALUES LESS THAN (735747) ENGINE = InnoDB, PARTITION P30May2014 VALUES LESS THAN (735748) ENGINE = InnoDB, PARTITION P31May2014 VALUES LESS THAN (735749) ENGINE = InnoDB, PARTITION P01Jun2014 VALUES LESS THAN (735750) ENGINE = InnoDB, PARTITION P02Jun2014 VALUES LESS THAN (735751) ENGINE = InnoDB, PARTITION P03Jun2014 VALUES LESS THAN (735752) ENGINE = InnoDB, PARTITION P04Jun2014 VALUES LESS THAN (735753) ENGINE = InnoDB, PARTITION P05Jun2014 VALUES LESS THAN (735754) ENGINE = InnoDB, PARTITION P06Jun2014 VALUES LESS THAN (735755) ENGINE = InnoDB, PARTITION P07Jun2014 VALUES LESS THAN (735756) ENGINE = InnoDB, PARTITION P08Jun2014 VALUES LESS THAN (735757) ENGINE = InnoDB, PARTITION P09Jun2014 VALUES LESS THAN (735758) ENGINE = InnoDB, PARTITION P10Jun2014 VALUES LESS THAN (735759) ENGINE = InnoDB, PARTITION P11Jun2014 VALUES LESS THAN (735760) ENGINE = InnoDB, PARTITION P12Jun2014 VALUES LESS THAN (735761) ENGINE = InnoDB, PARTITION P13Jun2014 VALUES LESS THAN (735762) ENGINE = InnoDB, PARTITION P14Jun2014 VALUES LESS THAN (735763) ENGINE = InnoDB, PARTITION P15Jun2014 VALUES LESS THAN (735764) ENGINE = InnoDB, PARTITION P16Jun2014 VALUES LESS THAN (735765) ENGINE = InnoDB, PARTITION P17Jun2014 VALUES LESS THAN (735766) ENGINE = InnoDB, PARTITION P18Jun2014 VALUES LESS THAN (735767) ENGINE = InnoDB, PARTITION P19Jun2014 VALUES LESS THAN (735768) ENGINE = InnoDB, PARTITION P20Jun2014 VALUES LESS THAN (735769) ENGINE = InnoDB, PARTITION P21Jun2014 VALUES LESS THAN (735770) ENGINE = InnoDB, PARTITION P22Jun2014 VALUES LESS THAN (735771) ENGINE = InnoDB, PARTITION P23Jun2014 VALUES LESS THAN (735772) ENGINE = InnoDB, PARTITION P24Jun2014 VALUES LESS THAN (735773) ENGINE = InnoDB, PARTITION P25Jun2014 VALUES LESS THAN (735774) ENGINE = InnoDB, PARTITION P26Jun2014 VALUES LESS THAN (735775) ENGINE = InnoDB, PARTITION P27Jun2014 VALUES LESS THAN (735776) ENGINE = InnoDB, PARTITION P28Jun2014 VALUES LESS THAN (735777) ENGINE = InnoDB, PARTITION P29Jun2014 VALUES LESS THAN (735778) ENGINE = InnoDB, PARTITION P30Jun2014 VALUES LESS THAN (735779) ENGINE = InnoDB, PARTITION P01Jul2014 VALUES LESS THAN (735780) ENGINE = InnoDB, PARTITION P02Jul2014 VALUES LESS THAN (735781) ENGINE = InnoDB, PARTITION P03Jul2014 VALUES LESS THAN (735782) ENGINE = InnoDB, PARTITION P04Jul2014 VALUES LESS THAN (735783) ENGINE = InnoDB, PARTITION P05Jul2014 VALUES LESS THAN (735784) ENGINE = InnoDB, PARTITION P06Jul2014 VALUES LESS THAN (735785) ENGINE = InnoDB, PARTITION P07Jul2014 VALUES LESS THAN (735786) ENGINE = InnoDB, PARTITION P08Jul2014 VALUES LESS THAN (735787) ENGINE = InnoDB, PARTITION P09Jul2014 VALUES LESS THAN (735788) ENGINE = InnoDB, PARTITION P10Jul2014 VALUES LESS THAN (735789) ENGINE = InnoDB, PARTITION P11Jul2014 VALUES LESS THAN (735790) ENGINE = InnoDB, PARTITION P12Jul2014 VALUES LESS THAN (735791) ENGINE = InnoDB, PARTITION P13Jul2014 VALUES LESS THAN (735792) ENGINE = InnoDB, PARTITION P14Jul2014 VALUES LESS THAN (735793) ENGINE = InnoDB, PARTITION P15Jul2014 VALUES LESS THAN (735794) ENGINE = InnoDB, PARTITION P16Jul2014 VALUES LESS THAN (735795) ENGINE = InnoDB, PARTITION P17Jul2014 VALUES LESS THAN (735796) ENGINE = InnoDB, PARTITION P18Jul2014 VALUES LESS THAN (735797) ENGINE = InnoDB, PARTITION P19Jul2014 VALUES LESS THAN (735798) ENGINE = InnoDB, PARTITION P20Jul2014 VALUES LESS THAN (735799) ENGINE = InnoDB, PARTITION P21Jul2014 VALUES LESS THAN (735800) ENGINE = InnoDB, PARTITION P22Jul2014 VALUES LESS THAN (735801) ENGINE = InnoDB, PARTITION P23Jul2014 VALUES LESS THAN (735802) ENGINE = InnoDB, PARTITION P24Jul2014 VALUES LESS THAN (735803) ENGINE = InnoDB, PARTITION P25Jul2014 VALUES LESS THAN (735804) ENGINE = InnoDB, PARTITION P26Jul2014 VALUES LESS THAN (735805) ENGINE = InnoDB, PARTITION P27Jul2014 VALUES LESS THAN (735806) ENGINE = InnoDB, PARTITION P28Jul2014 VALUES LESS THAN (735807) ENGINE = InnoDB, PARTITION P29Jul2014 VALUES LESS THAN (735808) ENGINE = InnoDB, PARTITION P30Jul2014 VALUES LESS THAN (735809) ENGINE = InnoDB, PARTITION P31Jul2014 VALUES LESS THAN (735810) ENGINE = InnoDB, PARTITION P01Aug2014 VALUES LESS THAN (735811) ENGINE = InnoDB, PARTITION P02Aug2014 VALUES LESS THAN (735812) ENGINE = InnoDB, PARTITION P03Aug2014 VALUES LESS THAN (735813) ENGINE = InnoDB, PARTITION P04Aug2014 VALUES LESS THAN (735814) ENGINE = InnoDB, PARTITION P05Aug2014 VALUES LESS THAN (735815) ENGINE = InnoDB, PARTITION P06Aug2014 VALUES LESS THAN (735816) ENGINE = InnoDB, PARTITION P07Aug2014 VALUES LESS THAN (735817) ENGINE = InnoDB, PARTITION P08Aug2014 VALUES LESS THAN (735818) ENGINE = InnoDB, PARTITION P09Aug2014 VALUES LESS THAN (735819) ENGINE = InnoDB, PARTITION P10Aug2014 VALUES LESS THAN (735820) ENGINE = InnoDB, PARTITION P11Aug2014 VALUES LESS THAN (735821) ENGINE = InnoDB, PARTITION P12Aug2014 VALUES LESS THAN (735822) ENGINE = InnoDB, PARTITION P13Aug2014 VALUES LESS THAN (735823) ENGINE = InnoDB, PARTITION P14Aug2014 VALUES LESS THAN (735824) ENGINE = InnoDB, PARTITION P15Aug2014 VALUES LESS THAN (735825) ENGINE = InnoDB, PARTITION P16Aug2014 VALUES LESS THAN (735826) ENGINE = InnoDB, PARTITION P17Aug2014 VALUES LESS THAN (735827) ENGINE = InnoDB, PARTITION P18Aug2014 VALUES LESS THAN (735828) ENGINE = InnoDB, PARTITION P19Aug2014 VALUES LESS THAN (735829) ENGINE = InnoDB, PARTITION P20Aug2014 VALUES LESS THAN (735830) ENGINE = InnoDB, PARTITION P21Aug2014 VALUES LESS THAN (735831) ENGINE = InnoDB, PARTITION P22Aug2014 VALUES LESS THAN (735832) ENGINE = InnoDB, PARTITION P23Aug2014 VALUES LESS THAN (735833) ENGINE = InnoDB, PARTITION P24Aug2014 VALUES LESS THAN (735834) ENGINE = InnoDB, PARTITION P25Aug2014 VALUES LESS THAN (735835) ENGINE = InnoDB, PARTITION P26Aug2014 VALUES LESS THAN (735836) ENGINE = InnoDB, PARTITION P27Aug2014 VALUES LESS THAN (735837) ENGINE = InnoDB, PARTITION P28Aug2014 VALUES LESS THAN (735838) ENGINE = InnoDB, PARTITION P29Aug2014 VALUES LESS THAN (735839) ENGINE = InnoDB, PARTITION P30Aug2014 VALUES LESS THAN (735840) ENGINE = InnoDB, PARTITION P31Aug2014 VALUES LESS THAN (735841) ENGINE = InnoDB, PARTITION P01Sep2014 VALUES LESS THAN (735842) ENGINE = InnoDB, PARTITION P02Sep2014 VALUES LESS THAN (735843) ENGINE = InnoDB, PARTITION P03Sep2014 VALUES LESS THAN (735844) ENGINE = InnoDB, PARTITION P04Sep2014 VALUES LESS THAN (735845) ENGINE = InnoDB, PARTITION P05Sep2014 VALUES LESS THAN (735846) ENGINE = InnoDB, PARTITION P06Sep2014 VALUES LESS THAN (735847) ENGINE = InnoDB, PARTITION P07Sep2014 VALUES LESS THAN (735848) ENGINE = InnoDB, PARTITION P08Sep2014 VALUES LESS THAN (735849) ENGINE = InnoDB, PARTITION P09Sep2014 VALUES LESS THAN (735850) ENGINE = InnoDB, PARTITION P10Sep2014 VALUES LESS THAN (735851) ENGINE = InnoDB, PARTITION P11Sep2014 VALUES LESS THAN (735852) ENGINE = InnoDB, PARTITION P12Sep2014 VALUES LESS THAN (735853) ENGINE = InnoDB, PARTITION P13Sep2014 VALUES LESS THAN (735854) ENGINE = InnoDB, PARTITION P14Sep2014 VALUES LESS THAN (735855) ENGINE = InnoDB, PARTITION P15Sep2014 VALUES LESS THAN (735856) ENGINE = InnoDB, PARTITION P16Sep2014 VALUES LESS THAN (735857) ENGINE = InnoDB, PARTITION P17Sep2014 VALUES LESS THAN (735858) ENGINE = InnoDB, PARTITION P18Sep2014 VALUES LESS THAN (735859) ENGINE = InnoDB, PARTITION P19Sep2014 VALUES LESS THAN (735860) ENGINE = InnoDB, PARTITION P20Sep2014 VALUES LESS THAN (735861) ENGINE = InnoDB, PARTITION P21Sep2014 VALUES LESS THAN (735862) ENGINE = InnoDB, PARTITION P22Sep2014 VALUES LESS THAN (735863) ENGINE = InnoDB, PARTITION P23Sep2014 VALUES LESS THAN (735864) ENGINE = InnoDB, PARTITION P24Sep2014 VALUES LESS THAN (735865) ENGINE = InnoDB, PARTITION P25Sep2014 VALUES LESS THAN (735866) ENGINE = InnoDB, PARTITION P26Sep2014 VALUES LESS THAN (735867) ENGINE = InnoDB, PARTITION P27Sep2014 VALUES LESS THAN (735868) ENGINE = InnoDB, PARTITION P28Sep2014 VALUES LESS THAN (735869) ENGINE = InnoDB, PARTITION P29Sep2014 VALUES LESS THAN (735870) ENGINE = InnoDB, PARTITION P30Sep2014 VALUES LESS THAN (735871) ENGINE = InnoDB, PARTITION P01Oct2014 VALUES LESS THAN (735872) ENGINE = InnoDB, PARTITION P02Oct2014 VALUES LESS THAN (735873) ENGINE = InnoDB, PARTITION P03Oct2014 VALUES LESS THAN (735874) ENGINE = InnoDB, PARTITION P04Oct2014 VALUES LESS THAN (735875) ENGINE = InnoDB, PARTITION P05Oct2014 VALUES LESS THAN (735876) ENGINE = InnoDB, PARTITION P06Oct2014 VALUES LESS THAN (735877) ENGINE = InnoDB, PARTITION P07Oct2014 VALUES LESS THAN (735878) ENGINE = InnoDB, PARTITION P08Oct2014 VALUES LESS THAN (735879) ENGINE = InnoDB, PARTITION P09Oct2014 VALUES LESS THAN (735880) ENGINE = InnoDB, PARTITION P10Oct2014 VALUES LESS THAN (735881) ENGINE = InnoDB, PARTITION P11Oct2014 VALUES LESS THAN (735882) ENGINE = InnoDB, PARTITION P12Oct2014 VALUES LESS THAN (735883) ENGINE = InnoDB, PARTITION P13Oct2014 VALUES LESS THAN (735884) ENGINE = InnoDB, PARTITION P14Oct2014 VALUES LESS THAN (735885) ENGINE = InnoDB, PARTITION P15Oct2014 VALUES LESS THAN (735886) ENGINE = InnoDB, PARTITION P16Oct2014 VALUES LESS THAN (735887) ENGINE = InnoDB, PARTITION P17Oct2014 VALUES LESS THAN (735888) ENGINE = InnoDB, PARTITION P18Oct2014 VALUES LESS THAN (735889) ENGINE = InnoDB, PARTITION P19Oct2014 VALUES LESS THAN (735890) ENGINE = InnoDB, PARTITION P20Oct2014 VALUES LESS THAN (735891) ENGINE = InnoDB, PARTITION P21Oct2014 VALUES LESS THAN (735892) ENGINE = InnoDB, PARTITION P22Oct2014 VALUES LESS THAN (735893) ENGINE = InnoDB, PARTITION P23Oct2014 VALUES LESS THAN (735894) ENGINE = InnoDB, PARTITION P24Oct2014 VALUES LESS THAN (735895) ENGINE = InnoDB, PARTITION P25Oct2014 VALUES LESS THAN (735896) ENGINE = InnoDB, PARTITION P26Oct2014 VALUES LESS THAN (735897) ENGINE = InnoDB, PARTITION P27Oct2014 VALUES LESS THAN (735898) ENGINE = InnoDB, PARTITION P28Oct2014 VALUES LESS THAN (735899) ENGINE = InnoDB, PARTITION P29Oct2014 VALUES LESS THAN (735900) ENGINE = InnoDB, PARTITION P30Oct2014 VALUES LESS THAN (735901) ENGINE = InnoDB, PARTITION P31Oct2014 VALUES LESS THAN (735902) ENGINE = InnoDB, PARTITION P01Nov2014 VALUES LESS THAN (735903) ENGINE = InnoDB, PARTITION P02Nov2014 VALUES LESS THAN (735904) ENGINE = InnoDB, PARTITION P03Nov2014 VALUES LESS THAN (735905) ENGINE = InnoDB, PARTITION P04Nov2014 VALUES LESS THAN (735906) ENGINE = InnoDB, PARTITION P05Nov2014 VALUES LESS THAN (735907) ENGINE = InnoDB, PARTITION P06Nov2014 VALUES LESS THAN (735908) ENGINE = InnoDB, PARTITION P07Nov2014 VALUES LESS THAN (735909) ENGINE = InnoDB, PARTITION P08Nov2014 VALUES LESS THAN (735910) ENGINE = InnoDB, PARTITION P09Nov2014 VALUES LESS THAN (735911) ENGINE = InnoDB, PARTITION P10Nov2014 VALUES LESS THAN (735912) ENGINE = InnoDB, PARTITION P11Nov2014 VALUES LESS THAN (735913) ENGINE = InnoDB, PARTITION P12Nov2014 VALUES LESS THAN (735914) ENGINE = InnoDB, PARTITION P13Nov2014 VALUES LESS THAN (735915) ENGINE = InnoDB, PARTITION P14Nov2014 VALUES LESS THAN (735916) ENGINE = InnoDB, PARTITION P15Nov2014 VALUES LESS THAN (735917) ENGINE = InnoDB, PARTITION P16Nov2014 VALUES LESS THAN (735918) ENGINE = InnoDB, PARTITION P17Nov2014 VALUES LESS THAN (735919) ENGINE = InnoDB, PARTITION P18Nov2014 VALUES LESS THAN (735920) ENGINE = InnoDB, PARTITION P19Nov2014 VALUES LESS THAN (735921) ENGINE = InnoDB, PARTITION P20Nov2014 VALUES LESS THAN (735922) ENGINE = InnoDB, PARTITION P21Nov2014 VALUES LESS THAN (735923) ENGINE = InnoDB, PARTITION P22Nov2014 VALUES LESS THAN (735924) ENGINE = InnoDB, PARTITION P23Nov2014 VALUES LESS THAN (735925) ENGINE = InnoDB, PARTITION P24Nov2014 VALUES LESS THAN (735926) ENGINE = InnoDB, PARTITION P25Nov2014 VALUES LESS THAN (735927) ENGINE = InnoDB, PARTITION P26Nov2014 VALUES LESS THAN (735928) ENGINE = InnoDB, PARTITION P27Nov2014 VALUES LESS THAN (735929) ENGINE = InnoDB, PARTITION P28Nov2014 VALUES LESS THAN (735930) ENGINE = InnoDB, PARTITION P29Nov2014 VALUES LESS THAN (735931) ENGINE = InnoDB, PARTITION P30Nov2014 VALUES LESS THAN (735932) ENGINE = InnoDB, PARTITION P01Dec2014 VALUES LESS THAN (735933) ENGINE = InnoDB, PARTITION P02Dec2014 VALUES LESS THAN (735934) ENGINE = InnoDB, PARTITION P03Dec2014 VALUES LESS THAN (735935) ENGINE = InnoDB, PARTITION P04Dec2014 VALUES LESS THAN (735936) ENGINE = InnoDB, PARTITION P05Dec2014 VALUES LESS THAN (735937) ENGINE = InnoDB, PARTITION P06Dec2014 VALUES LESS THAN (735938) ENGINE = InnoDB, PARTITION P07Dec2014 VALUES LESS THAN (735939) ENGINE = InnoDB, PARTITION P08Dec2014 VALUES LESS THAN (735940) ENGINE = InnoDB, PARTITION P09Dec2014 VALUES LESS THAN (735941) ENGINE = InnoDB, PARTITION P10Dec2014 VALUES LESS THAN (735942) ENGINE = InnoDB, PARTITION P11Dec2014 VALUES LESS THAN (735943) ENGINE = InnoDB, PARTITION P12Dec2014 VALUES LESS THAN (735944) ENGINE = InnoDB, PARTITION P13Dec2014 VALUES LESS THAN (735945) ENGINE = InnoDB, PARTITION P14Dec2014 VALUES LESS THAN (735946) ENGINE = InnoDB, PARTITION P15Dec2014 VALUES LESS THAN (735947) ENGINE = InnoDB, PARTITION P16Dec2014 VALUES LESS THAN (735948) ENGINE = InnoDB, PARTITION P17Dec2014 VALUES LESS THAN (735949) ENGINE = InnoDB, PARTITION P18Dec2014 VALUES LESS THAN (735950) ENGINE = InnoDB, PARTITION P19Dec2014 VALUES LESS THAN (735951) ENGINE = InnoDB, PARTITION P20Dec2014 VALUES LESS THAN (735952) ENGINE = InnoDB, PARTITION P21Dec2014 VALUES LESS THAN (735953) ENGINE = InnoDB, PARTITION P22Dec2014 VALUES LESS THAN (735954) ENGINE = InnoDB, PARTITION P23Dec2014 VALUES LESS THAN (735955) ENGINE = InnoDB, PARTITION P24Dec2014 VALUES LESS THAN (735956) ENGINE = InnoDB, PARTITION P25Dec2014 VALUES LESS THAN (735957) ENGINE = InnoDB, PARTITION P26Dec2014 VALUES LESS THAN (735958) ENGINE = InnoDB, PARTITION P27Dec2014 VALUES LESS THAN (735959) ENGINE = InnoDB, PARTITION P28Dec2014 VALUES LESS THAN (735960) ENGINE = InnoDB, PARTITION P29Dec2014 VALUES LESS THAN (735961) ENGINE = InnoDB, PARTITION P30Dec2014 VALUES LESS THAN (735962) ENGINE = InnoDB, PARTITION P31Dec2014 VALUES LESS THAN (735963) ENGINE = InnoDB, PARTITION P01Jan2015 VALUES LESS THAN (735964) ENGINE = InnoDB, PARTITION P02Jan2015 VALUES LESS THAN (735965) ENGINE = InnoDB, PARTITION P03Jan2015 VALUES LESS THAN (735966) ENGINE = InnoDB, PARTITION P04Jan2015 VALUES LESS THAN (735967) ENGINE = InnoDB, PARTITION P05Jan2015 VALUES LESS THAN (735968) ENGINE = InnoDB, PARTITION P06Jan2015 VALUES LESS THAN (735969) ENGINE = InnoDB, PARTITION P07Jan2015 VALUES LESS THAN (735970) ENGINE = InnoDB, PARTITION P08Jan2015 VALUES LESS THAN (735971) ENGINE = InnoDB, PARTITION P09Jan2015 VALUES LESS THAN (735972) ENGINE = InnoDB, PARTITION P10Jan2015 VALUES LESS THAN (735973) ENGINE = InnoDB, PARTITION P11Jan2015 VALUES LESS THAN (735974) ENGINE = InnoDB, PARTITION P12Jan2015 VALUES LESS THAN (735975) ENGINE = InnoDB, PARTITION P13Jan2015 VALUES LESS THAN (735976) ENGINE = InnoDB, PARTITION P14Jan2015 VALUES LESS THAN (735977) ENGINE = InnoDB, PARTITION P15Jan2015 VALUES LESS THAN (735978) ENGINE = InnoDB, PARTITION P16Jan2015 VALUES LESS THAN (735979) ENGINE = InnoDB, PARTITION P17Jan2015 VALUES LESS THAN (735980) ENGINE = InnoDB, PARTITION P18Jan2015 VALUES LESS THAN (735981) ENGINE = InnoDB, PARTITION P19Jan2015 VALUES LESS THAN (735982) ENGINE = InnoDB, PARTITION P20Jan2015 VALUES LESS THAN (735983) ENGINE = InnoDB, PARTITION P21Jan2015 VALUES LESS THAN (735984) ENGINE = InnoDB, PARTITION P22Jan2015 VALUES LESS THAN (735985) ENGINE = InnoDB, PARTITION P23Jan2015 VALUES LESS THAN (735986) ENGINE = InnoDB, PARTITION P24Jan2015 VALUES LESS THAN (735987) ENGINE = InnoDB, PARTITION P25Jan2015 VALUES LESS THAN (735988) ENGINE = InnoDB, PARTITION P26Jan2015 VALUES LESS THAN (735989) ENGINE = InnoDB, PARTITION P27Jan2015 VALUES LESS THAN (735990) ENGINE = InnoDB, PARTITION P28Jan2015 VALUES LESS THAN (735991) ENGINE = InnoDB, PARTITION P29Jan2015 VALUES LESS THAN (735992) ENGINE = InnoDB, PARTITION P30Jan2015 VALUES LESS THAN (735993) ENGINE = InnoDB, PARTITION P31Jan2015 VALUES LESS THAN (735994) ENGINE = InnoDB, PARTITION P01Feb2015 VALUES LESS THAN (735995) ENGINE = InnoDB, PARTITION P02Feb2015 VALUES LESS THAN (735996) ENGINE = InnoDB, PARTITION P03Feb2015 VALUES LESS THAN (735997) ENGINE = InnoDB, PARTITION P04Feb2015 VALUES LESS THAN (735998) ENGINE = InnoDB, PARTITION P05Feb2015 VALUES LESS THAN (735999) ENGINE = InnoDB, PARTITION P06Feb2015 VALUES LESS THAN (736000) ENGINE = InnoDB, PARTITION P07Feb2015 VALUES LESS THAN (736001) ENGINE = InnoDB, PARTITION P08Feb2015 VALUES LESS THAN (736002) ENGINE = InnoDB, PARTITION P09Feb2015 VALUES LESS THAN (736003) ENGINE = InnoDB, PARTITION P10Feb2015 VALUES LESS THAN (736004) ENGINE = InnoDB, PARTITION P11Feb2015 VALUES LESS THAN (736005) ENGINE = InnoDB, PARTITION P12Feb2015 VALUES LESS THAN (736006) ENGINE = InnoDB, PARTITION P13Feb2015 VALUES LESS THAN (736007) ENGINE = InnoDB, PARTITION P14Feb2015 VALUES LESS THAN (736008) ENGINE = InnoDB, PARTITION P15Feb2015 VALUES LESS THAN (736009) ENGINE = InnoDB, PARTITION P16Feb2015 VALUES LESS THAN (736010) ENGINE = InnoDB, PARTITION P17Feb2015 VALUES LESS THAN (736011) ENGINE = InnoDB, PARTITION P18Feb2015 VALUES LESS THAN (736012) ENGINE = InnoDB, PARTITION P19Feb2015 VALUES LESS THAN (736013) ENGINE = InnoDB, PARTITION P20Feb2015 VALUES LESS THAN (736014) ENGINE = InnoDB, PARTITION P21Feb2015 VALUES LESS THAN (736015) ENGINE = InnoDB, PARTITION P22Feb2015 VALUES LESS THAN (736016) ENGINE = InnoDB, PARTITION P23Feb2015 VALUES LESS THAN (736017) ENGINE = InnoDB, PARTITION P24Feb2015 VALUES LESS THAN (736018) ENGINE = InnoDB, PARTITION P25Feb2015 VALUES LESS THAN (736019) ENGINE = InnoDB, PARTITION P26Feb2015 VALUES LESS THAN (736020) ENGINE = InnoDB, PARTITION P27Feb2015 VALUES LESS THAN (736021) ENGINE = InnoDB, PARTITION P28Feb2015 VALUES LESS THAN (736022) ENGINE = InnoDB, PARTITION P01Mar2015 VALUES LESS THAN (736023) ENGINE = InnoDB, PARTITION P02Mar2015 VALUES LESS THAN (736024) ENGINE = InnoDB, PARTITION P03Mar2015 VALUES LESS THAN (736025) ENGINE = InnoDB, PARTITION P04Mar2015 VALUES LESS THAN (736026) ENGINE = InnoDB, PARTITION P05Mar2015 VALUES LESS THAN (736027) ENGINE = InnoDB, PARTITION P06Mar2015 VALUES LESS THAN (736028) ENGINE = InnoDB, PARTITION P07Mar2015 VALUES LESS THAN (736029) ENGINE = InnoDB, PARTITION P08Mar2015 VALUES LESS THAN (736030) ENGINE = InnoDB, PARTITION P09Mar2015 VALUES LESS THAN (736031) ENGINE = InnoDB, PARTITION P10Mar2015 VALUES LESS THAN (736032) ENGINE = InnoDB, PARTITION P11Mar2015 VALUES LESS THAN (736033) ENGINE = InnoDB, PARTITION P12Mar2015 VALUES LESS THAN (736034) ENGINE = InnoDB, PARTITION P13Mar2015 VALUES LESS THAN (736035) ENGINE = InnoDB, PARTITION P14Mar2015 VALUES LESS THAN (736036) ENGINE = InnoDB, PARTITION P15Mar2015 VALUES LESS THAN (736037) ENGINE = InnoDB, PARTITION P16Mar2015 VALUES LESS THAN (736038) ENGINE = InnoDB, PARTITION P17Mar2015 VALUES LESS THAN (736039) ENGINE = InnoDB, PARTITION P18Mar2015 VALUES LESS THAN (736040) ENGINE = InnoDB, PARTITION P19Mar2015 VALUES LESS THAN (736041) ENGINE = InnoDB, PARTITION P20Mar2015 VALUES LESS THAN (736042) ENGINE = InnoDB, PARTITION P21Mar2015 VALUES LESS THAN (736043) ENGINE = InnoDB, PARTITION P22Mar2015 VALUES LESS THAN (736044) ENGINE = InnoDB, PARTITION P23Mar2015 VALUES LESS THAN (736045) ENGINE = InnoDB, PARTITION P24Mar2015 VALUES LESS THAN (736046) ENGINE = InnoDB, PARTITION P25Mar2015 VALUES LESS THAN (736047) ENGINE = InnoDB, PARTITION P26Mar2015 VALUES LESS THAN (736048) ENGINE = InnoDB, PARTITION P27Mar2015 VALUES LESS THAN (736049) ENGINE = InnoDB, PARTITION P28Mar2015 VALUES LESS THAN (736050) ENGINE = InnoDB, PARTITION P29Mar2015 VALUES LESS THAN (736051) ENGINE = InnoDB, PARTITION P30Mar2015 VALUES LESS THAN (736052) ENGINE = InnoDB, PARTITION P31Mar2015 VALUES LESS THAN (736053) ENGINE = InnoDB, PARTITION P01Apr2015 VALUES LESS THAN (736054) ENGINE = InnoDB, PARTITION PMaxValue VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */ 1 row in set (0.02 sec) ---------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------- mysql> show create view vwUnits\G *************************** 1. row *************************** View: vwUnits Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `vwUnits` AS select `tblUnits`.`UnitID` AS `UnitID`,`tblUnits`.`ESN` AS `ESN`,`tblUnits`.`ICCID` AS `ICCID`,`tblUnits`.`MSISDN` AS `MSISDN`,`tblUnits`.`IMEI` AS `IMEI`,`tblUnits`.`OwnerID` AS `OwnerID`,`tblUnits`.`VehicleID` AS `VehicleID`,`tblUnits`.`DesiredRateLevel` AS `DesiredRateLevel`,`tblUnits`.`RateLevel` AS `RateLevel`,`tblUnits`.`Config` AS `Config`,`tblUnits`.`ConfigLast` AS `ConfigLast`,`tblUnits`.`ConfigLastTime` AS `ConfigLastTime`,`tblUnits`.`Miles` AS `Miles`,`tblUnits`.`LastMiles` AS `LastMiles`,`tblUnits`.`LandmarkID` AS `LandmarkID`,`tblUnits`.`ResellerID` AS `ResellerID`,`tblUnits`.`RA` AS `RA`,`tblUnits`.`RAReason` AS `RAReason`,`tblUnits`.`RAOther` AS `RAOther`,`tblModelPrefixes`.`ModelName` AS `ModelName`,`tblCellularCarriers`.`CarrierName` AS `CarrierName`,`tblCellularCarriers`.`CarrierSub` AS `CarrierSub` from ((`tblUnits` left join `tblModelPrefixes` on(((length(`tblUnits`.`ESN`) = `tblModelPrefixes`.`ESNLength`) and (`tblUnits`.`ESN` like concat(`tblModelPrefixes`.`ESNPrefix`,_latin1'%'))))) left join `tblCellularCarriers` on(((length(`tblUnits`.`ICCID`) = `tblCellularCarriers`.`ICCIDLength`) and (`tblUnits`.`ICCID` like concat(`tblCellularCarriers`.`ICCIDPrefix`,_latin1'%'))))) character_set_client: utf8 collation_connection: utf8_general_ci 1 row in set (0.00 sec) ---------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------- mysql> show create table tblUnits\G *************************** 1. row *************************** Table: tblUnits Create Table: CREATE TABLE `tblUnits` ( `UnitID` char(22) NOT NULL, `ESN` char(16) NOT NULL, `ICCID` char(32) DEFAULT NULL, `MSISDN` char(20) DEFAULT NULL, `IMEI` char(16) DEFAULT NULL, `OwnerID` char(22) DEFAULT NULL, `VehicleID` char(22) DEFAULT NULL, `DesiredRateLevel` smallint(5) unsigned NOT NULL DEFAULT '0', `RateLevel` smallint(5) DEFAULT NULL, `Config` char(255) DEFAULT NULL, `ConfigLast` char(255) DEFAULT NULL, `ConfigLastTime` datetime DEFAULT NULL, `HardwareVersion` varchar(10) DEFAULT NULL, `SoftwareVersion` varchar(10) DEFAULT NULL, `Miles` int(11) DEFAULT NULL, `LastMiles` int(11) DEFAULT NULL, `LandmarkID` char(22) DEFAULT NULL, `ResellerID` char(22) DEFAULT NULL, `RA` varchar(50) NOT NULL, `RAReason` varchar(25) NOT NULL, `RAOther` text NOT NULL, `DevelopmentUnit` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`UnitID`), UNIQUE KEY `ESN` (`ESN`), UNIQUE KEY `ICCID` (`ICCID`), KEY `OwnerID` (`OwnerID`), KEY `ResellerID` (`ResellerID`), KEY `VehicleID` (`VehicleID`), KEY `MSISDN` (`MSISDN`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='GPS Units' 1 row in set (0.00 sec) ---------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------- mysql> show create table tblModelPrefixes\G *************************** 1. row *************************** Table: tblModelPrefixes Create Table: CREATE TABLE `tblModelPrefixes` ( `ModelName` char(16) NOT NULL, `ESNPrefix` char(12) NOT NULL, `ESNLength` smallint(5) unsigned NOT NULL DEFAULT '0', `DefaultModel` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ESNPrefix`), KEY `ModelName` (`ModelName`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='GPS Model Type ESN Prefixes' 1 row in set (0.00 sec) ---------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------- mysql> show create table tblCellularCarriers\G *************************** 1. row *************************** Table: tblCellularCarriers Create Table: CREATE TABLE `tblCellularCarriers` ( `CarrierName` char(50) NOT NULL, `CarrierSub` char(8) NOT NULL, `ICCIDPrefix` char(20) DEFAULT NULL, `ICCIDLength` smallint(5) unsigned NOT NULL DEFAULT '0', `MSISDNPrefix` char(10) DEFAULT NULL, `DefaultCarrier` tinyint(1) unsigned NOT NULL DEFAULT '0', `CarrierKBRate` decimal(10,2) NOT NULL, `CarrierSMSRate` decimal(2,2) NOT NULL, `CarrierMonthDeviceRate` decimal(3,2) NOT NULL, `CarrierPlanDescr` varchar(200) NOT NULL, PRIMARY KEY (`CarrierName`,`CarrierSub`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Cellular Carriers and their ICCID ranges' 1 row in set (0.00 sec) ---------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------