From c1147646b9ef1d713a202d7ab8cf3ea8d677f142 Mon Sep 17 00:00:00 2001 From: wlzboy <66905212@qq.com> Date: 星期六, 27 九月 2025 21:56:54 +0800 Subject: [PATCH] fix:优化评价 --- sql/vehicle_gps.sql | 3 +++ 1 files changed, 3 insertions(+), 0 deletions(-) diff --git a/sql/vehicle_gps.sql b/sql/vehicle_gps.sql index 87630d7..04e296c 100644 --- a/sql/vehicle_gps.sql +++ b/sql/vehicle_gps.sql @@ -26,11 +26,14 @@ `direction` decimal(10,2) DEFAULT NULL COMMENT '鏂瑰悜(搴�)', `collect_time` datetime NOT NULL COMMENT '閲囬泦鏃堕棿', `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + `device_report_time` datetime DEFAULT NULL COMMENT '璁惧涓婃姤鏃堕棿', + `platform_process_time` datetime DEFAULT NULL COMMENT '骞冲彴澶勭悊鏃堕棿', PRIMARY KEY (`gps_id`), KEY `idx_vehicle_id` (`vehicle_id`), KEY `idx_collect_time` (`collect_time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='杞﹁締GPS鍧愭爣琛�'; + -- GPS閲囬泦鏃ュ織琛� CREATE TABLE `tb_gps_collect_log` ( `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '鏃ュ織ID', -- Gitblit v1.9.1