ALTER TABLE tb_promotion_advertiser_report_rolling
    ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';

ALTER TABLE tb_promotion_advertiser_report
    ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';

ALTER TABLE tb_promotion_campaign_report_rolling
    ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';

ALTER TABLE tb_promotion_campaign_report
    ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';

ALTER TABLE tb_promotion_creative_report_rolling
    ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';

ALTER TABLE tb_promotion_creative_report
    ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';

ALTER TABLE tb_promotion_unit_report_rolling
    ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';

ALTER TABLE tb_promotion_unit_report
    ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';