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 '盈亏值';