SHARE
TWEET

partitioned table creation and insert

a guest Aug 13th, 2014 286 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # insert_datapoint.SQL
  2. INSERT INTO timeseries (timestamp_millis,id,VALUE) VALUES (1378232792489,1,25.0) ON DUPLICATE KEY UPDATE VALUE=VALUES(VALUE)
  3.  
  4. # create_timeseries.SQL
  5.  
  6. CREATE TABLE `timeseries` (
  7.   `timestamp_millis` BIGINT(20) NOT NULL,
  8.   `id` CHAR(22) NOT NULL,
  9.   `value` DOUBLE NOT NULL,
  10.   PRIMARY KEY (`timestamp_millis`,`id`)
  11. ) ENGINE=InnoDB DEFAULT CHARSET=utf8
  12. PARTITION BY RANGE (timestamp_millis)
  13. SUBPARTITION BY KEY (id)
  14. SUBPARTITIONS 8
  15. (PARTITION p20130902 VALUES LESS THAN (1378166400000) ENGINE = InnoDB,
  16.  PARTITION p20130903 VALUES LESS THAN (1378252800000) ENGINE = InnoDB,
  17.  PARTITION p20130904 VALUES LESS THAN (1378339200000) ENGINE = InnoDB,
  18.  PARTITION p20130905 VALUES LESS THAN (1378425600000) ENGINE = InnoDB,
  19.  PARTITION p20130906 VALUES LESS THAN (1378512000000) ENGINE = InnoDB,
  20.  PARTITION p20130907 VALUES LESS THAN (1378598400000) ENGINE = InnoDB,
  21.  PARTITION p20130908 VALUES LESS THAN (1378684800000) ENGINE = InnoDB,
  22.  PARTITION p20130909 VALUES LESS THAN (1378771200000) ENGINE = InnoDB,
  23.  PARTITION p20130910 VALUES LESS THAN (1378857600000) ENGINE = InnoDB,
  24.  PARTITION p20130911 VALUES LESS THAN (1378944000000) ENGINE = InnoDB,
  25.  PARTITION p20130912 VALUES LESS THAN (1379030400000) ENGINE = InnoDB,
  26.  PARTITION p20130913 VALUES LESS THAN (1379116800000) ENGINE = InnoDB,
  27.  PARTITION p20130914 VALUES LESS THAN (1379203200000) ENGINE = InnoDB,
  28.  PARTITION p20130915 VALUES LESS THAN (1379289600000) ENGINE = InnoDB,
  29.  PARTITION p20130916 VALUES LESS THAN (1379376000000) ENGINE = InnoDB,
  30.  PARTITION p20130917 VALUES LESS THAN (1379462400000) ENGINE = InnoDB,
  31.  PARTITION p20130918 VALUES LESS THAN (1379548800000) ENGINE = InnoDB,
  32.  PARTITION p20130919 VALUES LESS THAN (1379635200000) ENGINE = InnoDB,
  33.  PARTITION p20130920 VALUES LESS THAN (1379721600000) ENGINE = InnoDB,
  34.  PARTITION p20130921 VALUES LESS THAN (1379808000000) ENGINE = InnoDB,
  35.  PARTITION p20130922 VALUES LESS THAN (1379894400000) ENGINE = InnoDB,
  36.  PARTITION p20130923 VALUES LESS THAN (1379980800000) ENGINE = InnoDB,
  37.  PARTITION p20130924 VALUES LESS THAN (1380067200000) ENGINE = InnoDB,
  38.  PARTITION p20130925 VALUES LESS THAN (1380153600000) ENGINE = InnoDB,
  39.  PARTITION p20130926 VALUES LESS THAN (1380240000000) ENGINE = InnoDB,
  40.  PARTITION p20130927 VALUES LESS THAN (1380326400000) ENGINE = InnoDB,
  41.  PARTITION p20130928 VALUES LESS THAN (1380412800000) ENGINE = InnoDB,
  42.  PARTITION p20130929 VALUES LESS THAN (1380499200000) ENGINE = InnoDB,
  43.  PARTITION p20130930 VALUES LESS THAN (1380585600000) ENGINE = InnoDB,
  44.  PARTITION p20131001 VALUES LESS THAN (1380672000000) ENGINE = InnoDB,
  45.  PARTITION p20131002 VALUES LESS THAN (1380758400000) ENGINE = InnoDB,
  46.  PARTITION p20131003 VALUES LESS THAN (1380844800000) ENGINE = InnoDB,
  47.  PARTITION p20131004 VALUES LESS THAN (1380931200000) ENGINE = InnoDB,
  48.  PARTITION p20131005 VALUES LESS THAN (1381017600000) ENGINE = InnoDB,
  49.  PARTITION p20131006 VALUES LESS THAN (1381104000000) ENGINE = InnoDB,
  50.  PARTITION p20131007 VALUES LESS THAN (1381190400000) ENGINE = InnoDB,
  51.  PARTITION p20131008 VALUES LESS THAN (1381276800000) ENGINE = InnoDB,
  52.  PARTITION p20131009 VALUES LESS THAN (1381363200000) ENGINE = InnoDB,
  53.  PARTITION p20131010 VALUES LESS THAN (1381449600000) ENGINE = InnoDB,
  54.  PARTITION p20131011 VALUES LESS THAN (1381536000000) ENGINE = InnoDB,
  55.  PARTITION p20131012 VALUES LESS THAN (1381622400000) ENGINE = InnoDB,
  56.  PARTITION p20131013 VALUES LESS THAN (1381708800000) ENGINE = InnoDB,
  57.  PARTITION p20131014 VALUES LESS THAN (1381795200000) ENGINE = InnoDB,
  58.  PARTITION p20131015 VALUES LESS THAN (1381881600000) ENGINE = InnoDB,
  59.  PARTITION p20131016 VALUES LESS THAN (1381968000000) ENGINE = InnoDB,
  60.  PARTITION p20131017 VALUES LESS THAN (1382054400000) ENGINE = InnoDB,
  61.  PARTITION p20131018 VALUES LESS THAN (1382140800000) ENGINE = InnoDB,
  62.  PARTITION p20131019 VALUES LESS THAN (1382227200000) ENGINE = InnoDB,
  63.  PARTITION p20131020 VALUES LESS THAN (1382313600000) ENGINE = InnoDB,
  64.  PARTITION p20131021 VALUES LESS THAN (1382400000000) ENGINE = InnoDB,
  65.  PARTITION p20131022 VALUES LESS THAN (1382486400000) ENGINE = InnoDB,
  66.  PARTITION p20131023 VALUES LESS THAN (1382572800000) ENGINE = InnoDB,
  67.  PARTITION p20131024 VALUES LESS THAN (1382659200000) ENGINE = InnoDB,
  68.  PARTITION p20131025 VALUES LESS THAN (1382745600000) ENGINE = InnoDB,
  69.  PARTITION p20131026 VALUES LESS THAN (1382832000000) ENGINE = InnoDB,
  70.  PARTITION p20131027 VALUES LESS THAN (1382918400000) ENGINE = InnoDB,
  71.  PARTITION p20131028 VALUES LESS THAN (1383004800000) ENGINE = InnoDB,
  72.  PARTITION p20131029 VALUES LESS THAN (1383091200000) ENGINE = InnoDB,
  73.  PARTITION p20131030 VALUES LESS THAN (1383177600000) ENGINE = InnoDB,
  74.  PARTITION p20131031 VALUES LESS THAN (1383264000000) ENGINE = InnoDB,
  75.  PARTITION p20131101 VALUES LESS THAN (1383350400000) ENGINE = InnoDB,
  76.  PARTITION p20131102 VALUES LESS THAN (1383436800000) ENGINE = InnoDB,
  77.  PARTITION p20131103 VALUES LESS THAN (1383523200000) ENGINE = InnoDB,
  78.  PARTITION p20131104 VALUES LESS THAN (1383609600000) ENGINE = InnoDB,
  79.  PARTITION p20131105 VALUES LESS THAN (1383696000000) ENGINE = InnoDB,
  80.  PARTITION p20131106 VALUES LESS THAN (1383782400000) ENGINE = InnoDB,
  81.  PARTITION p20131107 VALUES LESS THAN (1383868800000) ENGINE = InnoDB,
  82.  PARTITION p20131108 VALUES LESS THAN (1383955200000) ENGINE = InnoDB,
  83.  PARTITION p20131109 VALUES LESS THAN (1384041600000) ENGINE = InnoDB,
  84.  PARTITION p20131110 VALUES LESS THAN (1384128000000) ENGINE = InnoDB,
  85.  PARTITION p20131111 VALUES LESS THAN (1384214400000) ENGINE = InnoDB,
  86.  PARTITION p20131112 VALUES LESS THAN (1384300800000) ENGINE = InnoDB,
  87.  PARTITION p20131113 VALUES LESS THAN (1384387200000) ENGINE = InnoDB,
  88.  PARTITION p20131114 VALUES LESS THAN (1384473600000) ENGINE = InnoDB,
  89.  PARTITION p20131115 VALUES LESS THAN (1384560000000) ENGINE = InnoDB,
  90.  PARTITION p20131116 VALUES LESS THAN (1384646400000) ENGINE = InnoDB,
  91.  PARTITION p20131117 VALUES LESS THAN (1384732800000) ENGINE = InnoDB,
  92.  PARTITION p20131118 VALUES LESS THAN (1384819200000) ENGINE = InnoDB,
  93.  PARTITION p20131119 VALUES LESS THAN (1384905600000) ENGINE = InnoDB,
  94.  PARTITION p20131120 VALUES LESS THAN (1384992000000) ENGINE = InnoDB,
  95.  PARTITION p20131121 VALUES LESS THAN (1385078400000) ENGINE = InnoDB,
  96.  PARTITION p20131122 VALUES LESS THAN (1385164800000) ENGINE = InnoDB,
  97.  PARTITION p20131123 VALUES LESS THAN (1385251200000) ENGINE = InnoDB,
  98.  PARTITION p20131124 VALUES LESS THAN (1385337600000) ENGINE = InnoDB,
  99.  PARTITION p20131125 VALUES LESS THAN (1385424000000) ENGINE = InnoDB,
  100.  PARTITION p20131126 VALUES LESS THAN (1385510400000) ENGINE = InnoDB,
  101.  PARTITION p20131127 VALUES LESS THAN (1385596800000) ENGINE = InnoDB,
  102.  PARTITION p20131128 VALUES LESS THAN (1385683200000) ENGINE = InnoDB,
  103.  PARTITION p20131129 VALUES LESS THAN (1385769600000) ENGINE = InnoDB,
  104.  PARTITION p20131130 VALUES LESS THAN (1385856000000) ENGINE = InnoDB,
  105.  PARTITION p20131201 VALUES LESS THAN (1385942400000) ENGINE = InnoDB,
  106.  PARTITION p20131202 VALUES LESS THAN (1386028800000) ENGINE = InnoDB,
  107.  PARTITION p20131203 VALUES LESS THAN (1386115200000) ENGINE = InnoDB,
  108.  PARTITION p20131204 VALUES LESS THAN (1386201600000) ENGINE = InnoDB,
  109.  PARTITION p20131205 VALUES LESS THAN (1386288000000) ENGINE = InnoDB,
  110.  PARTITION p20131206 VALUES LESS THAN (1386374400000) ENGINE = InnoDB,
  111.  PARTITION p20131207 VALUES LESS THAN (1386460800000) ENGINE = InnoDB,
  112.  PARTITION p20131208 VALUES LESS THAN (1386547200000) ENGINE = InnoDB,
  113.  PARTITION p20131209 VALUES LESS THAN (1386633600000) ENGINE = InnoDB,
  114.  PARTITION p20131210 VALUES LESS THAN (1386720000000) ENGINE = InnoDB,
  115.  PARTITION p20131211 VALUES LESS THAN (1386806400000) ENGINE = InnoDB,
  116.  PARTITION p20131212 VALUES LESS THAN (1386892800000) ENGINE = InnoDB,
  117.  PARTITION p20131213 VALUES LESS THAN (1386979200000) ENGINE = InnoDB,
  118.  PARTITION p20131214 VALUES LESS THAN (1387065600000) ENGINE = InnoDB,
  119.  PARTITION p20131215 VALUES LESS THAN (1387152000000) ENGINE = InnoDB,
  120.  PARTITION p20131216 VALUES LESS THAN (1387238400000) ENGINE = InnoDB,
  121.  PARTITION p20131217 VALUES LESS THAN (1387324800000) ENGINE = InnoDB,
  122.  PARTITION p20131218 VALUES LESS THAN (1387411200000) ENGINE = InnoDB,
  123.  PARTITION p20131219 VALUES LESS THAN (1387497600000) ENGINE = InnoDB,
  124.  PARTITION p20131220 VALUES LESS THAN (1387584000000) ENGINE = InnoDB,
  125.  PARTITION p20131221 VALUES LESS THAN (1387670400000) ENGINE = InnoDB,
  126.  PARTITION p20131222 VALUES LESS THAN (1387756800000) ENGINE = InnoDB,
  127.  PARTITION p20131223 VALUES LESS THAN (1387843200000) ENGINE = InnoDB,
  128.  PARTITION p20131224 VALUES LESS THAN (1387929600000) ENGINE = InnoDB,
  129.  PARTITION p20131225 VALUES LESS THAN (1388016000000) ENGINE = InnoDB,
  130.  PARTITION p20131226 VALUES LESS THAN (1388102400000) ENGINE = InnoDB,
  131.  PARTITION p20131227 VALUES LESS THAN (1388188800000) ENGINE = InnoDB,
  132.  PARTITION p20131228 VALUES LESS THAN (1388275200000) ENGINE = InnoDB,
  133.  PARTITION p20131229 VALUES LESS THAN (1388361600000) ENGINE = InnoDB,
  134.  PARTITION p20131230 VALUES LESS THAN (1388448000000) ENGINE = InnoDB,
  135.  PARTITION p20131231 VALUES LESS THAN (1388534400000) ENGINE = InnoDB,
  136.  PARTITION p20140101 VALUES LESS THAN (1388620800000) ENGINE = InnoDB,
  137.  PARTITION p20140102 VALUES LESS THAN (1388707200000) ENGINE = InnoDB,
  138.  PARTITION p20140103 VALUES LESS THAN (1388793600000) ENGINE = InnoDB,
  139.  PARTITION p20140104 VALUES LESS THAN (1388880000000) ENGINE = InnoDB,
  140.  PARTITION p20140105 VALUES LESS THAN (1388966400000) ENGINE = InnoDB,
  141.  PARTITION p20140106 VALUES LESS THAN (1389052800000) ENGINE = InnoDB,
  142.  PARTITION p20140107 VALUES LESS THAN (1389139200000) ENGINE = InnoDB,
  143.  PARTITION p20140108 VALUES LESS THAN (1389225600000) ENGINE = InnoDB,
  144.  PARTITION p20140109 VALUES LESS THAN (1389312000000) ENGINE = InnoDB,
  145.  PARTITION p20140110 VALUES LESS THAN (1389398400000) ENGINE = InnoDB,
  146.  PARTITION p20140111 VALUES LESS THAN (1389484800000) ENGINE = InnoDB,
  147.  PARTITION p20140112 VALUES LESS THAN (1389571200000) ENGINE = InnoDB,
  148.  PARTITION p20140113 VALUES LESS THAN (1389657600000) ENGINE = InnoDB,
  149.  PARTITION p20140114 VALUES LESS THAN (1389744000000) ENGINE = InnoDB,
  150.  PARTITION p20140115 VALUES LESS THAN (1389830400000) ENGINE = InnoDB,
  151.  PARTITION p20140116 VALUES LESS THAN (1389916800000) ENGINE = InnoDB,
  152.  PARTITION p20140117 VALUES LESS THAN (1390003200000) ENGINE = InnoDB,
  153.  PARTITION p20140118 VALUES LESS THAN (1390089600000) ENGINE = InnoDB,
  154.  PARTITION p20140119 VALUES LESS THAN (1390176000000) ENGINE = InnoDB,
  155.  PARTITION p20140120 VALUES LESS THAN (1390262400000) ENGINE = InnoDB,
  156.  PARTITION p20140121 VALUES LESS THAN (1390348800000) ENGINE = InnoDB,
  157.  PARTITION p20140122 VALUES LESS THAN (1390435200000) ENGINE = InnoDB,
  158.  PARTITION p20140123 VALUES LESS THAN (1390521600000) ENGINE = InnoDB,
  159.  PARTITION p20140124 VALUES LESS THAN (1390608000000) ENGINE = InnoDB,
  160.  PARTITION p20140125 VALUES LESS THAN (1390694400000) ENGINE = InnoDB,
  161.  PARTITION p20140126 VALUES LESS THAN (1390780800000) ENGINE = InnoDB,
  162.  PARTITION p20140127 VALUES LESS THAN (1390867200000) ENGINE = InnoDB,
  163.  PARTITION p20140128 VALUES LESS THAN (1390953600000) ENGINE = InnoDB,
  164.  PARTITION p20140129 VALUES LESS THAN (1391040000000) ENGINE = InnoDB,
  165.  PARTITION p20140130 VALUES LESS THAN (1391126400000) ENGINE = InnoDB,
  166.  PARTITION p20140131 VALUES LESS THAN (1391212800000) ENGINE = InnoDB,
  167.  PARTITION p20140201 VALUES LESS THAN (1391299200000) ENGINE = InnoDB,
  168.  PARTITION p20140202 VALUES LESS THAN (1391385600000) ENGINE = InnoDB,
  169.  PARTITION p20140203 VALUES LESS THAN (1391472000000) ENGINE = InnoDB,
  170.  PARTITION p20140204 VALUES LESS THAN (1391558400000) ENGINE = InnoDB,
  171.  PARTITION p20140205 VALUES LESS THAN (1391644800000) ENGINE = InnoDB,
  172.  PARTITION p20140206 VALUES LESS THAN (1391731200000) ENGINE = InnoDB,
  173.  PARTITION p20140207 VALUES LESS THAN (1391817600000) ENGINE = InnoDB,
  174.  PARTITION p20140208 VALUES LESS THAN (1391904000000) ENGINE = InnoDB,
  175.  PARTITION p20140209 VALUES LESS THAN (1391990400000) ENGINE = InnoDB,
  176.  PARTITION p20140210 VALUES LESS THAN (1392076800000) ENGINE = InnoDB,
  177.  PARTITION p20140211 VALUES LESS THAN (1392163200000) ENGINE = InnoDB,
  178.  PARTITION p20140212 VALUES LESS THAN (1392249600000) ENGINE = InnoDB,
  179.  PARTITION p20140213 VALUES LESS THAN (1392336000000) ENGINE = InnoDB,
  180.  PARTITION p20140214 VALUES LESS THAN (1392422400000) ENGINE = InnoDB,
  181.  PARTITION p20140215 VALUES LESS THAN (1392508800000) ENGINE = InnoDB,
  182.  PARTITION p20140216 VALUES LESS THAN (1392595200000) ENGINE = InnoDB,
  183.  PARTITION p20140217 VALUES LESS THAN (1392681600000) ENGINE = InnoDB,
  184.  PARTITION p20140218 VALUES LESS THAN (1392768000000) ENGINE = InnoDB,
  185.  PARTITION p20140219 VALUES LESS THAN (1392854400000) ENGINE = InnoDB,
  186.  PARTITION p20140220 VALUES LESS THAN (1392940800000) ENGINE = InnoDB,
  187.  PARTITION p20140221 VALUES LESS THAN (1393027200000) ENGINE = InnoDB,
  188.  PARTITION p20140222 VALUES LESS THAN (1393113600000) ENGINE = InnoDB,
  189.  PARTITION p20140223 VALUES LESS THAN (1393200000000) ENGINE = InnoDB,
  190.  PARTITION p20140224 VALUES LESS THAN (1393286400000) ENGINE = InnoDB,
  191.  PARTITION p20140225 VALUES LESS THAN (1393372800000) ENGINE = InnoDB,
  192.  PARTITION p20140226 VALUES LESS THAN (1393459200000) ENGINE = InnoDB,
  193.  PARTITION p20140227 VALUES LESS THAN (1393545600000) ENGINE = InnoDB,
  194.  PARTITION p20140228 VALUES LESS THAN (1393632000000) ENGINE = InnoDB,
  195.  PARTITION p20140301 VALUES LESS THAN (1393718400000) ENGINE = InnoDB,
  196.  PARTITION p20140302 VALUES LESS THAN (1393804800000) ENGINE = InnoDB,
  197.  PARTITION p20140303 VALUES LESS THAN (1393891200000) ENGINE = InnoDB,
  198.  PARTITION p20140304 VALUES LESS THAN (1393977600000) ENGINE = InnoDB,
  199.  PARTITION p20140305 VALUES LESS THAN (1394064000000) ENGINE = InnoDB,
  200.  PARTITION p20140306 VALUES LESS THAN (1394150400000) ENGINE = InnoDB,
  201.  PARTITION p20140307 VALUES LESS THAN (1394236800000) ENGINE = InnoDB,
  202.  PARTITION p20140308 VALUES LESS THAN (1394323200000) ENGINE = InnoDB,
  203.  PARTITION p20140309 VALUES LESS THAN (1394409600000) ENGINE = InnoDB,
  204.  PARTITION p20140310 VALUES LESS THAN (1394496000000) ENGINE = InnoDB,
  205.  PARTITION p20140311 VALUES LESS THAN (1394582400000) ENGINE = InnoDB,
  206.  PARTITION p20140312 VALUES LESS THAN (1394668800000) ENGINE = InnoDB,
  207.  PARTITION p20140313 VALUES LESS THAN (1394755200000) ENGINE = InnoDB,
  208.  PARTITION p20140314 VALUES LESS THAN (1394841600000) ENGINE = InnoDB,
  209.  PARTITION p20140315 VALUES LESS THAN (1394928000000) ENGINE = InnoDB,
  210.  PARTITION p20140316 VALUES LESS THAN (1395014400000) ENGINE = InnoDB,
  211.  PARTITION p20140317 VALUES LESS THAN (1395100800000) ENGINE = InnoDB,
  212.  PARTITION p20140318 VALUES LESS THAN (1395187200000) ENGINE = InnoDB,
  213.  PARTITION p20140319 VALUES LESS THAN (1395273600000) ENGINE = InnoDB,
  214.  PARTITION p20140320 VALUES LESS THAN (1395360000000) ENGINE = InnoDB,
  215.  PARTITION p20140321 VALUES LESS THAN (1395446400000) ENGINE = InnoDB,
  216.  PARTITION p20140322 VALUES LESS THAN (1395532800000) ENGINE = InnoDB,
  217.  PARTITION p20140323 VALUES LESS THAN (1395619200000) ENGINE = InnoDB,
  218.  PARTITION p20140324 VALUES LESS THAN (1395705600000) ENGINE = InnoDB,
  219.  PARTITION p20140325 VALUES LESS THAN (1395792000000) ENGINE = InnoDB,
  220.  PARTITION p20140326 VALUES LESS THAN (1395878400000) ENGINE = InnoDB,
  221.  PARTITION p20140327 VALUES LESS THAN (1395964800000) ENGINE = InnoDB,
  222.  PARTITION p20140328 VALUES LESS THAN (1396051200000) ENGINE = InnoDB,
  223.  PARTITION p20140329 VALUES LESS THAN (1396137600000) ENGINE = InnoDB,
  224.  PARTITION p20140330 VALUES LESS THAN (1396224000000) ENGINE = InnoDB,
  225.  PARTITION p20140331 VALUES LESS THAN (1396310400000) ENGINE = InnoDB,
  226.  PARTITION p20140401 VALUES LESS THAN (1396396800000) ENGINE = InnoDB,
  227.  PARTITION p20140402 VALUES LESS THAN (1396483200000) ENGINE = InnoDB,
  228.  PARTITION p20140403 VALUES LESS THAN (1396569600000) ENGINE = InnoDB,
  229.  PARTITION p20140404 VALUES LESS THAN (1396656000000) ENGINE = InnoDB,
  230.  PARTITION p20140405 VALUES LESS THAN (1396742400000) ENGINE = InnoDB,
  231.  PARTITION p20140406 VALUES LESS THAN (1396828800000) ENGINE = InnoDB,
  232.  PARTITION p20140407 VALUES LESS THAN (1396915200000) ENGINE = InnoDB,
  233.  PARTITION p20140408 VALUES LESS THAN (1397001600000) ENGINE = InnoDB,
  234.  PARTITION p20140409 VALUES LESS THAN (1397088000000) ENGINE = InnoDB,
  235.  PARTITION p20140410 VALUES LESS THAN (1397174400000) ENGINE = InnoDB,
  236.  PARTITION p20140411 VALUES LESS THAN (1397260800000) ENGINE = InnoDB,
  237.  PARTITION p20140412 VALUES LESS THAN (1397347200000) ENGINE = InnoDB,
  238.  PARTITION p20140413 VALUES LESS THAN (1397433600000) ENGINE = InnoDB,
  239.  PARTITION p20140414 VALUES LESS THAN (1397520000000) ENGINE = InnoDB,
  240.  PARTITION p20140415 VALUES LESS THAN (1397606400000) ENGINE = InnoDB,
  241.  PARTITION p20140416 VALUES LESS THAN (1397692800000) ENGINE = InnoDB,
  242.  PARTITION p20140417 VALUES LESS THAN (1397779200000) ENGINE = InnoDB,
  243.  PARTITION p20140418 VALUES LESS THAN (1397865600000) ENGINE = InnoDB,
  244.  PARTITION p20140419 VALUES LESS THAN (1397952000000) ENGINE = InnoDB,
  245.  PARTITION p20140420 VALUES LESS THAN (1398038400000) ENGINE = InnoDB,
  246.  PARTITION p20140421 VALUES LESS THAN (1398124800000) ENGINE = InnoDB,
  247.  PARTITION p20140422 VALUES LESS THAN (1398211200000) ENGINE = InnoDB,
  248.  PARTITION p20140423 VALUES LESS THAN (1398297600000) ENGINE = InnoDB,
  249.  PARTITION p20140424 VALUES LESS THAN (1398384000000) ENGINE = InnoDB,
  250.  PARTITION p20140425 VALUES LESS THAN (1398470400000) ENGINE = InnoDB,
  251.  PARTITION p20140426 VALUES LESS THAN (1398556800000) ENGINE = InnoDB,
  252.  PARTITION p20140427 VALUES LESS THAN (1398643200000) ENGINE = InnoDB,
  253.  PARTITION p20140428 VALUES LESS THAN (1398729600000) ENGINE = InnoDB,
  254.  PARTITION p20140429 VALUES LESS THAN (1398816000000) ENGINE = InnoDB,
  255.  PARTITION p20140430 VALUES LESS THAN (1398902400000) ENGINE = InnoDB,
  256.  PARTITION p20140501 VALUES LESS THAN (1398988800000) ENGINE = InnoDB,
  257.  PARTITION p20140502 VALUES LESS THAN (1399075200000) ENGINE = InnoDB,
  258.  PARTITION p20140503 VALUES LESS THAN (1399161600000) ENGINE = InnoDB,
  259.  PARTITION p20140504 VALUES LESS THAN (1399248000000) ENGINE = InnoDB,
  260.  PARTITION p20140505 VALUES LESS THAN (1399334400000) ENGINE = InnoDB,
  261.  PARTITION p20140506 VALUES LESS THAN (1399420800000) ENGINE = InnoDB,
  262.  PARTITION p20140507 VALUES LESS THAN (1399507200000) ENGINE = InnoDB,
  263.  PARTITION p20140508 VALUES LESS THAN (1399593600000) ENGINE = InnoDB,
  264.  PARTITION p20140509 VALUES LESS THAN (1399680000000) ENGINE = InnoDB,
  265.  PARTITION p20140510 VALUES LESS THAN (1399766400000) ENGINE = InnoDB,
  266.  PARTITION p20140511 VALUES LESS THAN (1399852800000) ENGINE = InnoDB,
  267.  PARTITION p20140512 VALUES LESS THAN (1399939200000) ENGINE = InnoDB,
  268.  PARTITION p20140513 VALUES LESS THAN (1400025600000) ENGINE = InnoDB,
  269.  PARTITION p20140514 VALUES LESS THAN (1400112000000) ENGINE = InnoDB,
  270.  PARTITION p20140515 VALUES LESS THAN (1400198400000) ENGINE = InnoDB,
  271.  PARTITION p20140516 VALUES LESS THAN (1400284800000) ENGINE = InnoDB,
  272.  PARTITION p20140517 VALUES LESS THAN (1400371200000) ENGINE = InnoDB,
  273.  PARTITION p20140518 VALUES LESS THAN (1400457600000) ENGINE = InnoDB,
  274.  PARTITION p20140519 VALUES LESS THAN (1400544000000) ENGINE = InnoDB,
  275.  PARTITION p20140520 VALUES LESS THAN (1400630400000) ENGINE = InnoDB,
  276.  PARTITION p20140521 VALUES LESS THAN (1400716800000) ENGINE = InnoDB,
  277.  PARTITION p20140522 VALUES LESS THAN (1400803200000) ENGINE = InnoDB,
  278.  PARTITION p20140523 VALUES LESS THAN (1400889600000) ENGINE = InnoDB,
  279.  PARTITION p20140524 VALUES LESS THAN (1400976000000) ENGINE = InnoDB,
  280.  PARTITION p20140525 VALUES LESS THAN (1401062400000) ENGINE = InnoDB,
  281.  PARTITION p20140526 VALUES LESS THAN (1401148800000) ENGINE = InnoDB,
  282.  PARTITION p20140527 VALUES LESS THAN (1401235200000) ENGINE = InnoDB,
  283.  PARTITION p20140528 VALUES LESS THAN (1401321600000) ENGINE = InnoDB,
  284.  PARTITION p20140529 VALUES LESS THAN (1401408000000) ENGINE = InnoDB,
  285.  PARTITION p20140530 VALUES LESS THAN (1401494400000) ENGINE = InnoDB,
  286.  PARTITION p20140531 VALUES LESS THAN (1401580800000) ENGINE = InnoDB,
  287.  PARTITION p20140601 VALUES LESS THAN (1401667200000) ENGINE = InnoDB,
  288.  PARTITION p20140602 VALUES LESS THAN (1401753600000) ENGINE = InnoDB,
  289.  PARTITION p20140603 VALUES LESS THAN (1401840000000) ENGINE = InnoDB,
  290.  PARTITION p20140604 VALUES LESS THAN (1401926400000) ENGINE = InnoDB,
  291.  PARTITION p20140605 VALUES LESS THAN (1402012800000) ENGINE = InnoDB,
  292.  PARTITION p20140606 VALUES LESS THAN (1402099200000) ENGINE = InnoDB,
  293.  PARTITION p20140607 VALUES LESS THAN (1402185600000) ENGINE = InnoDB,
  294.  PARTITION p20140608 VALUES LESS THAN (1402272000000) ENGINE = InnoDB,
  295.  PARTITION p20140609 VALUES LESS THAN (1402358400000) ENGINE = InnoDB,
  296.  PARTITION p20140610 VALUES LESS THAN (1402444800000) ENGINE = InnoDB,
  297.  PARTITION p20140611 VALUES LESS THAN (1402531200000) ENGINE = InnoDB,
  298.  PARTITION p20140612 VALUES LESS THAN (1402617600000) ENGINE = InnoDB,
  299.  PARTITION p20140613 VALUES LESS THAN (1402704000000) ENGINE = InnoDB,
  300.  PARTITION p20140614 VALUES LESS THAN (1402790400000) ENGINE = InnoDB,
  301.  PARTITION p20140615 VALUES LESS THAN (1402876800000) ENGINE = InnoDB,
  302.  PARTITION p20140616 VALUES LESS THAN (1402963200000) ENGINE = InnoDB,
  303.  PARTITION p20140617 VALUES LESS THAN (1403049600000) ENGINE = InnoDB,
  304.  PARTITION p20140618 VALUES LESS THAN (1403136000000) ENGINE = InnoDB,
  305.  PARTITION p20140619 VALUES LESS THAN (1403222400000) ENGINE = InnoDB,
  306.  PARTITION p20140620 VALUES LESS THAN (1403308800000) ENGINE = InnoDB,
  307.  PARTITION p20140621 VALUES LESS THAN (1403395200000) ENGINE = InnoDB,
  308.  PARTITION p20140622 VALUES LESS THAN (1403481600000) ENGINE = InnoDB,
  309.  PARTITION p20140623 VALUES LESS THAN (1403568000000) ENGINE = InnoDB,
  310.  PARTITION p20140624 VALUES LESS THAN (1403654400000) ENGINE = InnoDB,
  311.  PARTITION p20140625 VALUES LESS THAN (1403740800000) ENGINE = InnoDB,
  312.  PARTITION p20140626 VALUES LESS THAN (1403827200000) ENGINE = InnoDB,
  313.  PARTITION p20140627 VALUES LESS THAN (1403913600000) ENGINE = InnoDB,
  314.  PARTITION p20140628 VALUES LESS THAN (1404000000000) ENGINE = InnoDB,
  315.  PARTITION p20140629 VALUES LESS THAN (1404086400000) ENGINE = InnoDB,
  316.  PARTITION p20140630 VALUES LESS THAN (1404172800000) ENGINE = InnoDB,
  317.  PARTITION p20140701 VALUES LESS THAN (1404259200000) ENGINE = InnoDB,
  318.  PARTITION p20140702 VALUES LESS THAN (1404345600000) ENGINE = InnoDB,
  319.  PARTITION p20140703 VALUES LESS THAN (1404432000000) ENGINE = InnoDB,
  320.  PARTITION p20140704 VALUES LESS THAN (1404518400000) ENGINE = InnoDB,
  321.  PARTITION p20140705 VALUES LESS THAN (1404604800000) ENGINE = InnoDB,
  322.  PARTITION p20140706 VALUES LESS THAN (1404691200000) ENGINE = InnoDB,
  323.  PARTITION p20140707 VALUES LESS THAN (1404777600000) ENGINE = InnoDB,
  324.  PARTITION p20140708 VALUES LESS THAN (1404864000000) ENGINE = InnoDB,
  325.  PARTITION p20140709 VALUES LESS THAN (1404950400000) ENGINE = InnoDB,
  326.  PARTITION p20140710 VALUES LESS THAN (1405036800000) ENGINE = InnoDB,
  327.  PARTITION p20140711 VALUES LESS THAN (1405123200000) ENGINE = InnoDB,
  328.  PARTITION p20140712 VALUES LESS THAN (1405209600000) ENGINE = InnoDB,
  329.  PARTITION p20140713 VALUES LESS THAN (1405296000000) ENGINE = InnoDB,
  330.  PARTITION p20140714 VALUES LESS THAN (1405382400000) ENGINE = InnoDB,
  331.  PARTITION p20140715 VALUES LESS THAN (1405468800000) ENGINE = InnoDB,
  332.  PARTITION p20140716 VALUES LESS THAN (1405555200000) ENGINE = InnoDB,
  333.  PARTITION p20140717 VALUES LESS THAN (1405641600000) ENGINE = InnoDB,
  334.  PARTITION p20140718 VALUES LESS THAN (1405728000000) ENGINE = InnoDB,
  335.  PARTITION p20140719 VALUES LESS THAN (1405814400000) ENGINE = InnoDB,
  336.  PARTITION p20140720 VALUES LESS THAN (1405900800000) ENGINE = InnoDB,
  337.  PARTITION p20140721 VALUES LESS THAN (1405987200000) ENGINE = InnoDB,
  338.  PARTITION p20140722 VALUES LESS THAN (1406073600000) ENGINE = InnoDB,
  339.  PARTITION p20140723 VALUES LESS THAN (1406160000000) ENGINE = InnoDB,
  340.  PARTITION p20140724 VALUES LESS THAN (1406246400000) ENGINE = InnoDB,
  341.  PARTITION p20140725 VALUES LESS THAN (1406332800000) ENGINE = InnoDB,
  342.  PARTITION p20140726 VALUES LESS THAN (1406419200000) ENGINE = InnoDB,
  343.  PARTITION p20140727 VALUES LESS THAN (1406505600000) ENGINE = InnoDB,
  344.  PARTITION p20140728 VALUES LESS THAN (1406592000000) ENGINE = InnoDB,
  345.  PARTITION p20140729 VALUES LESS THAN (1406678400000) ENGINE = InnoDB,
  346.  PARTITION p20140730 VALUES LESS THAN (1406764800000) ENGINE = InnoDB,
  347.  PARTITION p20140731 VALUES LESS THAN (1406851200000) ENGINE = InnoDB,
  348.  PARTITION p20140801 VALUES LESS THAN (1406937600000) ENGINE = InnoDB,
  349.  PARTITION p20140802 VALUES LESS THAN (1407024000000) ENGINE = InnoDB,
  350.  PARTITION p20140803 VALUES LESS THAN (1407110400000) ENGINE = InnoDB,
  351.  PARTITION p20140804 VALUES LESS THAN (1407196800000) ENGINE = InnoDB,
  352.  PARTITION p20140805 VALUES LESS THAN (1407283200000) ENGINE = InnoDB,
  353.  PARTITION p20140806 VALUES LESS THAN (1407369600000) ENGINE = InnoDB,
  354.  PARTITION p20140807 VALUES LESS THAN (1407456000000) ENGINE = InnoDB,
  355.  PARTITION p20140808 VALUES LESS THAN (1407542400000) ENGINE = InnoDB,
  356.  PARTITION p20140809 VALUES LESS THAN (1407628800000) ENGINE = InnoDB,
  357.  PARTITION p20140810 VALUES LESS THAN (1407715200000) ENGINE = InnoDB,
  358.  PARTITION p20140811 VALUES LESS THAN (1407801600000) ENGINE = InnoDB,
  359.  PARTITION p20140812 VALUES LESS THAN (1407888000000) ENGINE = InnoDB,
  360.  PARTITION p20140813 VALUES LESS THAN (1407974400000) ENGINE = InnoDB,
  361.  PARTITION p20140814 VALUES LESS THAN (1408060800000) ENGINE = InnoDB,
  362.  PARTITION p20140815 VALUES LESS THAN (1408147200000) ENGINE = InnoDB,
  363.  PARTITION p20140816 VALUES LESS THAN (1408233600000) ENGINE = InnoDB,
  364.  PARTITION p20140817 VALUES LESS THAN (1408320000000) ENGINE = InnoDB,
  365.  PARTITION p20140818 VALUES LESS THAN (1408406400000) ENGINE = InnoDB,
  366.  PARTITION p20140819 VALUES LESS THAN (1408492800000) ENGINE = InnoDB,
  367.  PARTITION p20140820 VALUES LESS THAN (1408579200000) ENGINE = InnoDB,
  368.  PARTITION p20140821 VALUES LESS THAN (1408665600000) ENGINE = InnoDB,
  369.  PARTITION p20140822 VALUES LESS THAN (1408752000000) ENGINE = InnoDB,
  370.  PARTITION p20140823 VALUES LESS THAN (1408838400000) ENGINE = InnoDB,
  371.  PARTITION p20140824 VALUES LESS THAN (1408924800000) ENGINE = InnoDB,
  372.  PARTITION p20140825 VALUES LESS THAN (1409011200000) ENGINE = InnoDB,
  373.  PARTITION p20140826 VALUES LESS THAN (1409097600000) ENGINE = InnoDB,
  374.  PARTITION p20140827 VALUES LESS THAN (1409184000000) ENGINE = InnoDB,
  375.  PARTITION p20140828 VALUES LESS THAN (1409270400000) ENGINE = InnoDB,
  376.  PARTITION p20140829 VALUES LESS THAN (1409356800000) ENGINE = InnoDB,
  377.  PARTITION p20140830 VALUES LESS THAN (1409443200000) ENGINE = InnoDB,
  378.  PARTITION p20140831 VALUES LESS THAN (1409529600000) ENGINE = InnoDB,
  379.  PARTITION p20140901 VALUES LESS THAN (1409616000000) ENGINE = InnoDB,
  380.  PARTITION p20140902 VALUES LESS THAN (1409702400000) ENGINE = InnoDB,
  381.  PARTITION p20140903 VALUES LESS THAN (1409788800000) ENGINE = InnoDB,
  382.  PARTITION p20140904 VALUES LESS THAN (1409875200000) ENGINE = InnoDB,
  383.  PARTITION p20140905 VALUES LESS THAN (1409961600000) ENGINE = InnoDB,
  384.  PARTITION p20140906 VALUES LESS THAN (1410048000000) ENGINE = InnoDB,
  385.  PARTITION p20140907 VALUES LESS THAN (1410134400000) ENGINE = InnoDB,
  386.  PARTITION p20140908 VALUES LESS THAN (1410220800000) ENGINE = InnoDB,
  387.  PARTITION p20140909 VALUES LESS THAN (1410307200000) ENGINE = InnoDB,
  388.  PARTITION p20140910 VALUES LESS THAN (1410393600000) ENGINE = InnoDB,
  389.  PARTITION p20140911 VALUES LESS THAN (1410480000000) ENGINE = InnoDB,
  390.  PARTITION p20140912 VALUES LESS THAN (1410566400000) ENGINE = InnoDB,
  391.  PARTITION p20140913 VALUES LESS THAN (1410652800000) ENGINE = InnoDB,
  392.  PARTITION p20140914 VALUES LESS THAN (1410739200000) ENGINE = InnoDB,
  393.  PARTITION p20140915 VALUES LESS THAN (1410825600000) ENGINE = InnoDB,
  394.  PARTITION p20140916 VALUES LESS THAN (1410912000000) ENGINE = InnoDB,
  395.  PARTITION p20140917 VALUES LESS THAN (1410998400000) ENGINE = InnoDB,
  396.  PARTITION p20140918 VALUES LESS THAN (1411084800000) ENGINE = InnoDB,
  397.  PARTITION p20140919 VALUES LESS THAN (1411171200000) ENGINE = InnoDB,
  398.  PARTITION p20140920 VALUES LESS THAN (1411257600000) ENGINE = InnoDB,
  399.  PARTITION p20140921 VALUES LESS THAN (1411344000000) ENGINE = InnoDB,
  400.  PARTITION p20140922 VALUES LESS THAN (1411430400000) ENGINE = InnoDB,
  401.  PARTITION p20140923 VALUES LESS THAN (1411516800000) ENGINE = InnoDB,
  402.  PARTITION p20140924 VALUES LESS THAN (1411603200000) ENGINE = InnoDB,
  403.  PARTITION p20140925 VALUES LESS THAN (1411689600000) ENGINE = InnoDB,
  404.  PARTITION p20140926 VALUES LESS THAN (1411776000000) ENGINE = InnoDB,
  405.  PARTITION p20140927 VALUES LESS THAN (1411862400000) ENGINE = InnoDB,
  406.  PARTITION p20140928 VALUES LESS THAN (1411948800000) ENGINE = InnoDB,
  407.  PARTITION p20140929 VALUES LESS THAN (1412035200000) ENGINE = InnoDB,
  408.  PARTITION p20140930 VALUES LESS THAN (1412121600000) ENGINE = InnoDB,
  409.  PARTITION p20141001 VALUES LESS THAN (1412208000000) ENGINE = InnoDB,
  410.  PARTITION p20141002 VALUES LESS THAN (1412294400000) ENGINE = InnoDB,
  411.  PARTITION p20141003 VALUES LESS THAN (1412380800000) ENGINE = InnoDB,
  412.  PARTITION p20141004 VALUES LESS THAN (1412467200000) ENGINE = InnoDB,
  413.  PARTITION p20141005 VALUES LESS THAN (1412553600000) ENGINE = InnoDB,
  414.  PARTITION p20141006 VALUES LESS THAN (1412640000000) ENGINE = InnoDB,
  415.  PARTITION p20141007 VALUES LESS THAN (1412726400000) ENGINE = InnoDB,
  416.  PARTITION p20141008 VALUES LESS THAN (1412812800000) ENGINE = InnoDB,
  417.  PARTITION p20141009 VALUES LESS THAN (1412899200000) ENGINE = InnoDB,
  418.  PARTITION p20141010 VALUES LESS THAN (1412985600000) ENGINE = InnoDB,
  419.  PARTITION p20141011 VALUES LESS THAN (1413072000000) ENGINE = InnoDB,
  420.  PARTITION p20141012 VALUES LESS THAN (1413158400000) ENGINE = InnoDB,
  421.  PARTITION p20141013 VALUES LESS THAN (1413244800000) ENGINE = InnoDB,
  422.  PARTITION p20141014 VALUES LESS THAN (1413331200000) ENGINE = InnoDB,
  423.  PARTITION p20141015 VALUES LESS THAN (1413417600000) ENGINE = InnoDB,
  424.  PARTITION p20141016 VALUES LESS THAN (1413504000000) ENGINE = InnoDB,
  425.  PARTITION p20141017 VALUES LESS THAN (1413590400000) ENGINE = InnoDB,
  426.  PARTITION p20141018 VALUES LESS THAN (1413676800000) ENGINE = InnoDB,
  427.  PARTITION p20141019 VALUES LESS THAN (1413763200000) ENGINE = InnoDB,
  428.  PARTITION p20141020 VALUES LESS THAN (1413849600000) ENGINE = InnoDB,
  429.  PARTITION p20141021 VALUES LESS THAN (1413936000000) ENGINE = InnoDB,
  430.  PARTITION p20141022 VALUES LESS THAN (1414022400000) ENGINE = InnoDB,
  431.  PARTITION p20141023 VALUES LESS THAN (1414108800000) ENGINE = InnoDB,
  432.  PARTITION p20141024 VALUES LESS THAN (1414195200000) ENGINE = InnoDB,
  433.  PARTITION p20141025 VALUES LESS THAN (1414281600000) ENGINE = InnoDB,
  434.  PARTITION p20141026 VALUES LESS THAN (1414368000000) ENGINE = InnoDB,
  435.  PARTITION p20141027 VALUES LESS THAN (1414454400000) ENGINE = InnoDB,
  436.  PARTITION p20141028 VALUES LESS THAN (1414540800000) ENGINE = InnoDB,
  437.  PARTITION p20141029 VALUES LESS THAN (1414627200000) ENGINE = InnoDB,
  438.  PARTITION p20141030 VALUES LESS THAN (1414713600000) ENGINE = InnoDB,
  439.  PARTITION p20141031 VALUES LESS THAN (1414800000000) ENGINE = InnoDB,
  440.  PARTITION p20141101 VALUES LESS THAN (1414886400000) ENGINE = InnoDB,
  441.  PARTITION p20141102 VALUES LESS THAN (1414972800000) ENGINE = InnoDB,
  442.  PARTITION p20141103 VALUES LESS THAN (1415059200000) ENGINE = InnoDB,
  443.  PARTITION p20141104 VALUES LESS THAN (1415145600000) ENGINE = InnoDB,
  444.  PARTITION p20141105 VALUES LESS THAN (1415232000000) ENGINE = InnoDB,
  445.  PARTITION p20141106 VALUES LESS THAN (1415318400000) ENGINE = InnoDB,
  446.  PARTITION p20141107 VALUES LESS THAN (1415404800000) ENGINE = InnoDB,
  447.  PARTITION p20141108 VALUES LESS THAN (1415491200000) ENGINE = InnoDB,
  448.  PARTITION p20141109 VALUES LESS THAN (1415577600000) ENGINE = InnoDB,
  449.  PARTITION p20141110 VALUES LESS THAN (1415664000000) ENGINE = InnoDB,
  450.  PARTITION p20141111 VALUES LESS THAN (1415750400000) ENGINE = InnoDB,
  451.  PARTITION p20141112 VALUES LESS THAN (1415836800000) ENGINE = InnoDB,
  452.  PARTITION p20141113 VALUES LESS THAN (1415923200000) ENGINE = InnoDB,
  453.  PARTITION p20141114 VALUES LESS THAN (1416009600000) ENGINE = InnoDB,
  454.  PARTITION p20141115 VALUES LESS THAN (1416096000000) ENGINE = InnoDB,
  455.  PARTITION p20141116 VALUES LESS THAN (1416182400000) ENGINE = InnoDB,
  456.  PARTITION p20141117 VALUES LESS THAN (1416268800000) ENGINE = InnoDB,
  457.  PARTITION p20141118 VALUES LESS THAN (1416355200000) ENGINE = InnoDB,
  458.  PARTITION p20141119 VALUES LESS THAN (1416441600000) ENGINE = InnoDB,
  459.  PARTITION p20141120 VALUES LESS THAN (1416528000000) ENGINE = InnoDB,
  460.  PARTITION p20141121 VALUES LESS THAN (1416614400000) ENGINE = InnoDB,
  461.  PARTITION p20141122 VALUES LESS THAN (1416700800000) ENGINE = InnoDB,
  462.  PARTITION p20141123 VALUES LESS THAN (1416787200000) ENGINE = InnoDB,
  463.  PARTITION p20141124 VALUES LESS THAN (1416873600000) ENGINE = InnoDB,
  464.  PARTITION p20141125 VALUES LESS THAN (1416960000000) ENGINE = InnoDB,
  465.  PARTITION p20141126 VALUES LESS THAN (1417046400000) ENGINE = InnoDB,
  466.  PARTITION p20141127 VALUES LESS THAN (1417132800000) ENGINE = InnoDB,
  467.  PARTITION p20141128 VALUES LESS THAN (1417219200000) ENGINE = InnoDB,
  468.  PARTITION p20141129 VALUES LESS THAN (1417305600000) ENGINE = InnoDB,
  469.  PARTITION p20141130 VALUES LESS THAN (1417392000000) ENGINE = InnoDB,
  470.  PARTITION p20141201 VALUES LESS THAN (1417478400000) ENGINE = InnoDB,
  471.  PARTITION p20141202 VALUES LESS THAN (1417564800000) ENGINE = InnoDB,
  472.  PARTITION p20141203 VALUES LESS THAN (1417651200000) ENGINE = InnoDB,
  473.  PARTITION p20141204 VALUES LESS THAN (1417737600000) ENGINE = InnoDB,
  474.  PARTITION p20141205 VALUES LESS THAN (1417824000000) ENGINE = InnoDB,
  475.  PARTITION p20141206 VALUES LESS THAN (1417910400000) ENGINE = InnoDB,
  476.  PARTITION p20141207 VALUES LESS THAN (1417996800000) ENGINE = InnoDB,
  477.  PARTITION p20141208 VALUES LESS THAN (1418083200000) ENGINE = InnoDB,
  478.  PARTITION p20141209 VALUES LESS THAN (1418169600000) ENGINE = InnoDB,
  479.  PARTITION p20141210 VALUES LESS THAN (1418256000000) ENGINE = InnoDB,
  480.  PARTITION p20141211 VALUES LESS THAN (1418342400000) ENGINE = InnoDB,
  481.  PARTITION p20141212 VALUES LESS THAN (1418428800000) ENGINE = InnoDB,
  482.  PARTITION p20141213 VALUES LESS THAN (1418515200000) ENGINE = InnoDB,
  483.  PARTITION p20141214 VALUES LESS THAN (1418601600000) ENGINE = InnoDB,
  484.  PARTITION p20141215 VALUES LESS THAN (1418688000000) ENGINE = InnoDB,
  485.  PARTITION p20141216 VALUES LESS THAN (1418774400000) ENGINE = InnoDB,
  486.  PARTITION p20141217 VALUES LESS THAN (1418860800000) ENGINE = InnoDB,
  487.  PARTITION p20141218 VALUES LESS THAN (1418947200000) ENGINE = InnoDB,
  488.  PARTITION p20141219 VALUES LESS THAN (1419033600000) ENGINE = InnoDB,
  489.  PARTITION p20141220 VALUES LESS THAN (1419120000000) ENGINE = InnoDB,
  490.  PARTITION p20141221 VALUES LESS THAN (1419206400000) ENGINE = InnoDB,
  491.  PARTITION p20141222 VALUES LESS THAN (1419292800000) ENGINE = InnoDB,
  492.  PARTITION p20141223 VALUES LESS THAN (1419379200000) ENGINE = InnoDB,
  493.  PARTITION p20141224 VALUES LESS THAN (1419465600000) ENGINE = InnoDB,
  494.  PARTITION p20141225 VALUES LESS THAN (1419552000000) ENGINE = InnoDB,
  495.  PARTITION p20141226 VALUES LESS THAN (1419638400000) ENGINE = InnoDB,
  496.  PARTITION p20141227 VALUES LESS THAN (1419724800000) ENGINE = InnoDB,
  497.  PARTITION p20141228 VALUES LESS THAN (1419811200000) ENGINE = InnoDB,
  498.  PARTITION p20141229 VALUES LESS THAN (1419897600000) ENGINE = InnoDB,
  499.  PARTITION p20141230 VALUES LESS THAN (1419984000000) ENGINE = InnoDB,
  500.  PARTITION p20141231 VALUES LESS THAN (1420070400000) ENGINE = InnoDB,
  501.  PARTITION p20150101 VALUES LESS THAN (1420156800000) ENGINE = InnoDB,
  502.  PARTITION p20150102 VALUES LESS THAN (1420243200000) ENGINE = InnoDB,
  503.  PARTITION p20150103 VALUES LESS THAN (1420329600000) ENGINE = InnoDB,
  504.  PARTITION p20150104 VALUES LESS THAN (1420416000000) ENGINE = InnoDB,
  505.  PARTITION p20150105 VALUES LESS THAN (1420502400000) ENGINE = InnoDB,
  506.  PARTITION p20150106 VALUES LESS THAN (1420588800000) ENGINE = InnoDB,
  507.  PARTITION p20150107 VALUES LESS THAN (1420675200000) ENGINE = InnoDB,
  508.  PARTITION p20150108 VALUES LESS THAN (1420761600000) ENGINE = InnoDB,
  509.  PARTITION p20150109 VALUES LESS THAN (1420848000000) ENGINE = InnoDB,
  510.  PARTITION p20150110 VALUES LESS THAN (1420934400000) ENGINE = InnoDB,
  511.  PARTITION p20150111 VALUES LESS THAN (1421020800000) ENGINE = InnoDB,
  512.  PARTITION p20150112 VALUES LESS THAN (1421107200000) ENGINE = InnoDB,
  513.  PARTITION p20150113 VALUES LESS THAN (1421193600000) ENGINE = InnoDB,
  514.  PARTITION p20150114 VALUES LESS THAN (1421280000000) ENGINE = InnoDB,
  515.  PARTITION p20150115 VALUES LESS THAN (1421366400000) ENGINE = InnoDB,
  516.  PARTITION p20150116 VALUES LESS THAN (1421452800000) ENGINE = InnoDB,
  517.  PARTITION p20150117 VALUES LESS THAN (1421539200000) ENGINE = InnoDB,
  518.  PARTITION p20150118 VALUES LESS THAN (1421625600000) ENGINE = InnoDB,
  519.  PARTITION p20150119 VALUES LESS THAN (1421712000000) ENGINE = InnoDB,
  520.  PARTITION p20150120 VALUES LESS THAN (1421798400000) ENGINE = InnoDB,
  521.  PARTITION p20150121 VALUES LESS THAN (1421884800000) ENGINE = InnoDB,
  522.  PARTITION p20150122 VALUES LESS THAN (1421971200000) ENGINE = InnoDB,
  523.  PARTITION p20150123 VALUES LESS THAN (1422057600000) ENGINE = InnoDB,
  524.  PARTITION p20150124 VALUES LESS THAN (1422144000000) ENGINE = InnoDB,
  525.  PARTITION p20150125 VALUES LESS THAN (1422230400000) ENGINE = InnoDB,
  526.  PARTITION p20150126 VALUES LESS THAN (1422316800000) ENGINE = InnoDB,
  527.  PARTITION p20150127 VALUES LESS THAN (1422403200000) ENGINE = InnoDB,
  528.  PARTITION p20150128 VALUES LESS THAN (1422489600000) ENGINE = InnoDB,
  529.  PARTITION p20150129 VALUES LESS THAN (1422576000000) ENGINE = InnoDB,
  530.  PARTITION p20150130 VALUES LESS THAN (1422662400000) ENGINE = InnoDB,
  531.  PARTITION p20150131 VALUES LESS THAN (1422748800000) ENGINE = InnoDB,
  532.  PARTITION p20150201 VALUES LESS THAN (1422835200000) ENGINE = InnoDB,
  533.  PARTITION p20150202 VALUES LESS THAN (1422921600000) ENGINE = InnoDB,
  534.  PARTITION p20150203 VALUES LESS THAN (1423008000000) ENGINE = InnoDB,
  535.  PARTITION p20150204 VALUES LESS THAN (1423094400000) ENGINE = InnoDB,
  536.  PARTITION p20150205 VALUES LESS THAN (1423180800000) ENGINE = InnoDB,
  537.  PARTITION p20150206 VALUES LESS THAN (1423267200000) ENGINE = InnoDB,
  538.  PARTITION p20150207 VALUES LESS THAN (1423353600000) ENGINE = InnoDB,
  539.  PARTITION p20150208 VALUES LESS THAN (1423440000000) ENGINE = InnoDB,
  540.  PARTITION p20150209 VALUES LESS THAN (1423526400000) ENGINE = InnoDB,
  541.  PARTITION p20150210 VALUES LESS THAN (1423612800000) ENGINE = InnoDB,
  542.  PARTITION p20150211 VALUES LESS THAN (1423699200000) ENGINE = InnoDB,
  543.  PARTITION p20150212 VALUES LESS THAN (1423785600000) ENGINE = InnoDB,
  544.  PARTITION p20150213 VALUES LESS THAN (1423872000000) ENGINE = InnoDB,
  545.  PARTITION p20150214 VALUES LESS THAN (1423958400000) ENGINE = InnoDB,
  546.  PARTITION p20150215 VALUES LESS THAN (1424044800000) ENGINE = InnoDB,
  547.  PARTITION p20150216 VALUES LESS THAN (1424131200000) ENGINE = InnoDB,
  548.  PARTITION p20150217 VALUES LESS THAN (1424217600000) ENGINE = InnoDB,
  549.  PARTITION p20150218 VALUES LESS THAN (1424304000000) ENGINE = InnoDB,
  550.  PARTITION p20150219 VALUES LESS THAN (1424390400000) ENGINE = InnoDB,
  551.  PARTITION p20150220 VALUES LESS THAN (1424476800000) ENGINE = InnoDB,
  552.  PARTITION p20150221 VALUES LESS THAN (1424563200000) ENGINE = InnoDB,
  553.  PARTITION p20150222 VALUES LESS THAN (1424649600000) ENGINE = InnoDB,
  554.  PARTITION p20150223 VALUES LESS THAN (1424736000000) ENGINE = InnoDB,
  555.  PARTITION p20150224 VALUES LESS THAN (1424822400000) ENGINE = InnoDB,
  556.  PARTITION p20150225 VALUES LESS THAN (1424908800000) ENGINE = InnoDB,
  557.  PARTITION p20150226 VALUES LESS THAN (1424995200000) ENGINE = InnoDB,
  558.  PARTITION p20150227 VALUES LESS THAN (1425081600000) ENGINE = InnoDB,
  559.  PARTITION p20150228 VALUES LESS THAN (1425168000000) ENGINE = InnoDB,
  560.  PARTITION p20150301 VALUES LESS THAN (1425254400000) ENGINE = InnoDB,
  561.  PARTITION p20150302 VALUES LESS THAN (1425340800000) ENGINE = InnoDB,
  562.  PARTITION p20150303 VALUES LESS THAN (1425427200000) ENGINE = InnoDB,
  563.  PARTITION p20150304 VALUES LESS THAN (1425513600000) ENGINE = InnoDB,
  564.  PARTITION p20150305 VALUES LESS THAN (1425600000000) ENGINE = InnoDB,
  565.  PARTITION p20150306 VALUES LESS THAN (1425686400000) ENGINE = InnoDB,
  566.  PARTITION p20150307 VALUES LESS THAN (1425772800000) ENGINE = InnoDB,
  567.  PARTITION p20150308 VALUES LESS THAN (1425859200000) ENGINE = InnoDB,
  568.  PARTITION p20150309 VALUES LESS THAN (1425945600000) ENGINE = InnoDB,
  569.  PARTITION p20150310 VALUES LESS THAN (1426032000000) ENGINE = InnoDB,
  570.  PARTITION p20150311 VALUES LESS THAN (1426118400000) ENGINE = InnoDB,
  571.  PARTITION p20150312 VALUES LESS THAN (1426204800000) ENGINE = InnoDB,
  572.  PARTITION p20150313 VALUES LESS THAN (1426291200000) ENGINE = InnoDB,
  573.  PARTITION p20150314 VALUES LESS THAN (1426377600000) ENGINE = InnoDB,
  574.  PARTITION p20150315 VALUES LESS THAN (1426464000000) ENGINE = InnoDB,
  575.  PARTITION p20150316 VALUES LESS THAN (1426550400000) ENGINE = InnoDB,
  576.  PARTITION p20150317 VALUES LESS THAN (1426636800000) ENGINE = InnoDB,
  577.  PARTITION p20150318 VALUES LESS THAN (1426723200000) ENGINE = InnoDB,
  578.  PARTITION p20150319 VALUES LESS THAN (1426809600000) ENGINE = InnoDB,
  579.  PARTITION p20150320 VALUES LESS THAN (1426896000000) ENGINE = InnoDB,
  580.  PARTITION p20150321 VALUES LESS THAN (1426982400000) ENGINE = InnoDB,
  581.  PARTITION p20150322 VALUES LESS THAN (1427068800000) ENGINE = InnoDB,
  582.  PARTITION p20150323 VALUES LESS THAN (1427155200000) ENGINE = InnoDB,
  583.  PARTITION p20150324 VALUES LESS THAN (1427241600000) ENGINE = InnoDB,
  584.  PARTITION p20150325 VALUES LESS THAN (1427328000000) ENGINE = InnoDB,
  585.  PARTITION p20150326 VALUES LESS THAN (1427414400000) ENGINE = InnoDB,
  586.  PARTITION p20150327 VALUES LESS THAN (1427500800000) ENGINE = InnoDB,
  587.  PARTITION p20150328 VALUES LESS THAN (1427587200000) ENGINE = InnoDB,
  588.  PARTITION p20150329 VALUES LESS THAN (1427673600000) ENGINE = InnoDB,
  589.  PARTITION p20150330 VALUES LESS THAN (1427760000000) ENGINE = InnoDB,
  590.  PARTITION p20150331 VALUES LESS THAN (1427846400000) ENGINE = InnoDB,
  591.  PARTITION p20150401 VALUES LESS THAN (1427932800000) ENGINE = InnoDB,
  592.  PARTITION p20150402 VALUES LESS THAN (1428019200000) ENGINE = InnoDB,
  593.  PARTITION p20150403 VALUES LESS THAN (1428105600000) ENGINE = InnoDB,
  594.  PARTITION p20150404 VALUES LESS THAN (1428192000000) ENGINE = InnoDB,
  595.  PARTITION p20150405 VALUES LESS THAN (1428278400000) ENGINE = InnoDB,
  596.  PARTITION p20150406 VALUES LESS THAN (1428364800000) ENGINE = InnoDB,
  597.  PARTITION p20150407 VALUES LESS THAN (1428451200000) ENGINE = InnoDB,
  598.  PARTITION p20150408 VALUES LESS THAN (1428537600000) ENGINE = InnoDB,
  599.  PARTITION p20150409 VALUES LESS THAN (1428624000000) ENGINE = InnoDB,
  600.  PARTITION p20150410 VALUES LESS THAN (1428710400000) ENGINE = InnoDB,
  601.  PARTITION p20150411 VALUES LESS THAN (1428796800000) ENGINE = InnoDB,
  602.  PARTITION p20150412 VALUES LESS THAN (1428883200000) ENGINE = InnoDB,
  603.  PARTITION p20150413 VALUES LESS THAN (1428969600000) ENGINE = InnoDB,
  604.  PARTITION p20150414 VALUES LESS THAN (1429056000000) ENGINE = InnoDB,
  605.  PARTITION p20150415 VALUES LESS THAN (1429142400000) ENGINE = InnoDB,
  606.  PARTITION p20150416 VALUES LESS THAN (1429228800000) ENGINE = InnoDB,
  607.  PARTITION p20150417 VALUES LESS THAN (1429315200000) ENGINE = InnoDB,
  608.  PARTITION p20150418 VALUES LESS THAN (1429401600000) ENGINE = InnoDB,
  609.  PARTITION p20150419 VALUES LESS THAN (1429488000000) ENGINE = InnoDB,
  610.  PARTITION p20150420 VALUES LESS THAN (1429574400000) ENGINE = InnoDB,
  611.  PARTITION p20150421 VALUES LESS THAN (1429660800000) ENGINE = InnoDB,
  612.  PARTITION p20150422 VALUES LESS THAN (1429747200000) ENGINE = InnoDB,
  613.  PARTITION p20150423 VALUES LESS THAN (1429833600000) ENGINE = InnoDB,
  614.  PARTITION p20150424 VALUES LESS THAN (1429920000000) ENGINE = InnoDB,
  615.  PARTITION p20150425 VALUES LESS THAN (1430006400000) ENGINE = InnoDB,
  616.  PARTITION p20150426 VALUES LESS THAN (1430092800000) ENGINE = InnoDB,
  617.  PARTITION p20150427 VALUES LESS THAN (1430179200000) ENGINE = InnoDB,
  618.  PARTITION p20150428 VALUES LESS THAN (1430265600000) ENGINE = InnoDB,
  619.  PARTITION p20150429 VALUES LESS THAN (1430352000000) ENGINE = InnoDB,
  620.  PARTITION p20150430 VALUES LESS THAN (1430438400000) ENGINE = InnoDB,
  621.  PARTITION p20150501 VALUES LESS THAN (1430524800000) ENGINE = InnoDB,
  622.  PARTITION p20150502 VALUES LESS THAN (1430611200000) ENGINE = InnoDB,
  623.  PARTITION p20150503 VALUES LESS THAN (1430697600000) ENGINE = InnoDB,
  624.  PARTITION p20150504 VALUES LESS THAN (1430784000000) ENGINE = InnoDB,
  625.  PARTITION p20150505 VALUES LESS THAN (1430870400000) ENGINE = InnoDB,
  626.  PARTITION p20150506 VALUES LESS THAN (1430956800000) ENGINE = InnoDB,
  627.  PARTITION p20150507 VALUES LESS THAN (1431043200000) ENGINE = InnoDB,
  628.  PARTITION p20150508 VALUES LESS THAN (1431129600000) ENGINE = InnoDB,
  629.  PARTITION p20150509 VALUES LESS THAN (1431216000000) ENGINE = InnoDB,
  630.  PARTITION p20150510 VALUES LESS THAN (1431302400000) ENGINE = InnoDB,
  631.  PARTITION p20150511 VALUES LESS THAN (1431388800000) ENGINE = InnoDB,
  632.  PARTITION p20150512 VALUES LESS THAN (1431475200000) ENGINE = InnoDB,
  633.  PARTITION p20150513 VALUES LESS THAN (1431561600000) ENGINE = InnoDB,
  634.  PARTITION p20150514 VALUES LESS THAN (1431648000000) ENGINE = InnoDB,
  635.  PARTITION p20150515 VALUES LESS THAN (1431734400000) ENGINE = InnoDB,
  636.  PARTITION p20150516 VALUES LESS THAN (1431820800000) ENGINE = InnoDB,
  637.  PARTITION p20150517 VALUES LESS THAN (1431907200000) ENGINE = InnoDB,
  638.  PARTITION p20150518 VALUES LESS THAN (1431993600000) ENGINE = InnoDB,
  639.  PARTITION p20150519 VALUES LESS THAN (1432080000000) ENGINE = InnoDB,
  640.  PARTITION p20150520 VALUES LESS THAN (1432166400000) ENGINE = InnoDB,
  641.  PARTITION p20150521 VALUES LESS THAN (1432252800000) ENGINE = InnoDB,
  642.  PARTITION p20150522 VALUES LESS THAN (1432339200000) ENGINE = InnoDB,
  643.  PARTITION p20150523 VALUES LESS THAN (1432425600000) ENGINE = InnoDB,
  644.  PARTITION p20150524 VALUES LESS THAN (1432512000000) ENGINE = InnoDB,
  645.  PARTITION p20150525 VALUES LESS THAN (1432598400000) ENGINE = InnoDB,
  646.  PARTITION p20150526 VALUES LESS THAN (1432684800000) ENGINE = InnoDB,
  647.  PARTITION p20150527 VALUES LESS THAN (1432771200000) ENGINE = InnoDB,
  648.  PARTITION p20150528 VALUES LESS THAN (1432857600000) ENGINE = InnoDB,
  649.  PARTITION p20150529 VALUES LESS THAN (1432944000000) ENGINE = InnoDB,
  650.  PARTITION p20150530 VALUES LESS THAN (1433030400000) ENGINE = InnoDB,
  651.  PARTITION p20150531 VALUES LESS THAN (1433116800000) ENGINE = InnoDB,
  652.  PARTITION p20150601 VALUES LESS THAN (1433203200000) ENGINE = InnoDB,
  653.  PARTITION p20150602 VALUES LESS THAN (1433289600000) ENGINE = InnoDB,
  654.  PARTITION p20150603 VALUES LESS THAN (1433376000000) ENGINE = InnoDB,
  655.  PARTITION p20150604 VALUES LESS THAN (1433462400000) ENGINE = InnoDB,
  656.  PARTITION p20150605 VALUES LESS THAN (1433548800000) ENGINE = InnoDB,
  657.  PARTITION p20150606 VALUES LESS THAN (1433635200000) ENGINE = InnoDB,
  658.  PARTITION p20150607 VALUES LESS THAN (1433721600000) ENGINE = InnoDB,
  659.  PARTITION p20150608 VALUES LESS THAN (1433808000000) ENGINE = InnoDB,
  660.  PARTITION p20150609 VALUES LESS THAN (1433894400000) ENGINE = InnoDB,
  661.  PARTITION p20150610 VALUES LESS THAN (1433980800000) ENGINE = InnoDB,
  662.  PARTITION p20150611 VALUES LESS THAN (1434067200000) ENGINE = InnoDB,
  663.  PARTITION p20150612 VALUES LESS THAN (1434153600000) ENGINE = InnoDB,
  664.  PARTITION p20150613 VALUES LESS THAN (1434240000000) ENGINE = InnoDB,
  665.  PARTITION p20150614 VALUES LESS THAN (1434326400000) ENGINE = InnoDB,
  666.  PARTITION p20150615 VALUES LESS THAN (1434412800000) ENGINE = InnoDB,
  667.  PARTITION p20150616 VALUES LESS THAN (1434499200000) ENGINE = InnoDB,
  668.  PARTITION p20150617 VALUES LESS THAN (1434585600000) ENGINE = InnoDB,
  669.  PARTITION p20150618 VALUES LESS THAN (1434672000000) ENGINE = InnoDB,
  670.  PARTITION p20150619 VALUES LESS THAN (1434758400000) ENGINE = InnoDB,
  671.  PARTITION p20150620 VALUES LESS THAN (1434844800000) ENGINE = InnoDB,
  672.  PARTITION p20150621 VALUES LESS THAN (1434931200000) ENGINE = InnoDB,
  673.  PARTITION p20150622 VALUES LESS THAN (1435017600000) ENGINE = InnoDB,
  674.  PARTITION p20150623 VALUES LESS THAN (1435104000000) ENGINE = InnoDB,
  675.  PARTITION p20150624 VALUES LESS THAN (1435190400000) ENGINE = InnoDB,
  676.  PARTITION p20150625 VALUES LESS THAN (1435276800000) ENGINE = InnoDB,
  677.  PARTITION p20150626 VALUES LESS THAN (1435363200000) ENGINE = InnoDB,
  678.  PARTITION p20150627 VALUES LESS THAN (1435449600000) ENGINE = InnoDB,
  679.  PARTITION p20150628 VALUES LESS THAN (1435536000000) ENGINE = InnoDB,
  680.  PARTITION p20150629 VALUES LESS THAN (1435622400000) ENGINE = InnoDB,
  681.  PARTITION p20150630 VALUES LESS THAN (1435708800000) ENGINE = InnoDB,
  682.  PARTITION p20150701 VALUES LESS THAN (1435795200000) ENGINE = InnoDB,
  683.  PARTITION p20150702 VALUES LESS THAN (1435881600000) ENGINE = InnoDB,
  684.  PARTITION p20150703 VALUES LESS THAN (1435968000000) ENGINE = InnoDB,
  685.  PARTITION p20150704 VALUES LESS THAN (1436054400000) ENGINE = InnoDB,
  686.  PARTITION p20150705 VALUES LESS THAN (1436140800000) ENGINE = InnoDB,
  687.  PARTITION p20150706 VALUES LESS THAN (1436227200000) ENGINE = InnoDB,
  688.  PARTITION p20150707 VALUES LESS THAN (1436313600000) ENGINE = InnoDB,
  689.  PARTITION p20150708 VALUES LESS THAN (1436400000000) ENGINE = InnoDB,
  690.  PARTITION p20150709 VALUES LESS THAN (1436486400000) ENGINE = InnoDB,
  691.  PARTITION p20150710 VALUES LESS THAN (1436572800000) ENGINE = InnoDB,
  692.  PARTITION p20150711 VALUES LESS THAN (1436659200000) ENGINE = InnoDB,
  693.  PARTITION p20150712 VALUES LESS THAN (1436745600000) ENGINE = InnoDB,
  694.  PARTITION p20150713 VALUES LESS THAN (1436832000000) ENGINE = InnoDB,
  695.  PARTITION p20150714 VALUES LESS THAN (1436918400000) ENGINE = InnoDB,
  696.  PARTITION p20150715 VALUES LESS THAN (1437004800000) ENGINE = InnoDB,
  697.  PARTITION p20150716 VALUES LESS THAN (1437091200000) ENGINE = InnoDB,
  698.  PARTITION p20150717 VALUES LESS THAN (1437177600000) ENGINE = InnoDB,
  699.  PARTITION p20150718 VALUES LESS THAN (1437264000000) ENGINE = InnoDB,
  700.  PARTITION p20150719 VALUES LESS THAN (1437350400000) ENGINE = InnoDB,
  701.  PARTITION p20150720 VALUES LESS THAN (1437436800000) ENGINE = InnoDB,
  702.  PARTITION p20150721 VALUES LESS THAN (1437523200000) ENGINE = InnoDB,
  703.  PARTITION p20150722 VALUES LESS THAN (1437609600000) ENGINE = InnoDB,
  704.  PARTITION p20150723 VALUES LESS THAN (1437696000000) ENGINE = InnoDB,
  705.  PARTITION p20150724 VALUES LESS THAN (1437782400000) ENGINE = InnoDB,
  706.  PARTITION p20150725 VALUES LESS THAN (1437868800000) ENGINE = InnoDB,
  707.  PARTITION p20150726 VALUES LESS THAN (1437955200000) ENGINE = InnoDB,
  708.  PARTITION p20150727 VALUES LESS THAN (1438041600000) ENGINE = InnoDB,
  709.  PARTITION p20150728 VALUES LESS THAN (1438128000000) ENGINE = InnoDB,
  710.  PARTITION p20150729 VALUES LESS THAN (1438214400000) ENGINE = InnoDB,
  711.  PARTITION p20150730 VALUES LESS THAN (1438300800000) ENGINE = InnoDB,
  712.  PARTITION p20150731 VALUES LESS THAN (1438387200000) ENGINE = InnoDB,
  713.  PARTITION p20150801 VALUES LESS THAN (1438473600000) ENGINE = InnoDB,
  714.  PARTITION p20150802 VALUES LESS THAN (1438560000000) ENGINE = InnoDB,
  715.  PARTITION p20150803 VALUES LESS THAN (1438646400000) ENGINE = InnoDB,
  716.  PARTITION p20150804 VALUES LESS THAN (1438732800000) ENGINE = InnoDB,
  717.  PARTITION p20150805 VALUES LESS THAN (1438819200000) ENGINE = InnoDB,
  718.  PARTITION p20150806 VALUES LESS THAN (1438905600000) ENGINE = InnoDB,
  719.  PARTITION p20150807 VALUES LESS THAN (1438992000000) ENGINE = InnoDB,
  720.  PARTITION p20150808 VALUES LESS THAN (1439078400000) ENGINE = InnoDB,
  721.  PARTITION p20150809 VALUES LESS THAN (1439164800000) ENGINE = InnoDB,
  722.  PARTITION p20150810 VALUES LESS THAN (1439251200000) ENGINE = InnoDB,
  723.  PARTITION p20150811 VALUES LESS THAN (1439337600000) ENGINE = InnoDB,
  724.  PARTITION p20150812 VALUES LESS THAN (1439424000000) ENGINE = InnoDB,
  725.  PARTITION p20150813 VALUES LESS THAN (1439510400000) ENGINE = InnoDB,
  726.  PARTITION p20150814 VALUES LESS THAN (1439596800000) ENGINE = InnoDB,
  727.  PARTITION p20150815 VALUES LESS THAN (1439683200000) ENGINE = InnoDB,
  728.  PARTITION p20150816 VALUES LESS THAN (1439769600000) ENGINE = InnoDB,
  729.  PARTITION p20150817 VALUES LESS THAN (1439856000000) ENGINE = InnoDB,
  730.  PARTITION p20150818 VALUES LESS THAN (1439942400000) ENGINE = InnoDB,
  731.  PARTITION p20150819 VALUES LESS THAN (1440028800000) ENGINE = InnoDB,
  732.  PARTITION p20150820 VALUES LESS THAN (1440115200000) ENGINE = InnoDB,
  733.  PARTITION p20150821 VALUES LESS THAN (1440201600000) ENGINE = InnoDB,
  734.  PARTITION p20150822 VALUES LESS THAN (1440288000000) ENGINE = InnoDB,
  735.  PARTITION p20150823 VALUES LESS THAN (1440374400000) ENGINE = InnoDB,
  736.  PARTITION p20150824 VALUES LESS THAN (1440460800000) ENGINE = InnoDB,
  737.  PARTITION p20150825 VALUES LESS THAN (1440547200000) ENGINE = InnoDB,
  738.  PARTITION p20150826 VALUES LESS THAN (1440633600000) ENGINE = InnoDB,
  739.  PARTITION p20150827 VALUES LESS THAN (1440720000000) ENGINE = InnoDB,
  740.  PARTITION p20150828 VALUES LESS THAN (1440806400000) ENGINE = InnoDB,
  741.  PARTITION p20150829 VALUES LESS THAN (1440892800000) ENGINE = InnoDB,
  742.  PARTITION p20150830 VALUES LESS THAN (1440979200000) ENGINE = InnoDB,
  743.  PARTITION p20150831 VALUES LESS THAN (1441065600000) ENGINE = InnoDB,
  744.  PARTITION p20150901 VALUES LESS THAN (1441152000000) ENGINE = InnoDB,
  745.  PARTITION p20150902 VALUES LESS THAN (1441238400000) ENGINE = InnoDB,
  746.  PARTITION p20150903 VALUES LESS THAN (1441324800000) ENGINE = InnoDB,
  747.  PARTITION p20150904 VALUES LESS THAN (1441411200000) ENGINE = InnoDB,
  748.  PARTITION p20150905 VALUES LESS THAN (1441497600000) ENGINE = InnoDB,
  749.  PARTITION p20150906 VALUES LESS THAN (1441584000000) ENGINE = InnoDB,
  750.  PARTITION p20150907 VALUES LESS THAN (1441670400000) ENGINE = InnoDB,
  751.  PARTITION p20150908 VALUES LESS THAN (1441756800000) ENGINE = InnoDB,
  752.  PARTITION p20150909 VALUES LESS THAN (1441843200000) ENGINE = InnoDB,
  753.  PARTITION p20150910 VALUES LESS THAN (1441929600000) ENGINE = InnoDB,
  754.  PARTITION p20150911 VALUES LESS THAN (1442016000000) ENGINE = InnoDB,
  755.  PARTITION p20150912 VALUES LESS THAN (1442102400000) ENGINE = InnoDB,
  756.  PARTITION p20150913 VALUES LESS THAN (1442188800000) ENGINE = InnoDB,
  757.  PARTITION p20150914 VALUES LESS THAN (1442275200000) ENGINE = InnoDB,
  758.  PARTITION p20150915 VALUES LESS THAN (1442361600000) ENGINE = InnoDB,
  759.  PARTITION p20150916 VALUES LESS THAN (1442448000000) ENGINE = InnoDB,
  760.  PARTITION p20150917 VALUES LESS THAN (1442534400000) ENGINE = InnoDB,
  761.  PARTITION p20150918 VALUES LESS THAN (1442620800000) ENGINE = InnoDB,
  762.  PARTITION p20150919 VALUES LESS THAN (1442707200000) ENGINE = InnoDB,
  763.  PARTITION p20150920 VALUES LESS THAN (1442793600000) ENGINE = InnoDB,
  764.  PARTITION p20150921 VALUES LESS THAN (1442880000000) ENGINE = InnoDB,
  765.  PARTITION p20150922 VALUES LESS THAN (1442966400000) ENGINE = InnoDB,
  766.  PARTITION p20150923 VALUES LESS THAN (1443052800000) ENGINE = InnoDB,
  767.  PARTITION p20150924 VALUES LESS THAN (1443139200000) ENGINE = InnoDB,
  768.  PARTITION p20150925 VALUES LESS THAN (1443225600000) ENGINE = InnoDB,
  769.  PARTITION p20150926 VALUES LESS THAN (1443312000000) ENGINE = InnoDB,
  770.  PARTITION p20150927 VALUES LESS THAN (1443398400000) ENGINE = InnoDB,
  771.  PARTITION p20150928 VALUES LESS THAN (1443484800000) ENGINE = InnoDB,
  772.  PARTITION p20150929 VALUES LESS THAN (1443571200000) ENGINE = InnoDB,
  773.  PARTITION p20150930 VALUES LESS THAN (1443657600000) ENGINE = InnoDB,
  774.  PARTITION p20151001 VALUES LESS THAN (1443744000000) ENGINE = InnoDB,
  775.  PARTITION p20151002 VALUES LESS THAN (1443830400000) ENGINE = InnoDB,
  776.  PARTITION p20151003 VALUES LESS THAN (1443916800000) ENGINE = InnoDB,
  777.  PARTITION p20151004 VALUES LESS THAN (1444003200000) ENGINE = InnoDB,
  778.  PARTITION p20151005 VALUES LESS THAN (1444089600000) ENGINE = InnoDB,
  779.  PARTITION p20151006 VALUES LESS THAN (1444176000000) ENGINE = InnoDB,
  780.  PARTITION p20151007 VALUES LESS THAN (1444262400000) ENGINE = InnoDB,
  781.  PARTITION p20151008 VALUES LESS THAN (1444348800000) ENGINE = InnoDB,
  782.  PARTITION p20151009 VALUES LESS THAN (1444435200000) ENGINE = InnoDB,
  783.  PARTITION p20151010 VALUES LESS THAN (1444521600000) ENGINE = InnoDB,
  784.  PARTITION p20151011 VALUES LESS THAN (1444608000000) ENGINE = InnoDB,
  785.  PARTITION p20151012 VALUES LESS THAN (1444694400000) ENGINE = InnoDB,
  786.  PARTITION p20151013 VALUES LESS THAN (1444780800000) ENGINE = InnoDB,
  787.  PARTITION p20151014 VALUES LESS THAN (1444867200000) ENGINE = InnoDB,
  788.  PARTITION p20151015 VALUES LESS THAN (1444953600000) ENGINE = InnoDB,
  789.  PARTITION p20151016 VALUES LESS THAN (1445040000000) ENGINE = InnoDB,
  790.  PARTITION p20151017 VALUES LESS THAN (1445126400000) ENGINE = InnoDB,
  791.  PARTITION p20151018 VALUES LESS THAN (1445212800000) ENGINE = InnoDB,
  792.  PARTITION p20151019 VALUES LESS THAN (1445299200000) ENGINE = InnoDB,
  793.  PARTITION p20151020 VALUES LESS THAN (1445385600000) ENGINE = InnoDB,
  794.  PARTITION p20151021 VALUES LESS THAN (1445472000000) ENGINE = InnoDB,
  795.  PARTITION p20151022 VALUES LESS THAN (1445558400000) ENGINE = InnoDB,
  796.  PARTITION p20151023 VALUES LESS THAN (1445644800000) ENGINE = InnoDB,
  797.  PARTITION p20151024 VALUES LESS THAN (1445731200000) ENGINE = InnoDB,
  798.  PARTITION p20151025 VALUES LESS THAN (1445817600000) ENGINE = InnoDB,
  799.  PARTITION p20151026 VALUES LESS THAN (1445904000000) ENGINE = InnoDB,
  800.  PARTITION p20151027 VALUES LESS THAN (1445990400000) ENGINE = InnoDB,
  801.  PARTITION p20151028 VALUES LESS THAN (1446076800000) ENGINE = InnoDB,
  802.  PARTITION p20151029 VALUES LESS THAN (1446163200000) ENGINE = InnoDB,
  803.  PARTITION p20151030 VALUES LESS THAN (1446249600000) ENGINE = InnoDB,
  804.  PARTITION p20151031 VALUES LESS THAN (1446336000000) ENGINE = InnoDB,
  805.  PARTITION p20151101 VALUES LESS THAN (1446422400000) ENGINE = InnoDB,
  806.  PARTITION p20151102 VALUES LESS THAN (1446508800000) ENGINE = InnoDB,
  807.  PARTITION p20151103 VALUES LESS THAN (1446595200000) ENGINE = InnoDB,
  808.  PARTITION p20151104 VALUES LESS THAN (1446681600000) ENGINE = InnoDB,
  809.  PARTITION p20151105 VALUES LESS THAN (1446768000000) ENGINE = InnoDB,
  810.  PARTITION p20151106 VALUES LESS THAN (1446854400000) ENGINE = InnoDB,
  811.  PARTITION p20151107 VALUES LESS THAN (1446940800000) ENGINE = InnoDB,
  812.  PARTITION p20151108 VALUES LESS THAN (1447027200000) ENGINE = InnoDB,
  813.  PARTITION p20151109 VALUES LESS THAN (1447113600000) ENGINE = InnoDB,
  814.  PARTITION p20151110 VALUES LESS THAN (1447200000000) ENGINE = InnoDB,
  815.  PARTITION p20151111 VALUES LESS THAN (1447286400000) ENGINE = InnoDB,
  816.  PARTITION p20151112 VALUES LESS THAN (1447372800000) ENGINE = InnoDB,
  817.  PARTITION p20151113 VALUES LESS THAN (1447459200000) ENGINE = InnoDB,
  818.  PARTITION p20151114 VALUES LESS THAN (1447545600000) ENGINE = InnoDB,
  819.  PARTITION p20151115 VALUES LESS THAN (1447632000000) ENGINE = InnoDB,
  820.  PARTITION p20151116 VALUES LESS THAN (1447718400000) ENGINE = InnoDB,
  821.  PARTITION p20151117 VALUES LESS THAN (1447804800000) ENGINE = InnoDB,
  822.  PARTITION p20151118 VALUES LESS THAN (1447891200000) ENGINE = InnoDB,
  823.  PARTITION p20151119 VALUES LESS THAN (1447977600000) ENGINE = InnoDB,
  824.  PARTITION p20151120 VALUES LESS THAN (1448064000000) ENGINE = InnoDB,
  825.  PARTITION p20151121 VALUES LESS THAN (1448150400000) ENGINE = InnoDB,
  826.  PARTITION p20151122 VALUES LESS THAN (1448236800000) ENGINE = InnoDB,
  827.  PARTITION p20151123 VALUES LESS THAN (1448323200000) ENGINE = InnoDB,
  828.  PARTITION p20151124 VALUES LESS THAN (1448409600000) ENGINE = InnoDB,
  829.  PARTITION p20151125 VALUES LESS THAN (1448496000000) ENGINE = InnoDB,
  830.  PARTITION p20151126 VALUES LESS THAN (1448582400000) ENGINE = InnoDB,
  831.  PARTITION p20151127 VALUES LESS THAN (1448668800000) ENGINE = InnoDB,
  832.  PARTITION p20151128 VALUES LESS THAN (1448755200000) ENGINE = InnoDB,
  833.  PARTITION p20151129 VALUES LESS THAN (1448841600000) ENGINE = InnoDB,
  834.  PARTITION p20151130 VALUES LESS THAN (1448928000000) ENGINE = InnoDB,
  835.  PARTITION p20151201 VALUES LESS THAN (1449014400000) ENGINE = InnoDB,
  836.  PARTITION p20151202 VALUES LESS THAN (1449100800000) ENGINE = InnoDB,
  837.  PARTITION p20151203 VALUES LESS THAN (1449187200000) ENGINE = InnoDB,
  838.  PARTITION p20151204 VALUES LESS THAN (1449273600000) ENGINE = InnoDB,
  839.  PARTITION p20151205 VALUES LESS THAN (1449360000000) ENGINE = InnoDB,
  840.  PARTITION p20151206 VALUES LESS THAN (1449446400000) ENGINE = InnoDB,
  841.  PARTITION p20151207 VALUES LESS THAN (1449532800000) ENGINE = InnoDB,
  842.  PARTITION p20151208 VALUES LESS THAN (1449619200000) ENGINE = InnoDB,
  843.  PARTITION p20151209 VALUES LESS THAN (1449705600000) ENGINE = InnoDB,
  844.  PARTITION p20151210 VALUES LESS THAN (1449792000000) ENGINE = InnoDB,
  845.  PARTITION p20151211 VALUES LESS THAN (1449878400000) ENGINE = InnoDB,
  846.  PARTITION p20151212 VALUES LESS THAN (1449964800000) ENGINE = InnoDB,
  847.  PARTITION p20151213 VALUES LESS THAN (1450051200000) ENGINE = InnoDB,
  848.  PARTITION p20151214 VALUES LESS THAN (1450137600000) ENGINE = InnoDB,
  849.  PARTITION p20151215 VALUES LESS THAN (1450224000000) ENGINE = InnoDB,
  850.  PARTITION p20151216 VALUES LESS THAN (1450310400000) ENGINE = InnoDB,
  851.  PARTITION p20151217 VALUES LESS THAN (1450396800000) ENGINE = InnoDB,
  852.  PARTITION p20151218 VALUES LESS THAN (1450483200000) ENGINE = InnoDB,
  853.  PARTITION p20151219 VALUES LESS THAN (1450569600000) ENGINE = InnoDB,
  854.  PARTITION p20151220 VALUES LESS THAN (1450656000000) ENGINE = InnoDB,
  855.  PARTITION p20151221 VALUES LESS THAN (1450742400000) ENGINE = InnoDB,
  856.  PARTITION p20151222 VALUES LESS THAN (1450828800000) ENGINE = InnoDB,
  857.  PARTITION p20151223 VALUES LESS THAN (1450915200000) ENGINE = InnoDB,
  858.  PARTITION p20151224 VALUES LESS THAN (1451001600000) ENGINE = InnoDB,
  859.  PARTITION p20151225 VALUES LESS THAN (1451088000000) ENGINE = InnoDB,
  860.  PARTITION p20151226 VALUES LESS THAN (1451174400000) ENGINE = InnoDB,
  861.  PARTITION p20151227 VALUES LESS THAN (1451260800000) ENGINE = InnoDB,
  862.  PARTITION p20151228 VALUES LESS THAN (1451347200000) ENGINE = InnoDB,
  863.  PARTITION p20151229 VALUES LESS THAN (1451433600000) ENGINE = InnoDB,
  864.  PARTITION p20151230 VALUES LESS THAN (1451520000000) ENGINE = InnoDB,
  865.  PARTITION p20151231 VALUES LESS THAN (1451606400000) ENGINE = InnoDB,
  866.  PARTITION p20160101 VALUES LESS THAN (1451692800000) ENGINE = InnoDB)
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top