Startseite Erkunden Hilfe
Registrieren Anmelden
liuxiang
/
playlet
1
0
Fork 0
Dateien Issues 0 Pull-Requests 0 Wiki
Struktur: 6616ceb18d
Branches Tags
playlet
/
sql
/
central
/
central_update_20241024.sql

central_update_20241024.sql 31 KB
Verlauf Originalformat

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143 
  1. alter table device_detail
    2. 

  2.     add tg_platform int null comment '推广平台' after channel_name;
    3. 

  3. 

  4. alter table device_detail
    5. 

  5.     add country varchar(255) null comment '设备所在国家' after region;
    6. 

  6. 

  7. alter table device_detail
    8. 

  8.     add city varchar(255) null comment '设备所在城市' after country;
    9. 

  9. 

  10. alter table device_detail_update
    11. 

  11.     add tg_platform int null comment '推广平台' after channel_name;
    12. 

  12. 

  13. alter table device_detail_update
    14. 

  14.     add country varchar(255) null comment '设备所在国家' after region;
    15. 

  15. 

  16. alter table device_detail_update
    17. 

  17.     add city varchar(255) null comment '设备所在城市' after country;
    18. 

  18. 

  19. alter table device_detail_update
    20. 

  20.     add user_agent varchar(255) null comment '设备所在城市' after ip_region;
    21. 

  21. 

  22. 

  23. # COMMON
    24. 

  24. 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);
    25. 

  25. 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);
    26. 

  26. 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);
    27. 

  27. 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);
    28. 

  28. 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);
    29. 

  29. 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);
    30. 

  30. # project_song
    31. 

  31. 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);
    32. 

  32. 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);
    33. 

  33. 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);
    34. 

  34. 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);
    35. 

  35. 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);
    36. 

  36. 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);
    37. 

  37. # ad_event
    38. 

  38. 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);
    39. 

  39. 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);
    40. 

  40. 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);
    41. 

  41. 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);
    42. 

  42. 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);
    43. 

  43. 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);
    44. 

  44. # project_gpt
    45. 

  45. 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);
    46. 

  46. 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);
    47. 

  47. 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);
    48. 

  48. 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);
    49. 

  49. 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);
    50. 

  50. 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);
    51. 

  51. # project_skin
    52. 

  52. 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);
    53. 

  53. 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);
    54. 

  54. 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);
    55. 

  55. 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);
    56. 

  56. 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);
    57. 

  57. 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);
    58. 

  58. # project_location
    59. 

  59. 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);
    60. 

  60. 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);
    61. 

  61. 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);
    62. 

  62. 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);
    63. 

  63. 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);
    64. 

  64. 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);
    65. 

  65. # project_record
    66. 

  66. 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);
    67. 

  67. 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);
    68. 

  68. 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);
    69. 

  69. 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);
    70. 

  70. 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);
    71. 

  71. 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);
    72. 

  72. # project_voice
    73. 

  73. 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);
    74. 

  74. 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);
    75. 

  75. 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);
    76. 

  76. 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);
    77. 

  77. 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);
    78. 

  78. 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);
    79. 

  79. # project_charge
    80. 

  80. 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);
    81. 

  81. 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);
    82. 

  82. 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);
    83. 

  83. 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);
    84. 

  84. 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);
    85. 

  85. 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);
    86. 

  86. # project_recover
    87. 

  87. 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);
    88. 

  88. 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);
    89. 

  89. 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);
    90. 

  90. 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);
    91. 

  91. 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);
    92. 

  92. 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);
    93. 

  93. # project_playlet
    94. 

  94. 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);
    95. 

  95. 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);
    96. 

  96. 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);
    97. 

  97. 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);
    98. 

  98. 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);
    99. 

  99. 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);
    100. 

  100. # project_secretary
    101. 

  101. 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);
    102. 

  102. 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);
    103. 

  103. 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);
    104. 

  104. 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);
    105. 

  105. 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);
    106. 

  106. 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);
    107. 

  107. 

  108. --  海外 --
    109. 

  109. # project_game
    110. 

  110. 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);
    111. 

  111. 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);
    112. 

  112. 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);
    113. 

  113. 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);
    114. 

  114. 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);
    115. 

  115. 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);
    116. 

  116. # COMMON
    117. 

  117. 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);
    118. 

  118. 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);
    119. 

  119. 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);
    120. 

  120. 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);
    121. 

  121. 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);
    122. 

  122. 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);
    123. 

  123. # project_song
    124. 

  124. 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);
    125. 

  125. 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);
    126. 

  126. 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);
    127. 

  127. 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);
    128. 

  128. 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);
    129. 

  129. 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);
    130. 

  130. # ad_event
    131. 

  131. 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);
    132. 

  132. 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);
    133. 

  133. 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);
    134. 

  134. 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);
    135. 

  135. 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);
    136. 

  136. 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);
    137. 

  137. # project_voice
    138. 

  138. 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);
    139. 

  139. 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);
    140. 

  140. 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);
    141. 

  141. 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);
    142. 

  142. 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);
    143. 

  143. 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);
    144.