myself/sql/central/clickhouse_central_update_20250217.sql

ALTER TABLE tb_promotion_advertiser_report_rolling
    ADD COLUMN `balance` Float64 DEFAULT 0 COMMENT '账户总余额',
    ADD COLUMN `day_budget` Float64 DEFAULT 0 COMMENT '单日预算金额';

ALTER TABLE tb_promotion_advertiser_report
    ADD COLUMN `balance` Float64 DEFAULT 0 COMMENT '账户总余额',
    ADD COLUMN `day_budget` Float64 DEFAULT 0 COMMENT '单日预算金额';

ALTER TABLE tb_promotion_report_rolling
    ADD COLUMN `balance` Float64 DEFAULT 0 COMMENT '账户总余额',
    ADD COLUMN `day_budget` Float64 DEFAULT 0 COMMENT '单日预算金额';

ALTER TABLE tb_promotion_report
    ADD COLUMN `balance` Float64 DEFAULT 0 COMMENT '账户总余额',
    ADD COLUMN `day_budget` Float64 DEFAULT 0 COMMENT '单日预算金额';


ALTER TABLE tb_promotion_campaign_report_rolling
    ADD COLUMN `campaign_name` String DEFAULT '' COMMENT '广告计划名称',
    ADD COLUMN `put_status` Int32 DEFAULT 0 COMMENT '维度状态',
    ADD COLUMN `day_budget` Float64 DEFAULT 0 COMMENT '单日预算金额',
drop
column aid,
    drop
column cid;

ALTER TABLE tb_promotion_campaign_report
    ADD COLUMN `campaign_name` String DEFAULT '' COMMENT '广告计划名称',
    ADD COLUMN `put_status` Int32 DEFAULT 0 COMMENT '维度状态',
    ADD COLUMN `day_budget` Float64 DEFAULT 0 COMMENT '单日预算金额',
drop
column aid,
    drop
column cid;

ALTER TABLE tb_promotion_campaign_report_rolling_temp
    ADD COLUMN `campaign_name` String DEFAULT '' COMMENT '广告计划名称',
    ADD COLUMN `put_status` Int32 DEFAULT 0 COMMENT '维度状态',
    ADD COLUMN `day_budget` Float64 DEFAULT 0 COMMENT '单日预算金额',
drop
column aid,
    drop
column cid;

ALTER TABLE tb_promotion_campaign_report_temp
    ADD COLUMN `campaign_name` String DEFAULT '' COMMENT '广告计划名称',
    ADD COLUMN `put_status` Int32 DEFAULT 0 COMMENT '维度状态',
    ADD COLUMN `day_budget` Float64 DEFAULT 0 COMMENT '单日预算金额',
drop
column aid,
    drop
column cid;

ALTER TABLE tb_promotion_unit_report_rolling
    ADD COLUMN `campaign_name` String DEFAULT '' COMMENT '广告计划名称',
    ADD COLUMN `unit_name` String DEFAULT '' COMMENT '广告组名称',
    ADD COLUMN `put_status` Int32 DEFAULT 0 COMMENT '维度状态',
    ADD COLUMN `day_budget` Float64 DEFAULT 0 COMMENT '单日预算金额',
drop
column cid;

ALTER TABLE tb_promotion_unit_report
    ADD COLUMN `campaign_name` String DEFAULT '' COMMENT '广告计划名称',
    ADD COLUMN `unit_name` String DEFAULT '' COMMENT '广告组名称',
    ADD COLUMN `put_status` Int32 DEFAULT 0 COMMENT '维度状态',
    ADD COLUMN `day_budget` Float64 DEFAULT 0 COMMENT '单日预算金额',
drop
column cid;

ALTER TABLE tb_promotion_unit_report_rolling_temp
    ADD COLUMN `campaign_name` String DEFAULT '' COMMENT '广告计划名称',
    ADD COLUMN `unit_name` String DEFAULT '' COMMENT '广告组名称',
    ADD COLUMN `put_status` Int32 DEFAULT 0 COMMENT '维度状态',
    ADD COLUMN `day_budget` Float64 DEFAULT 0 COMMENT '单日预算金额',
drop
column cid;

ALTER TABLE tb_promotion_unit_report_temp
    ADD COLUMN `campaign_name` String DEFAULT '' COMMENT '广告计划名称',
    ADD COLUMN `unit_name` String DEFAULT '' COMMENT '广告组名称',
    ADD COLUMN `put_status` Int32 DEFAULT 0 COMMENT '维度状态',
    ADD COLUMN `day_budget` Float64 DEFAULT 0 COMMENT '单日预算金额',
drop
column cid;


ALTER TABLE tb_promotion_creative_report_rolling
    ADD COLUMN `campaign_name` String DEFAULT '' COMMENT '广告计划名称',
    ADD COLUMN `unit_name` String DEFAULT '' COMMENT '广告组名称',
    ADD COLUMN `creative_name` String DEFAULT '' COMMENT '广告创意名称',
    ADD COLUMN `put_status` Int32 DEFAULT 0 COMMENT '维度状态';

ALTER TABLE tb_promotion_creative_report
    ADD COLUMN `campaign_name` String DEFAULT '' COMMENT '广告计划名称',
    ADD COLUMN `unit_name` String DEFAULT '' COMMENT '广告组名称',
    ADD COLUMN `creative_name` String DEFAULT '' COMMENT '广告创意名称',
    ADD COLUMN `put_status` Int32 DEFAULT 0 COMMENT '维度状态';

ALTER TABLE tb_promotion_creative_report_rolling_temp
    ADD COLUMN `campaign_name` String DEFAULT '' COMMENT '广告计划名称',
    ADD COLUMN `unit_name` String DEFAULT '' COMMENT '广告组名称',
    ADD COLUMN `creative_name` String DEFAULT '' COMMENT '广告创意名称',
    ADD COLUMN `put_status` Int32 DEFAULT 0 COMMENT '维度状态';

ALTER TABLE tb_promotion_creative_report_temp
    ADD COLUMN `campaign_name` String DEFAULT '' COMMENT '广告计划名称',
    ADD COLUMN `unit_name` String DEFAULT '' COMMENT '广告组名称',
    ADD COLUMN `creative_name` String DEFAULT '' COMMENT '广告创意名称',
    ADD COLUMN `put_status` Int32 DEFAULT 0 COMMENT '维度状态';