-- 实训室管理员与联系电话改为独立文本字段(MySQL 5.7+/8.0)。 -- 部署应用前执行:历史联系人从原关联账号回填,之后不再随账号资料变化。 -- 保留manager_id历史列以避免破坏既有数据,新版接口不再读写或依赖该列。 delimiter $$ drop procedure if exists migrate_training_room_contact$$ create procedure migrate_training_room_contact() begin if not exists ( select 1 from information_schema.columns where table_schema = database() and table_name = 'training_room' and column_name = 'manager_name' ) then alter table training_room add column manager_name varchar(100) null comment '管理员姓名,文本输入'; end if; if not exists ( select 1 from information_schema.columns where table_schema = database() and table_name = 'training_room' and column_name = 'manager_phone' ) then alter table training_room add column manager_phone varchar(50) null comment '联系电话,文本输入'; end if; if exists ( select 1 from information_schema.columns where table_schema = database() and table_name = 'training_room' and column_name = 'manager_id' ) then -- 只填充尚未迁移的NULL字段:重复执行不会覆盖手工修改或主动清空的空字符串。 -- 与原列表查询保持一致,仅迁移未删除账号的姓名和电话。 update training_room r inner join user manager on manager.id = r.manager_id and manager.del_flag = 0 set r.manager_name = coalesce(r.manager_name, manager.nick_name), r.manager_phone = coalesce(r.manager_phone, manager.phone_number) where r.manager_name is null or r.manager_phone is null; end if; end$$ call migrate_training_room_contact()$$ drop procedure if exists migrate_training_room_contact$$ delimiter ;