playlet/sql/central/clickhouse_central_update_20241023.sql

alter table tb_event_base
    add column `$tg_platform` Int64 default 0;
alter table tb_event_base
    add column `$company` String default '';
alter table tb_event_base
    add column `$advertiser_id` String default '';
alter table tb_event_base
    add column `$gid` String default '';
alter table tb_event_base
    add column `$aid` String default '';
alter table tb_event_base
    add column `$cid` String default '';


alter table tb_event_ad_event
    add column `$tg_platform` Int64 default 0;
alter table tb_event_ad_event
    add column `$company` String default '';
alter table tb_event_ad_event
    add column `$advertiser_id` String default '';
alter table tb_event_ad_event
    add column `$gid` String default '';
alter table tb_event_ad_event
    add column `$aid` String default '';
alter table tb_event_ad_event
    add column `$cid` String default '';

alter table tb_event_project_charge
    add column `$tg_platform` Int64 default 0;
alter table tb_event_project_charge
    add column `$company` String default '';
alter table tb_event_project_charge
    add column `$advertiser_id` String default '';
alter table tb_event_project_charge
    add column `$gid` String default '';
alter table tb_event_project_charge
    add column `$aid` String default '';
alter table tb_event_project_charge
    add column `$cid` String default '';


alter table tb_event_project_gpt
    add column `$tg_platform` Int64 default 0;
alter table tb_event_project_gpt
    add column `$company` String default '';
alter table tb_event_project_gpt
    add column `$advertiser_id` String default '';
alter table tb_event_project_gpt
    add column `$gid` String default '';
alter table tb_event_project_gpt
    add column `$aid` String default '';
alter table tb_event_project_gpt
    add column `$cid` String default '';


alter table tb_event_project_location
    add column `$tg_platform` Int64 default 0;
alter table tb_event_project_location
    add column `$company` String default '';
alter table tb_event_project_location
    add column `$advertiser_id` String default '';
alter table tb_event_project_location
    add column `$gid` String default '';
alter table tb_event_project_location
    add column `$aid` String default '';
alter table tb_event_project_location
    add column `$cid` String default '';


alter table tb_event_project_playlet
    add column `$tg_platform` Int64 default 0;
alter table tb_event_project_playlet
    add column `$company` String default '';
alter table tb_event_project_playlet
    add column `$advertiser_id` String default '';
alter table tb_event_project_playlet
    add column `$gid` String default '';
alter table tb_event_project_playlet
    add column `$aid` String default '';
alter table tb_event_project_playlet
    add column `$cid` String default '';


alter table tb_event_project_record
    add column `$tg_platform` Int64 default 0;
alter table tb_event_project_record
    add column `$company` String default '';
alter table tb_event_project_record
    add column `$advertiser_id` String default '';
alter table tb_event_project_record
    add column `$gid` String default '';
alter table tb_event_project_record
    add column `$aid` String default '';
alter table tb_event_project_record
    add column `$cid` String default '';


alter table tb_event_project_recover
    add column `$tg_platform` Int64 default 0;
alter table tb_event_project_recover
    add column `$company` String default '';
alter table tb_event_project_recover
    add column `$advertiser_id` String default '';
alter table tb_event_project_recover
    add column `$gid` String default '';
alter table tb_event_project_recover
    add column `$aid` String default '';
alter table tb_event_project_recover
    add column `$cid` String default '';


alter table tb_event_project_skin
    add column `$tg_platform` Int64 default 0;
alter table tb_event_project_skin
    add column `$company` String default '';
alter table tb_event_project_skin
    add column `$advertiser_id` String default '';
alter table tb_event_project_skin
    add column `$gid` String default '';
alter table tb_event_project_skin
    add column `$aid` String default '';
alter table tb_event_project_skin
    add column `$cid` String default '';


alter table tb_event_project_song
    add column `$tg_platform` Int64 default 0;
alter table tb_event_project_song
    add column `$company` String default '';
alter table tb_event_project_song
    add column `$advertiser_id` String default '';
alter table tb_event_project_song
    add column `$gid` String default '';
alter table tb_event_project_song
    add column `$aid` String default '';
alter table tb_event_project_song
    add column `$cid` String default '';


alter table tb_event_project_voice
    add column `$tg_platform` Int64 default 0;
alter table tb_event_project_voice
    add column `$company` String default '';
alter table tb_event_project_voice
    add column `$advertiser_id` String default '';
alter table tb_event_project_voice
    add column `$gid` String default '';
alter table tb_event_project_voice
    add column `$aid` String default '';
alter table tb_event_project_voice
    add column `$cid` String default '';


alter table tb_event_project_secretary
    add column `$tg_platform` Int64 default 0;
alter table tb_event_project_secretary
    add column `$company` String default '';
alter table tb_event_project_secretary
    add column `$advertiser_id` String default '';
alter table tb_event_project_secretary
    add column `$gid` String default '';
alter table tb_event_project_secretary
    add column `$aid` String default '';
alter table tb_event_project_secretary
    add column `$cid` String default '';

-- 海外 --
alter table tb_event_project_game
    add column `$tg_platform` Int64 default 0;
alter table tb_event_project_game
    add column `$company` String default '';
alter table tb_event_project_game
    add column `$advertiser_id` String default '';
alter table tb_event_project_game
    add column `$gid` String default '';
alter table tb_event_project_game
    add column `$aid` String default '';
alter table tb_event_project_game
    add column `$cid` String default '';


alter table tb_event_project_song
    add column `$tg_platform` Int64 default 0;
alter table tb_event_project_song
    add column `$company` String default '';
alter table tb_event_project_song
    add column `$advertiser_id` String default '';
alter table tb_event_project_song
    add column `$gid` String default '';
alter table tb_event_project_song
    add column `$aid` String default '';
alter table tb_event_project_song
    add column `$cid` String default '';


alter table tb_event_project_voice
    add column `$tg_platform` Int64 default 0;
alter table tb_event_project_voice
    add column `$company` String default '';
alter table tb_event_project_voice
    add column `$advertiser_id` String default '';
alter table tb_event_project_voice
    add column `$gid` String default '';
alter table tb_event_project_voice
    add column `$aid` String default '';
alter table tb_event_project_voice
    add column `$cid` String default '';


alter table tb_event_base
    add column `$tg_platform` Int64 default 0;
alter table tb_event_base
    add column `$company` String default '';
alter table tb_event_base
    add column `$advertiser_id` String default '';
alter table tb_event_base
    add column `$gid` String default '';
alter table tb_event_base
    add column `$aid` String default '';
alter table tb_event_base
    add column `$cid` String default '';


alter table tb_event_ad_event
    add column `$tg_platform` Int64 default 0;
alter table tb_event_ad_event
    add column `$company` String default '';
alter table tb_event_ad_event
    add column `$advertiser_id` String default '';
alter table tb_event_ad_event
    add column `$gid` String default '';
alter table tb_event_ad_event
    add column `$aid` String default '';
alter table tb_event_ad_event
    add column `$cid` String default '';