use traceme; CREATE TABLE `Eventdelijn` ( `record_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `gps_date` datetime NOT NULL, `imei` bigint(20) NOT NULL, `switch` tinyint(3) unsigned NOT NULL, `event_id` smallint(5) unsigned NOT NULL, `latitude` int(10) unsigned NOT NULL, `longtitude` int(10) unsigned NOT NULL, `IO` tinyint(3) unsigned NOT NULL, `raw_data` tinyblob NOT NULL, `extra` longblob NOT NULL, PRIMARY KEY (`record_id`,`gps_date`), KEY `event_id` (`event_id`), KEY `imei` (`imei`), KEY `switch` (`switch`) ) ENGINE=InnoDB AUTO_INCREMENT=7448626 DEFAULT CHARSET=latin1 ( PARTITION BY RANGE (TO_DAYS(gps_date)) PARTITION p0000 VALUES LESS THAN (TO_DAYS('2006-01-01')), PARTITION p0010 VALUES LESS THAN (TO_DAYS('2008-01-01')), PARTITION p0015 VALUES LESS THAN (TO_DAYS('2008-01-05')), PARTITION p0020 VALUES LESS THAN (TO_DAYS('2008-01-09')), PARTITION p0025 VALUES LESS THAN (TO_DAYS('2008-01-13')), PARTITION p0030 VALUES LESS THAN (TO_DAYS('2008-01-17')), PARTITION p0035 VALUES LESS THAN (TO_DAYS('2008-01-21')), PARTITION p0040 VALUES LESS THAN (TO_DAYS('2008-01-25')), PARTITION p0045 VALUES LESS THAN (TO_DAYS('2008-01-29')), PARTITION p0050 VALUES LESS THAN (TO_DAYS('2008-02-02')), PARTITION p0055 VALUES LESS THAN (TO_DAYS('2008-02-06')), PARTITION p0060 VALUES LESS THAN (TO_DAYS('2008-02-10')), PARTITION p0065 VALUES LESS THAN (TO_DAYS('2008-02-14')), PARTITION p0070 VALUES LESS THAN (TO_DAYS('2008-02-18')), PARTITION p0075 VALUES LESS THAN (TO_DAYS('2008-02-22')), PARTITION p0080 VALUES LESS THAN (TO_DAYS('2008-02-26')), PARTITION p0085 VALUES LESS THAN (TO_DAYS('2008-03-01')), PARTITION p0090 VALUES LESS THAN (TO_DAYS('2008-03-05')), PARTITION p0095 VALUES LESS THAN (TO_DAYS('2008-03-09')), PARTITION p0100 VALUES LESS THAN (TO_DAYS('2008-03-13')), PARTITION p0105 VALUES LESS THAN (TO_DAYS('2008-03-17')), PARTITION p0110 VALUES LESS THAN (TO_DAYS('2008-03-21')), PARTITION p0115 VALUES LESS THAN (TO_DAYS('2008-03-25')), PARTITION p0120 VALUES LESS THAN (TO_DAYS('2008-03-29')), PARTITION p0125 VALUES LESS THAN (TO_DAYS('2008-04-02')), PARTITION p0130 VALUES LESS THAN (TO_DAYS('2008-04-06')), PARTITION p0135 VALUES LESS THAN (TO_DAYS('2008-04-10')), PARTITION p0140 VALUES LESS THAN (TO_DAYS('2008-04-14')), PARTITION p0145 VALUES LESS THAN (TO_DAYS('2008-04-18')), PARTITION p0150 VALUES LESS THAN (TO_DAYS('2008-04-22')), PARTITION p0155 VALUES LESS THAN (TO_DAYS('2008-04-26')), PARTITION p0160 VALUES LESS THAN (TO_DAYS('2008-04-30')), PARTITION p0165 VALUES LESS THAN (TO_DAYS('2008-05-04')), PARTITION p0170 VALUES LESS THAN (TO_DAYS('2008-05-08')), PARTITION p0175 VALUES LESS THAN (TO_DAYS('2008-05-12')), PARTITION p0180 VALUES LESS THAN (TO_DAYS('2008-05-16')), PARTITION p0185 VALUES LESS THAN (TO_DAYS('2008-05-20')), PARTITION p0190 VALUES LESS THAN (TO_DAYS('2008-05-24')), PARTITION p0195 VALUES LESS THAN (TO_DAYS('2008-05-28')), PARTITION p0200 VALUES LESS THAN (TO_DAYS('2008-06-01')), PARTITION p0205 VALUES LESS THAN (TO_DAYS('2008-06-05')), PARTITION p0210 VALUES LESS THAN (TO_DAYS('2008-06-09')), PARTITION p0215 VALUES LESS THAN (TO_DAYS('2008-06-13')), PARTITION p0220 VALUES LESS THAN (TO_DAYS('2008-06-17')), PARTITION p0225 VALUES LESS THAN (TO_DAYS('2008-06-21')), PARTITION p0230 VALUES LESS THAN (TO_DAYS('2008-06-25')), PARTITION p0235 VALUES LESS THAN (TO_DAYS('2008-06-29')), PARTITION p0240 VALUES LESS THAN (TO_DAYS('2008-07-03')), PARTITION p0245 VALUES LESS THAN (TO_DAYS('2008-07-07')), PARTITION p0250 VALUES LESS THAN (TO_DAYS('2008-07-11')), PARTITION p0255 VALUES LESS THAN (TO_DAYS('2008-07-15')), PARTITION p0260 VALUES LESS THAN (TO_DAYS('2008-07-19')), PARTITION p0265 VALUES LESS THAN (TO_DAYS('2008-07-23')), PARTITION p0270 VALUES LESS THAN (TO_DAYS('2008-07-27')), PARTITION p0275 VALUES LESS THAN (TO_DAYS('2008-07-31')), PARTITION p0280 VALUES LESS THAN (TO_DAYS('2008-08-04')), PARTITION p0285 VALUES LESS THAN (TO_DAYS('2008-08-08')), PARTITION p0290 VALUES LESS THAN (TO_DAYS('2008-08-12')), PARTITION p0295 VALUES LESS THAN (TO_DAYS('2008-08-16')), PARTITION p0300 VALUES LESS THAN (TO_DAYS('2008-08-20')), PARTITION p0305 VALUES LESS THAN (TO_DAYS('2008-08-24')), PARTITION p0310 VALUES LESS THAN (TO_DAYS('2008-08-28')), PARTITION p0315 VALUES LESS THAN (TO_DAYS('2008-09-01')), PARTITION p0320 VALUES LESS THAN (TO_DAYS('2008-09-05')), PARTITION p0325 VALUES LESS THAN (TO_DAYS('2008-09-09')), PARTITION p0330 VALUES LESS THAN (TO_DAYS('2008-09-13')), PARTITION p0335 VALUES LESS THAN (TO_DAYS('2008-09-17')), PARTITION p0340 VALUES LESS THAN (TO_DAYS('2008-09-21')), PARTITION p0345 VALUES LESS THAN (TO_DAYS('2008-09-25')), PARTITION p0350 VALUES LESS THAN (TO_DAYS('2008-09-29')), PARTITION p0355 VALUES LESS THAN (TO_DAYS('2008-10-03')), PARTITION p0360 VALUES LESS THAN (TO_DAYS('2008-10-07')), PARTITION p0365 VALUES LESS THAN (TO_DAYS('2008-10-11')), PARTITION p0370 VALUES LESS THAN (TO_DAYS('2008-10-15')), PARTITION p0375 VALUES LESS THAN (TO_DAYS('2008-10-19')), PARTITION p0380 VALUES LESS THAN (TO_DAYS('2008-10-23')), PARTITION p0385 VALUES LESS THAN (TO_DAYS('2008-10-27')), PARTITION p0390 VALUES LESS THAN (TO_DAYS('2008-10-31')), PARTITION p0395 VALUES LESS THAN (TO_DAYS('2008-11-04')), PARTITION p0400 VALUES LESS THAN (TO_DAYS('2008-11-08')), PARTITION p0405 VALUES LESS THAN (TO_DAYS('2008-11-12')), PARTITION p0410 VALUES LESS THAN (TO_DAYS('2008-11-16')), PARTITION p0415 VALUES LESS THAN (TO_DAYS('2008-11-20')), PARTITION p0420 VALUES LESS THAN (TO_DAYS('2008-11-24')), PARTITION p0425 VALUES LESS THAN (TO_DAYS('2008-11-28')), PARTITION p0430 VALUES LESS THAN (TO_DAYS('2008-12-02')), PARTITION p0435 VALUES LESS THAN (TO_DAYS('2008-12-06')), PARTITION p0440 VALUES LESS THAN (TO_DAYS('2008-12-10')), PARTITION p0445 VALUES LESS THAN (TO_DAYS('2008-12-14')), PARTITION p0450 VALUES LESS THAN (TO_DAYS('2008-12-18')), PARTITION p0455 VALUES LESS THAN (TO_DAYS('2008-12-22')), PARTITION p0460 VALUES LESS THAN (TO_DAYS('2008-12-26')), PARTITION p0465 VALUES LESS THAN (TO_DAYS('2008-12-30')), PARTITION p0470 VALUES LESS THAN (TO_DAYS('2009-01-03')), PARTITION p0475 VALUES LESS THAN (TO_DAYS('2009-01-07')), PARTITION p0480 VALUES LESS THAN (TO_DAYS('2009-01-11')), PARTITION p0485 VALUES LESS THAN (TO_DAYS('2009-01-15')), PARTITION p0490 VALUES LESS THAN (TO_DAYS('2009-01-19')), PARTITION p0495 VALUES LESS THAN (TO_DAYS('2009-01-23')), PARTITION p0500 VALUES LESS THAN (TO_DAYS('2009-01-27')), PARTITION p0505 VALUES LESS THAN (TO_DAYS('2009-01-31')), PARTITION p0510 VALUES LESS THAN (TO_DAYS('2009-02-04')), PARTITION p0515 VALUES LESS THAN (TO_DAYS('2009-02-08')), PARTITION p0520 VALUES LESS THAN (TO_DAYS('2009-02-12')), PARTITION p0525 VALUES LESS THAN (TO_DAYS('2009-02-16')), PARTITION p0530 VALUES LESS THAN (TO_DAYS('2009-02-20')), PARTITION p0535 VALUES LESS THAN (TO_DAYS('2009-02-24')), PARTITION p0540 VALUES LESS THAN (TO_DAYS('2009-02-28')), PARTITION p0545 VALUES LESS THAN (TO_DAYS('2009-03-04')), PARTITION p0550 VALUES LESS THAN (TO_DAYS('2009-03-08')), PARTITION p0555 VALUES LESS THAN (TO_DAYS('2009-03-12')), PARTITION p0560 VALUES LESS THAN (TO_DAYS('2009-03-16')), PARTITION p0565 VALUES LESS THAN (TO_DAYS('2009-03-20')), PARTITION p0570 VALUES LESS THAN (TO_DAYS('2009-03-24')), PARTITION p0575 VALUES LESS THAN (TO_DAYS('2009-03-28')), PARTITION p0580 VALUES LESS THAN (TO_DAYS('2009-04-01')), PARTITION p0585 VALUES LESS THAN (TO_DAYS('2009-04-05')), PARTITION p0590 VALUES LESS THAN (TO_DAYS('2009-04-09')), PARTITION p0595 VALUES LESS THAN (TO_DAYS('2009-04-13')), PARTITION p0600 VALUES LESS THAN (TO_DAYS('2009-04-17')), PARTITION p0605 VALUES LESS THAN (TO_DAYS('2009-04-21')), PARTITION p0610 VALUES LESS THAN (TO_DAYS('2009-04-25')), PARTITION p0615 VALUES LESS THAN (TO_DAYS('2009-04-29')), PARTITION p0620 VALUES LESS THAN (TO_DAYS('2009-05-03')), PARTITION p0625 VALUES LESS THAN (TO_DAYS('2009-05-07')), PARTITION p0630 VALUES LESS THAN (TO_DAYS('2009-05-11')), PARTITION p0635 VALUES LESS THAN (TO_DAYS('2009-05-15')), PARTITION p0640 VALUES LESS THAN (TO_DAYS('2009-05-19')), PARTITION p0645 VALUES LESS THAN (TO_DAYS('2009-05-23')), PARTITION p0650 VALUES LESS THAN (TO_DAYS('2009-05-27')), PARTITION p0655 VALUES LESS THAN (TO_DAYS('2009-05-31')), PARTITION p0660 VALUES LESS THAN (TO_DAYS('2009-06-04')), PARTITION p0665 VALUES LESS THAN (TO_DAYS('2009-06-08')), PARTITION p0670 VALUES LESS THAN (TO_DAYS('2009-06-12')), PARTITION p0675 VALUES LESS THAN (TO_DAYS('2009-06-16')), PARTITION p0680 VALUES LESS THAN (TO_DAYS('2009-06-20')), PARTITION p0685 VALUES LESS THAN (TO_DAYS('2009-06-24')), PARTITION p0690 VALUES LESS THAN (TO_DAYS('2009-06-28')), PARTITION p0695 VALUES LESS THAN (TO_DAYS('2009-07-02')), PARTITION p0700 VALUES LESS THAN (TO_DAYS('2009-07-06')), PARTITION p0705 VALUES LESS THAN (TO_DAYS('2009-07-10')), PARTITION p0710 VALUES LESS THAN (TO_DAYS('2009-07-14')), PARTITION p0715 VALUES LESS THAN (TO_DAYS('2009-07-18')), PARTITION p0720 VALUES LESS THAN (TO_DAYS('2009-07-22')), PARTITION p0725 VALUES LESS THAN (TO_DAYS('2009-07-26')), PARTITION p0730 VALUES LESS THAN (TO_DAYS('2009-07-30')), PARTITION p0735 VALUES LESS THAN (TO_DAYS('2009-08-03')), PARTITION p0740 VALUES LESS THAN (TO_DAYS('2009-08-07')), PARTITION p0745 VALUES LESS THAN (TO_DAYS('2009-08-11')), PARTITION p0750 VALUES LESS THAN (TO_DAYS('2009-08-15')), PARTITION p0755 VALUES LESS THAN (TO_DAYS('2009-08-19')), PARTITION p0760 VALUES LESS THAN (TO_DAYS('2009-08-23')), PARTITION p0765 VALUES LESS THAN (TO_DAYS('2009-08-27')), PARTITION p0770 VALUES LESS THAN (TO_DAYS('2009-08-31')), PARTITION p0775 VALUES LESS THAN (TO_DAYS('2009-09-04')), PARTITION p0780 VALUES LESS THAN (TO_DAYS('2009-09-08')), PARTITION p0785 VALUES LESS THAN (TO_DAYS('2009-09-12')), PARTITION p0790 VALUES LESS THAN (TO_DAYS('2009-09-16')), PARTITION p0795 VALUES LESS THAN (TO_DAYS('2009-09-20')), PARTITION p0800 VALUES LESS THAN (TO_DAYS('2009-09-24')), PARTITION p0805 VALUES LESS THAN (TO_DAYS('2009-09-28')), PARTITION p0810 VALUES LESS THAN (TO_DAYS('2009-10-02')), PARTITION p0815 VALUES LESS THAN (TO_DAYS('2009-10-06')), PARTITION p0820 VALUES LESS THAN (TO_DAYS('2009-10-10')), PARTITION p0825 VALUES LESS THAN (TO_DAYS('2009-10-14')), PARTITION p0830 VALUES LESS THAN (TO_DAYS('2009-10-18')), PARTITION p0835 VALUES LESS THAN (TO_DAYS('2009-10-22')), PARTITION p0840 VALUES LESS THAN (TO_DAYS('2009-10-26')), PARTITION p0845 VALUES LESS THAN (TO_DAYS('2009-10-30')), PARTITION p0850 VALUES LESS THAN (TO_DAYS('2009-11-03')), PARTITION p0855 VALUES LESS THAN (TO_DAYS('2009-11-07')), PARTITION p0860 VALUES LESS THAN (TO_DAYS('2009-11-11')), PARTITION p0865 VALUES LESS THAN (TO_DAYS('2009-11-15')), PARTITION p0870 VALUES LESS THAN (TO_DAYS('2009-11-19')), PARTITION p0875 VALUES LESS THAN (TO_DAYS('2009-11-23')), PARTITION p0880 VALUES LESS THAN (TO_DAYS('2009-11-27')), PARTITION p0885 VALUES LESS THAN (TO_DAYS('2009-12-01')), PARTITION p0890 VALUES LESS THAN (TO_DAYS('2009-12-05')), PARTITION p0895 VALUES LESS THAN (TO_DAYS('2009-12-09')), PARTITION p0900 VALUES LESS THAN (TO_DAYS('2009-12-13')), PARTITION p0905 VALUES LESS THAN (TO_DAYS('2009-12-17')), PARTITION p0910 VALUES LESS THAN (TO_DAYS('2009-12-21')), PARTITION p0915 VALUES LESS THAN (TO_DAYS('2009-12-25')), PARTITION p0920 VALUES LESS THAN (TO_DAYS('2009-12-29')), PARTITION p0925 VALUES LESS THAN (TO_DAYS('2010-01-02')), PARTITION p0930 VALUES LESS THAN (TO_DAYS('2010-01-06')), PARTITION p0935 VALUES LESS THAN (TO_DAYS('2010-01-10')), PARTITION p0940 VALUES LESS THAN (TO_DAYS('2010-01-14')), PARTITION p0945 VALUES LESS THAN (TO_DAYS('2010-01-18')), PARTITION p0950 VALUES LESS THAN (TO_DAYS('2010-01-22')), PARTITION p0955 VALUES LESS THAN (TO_DAYS('2010-01-26')), PARTITION p0960 VALUES LESS THAN (TO_DAYS('2010-01-30')), PARTITION p0965 VALUES LESS THAN (TO_DAYS('2010-02-03')), PARTITION p0970 VALUES LESS THAN (TO_DAYS('2010-02-07')), PARTITION p0975 VALUES LESS THAN (TO_DAYS('2010-02-11')), PARTITION p0980 VALUES LESS THAN (TO_DAYS('2010-02-15')), PARTITION p0985 VALUES LESS THAN (TO_DAYS('2010-02-19')), PARTITION p0990 VALUES LESS THAN (TO_DAYS('2010-02-23')), PARTITION p0995 VALUES LESS THAN (TO_DAYS('2010-02-27')), PARTITION p1000 VALUES LESS THAN (TO_DAYS('2010-03-03')), PARTITION p1005 VALUES LESS THAN (TO_DAYS('2010-03-07')), PARTITION p1010 VALUES LESS THAN (TO_DAYS('2010-03-11')), PARTITION p1015 VALUES LESS THAN (TO_DAYS('2010-03-15')), PARTITION p1020 VALUES LESS THAN (TO_DAYS('2010-03-19')), PARTITION p1025 VALUES LESS THAN (TO_DAYS('2010-03-23')), PARTITION p1030 VALUES LESS THAN (TO_DAYS('2010-03-27')), PARTITION p1035 VALUES LESS THAN (TO_DAYS('2010-03-31')), PARTITION p1040 VALUES LESS THAN (TO_DAYS('2010-04-04')), PARTITION p1045 VALUES LESS THAN (TO_DAYS('2010-04-08')), PARTITION p1050 VALUES LESS THAN (TO_DAYS('2010-04-12')), PARTITION p1055 VALUES LESS THAN (TO_DAYS('2010-04-16')), PARTITION p1060 VALUES LESS THAN (TO_DAYS('2010-04-20')), PARTITION p1065 VALUES LESS THAN (TO_DAYS('2010-04-24')), PARTITION p1070 VALUES LESS THAN (TO_DAYS('2010-04-28')), PARTITION p1075 VALUES LESS THAN (TO_DAYS('2010-05-02')), PARTITION p1080 VALUES LESS THAN (TO_DAYS('2010-05-06')), PARTITION p1085 VALUES LESS THAN (TO_DAYS('2010-05-10')), PARTITION p1090 VALUES LESS THAN (TO_DAYS('2010-05-14')), PARTITION p1095 VALUES LESS THAN (TO_DAYS('2010-05-18')), PARTITION p1100 VALUES LESS THAN (TO_DAYS('2010-05-22')), PARTITION p1105 VALUES LESS THAN (TO_DAYS('2010-05-26')), PARTITION p1110 VALUES LESS THAN (TO_DAYS('2010-05-30')), PARTITION p1115 VALUES LESS THAN (TO_DAYS('2010-06-03')), PARTITION p1120 VALUES LESS THAN (TO_DAYS('2010-06-07')), PARTITION p1125 VALUES LESS THAN (TO_DAYS('2010-06-11')), PARTITION p1130 VALUES LESS THAN (TO_DAYS('2010-06-15')), PARTITION p1135 VALUES LESS THAN (TO_DAYS('2010-06-19')), PARTITION p1140 VALUES LESS THAN (TO_DAYS('2010-06-23')), PARTITION p1145 VALUES LESS THAN (TO_DAYS('2010-06-27')), PARTITION p1150 VALUES LESS THAN (TO_DAYS('2010-07-01')), PARTITION p1155 VALUES LESS THAN (TO_DAYS('2010-07-05')), PARTITION p1160 VALUES LESS THAN (TO_DAYS('2010-07-09')), PARTITION p1165 VALUES LESS THAN (TO_DAYS('2010-07-13')), PARTITION p1170 VALUES LESS THAN (TO_DAYS('2010-07-17')), PARTITION p1175 VALUES LESS THAN (TO_DAYS('2010-07-21')), PARTITION p1180 VALUES LESS THAN (TO_DAYS('2010-07-25')), PARTITION p1185 VALUES LESS THAN (TO_DAYS('2010-07-29')), PARTITION p1190 VALUES LESS THAN (TO_DAYS('2010-08-02')), PARTITION p1195 VALUES LESS THAN (TO_DAYS('2010-08-06')), PARTITION p1200 VALUES LESS THAN (TO_DAYS('2010-08-10')), PARTITION p1205 VALUES LESS THAN (TO_DAYS('2010-08-14')), PARTITION p1210 VALUES LESS THAN (TO_DAYS('2010-08-18')), PARTITION p1215 VALUES LESS THAN (TO_DAYS('2010-08-22')), PARTITION p1220 VALUES LESS THAN (TO_DAYS('2010-08-26')), PARTITION p1225 VALUES LESS THAN (TO_DAYS('2010-08-30')), PARTITION p1230 VALUES LESS THAN (TO_DAYS('2010-09-03')), PARTITION p1235 VALUES LESS THAN (TO_DAYS('2010-09-07')), PARTITION p1240 VALUES LESS THAN (TO_DAYS('2010-09-11')), PARTITION p1245 VALUES LESS THAN (TO_DAYS('2010-09-15')), PARTITION p1250 VALUES LESS THAN (TO_DAYS('2010-09-19')), PARTITION p1255 VALUES LESS THAN (TO_DAYS('2010-09-23')), PARTITION p1260 VALUES LESS THAN (TO_DAYS('2010-09-27')), PARTITION p1265 VALUES LESS THAN (TO_DAYS('2010-10-01')), PARTITION p1270 VALUES LESS THAN (TO_DAYS('2010-10-05')), PARTITION p1275 VALUES LESS THAN (TO_DAYS('2010-10-09')), PARTITION p1280 VALUES LESS THAN (TO_DAYS('2010-10-13')), PARTITION p1285 VALUES LESS THAN (TO_DAYS('2010-10-17')), PARTITION p1290 VALUES LESS THAN (TO_DAYS('2010-10-21')), PARTITION p1295 VALUES LESS THAN (TO_DAYS('2010-10-25')), PARTITION p1300 VALUES LESS THAN (TO_DAYS('2010-10-29')), PARTITION p1305 VALUES LESS THAN (TO_DAYS('2010-11-02')), PARTITION p1310 VALUES LESS THAN (TO_DAYS('2010-11-06')), PARTITION p1315 VALUES LESS THAN (TO_DAYS('2010-11-10')), PARTITION p1320 VALUES LESS THAN (TO_DAYS('2010-11-14')), PARTITION p1325 VALUES LESS THAN (TO_DAYS('2010-11-18')), PARTITION p1330 VALUES LESS THAN (TO_DAYS('2010-11-22')), PARTITION p1335 VALUES LESS THAN (TO_DAYS('2010-11-26')), PARTITION p1340 VALUES LESS THAN (TO_DAYS('2010-11-30')), PARTITION p1345 VALUES LESS THAN (TO_DAYS('2010-12-04')), PARTITION p1350 VALUES LESS THAN (TO_DAYS('2010-12-08')), PARTITION p1355 VALUES LESS THAN (TO_DAYS('2010-12-12')), PARTITION p1360 VALUES LESS THAN (TO_DAYS('2010-12-16')), PARTITION p1365 VALUES LESS THAN (TO_DAYS('2010-12-20')), PARTITION p1370 VALUES LESS THAN (TO_DAYS('2010-12-24')), PARTITION p1375 VALUES LESS THAN (TO_DAYS('2010-12-28')), PARTITION p1380 VALUES LESS THAN (TO_DAYS('2011-01-01')), PARTITION p1385 VALUES LESS THAN (TO_DAYS('2011-01-05')), PARTITION p1390 VALUES LESS THAN (TO_DAYS('2011-01-09')), PARTITION p1395 VALUES LESS THAN (TO_DAYS('2011-01-13')), PARTITION p1400 VALUES LESS THAN (TO_DAYS('2011-01-17')), PARTITION p1405 VALUES LESS THAN (TO_DAYS('2011-01-21')), PARTITION p1410 VALUES LESS THAN (TO_DAYS('2011-01-25')), PARTITION p1415 VALUES LESS THAN (TO_DAYS('2011-01-29')), PARTITION p1420 VALUES LESS THAN (TO_DAYS('2011-02-02')), PARTITION p1425 VALUES LESS THAN (TO_DAYS('2011-02-06')), PARTITION p1430 VALUES LESS THAN (TO_DAYS('2011-02-10')), PARTITION p1435 VALUES LESS THAN (TO_DAYS('2011-02-14')), PARTITION p1440 VALUES LESS THAN (TO_DAYS('2011-02-18')), PARTITION p1445 VALUES LESS THAN (TO_DAYS('2011-02-22')), PARTITION p1450 VALUES LESS THAN (TO_DAYS('2011-02-26')), PARTITION p1455 VALUES LESS THAN (TO_DAYS('2011-03-02')), PARTITION p1460 VALUES LESS THAN (TO_DAYS('2011-03-06')), PARTITION p1465 VALUES LESS THAN (TO_DAYS('2011-03-10')), PARTITION p1470 VALUES LESS THAN (TO_DAYS('2011-03-14')), PARTITION p1475 VALUES LESS THAN (TO_DAYS('2011-03-18')), PARTITION p1480 VALUES LESS THAN (TO_DAYS('2011-03-22')), PARTITION p1485 VALUES LESS THAN (TO_DAYS('2011-03-26')), PARTITION p1490 VALUES LESS THAN (TO_DAYS('2011-03-30')), PARTITION p1495 VALUES LESS THAN (TO_DAYS('2011-04-03')), PARTITION p1500 VALUES LESS THAN (TO_DAYS('2011-04-07')), PARTITION p1505 VALUES LESS THAN (TO_DAYS('2011-04-11')), PARTITION p1510 VALUES LESS THAN (TO_DAYS('2011-04-15')), PARTITION p1515 VALUES LESS THAN (TO_DAYS('2011-04-19')), PARTITION p1520 VALUES LESS THAN (TO_DAYS('2011-04-23')), PARTITION p1525 VALUES LESS THAN (TO_DAYS('2011-04-27')), PARTITION p1530 VALUES LESS THAN (TO_DAYS('2011-05-01')), PARTITION p1535 VALUES LESS THAN (TO_DAYS('2011-05-05')), PARTITION p1540 VALUES LESS THAN (TO_DAYS('2011-05-09')), PARTITION p1545 VALUES LESS THAN (TO_DAYS('2011-05-13')), PARTITION p1550 VALUES LESS THAN (TO_DAYS('2011-05-17')), PARTITION p1555 VALUES LESS THAN (TO_DAYS('2011-05-21')), PARTITION p1560 VALUES LESS THAN (TO_DAYS('2011-05-25')), PARTITION p1565 VALUES LESS THAN (TO_DAYS('2011-05-29')), PARTITION p1570 VALUES LESS THAN (TO_DAYS('2011-06-02')), PARTITION p1575 VALUES LESS THAN (TO_DAYS('2011-06-06')), PARTITION p1580 VALUES LESS THAN (TO_DAYS('2011-06-10')), PARTITION p1585 VALUES LESS THAN (TO_DAYS('2011-06-14')), PARTITION p1590 VALUES LESS THAN (TO_DAYS('2011-06-18')), PARTITION p1595 VALUES LESS THAN (TO_DAYS('2011-06-22')), PARTITION p1600 VALUES LESS THAN (TO_DAYS('2011-06-26')), PARTITION p1605 VALUES LESS THAN (TO_DAYS('2011-06-30')), PARTITION p1610 VALUES LESS THAN (TO_DAYS('2011-07-04')), PARTITION p1615 VALUES LESS THAN (TO_DAYS('2011-07-08')), PARTITION p1620 VALUES LESS THAN (TO_DAYS('2011-07-12')), PARTITION p1625 VALUES LESS THAN (TO_DAYS('2011-07-16')), PARTITION p1630 VALUES LESS THAN (TO_DAYS('2011-07-20')), PARTITION p1635 VALUES LESS THAN (TO_DAYS('2011-07-24')), PARTITION p1640 VALUES LESS THAN (TO_DAYS('2011-07-28')), PARTITION p1645 VALUES LESS THAN (TO_DAYS('2011-08-01')), PARTITION p1650 VALUES LESS THAN (TO_DAYS('2011-08-05')), PARTITION p1655 VALUES LESS THAN (TO_DAYS('2011-08-09')), PARTITION p1660 VALUES LESS THAN (TO_DAYS('2011-08-13')), PARTITION p1665 VALUES LESS THAN (TO_DAYS('2011-08-17')), PARTITION p1670 VALUES LESS THAN (TO_DAYS('2011-08-21')), PARTITION p1675 VALUES LESS THAN (TO_DAYS('2011-08-25')), PARTITION p1680 VALUES LESS THAN (TO_DAYS('2011-08-29')), PARTITION p1685 VALUES LESS THAN (TO_DAYS('2011-09-02')), PARTITION p1690 VALUES LESS THAN (TO_DAYS('2011-09-06')), PARTITION p1695 VALUES LESS THAN (TO_DAYS('2011-09-10')), PARTITION p1700 VALUES LESS THAN (TO_DAYS('2011-09-14')), PARTITION p1705 VALUES LESS THAN (TO_DAYS('2011-09-18')), PARTITION p1710 VALUES LESS THAN (TO_DAYS('2011-09-22')), PARTITION p1715 VALUES LESS THAN (TO_DAYS('2011-09-26')), PARTITION p1720 VALUES LESS THAN (TO_DAYS('2011-09-30')), PARTITION p1725 VALUES LESS THAN (TO_DAYS('2011-10-04')), PARTITION p1730 VALUES LESS THAN (TO_DAYS('2011-10-08')), PARTITION p1735 VALUES LESS THAN (TO_DAYS('2011-10-12')), PARTITION p1740 VALUES LESS THAN (TO_DAYS('2011-10-16')), PARTITION p1745 VALUES LESS THAN (TO_DAYS('2011-10-20')), PARTITION p1750 VALUES LESS THAN (TO_DAYS('2011-10-24')), PARTITION p1755 VALUES LESS THAN (TO_DAYS('2011-10-28')), PARTITION p1760 VALUES LESS THAN (TO_DAYS('2011-11-01')), PARTITION p1765 VALUES LESS THAN (TO_DAYS('2011-11-05')), PARTITION p1770 VALUES LESS THAN (TO_DAYS('2011-11-09')), PARTITION p1775 VALUES LESS THAN (TO_DAYS('2011-11-13')), PARTITION p1780 VALUES LESS THAN (TO_DAYS('2011-11-17')), PARTITION p1785 VALUES LESS THAN (TO_DAYS('2011-11-21')), PARTITION p1790 VALUES LESS THAN (TO_DAYS('2011-11-25')), PARTITION p1795 VALUES LESS THAN (TO_DAYS('2011-11-29')), PARTITION p1800 VALUES LESS THAN (TO_DAYS('2011-12-03')), PARTITION p1805 VALUES LESS THAN (TO_DAYS('2011-12-07')), PARTITION p1810 VALUES LESS THAN (TO_DAYS('2011-12-11')), PARTITION p1815 VALUES LESS THAN (TO_DAYS('2011-12-15')), PARTITION p1820 VALUES LESS THAN (TO_DAYS('2011-12-19')), PARTITION p1825 VALUES LESS THAN (TO_DAYS('2011-12-23')), PARTITION p1830 VALUES LESS THAN (TO_DAYS('2011-12-27')), PARTITION p1835 VALUES LESS THAN (TO_DAYS('2011-12-31')), PARTITION p1840 VALUES LESS THAN (TO_DAYS('2012-01-04')), PARTITION p1845 VALUES LESS THAN (TO_DAYS('2012-01-08')), PARTITION p1850 VALUES LESS THAN (TO_DAYS('2012-01-12')), PARTITION p1855 VALUES LESS THAN (TO_DAYS('2012-01-16')), PARTITION p1860 VALUES LESS THAN (TO_DAYS('2012-01-20')), PARTITION p1865 VALUES LESS THAN (TO_DAYS('2012-01-24')), PARTITION p1870 VALUES LESS THAN (TO_DAYS('2012-01-28')), PARTITION p1875 VALUES LESS THAN (TO_DAYS('2012-02-01')), PARTITION p1880 VALUES LESS THAN (TO_DAYS('2012-02-05')), PARTITION p1885 VALUES LESS THAN (TO_DAYS('2012-02-09')), PARTITION p1890 VALUES LESS THAN (TO_DAYS('2012-02-13')), PARTITION p1895 VALUES LESS THAN (TO_DAYS('2012-02-17')), PARTITION p1900 VALUES LESS THAN (TO_DAYS('2012-02-21')), PARTITION p1905 VALUES LESS THAN (TO_DAYS('2012-02-25')), PARTITION p1910 VALUES LESS THAN (TO_DAYS('2012-02-29')), PARTITION p1915 VALUES LESS THAN (TO_DAYS('2012-03-04')), PARTITION p1920 VALUES LESS THAN (TO_DAYS('2012-03-08')), PARTITION p1925 VALUES LESS THAN (TO_DAYS('2012-03-12')), PARTITION p1930 VALUES LESS THAN (TO_DAYS('2012-03-16')), PARTITION p1935 VALUES LESS THAN (TO_DAYS('2012-03-20')), PARTITION p1940 VALUES LESS THAN (TO_DAYS('2012-03-24')), PARTITION p1945 VALUES LESS THAN (TO_DAYS('2012-03-28')), PARTITION p1950 VALUES LESS THAN (TO_DAYS('2012-04-01')), PARTITION p1955 VALUES LESS THAN (TO_DAYS('2012-04-05')), PARTITION p1960 VALUES LESS THAN (TO_DAYS('2012-04-09')), PARTITION p1965 VALUES LESS THAN (TO_DAYS('2012-04-13')), PARTITION p1970 VALUES LESS THAN (TO_DAYS('2012-04-17')), PARTITION p1975 VALUES LESS THAN (TO_DAYS('2012-04-21')), PARTITION p1980 VALUES LESS THAN (TO_DAYS('2012-04-25')), PARTITION p1985 VALUES LESS THAN (TO_DAYS('2012-04-29')), PARTITION p1990 VALUES LESS THAN (TO_DAYS('2012-05-03')), PARTITION p1995 VALUES LESS THAN (TO_DAYS('2012-05-07')), PARTITION p2000 VALUES LESS THAN (TO_DAYS('2012-05-11')), PARTITION p2005 VALUES LESS THAN (TO_DAYS('2012-05-15')), PARTITION p2010 VALUES LESS THAN (TO_DAYS('2012-05-19')), PARTITION p2015 VALUES LESS THAN (TO_DAYS('2012-05-23')), PARTITION p2020 VALUES LESS THAN (TO_DAYS('2012-05-27')), PARTITION p2025 VALUES LESS THAN (TO_DAYS('2012-05-31')), PARTITION p2030 VALUES LESS THAN (TO_DAYS('2012-06-04')), PARTITION p2035 VALUES LESS THAN (TO_DAYS('2012-06-08')), PARTITION p2040 VALUES LESS THAN (TO_DAYS('2012-06-12')), PARTITION p2045 VALUES LESS THAN (TO_DAYS('2012-06-16')), PARTITION p2050 VALUES LESS THAN (TO_DAYS('2012-06-20')), PARTITION p2055 VALUES LESS THAN (TO_DAYS('2012-06-24')), PARTITION p2060 VALUES LESS THAN (TO_DAYS('2012-06-28')), PARTITION p2065 VALUES LESS THAN (TO_DAYS('2012-07-02')), PARTITION p2070 VALUES LESS THAN (TO_DAYS('2012-07-06')), PARTITION p2075 VALUES LESS THAN (TO_DAYS('2012-07-10')), PARTITION p2080 VALUES LESS THAN (TO_DAYS('2012-07-14')), PARTITION p2085 VALUES LESS THAN (TO_DAYS('2012-07-18')), PARTITION p2090 VALUES LESS THAN (TO_DAYS('2012-07-22')), PARTITION p2095 VALUES LESS THAN (TO_DAYS('2012-07-26')), PARTITION p2100 VALUES LESS THAN (TO_DAYS('2012-07-30')), PARTITION p2105 VALUES LESS THAN (TO_DAYS('2012-08-03')), PARTITION p2110 VALUES LESS THAN (TO_DAYS('2012-08-07')), PARTITION p2115 VALUES LESS THAN (TO_DAYS('2012-08-11')), PARTITION p2120 VALUES LESS THAN (TO_DAYS('2012-08-15')), PARTITION p2125 VALUES LESS THAN (TO_DAYS('2012-08-19')), PARTITION p2130 VALUES LESS THAN (TO_DAYS('2012-08-23')), PARTITION p2135 VALUES LESS THAN (TO_DAYS('2012-08-27')), PARTITION p2140 VALUES LESS THAN (TO_DAYS('2012-08-31')), PARTITION p2145 VALUES LESS THAN (TO_DAYS('2012-09-04')), PARTITION p2150 VALUES LESS THAN (TO_DAYS('2012-09-08')), PARTITION p2155 VALUES LESS THAN (TO_DAYS('2012-09-12')), PARTITION p2160 VALUES LESS THAN (TO_DAYS('2012-09-16')), PARTITION p2165 VALUES LESS THAN (TO_DAYS('2012-09-20')), PARTITION p2170 VALUES LESS THAN (TO_DAYS('2012-09-24')), PARTITION p2175 VALUES LESS THAN (TO_DAYS('2012-09-28')), PARTITION p2180 VALUES LESS THAN (TO_DAYS('2012-10-02')), PARTITION p2185 VALUES LESS THAN (TO_DAYS('2012-10-06')), PARTITION p2190 VALUES LESS THAN (TO_DAYS('2012-10-10')), PARTITION p2195 VALUES LESS THAN (TO_DAYS('2012-10-14')), PARTITION p2200 VALUES LESS THAN (TO_DAYS('2012-10-18')), PARTITION p2205 VALUES LESS THAN (TO_DAYS('2012-10-22')), PARTITION p2210 VALUES LESS THAN (TO_DAYS('2012-10-26')), PARTITION p2215 VALUES LESS THAN (TO_DAYS('2012-10-30')), PARTITION p2220 VALUES LESS THAN (TO_DAYS('2012-11-03')), PARTITION p2225 VALUES LESS THAN (TO_DAYS('2012-11-07')), PARTITION p2230 VALUES LESS THAN (TO_DAYS('2012-11-11')), PARTITION p2235 VALUES LESS THAN (TO_DAYS('2012-11-15')), PARTITION p2240 VALUES LESS THAN (TO_DAYS('2012-11-19')), PARTITION p2245 VALUES LESS THAN (TO_DAYS('2012-11-23')), PARTITION p2250 VALUES LESS THAN (TO_DAYS('2012-11-27')), PARTITION p2255 VALUES LESS THAN (TO_DAYS('2012-12-01')), PARTITION p2260 VALUES LESS THAN (TO_DAYS('2012-12-05')), PARTITION p2265 VALUES LESS THAN (TO_DAYS('2012-12-09')), PARTITION p2270 VALUES LESS THAN (TO_DAYS('2012-12-13')), PARTITION p2275 VALUES LESS THAN (TO_DAYS('2012-12-17')), PARTITION p2280 VALUES LESS THAN (TO_DAYS('2012-12-21')), PARTITION p2285 VALUES LESS THAN (TO_DAYS('2012-12-25')), PARTITION p2290 VALUES LESS THAN (TO_DAYS('2012-12-29')), PARTITION p3000 VALUES LESS THAN MAXVALUE); use `Historics`; CREATE TABLE `his_Event_delijn` ( `record_id` int(10) unsigned NOT NULL, `gps_date` datetime NOT NULL, `imei` bigint(20) NOT NULL, `switch` tinyint(3) unsigned NOT NULL, `event_id` smallint(5) unsigned NOT NULL, `latitude` int(10) unsigned NOT NULL, `longtitude` int(10) unsigned NOT NULL, `IO` tinyint(3) unsigned NOT NULL, `raw_data` tinyblob NOT NULL, `extra` longblob ) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 ( PARTITION BY RANGE (TO_DAYS(gps_date)) PARTITION p0000 VALUES LESS THAN (TO_DAYS('2006-01-01')), PARTITION p0010 VALUES LESS THAN (TO_DAYS('2008-01-01')), PARTITION p0015 VALUES LESS THAN (TO_DAYS('2008-01-05')), PARTITION p0020 VALUES LESS THAN (TO_DAYS('2008-01-09')), PARTITION p0025 VALUES LESS THAN (TO_DAYS('2008-01-13')), PARTITION p0030 VALUES LESS THAN (TO_DAYS('2008-01-17')), PARTITION p0035 VALUES LESS THAN (TO_DAYS('2008-01-21')), PARTITION p0040 VALUES LESS THAN (TO_DAYS('2008-01-25')), PARTITION p0045 VALUES LESS THAN (TO_DAYS('2008-01-29')), PARTITION p0050 VALUES LESS THAN (TO_DAYS('2008-02-02')), PARTITION p0055 VALUES LESS THAN (TO_DAYS('2008-02-06')), PARTITION p0060 VALUES LESS THAN (TO_DAYS('2008-02-10')), PARTITION p0065 VALUES LESS THAN (TO_DAYS('2008-02-14')), PARTITION p0070 VALUES LESS THAN (TO_DAYS('2008-02-18')), PARTITION p0075 VALUES LESS THAN (TO_DAYS('2008-02-22')), PARTITION p0080 VALUES LESS THAN (TO_DAYS('2008-02-26')), PARTITION p0085 VALUES LESS THAN (TO_DAYS('2008-03-01')), PARTITION p0090 VALUES LESS THAN (TO_DAYS('2008-03-05')), PARTITION p0095 VALUES LESS THAN (TO_DAYS('2008-03-09')), PARTITION p0100 VALUES LESS THAN (TO_DAYS('2008-03-13')), PARTITION p0105 VALUES LESS THAN (TO_DAYS('2008-03-17')), PARTITION p0110 VALUES LESS THAN (TO_DAYS('2008-03-21')), PARTITION p0115 VALUES LESS THAN (TO_DAYS('2008-03-25')), PARTITION p0120 VALUES LESS THAN (TO_DAYS('2008-03-29')), PARTITION p0125 VALUES LESS THAN (TO_DAYS('2008-04-02')), PARTITION p0130 VALUES LESS THAN (TO_DAYS('2008-04-06')), PARTITION p0135 VALUES LESS THAN (TO_DAYS('2008-04-10')), PARTITION p0140 VALUES LESS THAN (TO_DAYS('2008-04-14')), PARTITION p0145 VALUES LESS THAN (TO_DAYS('2008-04-18')), PARTITION p0150 VALUES LESS THAN (TO_DAYS('2008-04-22')), PARTITION p0155 VALUES LESS THAN (TO_DAYS('2008-04-26')), PARTITION p0160 VALUES LESS THAN (TO_DAYS('2008-04-30')), PARTITION p0165 VALUES LESS THAN (TO_DAYS('2008-05-04')), PARTITION p0170 VALUES LESS THAN (TO_DAYS('2008-05-08')), PARTITION p0175 VALUES LESS THAN (TO_DAYS('2008-05-12')), PARTITION p0180 VALUES LESS THAN (TO_DAYS('2008-05-16')), PARTITION p0185 VALUES LESS THAN (TO_DAYS('2008-05-20')), PARTITION p0190 VALUES LESS THAN (TO_DAYS('2008-05-24')), PARTITION p0195 VALUES LESS THAN (TO_DAYS('2008-05-28')), PARTITION p0200 VALUES LESS THAN (TO_DAYS('2008-06-01')), PARTITION p0205 VALUES LESS THAN (TO_DAYS('2008-06-05')), PARTITION p0210 VALUES LESS THAN (TO_DAYS('2008-06-09')), PARTITION p0215 VALUES LESS THAN (TO_DAYS('2008-06-13')), PARTITION p0220 VALUES LESS THAN (TO_DAYS('2008-06-17')), PARTITION p0225 VALUES LESS THAN (TO_DAYS('2008-06-21')), PARTITION p0230 VALUES LESS THAN (TO_DAYS('2008-06-25')), PARTITION p0235 VALUES LESS THAN (TO_DAYS('2008-06-29')), PARTITION p0240 VALUES LESS THAN (TO_DAYS('2008-07-03')), PARTITION p0245 VALUES LESS THAN (TO_DAYS('2008-07-07')), PARTITION p0250 VALUES LESS THAN (TO_DAYS('2008-07-11')), PARTITION p0255 VALUES LESS THAN (TO_DAYS('2008-07-15')), PARTITION p0260 VALUES LESS THAN (TO_DAYS('2008-07-19')), PARTITION p0265 VALUES LESS THAN (TO_DAYS('2008-07-23')), PARTITION p0270 VALUES LESS THAN (TO_DAYS('2008-07-27')), PARTITION p0275 VALUES LESS THAN (TO_DAYS('2008-07-31')), PARTITION p0280 VALUES LESS THAN (TO_DAYS('2008-08-04')), PARTITION p0285 VALUES LESS THAN (TO_DAYS('2008-08-08')), PARTITION p0290 VALUES LESS THAN (TO_DAYS('2008-08-12')), PARTITION p0295 VALUES LESS THAN (TO_DAYS('2008-08-16')), PARTITION p0300 VALUES LESS THAN (TO_DAYS('2008-08-20')), PARTITION p0305 VALUES LESS THAN (TO_DAYS('2008-08-24')), PARTITION p0310 VALUES LESS THAN (TO_DAYS('2008-08-28')), PARTITION p0315 VALUES LESS THAN (TO_DAYS('2008-09-01')), PARTITION p0320 VALUES LESS THAN (TO_DAYS('2008-09-05')), PARTITION p0325 VALUES LESS THAN (TO_DAYS('2008-09-09')), PARTITION p0330 VALUES LESS THAN (TO_DAYS('2008-09-13')), PARTITION p0335 VALUES LESS THAN (TO_DAYS('2008-09-17')), PARTITION p0340 VALUES LESS THAN (TO_DAYS('2008-09-21')), PARTITION p0345 VALUES LESS THAN (TO_DAYS('2008-09-25')), PARTITION p0350 VALUES LESS THAN (TO_DAYS('2008-09-29')), PARTITION p0355 VALUES LESS THAN (TO_DAYS('2008-10-03')), PARTITION p0360 VALUES LESS THAN (TO_DAYS('2008-10-07')), PARTITION p0365 VALUES LESS THAN (TO_DAYS('2008-10-11')), PARTITION p0370 VALUES LESS THAN (TO_DAYS('2008-10-15')), PARTITION p0375 VALUES LESS THAN (TO_DAYS('2008-10-19')), PARTITION p0380 VALUES LESS THAN (TO_DAYS('2008-10-23')), PARTITION p0385 VALUES LESS THAN (TO_DAYS('2008-10-27')), PARTITION p0390 VALUES LESS THAN (TO_DAYS('2008-10-31')), PARTITION p0395 VALUES LESS THAN (TO_DAYS('2008-11-04')), PARTITION p0400 VALUES LESS THAN (TO_DAYS('2008-11-08')), PARTITION p0405 VALUES LESS THAN (TO_DAYS('2008-11-12')), PARTITION p0410 VALUES LESS THAN (TO_DAYS('2008-11-16')), PARTITION p0415 VALUES LESS THAN (TO_DAYS('2008-11-20')), PARTITION p0420 VALUES LESS THAN (TO_DAYS('2008-11-24')), PARTITION p0425 VALUES LESS THAN (TO_DAYS('2008-11-28')), PARTITION p0430 VALUES LESS THAN (TO_DAYS('2008-12-02')), PARTITION p0435 VALUES LESS THAN (TO_DAYS('2008-12-06')), PARTITION p0440 VALUES LESS THAN (TO_DAYS('2008-12-10')), PARTITION p0445 VALUES LESS THAN (TO_DAYS('2008-12-14')), PARTITION p0450 VALUES LESS THAN (TO_DAYS('2008-12-18')), PARTITION p0455 VALUES LESS THAN (TO_DAYS('2008-12-22')), PARTITION p0460 VALUES LESS THAN (TO_DAYS('2008-12-26')), PARTITION p0465 VALUES LESS THAN (TO_DAYS('2008-12-30')), PARTITION p0470 VALUES LESS THAN (TO_DAYS('2009-01-03')), PARTITION p0475 VALUES LESS THAN (TO_DAYS('2009-01-07')), PARTITION p0480 VALUES LESS THAN (TO_DAYS('2009-01-11')), PARTITION p0485 VALUES LESS THAN (TO_DAYS('2009-01-15')), PARTITION p0490 VALUES LESS THAN (TO_DAYS('2009-01-19')), PARTITION p0495 VALUES LESS THAN (TO_DAYS('2009-01-23')), PARTITION p0500 VALUES LESS THAN (TO_DAYS('2009-01-27')), PARTITION p0505 VALUES LESS THAN (TO_DAYS('2009-01-31')), PARTITION p0510 VALUES LESS THAN (TO_DAYS('2009-02-04')), PARTITION p0515 VALUES LESS THAN (TO_DAYS('2009-02-08')), PARTITION p0520 VALUES LESS THAN (TO_DAYS('2009-02-12')), PARTITION p0525 VALUES LESS THAN (TO_DAYS('2009-02-16')), PARTITION p0530 VALUES LESS THAN (TO_DAYS('2009-02-20')), PARTITION p0535 VALUES LESS THAN (TO_DAYS('2009-02-24')), PARTITION p0540 VALUES LESS THAN (TO_DAYS('2009-02-28')), PARTITION p0545 VALUES LESS THAN (TO_DAYS('2009-03-04')), PARTITION p0550 VALUES LESS THAN (TO_DAYS('2009-03-08')), PARTITION p0555 VALUES LESS THAN (TO_DAYS('2009-03-12')), PARTITION p0560 VALUES LESS THAN (TO_DAYS('2009-03-16')), PARTITION p0565 VALUES LESS THAN (TO_DAYS('2009-03-20')), PARTITION p0570 VALUES LESS THAN (TO_DAYS('2009-03-24')), PARTITION p0575 VALUES LESS THAN (TO_DAYS('2009-03-28')), PARTITION p0580 VALUES LESS THAN (TO_DAYS('2009-04-01')), PARTITION p0585 VALUES LESS THAN (TO_DAYS('2009-04-05')), PARTITION p0590 VALUES LESS THAN (TO_DAYS('2009-04-09')), PARTITION p0595 VALUES LESS THAN (TO_DAYS('2009-04-13')), PARTITION p0600 VALUES LESS THAN (TO_DAYS('2009-04-17')), PARTITION p0605 VALUES LESS THAN (TO_DAYS('2009-04-21')), PARTITION p0610 VALUES LESS THAN (TO_DAYS('2009-04-25')), PARTITION p0615 VALUES LESS THAN (TO_DAYS('2009-04-29')), PARTITION p0620 VALUES LESS THAN (TO_DAYS('2009-05-03')), PARTITION p0625 VALUES LESS THAN (TO_DAYS('2009-05-07')), PARTITION p0630 VALUES LESS THAN (TO_DAYS('2009-05-11')), PARTITION p0635 VALUES LESS THAN (TO_DAYS('2009-05-15')), PARTITION p0640 VALUES LESS THAN (TO_DAYS('2009-05-19')), PARTITION p0645 VALUES LESS THAN (TO_DAYS('2009-05-23')), PARTITION p0650 VALUES LESS THAN (TO_DAYS('2009-05-27')), PARTITION p0655 VALUES LESS THAN (TO_DAYS('2009-05-31')), PARTITION p0660 VALUES LESS THAN (TO_DAYS('2009-06-04')), PARTITION p0665 VALUES LESS THAN (TO_DAYS('2009-06-08')), PARTITION p0670 VALUES LESS THAN (TO_DAYS('2009-06-12')), PARTITION p0675 VALUES LESS THAN (TO_DAYS('2009-06-16')), PARTITION p0680 VALUES LESS THAN (TO_DAYS('2009-06-20')), PARTITION p0685 VALUES LESS THAN (TO_DAYS('2009-06-24')), PARTITION p0690 VALUES LESS THAN (TO_DAYS('2009-06-28')), PARTITION p0695 VALUES LESS THAN (TO_DAYS('2009-07-02')), PARTITION p0700 VALUES LESS THAN (TO_DAYS('2009-07-06')), PARTITION p0705 VALUES LESS THAN (TO_DAYS('2009-07-10')), PARTITION p0710 VALUES LESS THAN (TO_DAYS('2009-07-14')), PARTITION p0715 VALUES LESS THAN (TO_DAYS('2009-07-18')), PARTITION p0720 VALUES LESS THAN (TO_DAYS('2009-07-22')), PARTITION p0725 VALUES LESS THAN (TO_DAYS('2009-07-26')), PARTITION p0730 VALUES LESS THAN (TO_DAYS('2009-07-30')), PARTITION p0735 VALUES LESS THAN (TO_DAYS('2009-08-03')), PARTITION p0740 VALUES LESS THAN (TO_DAYS('2009-08-07')), PARTITION p0745 VALUES LESS THAN (TO_DAYS('2009-08-11')), PARTITION p0750 VALUES LESS THAN (TO_DAYS('2009-08-15')), PARTITION p0755 VALUES LESS THAN (TO_DAYS('2009-08-19')), PARTITION p0760 VALUES LESS THAN (TO_DAYS('2009-08-23')), PARTITION p0765 VALUES LESS THAN (TO_DAYS('2009-08-27')), PARTITION p0770 VALUES LESS THAN (TO_DAYS('2009-08-31')), PARTITION p0775 VALUES LESS THAN (TO_DAYS('2009-09-04')), PARTITION p0780 VALUES LESS THAN (TO_DAYS('2009-09-08')), PARTITION p0785 VALUES LESS THAN (TO_DAYS('2009-09-12')), PARTITION p0790 VALUES LESS THAN (TO_DAYS('2009-09-16')), PARTITION p0795 VALUES LESS THAN (TO_DAYS('2009-09-20')), PARTITION p0800 VALUES LESS THAN (TO_DAYS('2009-09-24')), PARTITION p0805 VALUES LESS THAN (TO_DAYS('2009-09-28')), PARTITION p0810 VALUES LESS THAN (TO_DAYS('2009-10-02')), PARTITION p0815 VALUES LESS THAN (TO_DAYS('2009-10-06')), PARTITION p0820 VALUES LESS THAN (TO_DAYS('2009-10-10')), PARTITION p0825 VALUES LESS THAN (TO_DAYS('2009-10-14')), PARTITION p0830 VALUES LESS THAN (TO_DAYS('2009-10-18')), PARTITION p0835 VALUES LESS THAN (TO_DAYS('2009-10-22')), PARTITION p0840 VALUES LESS THAN (TO_DAYS('2009-10-26')), PARTITION p0845 VALUES LESS THAN (TO_DAYS('2009-10-30')), PARTITION p0850 VALUES LESS THAN (TO_DAYS('2009-11-03')), PARTITION p0855 VALUES LESS THAN (TO_DAYS('2009-11-07')), PARTITION p0860 VALUES LESS THAN (TO_DAYS('2009-11-11')), PARTITION p0865 VALUES LESS THAN (TO_DAYS('2009-11-15')), PARTITION p0870 VALUES LESS THAN (TO_DAYS('2009-11-19')), PARTITION p0875 VALUES LESS THAN (TO_DAYS('2009-11-23')), PARTITION p0880 VALUES LESS THAN (TO_DAYS('2009-11-27')), PARTITION p0885 VALUES LESS THAN (TO_DAYS('2009-12-01')), PARTITION p0890 VALUES LESS THAN (TO_DAYS('2009-12-05')), PARTITION p0895 VALUES LESS THAN (TO_DAYS('2009-12-09')), PARTITION p0900 VALUES LESS THAN (TO_DAYS('2009-12-13')), PARTITION p0905 VALUES LESS THAN (TO_DAYS('2009-12-17')), PARTITION p0910 VALUES LESS THAN (TO_DAYS('2009-12-21')), PARTITION p0915 VALUES LESS THAN (TO_DAYS('2009-12-25')), PARTITION p0920 VALUES LESS THAN (TO_DAYS('2009-12-29')), PARTITION p0925 VALUES LESS THAN (TO_DAYS('2010-01-02')), PARTITION p0930 VALUES LESS THAN (TO_DAYS('2010-01-06')), PARTITION p0935 VALUES LESS THAN (TO_DAYS('2010-01-10')), PARTITION p0940 VALUES LESS THAN (TO_DAYS('2010-01-14')), PARTITION p0945 VALUES LESS THAN (TO_DAYS('2010-01-18')), PARTITION p0950 VALUES LESS THAN (TO_DAYS('2010-01-22')), PARTITION p0955 VALUES LESS THAN (TO_DAYS('2010-01-26')), PARTITION p0960 VALUES LESS THAN (TO_DAYS('2010-01-30')), PARTITION p0965 VALUES LESS THAN (TO_DAYS('2010-02-03')), PARTITION p0970 VALUES LESS THAN (TO_DAYS('2010-02-07')), PARTITION p0975 VALUES LESS THAN (TO_DAYS('2010-02-11')), PARTITION p0980 VALUES LESS THAN (TO_DAYS('2010-02-15')), PARTITION p0985 VALUES LESS THAN (TO_DAYS('2010-02-19')), PARTITION p0990 VALUES LESS THAN (TO_DAYS('2010-02-23')), PARTITION p0995 VALUES LESS THAN (TO_DAYS('2010-02-27')), PARTITION p1000 VALUES LESS THAN (TO_DAYS('2010-03-03')), PARTITION p1005 VALUES LESS THAN (TO_DAYS('2010-03-07')), PARTITION p1010 VALUES LESS THAN (TO_DAYS('2010-03-11')), PARTITION p1015 VALUES LESS THAN (TO_DAYS('2010-03-15')), PARTITION p1020 VALUES LESS THAN (TO_DAYS('2010-03-19')), PARTITION p1025 VALUES LESS THAN (TO_DAYS('2010-03-23')), PARTITION p1030 VALUES LESS THAN (TO_DAYS('2010-03-27')), PARTITION p1035 VALUES LESS THAN (TO_DAYS('2010-03-31')), PARTITION p1040 VALUES LESS THAN (TO_DAYS('2010-04-04')), PARTITION p1045 VALUES LESS THAN (TO_DAYS('2010-04-08')), PARTITION p1050 VALUES LESS THAN (TO_DAYS('2010-04-12')), PARTITION p1055 VALUES LESS THAN (TO_DAYS('2010-04-16')), PARTITION p1060 VALUES LESS THAN (TO_DAYS('2010-04-20')), PARTITION p1065 VALUES LESS THAN (TO_DAYS('2010-04-24')), PARTITION p1070 VALUES LESS THAN (TO_DAYS('2010-04-28')), PARTITION p1075 VALUES LESS THAN (TO_DAYS('2010-05-02')), PARTITION p1080 VALUES LESS THAN (TO_DAYS('2010-05-06')), PARTITION p1085 VALUES LESS THAN (TO_DAYS('2010-05-10')), PARTITION p1090 VALUES LESS THAN (TO_DAYS('2010-05-14')), PARTITION p1095 VALUES LESS THAN (TO_DAYS('2010-05-18')), PARTITION p1100 VALUES LESS THAN (TO_DAYS('2010-05-22')), PARTITION p1105 VALUES LESS THAN (TO_DAYS('2010-05-26')), PARTITION p1110 VALUES LESS THAN (TO_DAYS('2010-05-30')), PARTITION p1115 VALUES LESS THAN (TO_DAYS('2010-06-03')), PARTITION p1120 VALUES LESS THAN (TO_DAYS('2010-06-07')), PARTITION p1125 VALUES LESS THAN (TO_DAYS('2010-06-11')), PARTITION p1130 VALUES LESS THAN (TO_DAYS('2010-06-15')), PARTITION p1135 VALUES LESS THAN (TO_DAYS('2010-06-19')), PARTITION p1140 VALUES LESS THAN (TO_DAYS('2010-06-23')), PARTITION p1145 VALUES LESS THAN (TO_DAYS('2010-06-27')), PARTITION p1150 VALUES LESS THAN (TO_DAYS('2010-07-01')), PARTITION p1155 VALUES LESS THAN (TO_DAYS('2010-07-05')), PARTITION p1160 VALUES LESS THAN (TO_DAYS('2010-07-09')), PARTITION p1165 VALUES LESS THAN (TO_DAYS('2010-07-13')), PARTITION p1170 VALUES LESS THAN (TO_DAYS('2010-07-17')), PARTITION p1175 VALUES LESS THAN (TO_DAYS('2010-07-21')), PARTITION p1180 VALUES LESS THAN (TO_DAYS('2010-07-25')), PARTITION p1185 VALUES LESS THAN (TO_DAYS('2010-07-29')), PARTITION p1190 VALUES LESS THAN (TO_DAYS('2010-08-02')), PARTITION p1195 VALUES LESS THAN (TO_DAYS('2010-08-06')), PARTITION p1200 VALUES LESS THAN (TO_DAYS('2010-08-10')), PARTITION p1205 VALUES LESS THAN (TO_DAYS('2010-08-14')), PARTITION p1210 VALUES LESS THAN (TO_DAYS('2010-08-18')), PARTITION p1215 VALUES LESS THAN (TO_DAYS('2010-08-22')), PARTITION p1220 VALUES LESS THAN (TO_DAYS('2010-08-26')), PARTITION p1225 VALUES LESS THAN (TO_DAYS('2010-08-30')), PARTITION p1230 VALUES LESS THAN (TO_DAYS('2010-09-03')), PARTITION p1235 VALUES LESS THAN (TO_DAYS('2010-09-07')), PARTITION p1240 VALUES LESS THAN (TO_DAYS('2010-09-11')), PARTITION p1245 VALUES LESS THAN (TO_DAYS('2010-09-15')), PARTITION p1250 VALUES LESS THAN (TO_DAYS('2010-09-19')), PARTITION p1255 VALUES LESS THAN (TO_DAYS('2010-09-23')), PARTITION p1260 VALUES LESS THAN (TO_DAYS('2010-09-27')), PARTITION p1265 VALUES LESS THAN (TO_DAYS('2010-10-01')), PARTITION p1270 VALUES LESS THAN (TO_DAYS('2010-10-05')), PARTITION p1275 VALUES LESS THAN (TO_DAYS('2010-10-09')), PARTITION p1280 VALUES LESS THAN (TO_DAYS('2010-10-13')), PARTITION p1285 VALUES LESS THAN (TO_DAYS('2010-10-17')), PARTITION p1290 VALUES LESS THAN (TO_DAYS('2010-10-21')), PARTITION p1295 VALUES LESS THAN (TO_DAYS('2010-10-25')), PARTITION p1300 VALUES LESS THAN (TO_DAYS('2010-10-29')), PARTITION p1305 VALUES LESS THAN (TO_DAYS('2010-11-02')), PARTITION p1310 VALUES LESS THAN (TO_DAYS('2010-11-06')), PARTITION p1315 VALUES LESS THAN (TO_DAYS('2010-11-10')), PARTITION p1320 VALUES LESS THAN (TO_DAYS('2010-11-14')), PARTITION p1325 VALUES LESS THAN (TO_DAYS('2010-11-18')), PARTITION p1330 VALUES LESS THAN (TO_DAYS('2010-11-22')), PARTITION p1335 VALUES LESS THAN (TO_DAYS('2010-11-26')), PARTITION p1340 VALUES LESS THAN (TO_DAYS('2010-11-30')), PARTITION p1345 VALUES LESS THAN (TO_DAYS('2010-12-04')), PARTITION p1350 VALUES LESS THAN (TO_DAYS('2010-12-08')), PARTITION p1355 VALUES LESS THAN (TO_DAYS('2010-12-12')), PARTITION p1360 VALUES LESS THAN (TO_DAYS('2010-12-16')), PARTITION p1365 VALUES LESS THAN (TO_DAYS('2010-12-20')), PARTITION p1370 VALUES LESS THAN (TO_DAYS('2010-12-24')), PARTITION p1375 VALUES LESS THAN (TO_DAYS('2010-12-28')), PARTITION p1380 VALUES LESS THAN (TO_DAYS('2011-01-01')), PARTITION p1385 VALUES LESS THAN (TO_DAYS('2011-01-05')), PARTITION p1390 VALUES LESS THAN (TO_DAYS('2011-01-09')), PARTITION p1395 VALUES LESS THAN (TO_DAYS('2011-01-13')), PARTITION p1400 VALUES LESS THAN (TO_DAYS('2011-01-17')), PARTITION p1405 VALUES LESS THAN (TO_DAYS('2011-01-21')), PARTITION p1410 VALUES LESS THAN (TO_DAYS('2011-01-25')), PARTITION p1415 VALUES LESS THAN (TO_DAYS('2011-01-29')), PARTITION p1420 VALUES LESS THAN (TO_DAYS('2011-02-02')), PARTITION p1425 VALUES LESS THAN (TO_DAYS('2011-02-06')), PARTITION p1430 VALUES LESS THAN (TO_DAYS('2011-02-10')), PARTITION p1435 VALUES LESS THAN (TO_DAYS('2011-02-14')), PARTITION p1440 VALUES LESS THAN (TO_DAYS('2011-02-18')), PARTITION p1445 VALUES LESS THAN (TO_DAYS('2011-02-22')), PARTITION p1450 VALUES LESS THAN (TO_DAYS('2011-02-26')), PARTITION p1455 VALUES LESS THAN (TO_DAYS('2011-03-02')), PARTITION p1460 VALUES LESS THAN (TO_DAYS('2011-03-06')), PARTITION p1465 VALUES LESS THAN (TO_DAYS('2011-03-10')), PARTITION p1470 VALUES LESS THAN (TO_DAYS('2011-03-14')), PARTITION p1475 VALUES LESS THAN (TO_DAYS('2011-03-18')), PARTITION p1480 VALUES LESS THAN (TO_DAYS('2011-03-22')), PARTITION p1485 VALUES LESS THAN (TO_DAYS('2011-03-26')), PARTITION p1490 VALUES LESS THAN (TO_DAYS('2011-03-30')), PARTITION p1495 VALUES LESS THAN (TO_DAYS('2011-04-03')), PARTITION p1500 VALUES LESS THAN (TO_DAYS('2011-04-07')), PARTITION p1505 VALUES LESS THAN (TO_DAYS('2011-04-11')), PARTITION p1510 VALUES LESS THAN (TO_DAYS('2011-04-15')), PARTITION p1515 VALUES LESS THAN (TO_DAYS('2011-04-19')), PARTITION p1520 VALUES LESS THAN (TO_DAYS('2011-04-23')), PARTITION p1525 VALUES LESS THAN (TO_DAYS('2011-04-27')), PARTITION p1530 VALUES LESS THAN (TO_DAYS('2011-05-01')), PARTITION p1535 VALUES LESS THAN (TO_DAYS('2011-05-05')), PARTITION p1540 VALUES LESS THAN (TO_DAYS('2011-05-09')), PARTITION p1545 VALUES LESS THAN (TO_DAYS('2011-05-13')), PARTITION p1550 VALUES LESS THAN (TO_DAYS('2011-05-17')), PARTITION p1555 VALUES LESS THAN (TO_DAYS('2011-05-21')), PARTITION p1560 VALUES LESS THAN (TO_DAYS('2011-05-25')), PARTITION p1565 VALUES LESS THAN (TO_DAYS('2011-05-29')), PARTITION p1570 VALUES LESS THAN (TO_DAYS('2011-06-02')), PARTITION p1575 VALUES LESS THAN (TO_DAYS('2011-06-06')), PARTITION p1580 VALUES LESS THAN (TO_DAYS('2011-06-10')), PARTITION p1585 VALUES LESS THAN (TO_DAYS('2011-06-14')), PARTITION p1590 VALUES LESS THAN (TO_DAYS('2011-06-18')), PARTITION p1595 VALUES LESS THAN (TO_DAYS('2011-06-22')), PARTITION p1600 VALUES LESS THAN (TO_DAYS('2011-06-26')), PARTITION p1605 VALUES LESS THAN (TO_DAYS('2011-06-30')), PARTITION p1610 VALUES LESS THAN (TO_DAYS('2011-07-04')), PARTITION p1615 VALUES LESS THAN (TO_DAYS('2011-07-08')), PARTITION p1620 VALUES LESS THAN (TO_DAYS('2011-07-12')), PARTITION p1625 VALUES LESS THAN (TO_DAYS('2011-07-16')), PARTITION p1630 VALUES LESS THAN (TO_DAYS('2011-07-20')), PARTITION p1635 VALUES LESS THAN (TO_DAYS('2011-07-24')), PARTITION p1640 VALUES LESS THAN (TO_DAYS('2011-07-28')), PARTITION p1645 VALUES LESS THAN (TO_DAYS('2011-08-01')), PARTITION p1650 VALUES LESS THAN (TO_DAYS('2011-08-05')), PARTITION p1655 VALUES LESS THAN (TO_DAYS('2011-08-09')), PARTITION p1660 VALUES LESS THAN (TO_DAYS('2011-08-13')), PARTITION p1665 VALUES LESS THAN (TO_DAYS('2011-08-17')), PARTITION p1670 VALUES LESS THAN (TO_DAYS('2011-08-21')), PARTITION p1675 VALUES LESS THAN (TO_DAYS('2011-08-25')), PARTITION p1680 VALUES LESS THAN (TO_DAYS('2011-08-29')), PARTITION p1685 VALUES LESS THAN (TO_DAYS('2011-09-02')), PARTITION p1690 VALUES LESS THAN (TO_DAYS('2011-09-06')), PARTITION p1695 VALUES LESS THAN (TO_DAYS('2011-09-10')), PARTITION p1700 VALUES LESS THAN (TO_DAYS('2011-09-14')), PARTITION p1705 VALUES LESS THAN (TO_DAYS('2011-09-18')), PARTITION p1710 VALUES LESS THAN (TO_DAYS('2011-09-22')), PARTITION p1715 VALUES LESS THAN (TO_DAYS('2011-09-26')), PARTITION p1720 VALUES LESS THAN (TO_DAYS('2011-09-30')), PARTITION p1725 VALUES LESS THAN (TO_DAYS('2011-10-04')), PARTITION p1730 VALUES LESS THAN (TO_DAYS('2011-10-08')), PARTITION p1735 VALUES LESS THAN (TO_DAYS('2011-10-12')), PARTITION p1740 VALUES LESS THAN (TO_DAYS('2011-10-16')), PARTITION p1745 VALUES LESS THAN (TO_DAYS('2011-10-20')), PARTITION p1750 VALUES LESS THAN (TO_DAYS('2011-10-24')), PARTITION p1755 VALUES LESS THAN (TO_DAYS('2011-10-28')), PARTITION p1760 VALUES LESS THAN (TO_DAYS('2011-11-01')), PARTITION p1765 VALUES LESS THAN (TO_DAYS('2011-11-05')), PARTITION p1770 VALUES LESS THAN (TO_DAYS('2011-11-09')), PARTITION p1775 VALUES LESS THAN (TO_DAYS('2011-11-13')), PARTITION p1780 VALUES LESS THAN (TO_DAYS('2011-11-17')), PARTITION p1785 VALUES LESS THAN (TO_DAYS('2011-11-21')), PARTITION p1790 VALUES LESS THAN (TO_DAYS('2011-11-25')), PARTITION p1795 VALUES LESS THAN (TO_DAYS('2011-11-29')), PARTITION p1800 VALUES LESS THAN (TO_DAYS('2011-12-03')), PARTITION p1805 VALUES LESS THAN (TO_DAYS('2011-12-07')), PARTITION p1810 VALUES LESS THAN (TO_DAYS('2011-12-11')), PARTITION p1815 VALUES LESS THAN (TO_DAYS('2011-12-15')), PARTITION p1820 VALUES LESS THAN (TO_DAYS('2011-12-19')), PARTITION p1825 VALUES LESS THAN (TO_DAYS('2011-12-23')), PARTITION p1830 VALUES LESS THAN (TO_DAYS('2011-12-27')), PARTITION p1835 VALUES LESS THAN (TO_DAYS('2011-12-31')), PARTITION p1840 VALUES LESS THAN (TO_DAYS('2012-01-04')), PARTITION p1845 VALUES LESS THAN (TO_DAYS('2012-01-08')), PARTITION p1850 VALUES LESS THAN (TO_DAYS('2012-01-12')), PARTITION p1855 VALUES LESS THAN (TO_DAYS('2012-01-16')), PARTITION p1860 VALUES LESS THAN (TO_DAYS('2012-01-20')), PARTITION p1865 VALUES LESS THAN (TO_DAYS('2012-01-24')), PARTITION p1870 VALUES LESS THAN (TO_DAYS('2012-01-28')), PARTITION p1875 VALUES LESS THAN (TO_DAYS('2012-02-01')), PARTITION p1880 VALUES LESS THAN (TO_DAYS('2012-02-05')), PARTITION p1885 VALUES LESS THAN (TO_DAYS('2012-02-09')), PARTITION p1890 VALUES LESS THAN (TO_DAYS('2012-02-13')), PARTITION p1895 VALUES LESS THAN (TO_DAYS('2012-02-17')), PARTITION p1900 VALUES LESS THAN (TO_DAYS('2012-02-21')), PARTITION p1905 VALUES LESS THAN (TO_DAYS('2012-02-25')), PARTITION p1910 VALUES LESS THAN (TO_DAYS('2012-02-29')), PARTITION p1915 VALUES LESS THAN (TO_DAYS('2012-03-04')), PARTITION p1920 VALUES LESS THAN (TO_DAYS('2012-03-08')), PARTITION p1925 VALUES LESS THAN (TO_DAYS('2012-03-12')), PARTITION p1930 VALUES LESS THAN (TO_DAYS('2012-03-16')), PARTITION p1935 VALUES LESS THAN (TO_DAYS('2012-03-20')), PARTITION p1940 VALUES LESS THAN (TO_DAYS('2012-03-24')), PARTITION p1945 VALUES LESS THAN (TO_DAYS('2012-03-28')), PARTITION p1950 VALUES LESS THAN (TO_DAYS('2012-04-01')), PARTITION p1955 VALUES LESS THAN (TO_DAYS('2012-04-05')), PARTITION p1960 VALUES LESS THAN (TO_DAYS('2012-04-09')), PARTITION p1965 VALUES LESS THAN (TO_DAYS('2012-04-13')), PARTITION p1970 VALUES LESS THAN (TO_DAYS('2012-04-17')), PARTITION p1975 VALUES LESS THAN (TO_DAYS('2012-04-21')), PARTITION p1980 VALUES LESS THAN (TO_DAYS('2012-04-25')), PARTITION p1985 VALUES LESS THAN (TO_DAYS('2012-04-29')), PARTITION p1990 VALUES LESS THAN (TO_DAYS('2012-05-03')), PARTITION p1995 VALUES LESS THAN (TO_DAYS('2012-05-07')), PARTITION p2000 VALUES LESS THAN (TO_DAYS('2012-05-11')), PARTITION p2005 VALUES LESS THAN (TO_DAYS('2012-05-15')), PARTITION p2010 VALUES LESS THAN (TO_DAYS('2012-05-19')), PARTITION p2015 VALUES LESS THAN (TO_DAYS('2012-05-23')), PARTITION p2020 VALUES LESS THAN (TO_DAYS('2012-05-27')), PARTITION p2025 VALUES LESS THAN (TO_DAYS('2012-05-31')), PARTITION p2030 VALUES LESS THAN (TO_DAYS('2012-06-04')), PARTITION p2035 VALUES LESS THAN (TO_DAYS('2012-06-08')), PARTITION p2040 VALUES LESS THAN (TO_DAYS('2012-06-12')), PARTITION p2045 VALUES LESS THAN (TO_DAYS('2012-06-16')), PARTITION p2050 VALUES LESS THAN (TO_DAYS('2012-06-20')), PARTITION p2055 VALUES LESS THAN (TO_DAYS('2012-06-24')), PARTITION p2060 VALUES LESS THAN (TO_DAYS('2012-06-28')), PARTITION p2065 VALUES LESS THAN (TO_DAYS('2012-07-02')), PARTITION p2070 VALUES LESS THAN (TO_DAYS('2012-07-06')), PARTITION p2075 VALUES LESS THAN (TO_DAYS('2012-07-10')), PARTITION p2080 VALUES LESS THAN (TO_DAYS('2012-07-14')), PARTITION p2085 VALUES LESS THAN (TO_DAYS('2012-07-18')), PARTITION p2090 VALUES LESS THAN (TO_DAYS('2012-07-22')), PARTITION p2095 VALUES LESS THAN (TO_DAYS('2012-07-26')), PARTITION p2100 VALUES LESS THAN (TO_DAYS('2012-07-30')), PARTITION p2105 VALUES LESS THAN (TO_DAYS('2012-08-03')), PARTITION p2110 VALUES LESS THAN (TO_DAYS('2012-08-07')), PARTITION p2115 VALUES LESS THAN (TO_DAYS('2012-08-11')), PARTITION p2120 VALUES LESS THAN (TO_DAYS('2012-08-15')), PARTITION p2125 VALUES LESS THAN (TO_DAYS('2012-08-19')), PARTITION p2130 VALUES LESS THAN (TO_DAYS('2012-08-23')), PARTITION p2135 VALUES LESS THAN (TO_DAYS('2012-08-27')), PARTITION p2140 VALUES LESS THAN (TO_DAYS('2012-08-31')), PARTITION p2145 VALUES LESS THAN (TO_DAYS('2012-09-04')), PARTITION p2150 VALUES LESS THAN (TO_DAYS('2012-09-08')), PARTITION p2155 VALUES LESS THAN (TO_DAYS('2012-09-12')), PARTITION p2160 VALUES LESS THAN (TO_DAYS('2012-09-16')), PARTITION p2165 VALUES LESS THAN (TO_DAYS('2012-09-20')), PARTITION p2170 VALUES LESS THAN (TO_DAYS('2012-09-24')), PARTITION p2175 VALUES LESS THAN (TO_DAYS('2012-09-28')), PARTITION p2180 VALUES LESS THAN (TO_DAYS('2012-10-02')), PARTITION p2185 VALUES LESS THAN (TO_DAYS('2012-10-06')), PARTITION p2190 VALUES LESS THAN (TO_DAYS('2012-10-10')), PARTITION p2195 VALUES LESS THAN (TO_DAYS('2012-10-14')), PARTITION p2200 VALUES LESS THAN (TO_DAYS('2012-10-18')), PARTITION p2205 VALUES LESS THAN (TO_DAYS('2012-10-22')), PARTITION p2210 VALUES LESS THAN (TO_DAYS('2012-10-26')), PARTITION p2215 VALUES LESS THAN (TO_DAYS('2012-10-30')), PARTITION p2220 VALUES LESS THAN (TO_DAYS('2012-11-03')), PARTITION p2225 VALUES LESS THAN (TO_DAYS('2012-11-07')), PARTITION p2230 VALUES LESS THAN (TO_DAYS('2012-11-11')), PARTITION p2235 VALUES LESS THAN (TO_DAYS('2012-11-15')), PARTITION p2240 VALUES LESS THAN (TO_DAYS('2012-11-19')), PARTITION p2245 VALUES LESS THAN (TO_DAYS('2012-11-23')), PARTITION p2250 VALUES LESS THAN (TO_DAYS('2012-11-27')), PARTITION p2255 VALUES LESS THAN (TO_DAYS('2012-12-01')), PARTITION p2260 VALUES LESS THAN (TO_DAYS('2012-12-05')), PARTITION p2265 VALUES LESS THAN (TO_DAYS('2012-12-09')), PARTITION p2270 VALUES LESS THAN (TO_DAYS('2012-12-13')), PARTITION p2275 VALUES LESS THAN (TO_DAYS('2012-12-17')), PARTITION p2280 VALUES LESS THAN (TO_DAYS('2012-12-21')), PARTITION p2285 VALUES LESS THAN (TO_DAYS('2012-12-25')), PARTITION p2290 VALUES LESS THAN (TO_DAYS('2012-12-29')), PARTITION p3000 VALUES LESS THAN MAXVALUE);