-- migration-version: 20260908_100000_SUPPORT_GUIDE_TEAM_BALANCE
USE `tour_guide`;

ALTER TABLE `guide_team`
    ADD COLUMN `balance` DECIMAL(12,2) NOT NULL DEFAULT 0.00 COMMENT '讲解队可提现余额' AFTER `merchant_id`,
    ADD COLUMN `collection_guide_id` BIGINT UNSIGNED DEFAULT NULL COMMENT '收款导游ID' AFTER `balance`,
    ADD UNIQUE KEY `uk_guide_team_collection_guide` (`collection_guide_id`),
    ADD CONSTRAINT `fk_guide_team_collection_guide` FOREIGN KEY (`collection_guide_id`) REFERENCES `guide_user` (`id`) ON DELETE SET NULL;

ALTER TABLE `guide_withdrawal`
    ADD COLUMN `team_id` BIGINT UNSIGNED DEFAULT NULL COMMENT '资金归属讲解队ID，为空表示个人导游' AFTER `guide_id`,
    ADD KEY `idx_guide_withdrawal_team` (`team_id`);

INSERT INTO `sys_schema_migration` (`version`, `description`)
VALUES ('20260908_100000_SUPPORT_GUIDE_TEAM_BALANCE', 'support guide team balance and collection guide withdrawals');