CREATE TABLE `wp_rank_math_analytics_gsc` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `query` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `clicks` mediumint(6) NOT NULL,
  `impressions` mediumint(6) NOT NULL,
  `position` double NOT NULL,
  `ctr` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

ALTER TABLE `wp_rank_math_analytics_gsc`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analytics_query` (`query`),
  ADD KEY `analytics_page` (`page`),
  ADD KEY `clicks` (`clicks`),
  ADD KEY `position` (`position`);

ALTER TABLE `wp_rank_math_analytics_gsc`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;

CREATE TABLE `wp_rank_math_analytics_ga` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `page` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `pageviews` mediumint(6) NOT NULL,
  `visitors` mediumint(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

ALTER TABLE `wp_rank_math_analytics_ga`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analytics_object_analytics` (`page`);

ALTER TABLE `wp_rank_math_analytics_ga`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;

CREATE TABLE `wp_rank_math_analytics_keyword_manager` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `keyword` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL,
  `collection` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

ALTER TABLE `wp_rank_math_analytics_keyword_manager`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `wp_rank_math_analytics_keyword_manager`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
COMMIT;