· 6 years ago · Jul 31, 2019, 03:04 PM
1DROP TABLE IF EXISTS `wp_rank_math_redirections`;
2CREATE TABLE IF NOT EXISTS `wp_rank_math_redirections` (
3 `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
4 `sources` text COLLATE utf8mb4_unicode_520_ci NOT NULL,
5 `url_to` text COLLATE utf8mb4_unicode_520_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_520_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 AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;