From caf56217dc2bf898b63b0e1f31a7098202c32825 Mon Sep 17 00:00:00 2001 From: wlzboy <66905212@qq.com> Date: 星期六, 15 十一月 2025 16:50:17 +0800 Subject: [PATCH] Merge branch 'feature_gps' --- 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