24 lines
1.3 KiB
SQL
24 lines
1.3 KiB
SQL
-- 双场景聚合支付：仅新增场景字段，前置为统一支付基线表已存在。
|
|
-- 可重复执行：字段已存在则跳过，不修改已有字段定义。
|
|
USE `pjcloudx_thirdparty`;
|
|
|
|
-- 聚合会话默认 ORDER，兼容原订单聚合支付。
|
|
SET @ddl = (SELECT IF(COUNT(*) = 0,
|
|
'ALTER TABLE `third_aggregate_pay_session` ADD COLUMN `aggregate_scene` varchar(32) NOT NULL DEFAULT ''ORDER'' COMMENT ''聚合场景：ORDER订单聚合，OFFLINE线下收款'' AFTER `aggregate_no`',
|
|
'SELECT 1')
|
|
FROM information_schema.COLUMNS
|
|
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'third_aggregate_pay_session' AND COLUMN_NAME = 'aggregate_scene');
|
|
PREPARE stmt FROM @ddl;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|
|
|
|
-- 支付流水默认 NULL，避免把普通充值等非聚合支付标为订单聚合。
|
|
SET @ddl = (SELECT IF(COUNT(*) = 0,
|
|
'ALTER TABLE `third_pay_order` ADD COLUMN `aggregate_scene` varchar(32) DEFAULT NULL COMMENT ''聚合场景：ORDER订单聚合，OFFLINE线下收款，NULL非聚合'' AFTER `biz_type`',
|
|
'SELECT 1')
|
|
FROM information_schema.COLUMNS
|
|
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'third_pay_order' AND COLUMN_NAME = 'aggregate_scene');
|
|
PREPARE stmt FROM @ddl;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|