8 行
827 B
SQL
8 行
827 B
SQL
-- 分账表汇付扩展字段
|
|
ALTER TABLE `__PREFIX__shopro_split_receiver` ADD COLUMN `channel` varchar(16) NOT NULL DEFAULT 'wechat' COMMENT 'wechat/huifu' AFTER `role_id`;
|
|
ALTER TABLE `__PREFIX__shopro_split_receiver` MODIFY COLUMN `receiver_type` varchar(32) NOT NULL DEFAULT 'PERSONAL_OPENID';
|
|
ALTER TABLE `__PREFIX__shopro_split_receiver` ADD COLUMN `acct_id` varchar(64) DEFAULT NULL COMMENT '汇付子账户' AFTER `receiver_account`;
|
|
ALTER TABLE `__PREFIX__shopro_split_order` ADD COLUMN `channel` varchar(16) NOT NULL DEFAULT 'wechat' COMMENT 'wechat/huifu' AFTER `order_sn`;
|
|
ALTER TABLE `__PREFIX__shopro_split_order` ADD COLUMN `confirm_hf_seq_id` varchar(64) DEFAULT NULL AFTER `wx_result`;
|
|
ALTER TABLE `__PREFIX__shopro_split_order` ADD COLUMN `hf_req_seq_id` varchar(64) DEFAULT NULL AFTER `confirm_hf_seq_id`;
|