From 766c2b5c6940fb4373b7b8097b31d2b03aa49ac2 Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期一, 10 十一月 2025 21:22:16 +0800
Subject: [PATCH] fix:优化小程序人员加载和后台用户管理中的用户加载

---
 sql/vehicle_info.sql |    5 ++++-
 1 files changed, 4 insertions(+), 1 deletions(-)

diff --git a/sql/vehicle_info.sql b/sql/vehicle_info.sql
index cf24d47..943c861 100644
--- a/sql/vehicle_info.sql
+++ b/sql/vehicle_info.sql
@@ -25,4 +25,7 @@
 ALTER TABLE tb_vehicle_info ADD CONSTRAINT fk_vehicle_dept FOREIGN KEY (dept_id) REFERENCES sys_dept(dept_id) ON DELETE SET NULL;
 
 -- 鍦╰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
+ALTER TABLE tb_vehicle_gps ADD COLUMN device_id VARCHAR(50) DEFAULT NULL COMMENT '璁惧ID';
+
+-- 鍦╰b_vehicle_info琛ㄤ腑娣诲姞dept_id瀛楁
+ALTER TABLE tb_vehicle_info ADD COLUMN dept_id BIGINT(20) DEFAULT NULL COMMENT '褰掑睘閮ㄩ棬ID';
\ No newline at end of file

--
Gitblit v1.9.1