CREATE TABLE IF NOT EXISTS ALARM
(
  ALARM_START_TIME DATETIME,
  MONITOR_ID VARCHAR(40),
  ALARM_TYPE INTEGER,
  MONITOR_NAME VARCHAR(32),
  SPEED DOUBLE,
  ALARM_END_TIME DATETIME,
  ALARM_START_LOCATION VARCHAR(100),
  ALARM_END_LOCATION VARCHAR(100),
  ALARM_SOURCE INTEGER,
  PUSH_TYPE INTEGER,
  HANDLE_STATUS INTEGER,
  MAX_SPEED DOUBLE,
  SPEED_LIMIT DOUBLE,
  SEVERITY DOUBLE,
  DURATION BIGINT,
  HANDLE_TYPE VARCHAR(20),
  GROUP_NAME VARCHAR(200),
  PROFESSIONALS_NAME VARCHAR(200),
  DESCRIPTION VARCHAR(32),
  FENCE_TYPE VARCHAR(20),
  FENCE_NAME VARCHAR(20),
  MONITOR_TYPE INTEGER,
  SWIFT_NUMBER VARCHAR(20),
  PROTOCOL_TYPE INTEGER,
  CAL_STANDARD INTEGER,
  SPEED_TYPE INTEGER,
  ROAD_NET_SPEED_LIMIT DOUBLE,
  ALT VARCHAR(30),
  RECORDER_SPEED VARCHAR(30),
  PLATE_COLOR VARCHAR(10),
  VEHICLE_TYPE VARCHAR(20),
  DRIVER_NAME VARCHAR(200),
  CERTIFICATION_ID VARCHAR(40),
  PERSON_ID VARCHAR(40),
  PERSON_NAME VARCHAR(32),
  HANDLE_TIME BIGINT,
  ORG_ID VARCHAR(40),
  ORG_NAME VARCHAR(32),
  ROAD_TYPE INTEGER,
  DIR DOUBLE,
  RISKID VARCHAR(40),
  REMARK VARCHAR(32),
  PERSON_ORG_NAME VARCHAR(32),
  SEND_OF_MSG VARCHAR(20),
  DEAL_OF_MSG VARCHAR(20),
  OVERSEE_TIME BIGINT,
  OVERSEE_DEAD_TIME BIGINT,
  OVERSEE_PEOPLE VARCHAR(32),
  RESPONSE_TIME BIGINT,
  OVERSEE_STATUS INTEGER,
  OVERSEE_TYPE INTEGER,
  OVERSEE_LEVEL INTEGER,
  HANDLE_RESULT INTEGER,
  OVERSEE_RESULT INTEGER,
  CONSTRAINT PK PRIMARY KEY (ALARM_START_TIME,MONITOR_ID,ALARM_TYPE)
 )
ENGINE = INNODB
CHARACTER SET = UTF8
COLLATE = UTF8_GENERAL_CI
ROW_FORMAT = DYNAMIC
COMMENT '报警表'
PARTITION BY RANGE COLUMNS(ALARM_START_TIME)
(PARTITION p0 VALUES LESS THAN ('2022-05-08 00:00:00') ENGINE = InnoDB,
 PARTITION p1 VALUES LESS THAN ('2022-05-15 00:00:00') ENGINE = InnoDB,
 PARTITION p2 VALUES LESS THAN ('2022-05-22 00:00:00') ENGINE = InnoDB,
 PARTITION p3 VALUES LESS THAN ('2022-05-28 00:00:00') ENGINE = InnoDB,
 PARTITION p4 VALUES LESS THAN MAXVALUE ENGINE = InnoDB)