From 21c8161b67d69a16fbb665d8e1bbedd5e5f67775 Mon Sep 17 00:00:00 2001
From: wzp <2040239371@qq.com>
Date: 星期二, 20 五月 2025 15:28:21 +0800
Subject: [PATCH] fix: 增加报价参数

---
 sql/vehicle_info.sql |    8 +++++++-
 1 files changed, 7 insertions(+), 1 deletions(-)

diff --git a/sql/vehicle_info.sql b/sql/vehicle_info.sql
index bf73724..6434538 100644
--- a/sql/vehicle_info.sql
+++ b/sql/vehicle_info.sql
@@ -14,4 +14,10 @@
   update_time          datetime                                   comment '鏇存柊鏃堕棿',
   remark               varchar(500)    default null               comment '澶囨敞',
   primary key (vehicle_id)
-) engine=innodb auto_increment=100 comment = '杞﹁締淇℃伅琛�'; 
\ No newline at end of file
+) engine=innodb auto_increment=100 comment = '杞﹁締淇℃伅琛�'; 
+
+-- 鍦╰b_vehicle_info琛ㄤ腑娣诲姞device_id瀛楁
+ALTER TABLE tb_vehicle_info ADD COLUMN device_id VARCHAR(50) DEFAULT NULL COMMENT '璁惧ID';
+
+-- 鍦╰b_vehicle_gps琛ㄤ腑娣诲姞device_id瀛楁
+ALTER TABLE tb_vehicle_gps ADD COLUMN device_id VARCHAR(50) DEFAULT NULL COMMENT '璁惧ID';
\ No newline at end of file

--
Gitblit v1.9.1