-- 出款改为斗拱按结算周期自动完成后，平台不再生成提现记录。
|
--
|
-- 资金流变成：支付 → 延迟户（不可结算、不可取现）→ 核销确认 → 商户基本户 →
|
-- 按结算周期自动结算到结算卡。平台侧不再有「汇总 → 提交取现 → 结果收敛」这条链路，
|
-- 因此提现记录表、订单与提现记录的关联、以及订单上的提现锁定状态全部退役。
|
--
|
-- 后台的「结算记录」页改为直接查斗拱的结算流水，不再依赖本地表。
|
--
|
-- 用 exists 判断逐项删除，使脚本可以重复执行。
|
DROP PROCEDURE IF EXISTS drop_withdrawal_objects;
|
DELIMITER //
|
CREATE PROCEDURE drop_withdrawal_objects()
|
BEGIN
|
IF EXISTS (SELECT 1 FROM information_schema.tables
|
WHERE table_schema = DATABASE() AND table_name = 'merchant_withdrawal_order') THEN
|
DROP TABLE merchant_withdrawal_order;
|
END IF;
|
IF EXISTS (SELECT 1 FROM information_schema.tables
|
WHERE table_schema = DATABASE() AND table_name = 'merchant_withdrawal') THEN
|
DROP TABLE merchant_withdrawal;
|
END IF;
|
IF EXISTS (SELECT 1 FROM information_schema.columns
|
WHERE table_schema = DATABASE() AND table_name = 'benefit_order'
|
AND column_name = 'withdrawal_status') THEN
|
ALTER TABLE benefit_order DROP COLUMN withdrawal_status;
|
END IF;
|
END //
|
DELIMITER ;
|
CALL drop_withdrawal_objects();
|
DROP PROCEDURE drop_withdrawal_objects;
|
