central_update_20240913.sql 985 B

123456789101112131415161718192021222324252627
  1. alter table promotion_advertiser
  2. add grant_source varchar(64) null after advertiser_subject;
  3. alter table promotion_advertiser
  4. change promotion_status put_status int default 0 not null;
  5. alter table promotion_advertiser
  6. add put_update_time datetime null;
  7. create table promotion_grant_source
  8. (
  9. id varchar(64) not null
  10. primary key,
  11. name varchar(255) null,
  12. company varchar(64) not null,
  13. subject varchar(255) null,
  14. app_id varchar(64) null,
  15. app_secret varchar(255) null,
  16. user_id varchar(64) null,
  17. access_token varchar(1000) null,
  18. expires_time datetime not null,
  19. refresh_token varchar(1000) null,
  20. refresh_expires_time datetime not null,
  21. create_time datetime not null,
  22. update_time datetime not null,
  23. status int default 0 not null
  24. );