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 | 16 +++++++++++++++- 1 files changed, 15 insertions(+), 1 deletions(-) diff --git a/sql/vehicle_info.sql b/sql/vehicle_info.sql index bf73724..943c861 100644 --- a/sql/vehicle_info.sql +++ b/sql/vehicle_info.sql @@ -14,4 +14,18 @@ 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_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'; + +-- 鍦╰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