-- ============================================================
-- 增量补丁：merchants 加 fee_ratio 字段（手续费承担比例）
-- ============================================================

SET NAMES utf8mb4;

DROP PROCEDURE IF EXISTS _ensure_merchants_fee_ratio;
DELIMITER $$
CREATE PROCEDURE _ensure_merchants_fee_ratio()
BEGIN
    IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='merchants' AND COLUMN_NAME='fee_ratio') THEN
        ALTER TABLE `merchants` ADD COLUMN `fee_ratio` INT NOT NULL DEFAULT 100
          COMMENT '商户手续费承担比例(0-100)，100=商户全担，0=客户全担(平台补)，50=平摊'
          AFTER `epay_key`;
    END IF;
END$$
DELIMITER ;
CALL _ensure_merchants_fee_ratio(); DROP PROCEDURE IF EXISTS _ensure_merchants_fee_ratio;

-- 同时给平台自营也加一个默认值（merchant_id=0 的商品走平台设置）
INSERT INTO `settings` (`k`, `v`) VALUES ('platform_fee_ratio', '100')
ON DUPLICATE KEY UPDATE `k` = `k`;

SELECT '✅ fee_ratio 补丁执行完毕' AS result;