| 1234567891011121314151617181920212223 |
- create table pay_subscription
- (
- id bigint auto_increment
- primary key,
- out_trade_no varchar(128) not null,
- subscription_group varchar(255) not null,
- ssid varchar(64) not null,
- device_id varchar(64) not null,
- renew_item_id bigint null,
- auto_renew_status int default 0 not null,
- expire_time datetime not null,
- create_time datetime not null,
- update_time datetime not null
- );
- alter table payment
- add subscription_group varchar(255) null after apple_goods_id;
- alter table pay_item
- add subscribable int default 0 not null after apple_goods_id;
- alter table pay_item
- add subscription_group varchar(255) null after subscribable;
|
