Advertisement
jaideep06

Analytics table

May 17th, 2024
433
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JSON 0.63 KB | None | 0 0
  1. CREATE TABLE `wp_rank_math_analytics_ga` (
  2.   `id` bigint(20) UNSIGNED NOT NULL,
  3.   `page` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  4.   `created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  5.   `pageviews` mediumint(6) NOT NULL,
  6.   `visitors` mediumint(6) NOT NULL
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
  8.  
  9. ALTER TABLE `wp_rank_math_analytics_ga`
  10.   ADD PRIMARY KEY (`id`),
  11.   ADD KEY `analytics_object_analytics` (`page`);
  12.  
  13. ALTER TABLE `wp_rank_math_analytics_ga`
  14.   MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
  15. COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement