| 123456789101112131415161718192021222324252627 |
- 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
- );
|