From 4648a3bee638e9a99d2d80b66f8833b261a2db91 Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期四, 25 九月 2025 22:39:24 +0800
Subject: [PATCH] feat:设计 app ui

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

diff --git a/sql/vehicle_info.sql b/sql/vehicle_info.sql
index 6434538..cf24d47 100644
--- a/sql/vehicle_info.sql
+++ b/sql/vehicle_info.sql
@@ -19,5 +19,10 @@
 -- 鍦╰b_vehicle_info琛ㄤ腑娣诲姞device_id瀛楁
 ALTER TABLE tb_vehicle_info ADD COLUMN device_id VARCHAR(50) DEFAULT NULL COMMENT '璁惧ID';
 
+-- 鍦╰b_vehicle_info琛ㄤ腑娣诲姞褰掑睘鏈烘瀯瀛楁
+ALTER TABLE tb_vehicle_info ADD COLUMN dept_id BIGINT(20) DEFAULT NULL COMMENT '褰掑睘鏈烘瀯ID';
+ALTER TABLE tb_vehicle_info ADD INDEX idx_dept_id (dept_id);
+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

--
Gitblit v1.9.1