-- migration-version: 20260729_180000_ADD_GUIDE_APPLICATION_TEAM
|
-- 作用：导游注册申请记录讲解队选择，审核通过后同步到导游账号。
|
|
USE `tour_guide`;
|
|
ALTER TABLE `guide_application`
|
ADD COLUMN `team_id` BIGINT UNSIGNED DEFAULT NULL COMMENT '讲解队ID，为空表示个人导游' AFTER `guide_type`,
|
ADD KEY `idx_guide_application_team` (`team_id`);
|
|
INSERT INTO `sys_schema_migration` (`version`, `description`)
|
VALUES ('20260729_180000_ADD_GUIDE_APPLICATION_TEAM', '导游注册申请增加讲解队ID');
|
