central_update_20240122.sql 919 B

12345678910111213141516
  1. create table central.promotion_advertiser
  2. (
  3. advertiser_id bigint not null comment '广告主id'
  4. primary key,
  5. env varchar(256) default '' not null,
  6. advertiser_name varchar(256) null,
  7. platform_id int null comment '投放平台id',
  8. app_id int null comment '应用id',
  9. operator_id int null comment '优化师id',
  10. access_token varchar(256) not null,
  11. remark varchar(256) null,
  12. create_time datetime default (now()) not null,
  13. update_time datetime default CURRENT_TIMESTAMP null,
  14. invalid_time datetime not null comment '授权失效时间'
  15. );