DROP TABLE IF EXISTS `rm_rank_math_redirections`;
CREATE TABLE `rm_rank_math_redirections` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sources` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `url_to` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `header_code` SMALLINT(4) UNSIGNED NOT NULL,
  `hits` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
  `status` VARCHAR(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `last_accessed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


DROP TABLE IF EXISTS `rm_rank_math_redirections_cache`;
CREATE TABLE `rm_rank_math_redirections_cache` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `from_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `redirection_id` BIGINT(20) UNSIGNED NOT NULL,
  `object_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
  `object_type` VARCHAR(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'post',
  `is_redirected` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `redirection_id` (`redirection_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;