| 12345678910111213141516171819202122232425262728293031 |
- alter table pay_config
- add merchant_id int null after method;
- alter table pay_config
- add wx_api_version varchar(255) null comment 'v2,v3' after wx_app_id;
- alter table pay_config
- add create_time datetime default CURRENT_TIMESTAMP not null after zfb_app_public_key_path;
- alter table pay_config
- add update_time datetime default CURRENT_TIMESTAMP not null after create_time;
- create table pay_merchant
- (
- id int auto_increment comment 'id'
- primary key,
- name varchar(255) null,
- method int not null comment '1:支付宝 2:微信 3:苹果',
- create_time datetime not null,
- update_time datetime not null,
- status int default 0 not null,
- zfb_alipay_root_cert_path varchar(1000) null comment '支付宝根证书',
- zfb_alipay_public_cert_path varchar(1000) null comment '支付宝公钥证书',
- wx_merchant_id varchar(255) null comment '微信商户id',
- wx_merchant_serial_number varchar(255) null comment '微信商户证书序列号',
- wx_private_key_path varchar(1000) null comment '微信商户API私钥文件路径',
- wx_api_v3_key varchar(1000) null comment '微信商户API V3密钥',
- wx_v2_mch_key varchar(1000) null comment '微信商户V2密钥',
- wx_v2_key_path varchar(1000) null comment '微信商户V2私钥路径',
- apple_shared_secret varchar(255) null comment '苹果共享密钥'
- );
|
