Home Explore Help
Register Sign In
liuxiang
/
myself
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: c52df02780
Branches Tags
myself
/
sql
/
central
/
clickhouse_central_update_20250210.sql

clickhouse_central_update_20250210.sql 4.4 KB
History Raw

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071 
  1. ALTER TABLE tb_promotion_advertiser_report_rolling
    2. 

  2.     ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    3. 

  3. ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    4. 

  4. ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    5. 

  5. ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    6. 

  6. ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    7. 

  7. ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    8. 

  8. ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';
    9. 

  9. 

  10. ALTER TABLE tb_promotion_advertiser_report
    11. 

  11.     ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    12. 

  12.     ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    13. 

  13.     ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    14. 

  14.     ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    15. 

  15.     ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    16. 

  16.     ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    17. 

  17.     ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';
    18. 

  18. 

  19. ALTER TABLE tb_promotion_campaign_report_rolling
    20. 

  20.     ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    21. 

  21.     ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    22. 

  22.     ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    23. 

  23.     ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    24. 

  24.     ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    25. 

  25.     ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    26. 

  26.     ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';
    27. 

  27. 

  28. ALTER TABLE tb_promotion_campaign_report
    29. 

  29.     ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    30. 

  30.     ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    31. 

  31.     ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    32. 

  32.     ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    33. 

  33.     ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    34. 

  34.     ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    35. 

  35.     ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';
    36. 

  36. 

  37. ALTER TABLE tb_promotion_creative_report_rolling
    38. 

  38.     ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    39. 

  39.     ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    40. 

  40.     ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    41. 

  41.     ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    42. 

  42.     ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    43. 

  43.     ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    44. 

  44.     ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';
    45. 

  45. 

  46. ALTER TABLE tb_promotion_creative_report
    47. 

  47.     ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    48. 

  48.     ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    49. 

  49.     ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    50. 

  50.     ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    51. 

  51.     ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    52. 

  52.     ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    53. 

  53.     ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';
    54. 

  54. 

  55. ALTER TABLE tb_promotion_unit_report_rolling
    56. 

  56.     ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    57. 

  57.     ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    58. 

  58.     ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    59. 

  59.     ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    60. 

  60.     ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    61. 

  61.     ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    62. 

  62.     ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';
    63. 

  63. 

  64. ALTER TABLE tb_promotion_unit_report
    65. 

  65.     ADD COLUMN `total_roi` Float64 DEFAULT 0 COMMENT '总ROI',
    66. 

  66.     ADD COLUMN `total_income` Float64 DEFAULT 0 COMMENT '总收入',
    67. 

  67.     ADD COLUMN `total_ad_roi` Float64 DEFAULT 0 COMMENT '总广告ROI',
    68. 

  68.     ADD COLUMN `total_payment_roi` Float64 DEFAULT 0 COMMENT '总付费ROI',
    69. 

  69.     ADD COLUMN `first_day_ad_roi` Float64 DEFAULT 0 COMMENT '首日广告ROI',
    70. 

  70.     ADD COLUMN `first_day_payment_roi` Float64 DEFAULT 0 COMMENT '首日付费ROI',
    71. 

  71.     ADD COLUMN `profit_and_loss` Float64 DEFAULT 0 COMMENT '盈亏值';
    72.