alter table device_detail
    add tg_platform int null comment '推广平台' after channel_name;

alter table device_detail
    add country varchar(255) null comment '设备所在国家' after region;

alter table device_detail
    add city varchar(255) null comment '设备所在城市' after country;

alter table device_detail_update
    add tg_platform int null comment '推广平台' after channel_name;

alter table device_detail_update
    add country varchar(255) null comment '设备所在国家' after region;

alter table device_detail_update
    add city varchar(255) null comment '设备所在城市' after country;

alter table device_detail_update
    add user_agent varchar(255) null comment '设备所在城市' after ip_region;


# COMMON
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('COMMON', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('COMMON', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('COMMON', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('COMMON', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('COMMON', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('COMMON', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# project_song
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_song', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_song', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_song', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_song', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_song', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_song', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# ad_event
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('ad_event', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('ad_event', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('ad_event', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('ad_event', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('ad_event', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('ad_event', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# project_gpt
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_gpt', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_gpt', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_gpt', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_gpt', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_gpt', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_gpt', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# project_skin
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_skin', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_skin', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_skin', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_skin', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_skin', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_skin', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# project_location
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_location', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_location', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_location', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_location', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_location', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_location', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# project_record
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_record', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_record', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_record', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_record', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_record', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_record', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# project_voice
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_voice', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_voice', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_voice', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_voice', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_voice', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_voice', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# project_charge
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_charge', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_charge', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_charge', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_charge', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_charge', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_charge', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# project_recover
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_recover', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_recover', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_recover', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_recover', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_recover', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_recover', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# project_playlet
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_playlet', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_playlet', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_playlet', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_playlet', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_playlet', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_playlet', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# project_secretary
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_secretary', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_secretary', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_secretary', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_secretary', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_secretary', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_secretary', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);

--  海外 --
# project_game
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_game', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_game', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_game', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_game', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_game', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_game', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# COMMON
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('COMMON', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('COMMON', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('COMMON', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('COMMON', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('COMMON', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('COMMON', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# project_song
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_song', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_song', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_song', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_song', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_song', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_song', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# ad_event
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('ad_event', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('ad_event', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('ad_event', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('ad_event', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('ad_event', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('ad_event', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
# project_voice
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_voice', null, '$tg_platform', '$tplf', 'tgPlatform', 'COMMON', 'LONG', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_voice', null, '$company', '$company', 'company', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_voice', null, '$advertiser_id', '$advertiser_id', 'advertiserId', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_voice', null, '$gid', '$gid', 'gid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_voice', null, '$aid', '$aid', 'aid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);
INSERT INTO central.event_meta_prop (project_code, product_id, col, alias, name, prop_type, value_type, accept, description, create_time, update_time, status) VALUES ('project_voice', null, '$cid', '$cid', 'cid', 'COMMON', 'STRING', 1, null, '2024-06-25 11:06:33', '2024-06-25 11:06:35', 0);