API tools faq
paste
Advertisement
Guest User

partitioned table creation and insert

a guest
Aug 13th, 2014
440
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 60.36 KB | None | 0 0
raw download clone embed print report
  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)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!