-- 为tencent_ads_auth表添加新字段
-- 执行日期: 2026-02-05

ALTER TABLE tencent_ads_auth
    ADD COLUMN account_uin bigint NULL COMMENT '账户UIN' AFTER account_id,
    ADD COLUMN scope_list text NULL COMMENT '授权范围列表(JSON格式)' AFTER account_uin,
    ADD COLUMN wechat_account_id varchar(128) NULL COMMENT '微信账户ID' AFTER scope_list,
    ADD COLUMN account_role_type varchar(64) NULL COMMENT '账户角色类型' AFTER wechat_account_id,
    ADD COLUMN account_type varchar(64) NULL COMMENT '账户类型' AFTER account_role_type,
    ADD COLUMN role_type varchar(64) NULL COMMENT '角色类型' AFTER account_type;
