· 4 years ago · May 25, 2021, 08:46 AM
1DROP TABLE IF EXISTS `wp_rank_math_404_logs`;
2CREATE TABLE `wp_rank_math_404_logs` (
3 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4 `uri` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
5 `accessed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
6 `times_accessed` bigint(20) unsigned NOT NULL DEFAULT 1,
7 `ip` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
8 `referer` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
9 `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
10 PRIMARY KEY (`id`),
11 KEY `uri` (`uri`(191))
12) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;