Files
pay-bridge/backend/configs/migrations/005_merchant_application_channel_merchant_id.sql
2026-03-13 15:51:59 +08:00

6 lines
357 B
SQL

-- merchant_application 记录渠道审核通过后下发的渠道商户ID
-- 支持同一商户在多个渠道分别进件,每条记录对应一个渠道
ALTER TABLE `merchant_application`
ADD COLUMN `channel_merchant_id` VARCHAR(64) NOT NULL DEFAULT '' AFTER `channel_code`,
ADD UNIQUE KEY `uk_merchant_channel` (`merchant_id`, `channel_code`);