From 0bf199cf85a36157113d217363bb96314956b75f Mon Sep 17 00:00:00 2001 From: wlzboy <66905212@qq.com> Date: 星期四, 13 十一月 2025 22:14:12 +0800 Subject: [PATCH] feat: 修复小程序上传附件 --- sql/vehicle_mileage_stats.sql | 37 +++++++++++++++++++++++++++++++++++++ 1 files changed, 37 insertions(+), 0 deletions(-) diff --git a/sql/vehicle_mileage_stats.sql b/sql/vehicle_mileage_stats.sql index e69de29..b059dec 100644 --- a/sql/vehicle_mileage_stats.sql +++ b/sql/vehicle_mileage_stats.sql @@ -0,0 +1,37 @@ +-- 杞﹁締閲岀▼缁熻琛� +DROP TABLE IF EXISTS `vehicle_mileage_stats`; +CREATE TABLE `vehicle_mileage_stats` ( + `stats_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '缁熻ID', + `vehicle_id` bigint(20) NOT NULL COMMENT '杞﹁締ID', + `stats_date` date NOT NULL COMMENT '缁熻鏃ユ湡', + `total_mileage` decimal(10,2) DEFAULT '0.00' COMMENT '鎬婚噷绋�(鍏噷)', + `task_mileage` decimal(10,2) DEFAULT '0.00' COMMENT '浠诲姟閲岀▼(鍏噷)', + `non_task_mileage` decimal(10,2) DEFAULT '0.00' COMMENT '闈炰换鍔￠噷绋�(鍏噷)', + `task_mileage_ratio` decimal(5,2) DEFAULT '0.00' COMMENT '浠诲姟閲岀▼鍗犳瘮(%)', + `gps_count` int(11) DEFAULT '0' COMMENT 'GPS鐐规暟', + `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿', + PRIMARY KEY (`stats_id`), + UNIQUE KEY `uk_vehicle_date` (`vehicle_id`,`stats_date`), + KEY `idx_stats_date` (`stats_date`), + KEY `idx_vehicle_id` (`vehicle_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='杞﹁締閲岀▼缁熻琛�'; + +-- 杞﹁締閲岀▼缁熻鏄庣粏琛� +DROP TABLE IF EXISTS `vehicle_mileage_stats_detail`; +CREATE TABLE `vehicle_mileage_stats_detail` ( + `detail_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '鏄庣粏ID', + `stats_id` bigint(20) NOT NULL COMMENT '缁熻ID', + `vehicle_id` bigint(20) NOT NULL COMMENT '杞﹁締ID', + `task_id` bigint(20) DEFAULT NULL COMMENT '浠诲姟ID(浠诲姟鏃舵)', + `start_time` datetime NOT NULL COMMENT '寮�濮嬫椂闂�', + `end_time` datetime NOT NULL COMMENT '缁撴潫鏃堕棿', + `mileage` decimal(10,2) DEFAULT '0.00' COMMENT '閲岀▼(鍏噷)', + `is_task_period` char(1) DEFAULT '0' COMMENT '鏄惁浠诲姟鏃舵(0鍚� 1鏄�)', + `gps_count` int(11) DEFAULT '0' COMMENT 'GPS鐐规暟', + `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + PRIMARY KEY (`detail_id`), + KEY `idx_stats_id` (`stats_id`), + KEY `idx_vehicle_id` (`vehicle_id`), + KEY `idx_task_id` (`task_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='杞﹁締閲岀▼缁熻鏄庣粏琛�'; -- Gitblit v1.9.1