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;