kgZsFubg

1DROP TABLE IF EXISTS `rm_rank_math_redirections`;
2CREATE TABLE `rm_rank_math_redirections` (
3  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4  `sources` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
5  `url_to` text COLLATE utf8mb4_unicode_ci NOT NULL,
6  `header_code` smallint(4) unsigned NOT NULL,
7  `hits` bigint(20) unsigned NOT NULL DEFAULT 0,
8  `status` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
9  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
10  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
11  `last_accessed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
12  PRIMARY KEY (`id`),
13  KEY `status` (`status`)
14) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
15
16
17DROP TABLE IF EXISTS `rm_rank_math_redirections_cache`;
18CREATE TABLE `rm_rank_math_redirections_cache` (
19  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
20  `from_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
21  `redirection_id` bigint(20) unsigned NOT NULL,
22  `object_id` bigint(20) unsigned NOT NULL DEFAULT 0,
23  `object_type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'post',
24  `is_redirected` tinyint(1) NOT NULL DEFAULT 0,
25  PRIMARY KEY (`id`),
26  KEY `redirection_id` (`redirection_id`)
27) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;