alter table promotion_advertiser
    add grant_source varchar(64) null after advertiser_subject;

alter table promotion_advertiser
    change promotion_status put_status int default 0 not null;

alter table promotion_advertiser
    add put_update_time datetime null;

create table promotion_grant_source
(
    id                   varchar(64)   not null
        primary key,
    name                 varchar(255)  null,
    company              varchar(64)   not null,
    subject              varchar(255)  null,
    app_id               varchar(64)   null,
    app_secret           varchar(255)  null,
    user_id              varchar(64)   null,
    access_token         varchar(1000) null,
    expires_time         datetime      not null,
    refresh_token        varchar(1000) null,
    refresh_expires_time datetime      not null,
    create_time          datetime      not null,
    update_time          datetime      not null,
    status               int default 0 not null
);