Table creation

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;