-- ----------------------------
-- Table structure for ls_rider_route_record
-- ----------------------------
DROP TABLE IF EXISTS `ls_rider_route_record`;
CREATE TABLE `ls_rider_route_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rider_id` int(11) NOT NULL DEFAULT 0 COMMENT '骑手id',
  `start_lat` decimal(10,6) NOT NULL DEFAULT 0.000000 COMMENT '起点纬度',
  `start_lng` decimal(10,6) NOT NULL DEFAULT 0.000000 COMMENT '起点经度',
  `end_lat` decimal(10,6) NOT NULL DEFAULT 0.000000 COMMENT '终点纬度',
  `end_lng` decimal(10,6) NOT NULL DEFAULT 0.000000 COMMENT '终点经度',
  `start_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '起点地址',
  `end_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '终点地址',
  `distance` decimal(8,2) NOT NULL DEFAULT 0.00 COMMENT '路线距离(公里)',
  `duration` int(11) NOT NULL DEFAULT 0 COMMENT '预计时长(分钟)',
  `strategy` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'fastest' COMMENT '路线策略：fastest最快, shortest最短, avoid_traffic避开拥堵',
  `route_data` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '路线详细数据(JSON格式)',
  `create_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `rider_id`(`rider_id`) USING BTREE,
  INDEX `create_time`(`create_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '骑手路线规划记录表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for ls_rider_token
-- ----------------------------
DROP TABLE IF EXISTS `ls_rider_token`;
CREATE TABLE `ls_rider_token` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rider_id` int(11) NOT NULL DEFAULT 0 COMMENT '骑手id',
  `token` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'token值',
  `expires_at` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '过期时间',
  `created_at` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '创建时间',
  `updated_at` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `token`(`token`) USING BTREE,
  INDEX `rider_id`(`rider_id`) USING BTREE,
  INDEX `expires_at`(`expires_at`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '骑手token表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Table structure for ls_rider_vehicle
-- ----------------------------
DROP TABLE IF EXISTS `ls_rider_vehicle`;
CREATE TABLE `ls_rider_vehicle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rider_id` int(11) NOT NULL DEFAULT 0 COMMENT '骑手id',
  `vehicle_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '车辆类型：bicycle自行车, electric_bike电动车, motorcycle摩托车',
  `vehicle_brand` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车辆品牌',
  `vehicle_model` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车辆型号',
  `vehicle_color` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车辆颜色',
  `license_plate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车牌号',
  `vehicle_photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '车辆照片',
  `driving_license` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '行驶证照片',
  `insurance_photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '保险照片',
  `insurance_expire` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '保险过期时间',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态：0禁用 1正常',
  `is_current` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否当前使用：0否 1是',
  `add_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '添加时间',
  `update_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `rider_id`(`rider_id`) USING BTREE,
  INDEX `vehicle_type`(`vehicle_type`) USING BTREE,
  INDEX `status`(`status`) USING BTREE,
  INDEX `is_current`(`is_current`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '骑手车辆信息表' ROW_FORMAT = DYNAMIC;