· 6 years ago · May 14, 2019, 10:06 PM
1CREATE TABLE IF NOT EXISTS `accepted_tos_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
2CREATE TABLE IF NOT EXISTS `ad_group_spec_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
3CREATE TABLE IF NOT EXISTS `ad_group_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
4CREATE TABLE IF NOT EXISTS `advertiser_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
5CREATE TABLE IF NOT EXISTS `app_event_tracking_config_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
6CREATE TABLE IF NOT EXISTS `bill_detail_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
7CREATE TABLE IF NOT EXISTS `billing_action_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
8CREATE TABLE IF NOT EXISTS `billing_contact_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
9CREATE TABLE IF NOT EXISTS `billing_profile_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
10CREATE TABLE IF NOT EXISTS `bill_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
11CREATE TABLE IF NOT EXISTS `bulk_v2_job_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
12CREATE TABLE IF NOT EXISTS `business_profile_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
13CREATE TABLE IF NOT EXISTS `campaign_spec_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
14CREATE TABLE IF NOT EXISTS `campaign_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
15CREATE TABLE IF NOT EXISTS `carousel_slot_promotion_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
16CREATE TABLE IF NOT EXISTS `conversion_tag_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
17CREATE TABLE IF NOT EXISTS `goal_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
18CREATE TABLE IF NOT EXISTS `notification_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
19CREATE TABLE IF NOT EXISTS `order_line_spec_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
20CREATE TABLE IF NOT EXISTS `order_line_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
21CREATE TABLE IF NOT EXISTS `pin_promotion_spec_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
22CREATE TABLE IF NOT EXISTS `pin_promotion_specs_labels_xref_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
23CREATE TABLE IF NOT EXISTS `pin_promotion_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
24CREATE TABLE IF NOT EXISTS `pinner_list_spec_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
25CREATE TABLE IF NOT EXISTS `pinner_list_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
26CREATE TABLE IF NOT EXISTS `product_group_spec_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
27CREATE TABLE IF NOT EXISTS `product_group_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
28CREATE TABLE IF NOT EXISTS `promoted_catalog_product_group_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
29CREATE TABLE IF NOT EXISTS `promoted_catalog_product_groups_history_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
30CREATE TABLE IF NOT EXISTS `rule_subscription_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
31CREATE TABLE IF NOT EXISTS `targeting_attribute_history_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
32CREATE TABLE IF NOT EXISTS `targeting_attribute_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
33CREATE TABLE IF NOT EXISTS `targeting_spec_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';
34CREATE TABLE IF NOT EXISTS `user_preference_id_idx` (`id` bigint(20), `g_advertiser_id` bigint(20), primary key(`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT 'vitess_lookup_vindex';