10 lines
430 B
SQL
Executable File
10 lines
430 B
SQL
Executable File
-- 为 payment_transactions 表添加 payer_openid 字段
|
|
-- 用于存储支付时的微信 openid,确保虚拟发货时使用正确的 openid
|
|
|
|
ALTER TABLE `payment_transactions`
|
|
ADD COLUMN `payer_openid` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '支付用户openid(来自微信支付回调)' AFTER `transaction_id`;
|
|
|
|
-- 添加索引以便查询
|
|
ALTER TABLE `payment_transactions`
|
|
ADD INDEX `idx_payer_openid` (`payer_openid`);
|