create-table

gistfile1.sql

CREATE TABLE `obanyc_cclocationreport` (
  `id` bigint(20) NOT NULL DEFAULT '0',
  `archive_time_received` datetime NOT NULL,
  `data_quality_qualitative_indicator` tinyint(4) DEFAULT NULL,
  `dest_sign_code` int(11) NOT NULL,
  `direction_deg` decimal(5,2) NOT NULL,
  `emergency_code` varchar(1) DEFAULT NULL,
  `latitude` decimal(9,6) NOT NULL,
  `longitude` decimal(9,6) NOT NULL,
  `manufacturer_data` varchar(64) NOT NULL,
  `nmea_sentence_gpgga` varchar(160) DEFAULT NULL,
  `nmea_sentence_gprmc` varchar(160) DEFAULT NULL,
  `operator_id_designator` varchar(16) NOT NULL,
  `raw_message` longtext NOT NULL,
  `request_id` int(11) NOT NULL,
  `route_id_designator` varchar(16) NOT NULL,
  `run_id_designator` varchar(32) NOT NULL,
  `speed` decimal(4,1) NOT NULL,
  `time_received` datetime NOT NULL,
  `time_reported` datetime NOT NULL,
  `UUID` varchar(36) NOT NULL,
  `vehicle_agency_designator` varchar(64) NOT NULL,
  `vehicle_agency_id` int(11) NOT NULL,
  `vehicle_id` int(11) NOT NULL,
  `time_received_index` datetime DEFAULT NULL,
  PRIMARY KEY (`time_received`,`vehicle_id`,`id`),
  KEY `id` (`id`),
  KEY `time_received_index` (`time_received_index`,`dest_sign_code`),
  KEY `vehicle_id` (`vehicle_id`,`time_reported`),
  KEY `vehicle_id_2` (`vehicle_id`,`time_received`),
  KEY `manufacturer_data` (`manufacturer_data`),
  KEY `UUID` (`UUID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY RANGE (
        TO_DAYS(time_received))
(PARTITION P20120507 VALUES LESS THAN (734996) ENGINE = InnoDB,
 PARTITION P20120508 VALUES LESS THAN (734997) ENGINE = InnoDB,
 PARTITION P20120509 VALUES LESS THAN (734998) ENGINE = InnoDB,
 PARTITION P20120510 VALUES LESS THAN (734999) ENGINE = InnoDB,
 PARTITION P20120511 VALUES LESS THAN (735000) ENGINE = InnoDB,
 PARTITION P20120512 VALUES LESS THAN (735001) ENGINE = InnoDB,
 PARTITION P20120513 VALUES LESS THAN (735002) ENGINE = InnoDB,
 PARTITION P20120514 VALUES LESS THAN (735003) ENGINE = InnoDB,
 PARTITION P20120515 VALUES LESS THAN (735004) ENGINE = InnoDB,
 PARTITION P20120516 VALUES LESS THAN (735005) ENGINE = InnoDB,
 PARTITION P20120517 VALUES LESS THAN (735006) ENGINE = InnoDB,
 PARTITION P20120518 VALUES LESS THAN (735007) ENGINE = InnoDB,
 PARTITION P20120519 VALUES LESS THAN (735008) ENGINE = InnoDB,
 PARTITION P20120520 VALUES LESS THAN (735009) ENGINE = InnoDB,
 PARTITION P20120521 VALUES LESS THAN (735010) ENGINE = InnoDB,
 PARTITION P20120522 VALUES LESS THAN (735011) ENGINE = InnoDB,
 PARTITION P20120523 VALUES LESS THAN (735012) ENGINE = InnoDB,
 PARTITION P20120524 VALUES LESS THAN (735013) ENGINE = InnoDB,
 PARTITION P20120525 VALUES LESS THAN (735014) ENGINE = InnoDB,
 PARTITION P20120526 VALUES LESS THAN (735015) ENGINE = InnoDB,
 PARTITION P20120527 VALUES LESS THAN (735016) ENGINE = InnoDB,
 PARTITION P20120528 VALUES LESS THAN (735017) ENGINE = InnoDB,
 PARTITION P20120529 VALUES LESS THAN (735018) ENGINE = InnoDB,
 PARTITION P20120530 VALUES LESS THAN (735019) ENGINE = InnoDB,
 PARTITION P20120531 VALUES LESS THAN (735020) ENGINE = InnoDB,
 PARTITION P20120601 VALUES LESS THAN (735021) ENGINE = InnoDB,
 PARTITION P20120602 VALUES LESS THAN (735022) ENGINE = InnoDB,
 PARTITION P20120603 VALUES LESS THAN (735023) ENGINE = InnoDB,
 PARTITION P20120604 VALUES LESS THAN (735024) ENGINE = InnoDB,
 PARTITION P20120605 VALUES LESS THAN (735025) ENGINE = InnoDB,
 PARTITION P20120606 VALUES LESS THAN (735026) ENGINE = InnoDB,
 PARTITION P20120607 VALUES LESS THAN (735027) ENGINE = InnoDB,
 PARTITION P20120608 VALUES LESS THAN (735028) ENGINE = InnoDB,
 PARTITION P20120609 VALUES LESS THAN (735029) ENGINE = InnoDB,
 PARTITION P20120610 VALUES LESS THAN (735030) ENGINE = InnoDB,
 PARTITION P20120611 VALUES LESS THAN (735031) ENGINE = InnoDB,
 PARTITION P20120612 VALUES LESS THAN (735032) ENGINE = InnoDB,
 PARTITION P20120613 VALUES LESS THAN (735033) ENGINE = InnoDB,
 PARTITION P20120614 VALUES LESS THAN (735034) ENGINE = InnoDB,
 PARTITION P20120615 VALUES LESS THAN (735035) ENGINE = InnoDB,
 PARTITION P20120616 VALUES LESS THAN (735036) ENGINE = InnoDB,
 PARTITION P20120617 VALUES LESS THAN (735037) ENGINE = InnoDB,
 PARTITION P20120618 VALUES LESS THAN (735038) ENGINE = InnoDB,
 PARTITION P20120619 VALUES LESS THAN (735039) ENGINE = InnoDB,
 PARTITION P20120620 VALUES LESS THAN (735040) ENGINE = InnoDB,
 PARTITION P20120621 VALUES LESS THAN (735041) ENGINE = InnoDB,
 PARTITION P20120622 VALUES LESS THAN (735042) ENGINE = InnoDB,
 PARTITION P20120623 VALUES LESS THAN (735043) ENGINE = InnoDB,
 PARTITION P20120624 VALUES LESS THAN (735044) ENGINE = InnoDB,
 PARTITION P20120625 VALUES LESS THAN (735045) ENGINE = InnoDB,
 PARTITION P20120626 VALUES LESS THAN (735046) ENGINE = InnoDB,
 PARTITION P20120627 VALUES LESS THAN (735047) ENGINE = InnoDB,
 PARTITION P20120628 VALUES LESS THAN (735048) ENGINE = InnoDB,
 PARTITION P20120629 VALUES LESS THAN (735049) ENGINE = InnoDB,
 PARTITION P20120630 VALUES LESS THAN (735050) ENGINE = InnoDB,
 PARTITION P20120701 VALUES LESS THAN (735051) ENGINE = InnoDB,
 PARTITION P20120702 VALUES LESS THAN (735052) ENGINE = InnoDB,
 PARTITION P20120703 VALUES LESS THAN (735053) ENGINE = InnoDB,
 PARTITION P20120704 VALUES LESS THAN (735054) ENGINE = InnoDB,
 PARTITION P20120705 VALUES LESS THAN (735055) ENGINE = InnoDB,
 PARTITION P20120706 VALUES LESS THAN (735056) ENGINE = InnoDB,
 PARTITION P20120707 VALUES LESS THAN (735057) ENGINE = InnoDB,
 PARTITION P20120708 VALUES LESS THAN (735058) ENGINE = InnoDB,
 PARTITION P20120709 VALUES LESS THAN (735059) ENGINE = InnoDB,
 PARTITION P20120710 VALUES LESS THAN (735060) ENGINE = InnoDB,
 PARTITION P20120711 VALUES LESS THAN (735061) ENGINE = InnoDB,
 PARTITION P20120712 VALUES LESS THAN (735062) ENGINE = InnoDB,
 PARTITION P20120713 VALUES LESS THAN (735063) ENGINE = InnoDB,
 PARTITION P20120714 VALUES LESS THAN (735064) ENGINE = InnoDB,
 PARTITION P20120715 VALUES LESS THAN (735065) ENGINE = InnoDB,
 PARTITION P20120716 VALUES LESS THAN (735066) ENGINE = InnoDB,
 PARTITION P20120717 VALUES LESS THAN (735067) ENGINE = InnoDB,
 PARTITION PMAX VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */