Last active
September 26, 2020 14:15
-
-
Save lucanos/d479a26013569843cb18a0313b1b4445 to your computer and use it in GitHub Desktop.
WordPress Database Clean Sweep
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- ---------------------------------------------------------------------------- | |
| -- | |
| -- WordPress Database Clean Sweep | |
| -- ============================== | |
| -- | |
| -- NOTE: This SQL Script will completely delete any data in the Wordpress Tables | |
| -- starting with "wp_". Perform a backup before running this script. | |
| -- | |
| -- A New Admin User will be created by this script, with the following details: | |
| -- Username - new_admin | |
| -- Password - vIPdI$7gSoHWpuvPsJ | |
| -- Email - user@server.com | |
| -- | |
| -- Upon completion, the Wordpress Database will contain nothing but that User, | |
| -- some basic options, and post categories. | |
| -- | |
| -- Based on work at https://www.h3xed.com/web-development/wordpress-4-8-2-empty-clean-mysql-database-sql-file | |
| -- | |
| -- ---------------------------------------------------------------------------- | |
| SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO,ALLOW_INVALID_DATES"; | |
| SET time_zone = "+00:00"; | |
| /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; | |
| /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; | |
| /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; | |
| /*!40101 SET NAMES utf8mb4 */; | |
| -- | |
| -- Tables ===================================================================== | |
| -- | |
| -- User Tables | |
| DROP TABLE IF EXISTS `wp_users`; | |
| CREATE TABLE `wp_users` ( | |
| `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
| `user_login` varchar(60) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `user_pass` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `user_nicename` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `user_email` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `user_url` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `user_activation_key` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `user_status` int(11) NOT NULL DEFAULT '0', | |
| `display_name` varchar(250) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; | |
| ALTER TABLE `wp_users` | |
| ADD PRIMARY KEY (`ID`), | |
| ADD KEY `user_login_key` (`user_login`), | |
| ADD KEY `user_nicename` (`user_nicename`), | |
| ADD KEY `user_email` (`user_email`); | |
| DROP TABLE IF EXISTS `wp_usermeta`; | |
| CREATE TABLE `wp_usermeta` ( | |
| `umeta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
| `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', | |
| `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, | |
| `meta_value` longtext COLLATE utf8mb4_unicode_520_ci | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; | |
| ALTER TABLE `wp_usermeta` | |
| ADD PRIMARY KEY (`umeta_id`), | |
| ADD KEY `user_id` (`user_id`), | |
| ADD KEY `meta_key` (`meta_key`(191)); | |
| -- Option Table | |
| DROP TABLE IF EXISTS `wp_options`; | |
| CREATE TABLE `wp_options` ( | |
| `option_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
| `option_name` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `option_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL, | |
| `autoload` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'yes' | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; | |
| ALTER TABLE `wp_options` | |
| ADD PRIMARY KEY (`option_id`), | |
| ADD UNIQUE KEY `option_name` (`option_name`); | |
| -- Post Tables | |
| DROP TABLE IF EXISTS `wp_posts`; | |
| CREATE TABLE `wp_posts` ( | |
| `ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
| `post_author` bigint(20) UNSIGNED NOT NULL DEFAULT '0', | |
| `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `post_content` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL, | |
| `post_title` text COLLATE utf8mb4_unicode_520_ci NOT NULL, | |
| `post_excerpt` text COLLATE utf8mb4_unicode_520_ci NOT NULL, | |
| `post_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'publish', | |
| `comment_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open', | |
| `ping_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'open', | |
| `post_password` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `post_name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `to_ping` text COLLATE utf8mb4_unicode_520_ci NOT NULL, | |
| `pinged` text COLLATE utf8mb4_unicode_520_ci NOT NULL, | |
| `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `post_content_filtered` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL, | |
| `post_parent` bigint(20) UNSIGNED NOT NULL DEFAULT '0', | |
| `guid` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `menu_order` int(11) NOT NULL DEFAULT '0', | |
| `post_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'post', | |
| `post_mime_type` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `comment_count` bigint(20) NOT NULL DEFAULT '0' | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; | |
| ALTER TABLE `wp_posts` | |
| ADD PRIMARY KEY (`ID`), | |
| ADD KEY `post_name` (`post_name`(191)), | |
| ADD KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`), | |
| ADD KEY `post_parent` (`post_parent`), | |
| ADD KEY `post_author` (`post_author`); | |
| DROP TABLE IF EXISTS `wp_postmeta`; | |
| CREATE TABLE `wp_postmeta` ( | |
| `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
| `post_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', | |
| `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, | |
| `meta_value` longtext COLLATE utf8mb4_unicode_520_ci | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; | |
| ALTER TABLE `wp_postmeta` | |
| ADD PRIMARY KEY (`meta_id`), | |
| ADD KEY `post_id` (`post_id`), | |
| ADD KEY `meta_key` (`meta_key`(191)); | |
| -- Comment Tables | |
| DROP TABLE IF EXISTS `wp_comments`; | |
| CREATE TABLE `wp_comments` ( | |
| `comment_ID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
| `comment_post_ID` bigint(20) UNSIGNED NOT NULL DEFAULT '0', | |
| `comment_author` tinytext COLLATE utf8mb4_unicode_520_ci NOT NULL, | |
| `comment_author_email` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `comment_author_url` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `comment_author_IP` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `comment_content` text COLLATE utf8mb4_unicode_520_ci NOT NULL, | |
| `comment_karma` int(11) NOT NULL DEFAULT '0', | |
| `comment_approved` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '1', | |
| `comment_agent` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `comment_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `comment_parent` bigint(20) UNSIGNED NOT NULL DEFAULT '0', | |
| `user_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; | |
| ALTER TABLE `wp_comments` | |
| ADD PRIMARY KEY (`comment_ID`), | |
| ADD KEY `comment_post_ID` (`comment_post_ID`), | |
| ADD KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`), | |
| ADD KEY `comment_date_gmt` (`comment_date_gmt`), | |
| ADD KEY `comment_parent` (`comment_parent`), | |
| ADD KEY `comment_author_email` (`comment_author_email`(10)); | |
| DROP TABLE IF EXISTS `wp_commentmeta`; | |
| CREATE TABLE `wp_commentmeta` ( | |
| `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
| `comment_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', | |
| `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, | |
| `meta_value` longtext COLLATE utf8mb4_unicode_520_ci | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; | |
| ALTER TABLE `wp_commentmeta` | |
| ADD PRIMARY KEY (`meta_id`), | |
| ADD KEY `comment_id` (`comment_id`), | |
| ADD KEY `meta_key` (`meta_key`(191)); | |
| -- Term Tables | |
| DROP TABLE IF EXISTS `wp_terms`; | |
| CREATE TABLE `wp_terms` ( | |
| `term_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
| `name` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `slug` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `term_group` bigint(10) NOT NULL DEFAULT '0' | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; | |
| ALTER TABLE `wp_terms` | |
| ADD PRIMARY KEY (`term_id`), | |
| ADD KEY `slug` (`slug`(191)), | |
| ADD KEY `name` (`name`(191)); | |
| DROP TABLE IF EXISTS `wp_termmeta`; | |
| CREATE TABLE `wp_termmeta` ( | |
| `meta_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
| `term_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', | |
| `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL, | |
| `meta_value` longtext COLLATE utf8mb4_unicode_520_ci | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; | |
| ALTER TABLE `wp_termmeta` | |
| ADD PRIMARY KEY (`meta_id`), | |
| ADD KEY `term_id` (`term_id`), | |
| ADD KEY `meta_key` (`meta_key`(191)); | |
| DROP TABLE IF EXISTS `wp_term_taxonomy`; | |
| CREATE TABLE `wp_term_taxonomy` ( | |
| `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
| `term_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', | |
| `taxonomy` varchar(32) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `description` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL, | |
| `parent` bigint(20) UNSIGNED NOT NULL DEFAULT '0', | |
| `count` bigint(20) NOT NULL DEFAULT '0' | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; | |
| ALTER TABLE `wp_term_taxonomy` | |
| ADD PRIMARY KEY (`term_taxonomy_id`), | |
| ADD UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`), | |
| ADD KEY `taxonomy` (`taxonomy`); | |
| DROP TABLE IF EXISTS `wp_term_relationships`; | |
| CREATE TABLE `wp_term_relationships` ( | |
| `object_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', | |
| `term_taxonomy_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0', | |
| `term_order` int(11) NOT NULL DEFAULT '0' | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; | |
| ALTER TABLE `wp_term_relationships` | |
| ADD PRIMARY KEY (`object_id`,`term_taxonomy_id`), | |
| ADD KEY `term_taxonomy_id` (`term_taxonomy_id`); | |
| -- Link Table | |
| DROP TABLE IF EXISTS `wp_links`; | |
| CREATE TABLE `wp_links` ( | |
| `link_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, | |
| `link_url` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `link_name` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `link_image` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `link_target` varchar(25) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `link_description` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `link_visible` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y', | |
| `link_owner` bigint(20) UNSIGNED NOT NULL DEFAULT '1', | |
| `link_rating` int(11) NOT NULL DEFAULT '0', | |
| `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', | |
| `link_rel` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '', | |
| `link_notes` mediumtext COLLATE utf8mb4_unicode_520_ci NOT NULL, | |
| `link_rss` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci; | |
| ALTER TABLE `wp_links` | |
| ADD PRIMARY KEY (`link_id`), | |
| ADD KEY `link_visible` (`link_visible`); | |
| -- ---------------------------------------------------------------------------- | |
| -- | |
| -- Content ==================================================================== | |
| -- | |
| -- Users | |
| INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES | |
| ('new_admin', MD5('vIPdI$7gSoHWpuvPsJ'), 'new_admin', 'user@server.com', '', '2017-10-03 02:06:38', '', 0, 'new_admin'); | |
| INSERT INTO `wp_usermeta` (`user_id`, `meta_key`, `meta_value`) VALUES | |
| (1, 'nickname', 'admin'), | |
| (1, 'first_name', ''), | |
| (1, 'last_name', ''), | |
| (1, 'description', ''), | |
| (1, 'rich_editing', 'true'), | |
| (1, 'comment_shortcuts', 'false'), | |
| (1, 'admin_color', 'fresh'), | |
| (1, 'use_ssl', '0'), | |
| (1, 'show_admin_bar_front', 'true'), | |
| (1, 'locale', ''), | |
| (1, 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}'), | |
| (1, 'wp_user_level', '10'), | |
| (1, 'dismissed_wp_pointers', ''), | |
| (1, 'show_welcome_panel', '1'); | |
| -- Terms | |
| INSERT INTO `wp_terms` (`name`, `slug`, `term_group`) VALUES | |
| ('Uncategorized', 'uncategorized', 0); | |
| INSERT INTO `wp_term_taxonomy` (`term_id`, `taxonomy`, `description`, `parent`, `count`) VALUES | |
| (1, 'category', '', 0, 0); | |
| -- Options | |
| INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES | |
| ('siteurl', 'http://wordpress', 'yes'), | |
| ('home', 'http://wordpress', 'yes'), | |
| ('blogname', 'WordPress Site', 'yes'), | |
| ('blogdescription', 'Just another WordPress site', 'yes'), | |
| ('users_can_register', '0', 'yes'), | |
| ('admin_email', 'myemailaddress@emaildomain.com', 'yes'), | |
| ('start_of_week', '1', 'yes'), | |
| ('use_balanceTags', '0', 'yes'), | |
| ('use_smilies', '1', 'yes'), | |
| ('require_name_email', '1', 'yes'), | |
| ('comments_notify', '1', 'yes'), | |
| ('posts_per_rss', '10', 'yes'), | |
| ('rss_use_excerpt', '0', 'yes'), | |
| ('mailserver_url', 'mail.example.com', 'yes'), | |
| ('mailserver_login', 'login@example.com', 'yes'), | |
| ('mailserver_pass', 'password', 'yes'), | |
| ('mailserver_port', '110', 'yes'), | |
| ('default_category', '1', 'yes'), | |
| ('default_comment_status', 'open', 'yes'), | |
| ('default_ping_status', 'open', 'yes'), | |
| ('default_pingback_flag', '1', 'yes'), | |
| ('posts_per_page', '10', 'yes'), | |
| ('date_format', 'F j, Y', 'yes'), | |
| ('time_format', 'g:i a', 'yes'), | |
| ('links_updated_date_format', 'F j, Y g:i a', 'yes'), | |
| ('comment_moderation', '0', 'yes'), | |
| ('moderation_notify', '1', 'yes'), | |
| ('permalink_structure', '/%year%/%monthnum%/%day%/%postname%/', 'yes'), | |
| ('rewrite_rules', 'a:75:{s:11:"^wp-json/?$";s:22:"index.php?rest_route=/";s:14:"^wp-json/(.*)?";s:33:"index.php?rest_route=/$matches[1]";s:21:"^index.php/wp-json/?$";s:22:"index.php?rest_route=/";s:24:"^index.php/wp-json/(.*)?";s:33:"index.php?rest_route=/$matches[1]";s:12:"robots\\.txt$";s:18:"index.php?robots=1";s:48:".*wp-(atom|rdf|rss|rss2|feed|commentsrss2)\\.php$";s:18:"index.php?feed=old";s:20:".*wp-app\\.php(/.*)?$";s:19:"index.php?error=403";s:18:".*wp-register.php$";s:23:"index.php?register=true";s:32:"feed/(feed|rdf|rss|rss2|atom)/?$";s:27:"index.php?&feed=$matches[1]";s:27:"(feed|rdf|rss|rss2|atom)/?$";s:27:"index.php?&feed=$matches[1]";s:8:"embed/?$";s:21:"index.php?&embed=true";s:20:"page/?([0-9]{1,})/?$";s:28:"index.php?&paged=$matches[1]";s:41:"comments/feed/(feed|rdf|rss|rss2|atom)/?$";s:42:"index.php?&feed=$matches[1]&withcomments=1";s:36:"comments/(feed|rdf|rss|rss2|atom)/?$";s:42:"index.php?&feed=$matches[1]&withcomments=1";s:17:"comments/embed/?$";s:21:"index.php?&embed=true";s:44:"search/(.+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:40:"index.php?s=$matches[1]&feed=$matches[2]";s:39:"search/(.+)/(feed|rdf|rss|rss2|atom)/?$";s:40:"index.php?s=$matches[1]&feed=$matches[2]";s:20:"search/(.+)/embed/?$";s:34:"index.php?s=$matches[1]&embed=true";s:32:"search/(.+)/page/?([0-9]{1,})/?$";s:41:"index.php?s=$matches[1]&paged=$matches[2]";s:14:"search/(.+)/?$";s:23:"index.php?s=$matches[1]";s:47:"author/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:50:"index.php?author_name=$matches[1]&feed=$matches[2]";s:42:"author/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:50:"index.php?author_name=$matches[1]&feed=$matches[2]";s:23:"author/([^/]+)/embed/?$";s:44:"index.php?author_name=$matches[1]&embed=true";s:35:"author/([^/]+)/page/?([0-9]{1,})/?$";s:51:"index.php?author_name=$matches[1]&paged=$matches[2]";s:17:"author/([^/]+)/?$";s:33:"index.php?author_name=$matches[1]";s:69:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?$";s:80:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]";s:64:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?$";s:80:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&feed=$matches[4]";s:45:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/embed/?$";s:74:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&embed=true";s:57:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/page/?([0-9]{1,})/?$";s:81:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&paged=$matches[4]";s:39:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/?$";s:63:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]";s:56:"([0-9]{4})/([0-9]{1,2})/feed/(feed|rdf|rss|rss2|atom)/?$";s:64:"index.php?year=$matches[1]&monthnum=$matches[2]&feed=$matches[3]";s:51:"([0-9]{4})/([0-9]{1,2})/(feed|rdf|rss|rss2|atom)/?$";s:64:"index.php?year=$matches[1]&monthnum=$matches[2]&feed=$matches[3]";s:32:"([0-9]{4})/([0-9]{1,2})/embed/?$";s:58:"index.php?year=$matches[1]&monthnum=$matches[2]&embed=true";s:44:"([0-9]{4})/([0-9]{1,2})/page/?([0-9]{1,})/?$";s:65:"index.php?year=$matches[1]&monthnum=$matches[2]&paged=$matches[3]";s:26:"([0-9]{4})/([0-9]{1,2})/?$";s:47:"index.php?year=$matches[1]&monthnum=$matches[2]";s:43:"([0-9]{4})/feed/(feed|rdf|rss|rss2|atom)/?$";s:43:"index.php?year=$matches[1]&feed=$matches[2]";s:38:"([0-9]{4})/(feed|rdf|rss|rss2|atom)/?$";s:43:"index.php?year=$matches[1]&feed=$matches[2]";s:19:"([0-9]{4})/embed/?$";s:37:"index.php?year=$matches[1]&embed=true";s:31:"([0-9]{4})/page/?([0-9]{1,})/?$";s:44:"index.php?year=$matches[1]&paged=$matches[2]";s:13:"([0-9]{4})/?$";s:26:"index.php?year=$matches[1]";s:58:"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/?$";s:32:"index.php?attachment=$matches[1]";s:68:"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/trackback/?$";s:37:"index.php?attachment=$matches[1]&tb=1";s:88:"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:49:"index.php?attachment=$matches[1]&feed=$matches[2]";s:83:"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:49:"index.php?attachment=$matches[1]&feed=$matches[2]";s:83:"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/comment-page-([0-9]{1,})/?$";s:50:"index.php?attachment=$matches[1]&cpage=$matches[2]";s:64:"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/attachment/([^/]+)/embed/?$";s:43:"index.php?attachment=$matches[1]&embed=true";s:53:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)/embed/?$";s:91:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&embed=true";s:57:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)/trackback/?$";s:85:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&tb=1";s:77:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:97:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&feed=$matches[5]";s:72:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:97:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&feed=$matches[5]";s:65:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)/page/?([0-9]{1,})/?$";s:98:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&paged=$matches[5]";s:72:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)/comment-page-([0-9]{1,})/?$";s:98:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&cpage=$matches[5]";s:61:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/([^/]+)(?:/([0-9]+))?/?$";s:97:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&name=$matches[4]&page=$matches[5]";s:47:"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/([^/]+)/?$";s:32:"index.php?attachment=$matches[1]";s:57:"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/([^/]+)/trackback/?$";s:37:"index.php?attachment=$matches[1]&tb=1";s:77:"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:49:"index.php?attachment=$matches[1]&feed=$matches[2]";s:72:"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:49:"index.php?attachment=$matches[1]&feed=$matches[2]";s:72:"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/([^/]+)/comment-page-([0-9]{1,})/?$";s:50:"index.php?attachment=$matches[1]&cpage=$matches[2]";s:53:"[0-9]{4}/[0-9]{1,2}/[0-9]{1,2}/[^/]+/([^/]+)/embed/?$";s:43:"index.php?attachment=$matches[1]&embed=true";s:64:"([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/comment-page-([0-9]{1,})/?$";s:81:"index.php?year=$matches[1]&monthnum=$matches[2]&day=$matches[3]&cpage=$matches[4]";s:51:"([0-9]{4})/([0-9]{1,2})/comment-page-([0-9]{1,})/?$";s:65:"index.php?year=$matches[1]&monthnum=$matches[2]&cpage=$matches[3]";s:38:"([0-9]{4})/comment-page-([0-9]{1,})/?$";s:44:"index.php?year=$matches[1]&cpage=$matches[2]";s:27:".?.+?/attachment/([^/]+)/?$";s:32:"index.php?attachment=$matches[1]";s:37:".?.+?/attachment/([^/]+)/trackback/?$";s:37:"index.php?attachment=$matches[1]&tb=1";s:57:".?.+?/attachment/([^/]+)/feed/(feed|rdf|rss|rss2|atom)/?$";s:49:"index.php?attachment=$matches[1]&feed=$matches[2]";s:52:".?.+?/attachment/([^/]+)/(feed|rdf|rss|rss2|atom)/?$";s:49:"index.php?attachment=$matches[1]&feed=$matches[2]";s:52:".?.+?/attachment/([^/]+)/comment-page-([0-9]{1,})/?$";s:50:"index.php?attachment=$matches[1]&cpage=$matches[2]";s:33:".?.+?/attachment/([^/]+)/embed/?$";s:43:"index.php?attachment=$matches[1]&embed=true";s:16:"(.?.+?)/embed/?$";s:41:"index.php?pagename=$matches[1]&embed=true";s:20:"(.?.+?)/trackback/?$";s:35:"index.php?pagename=$matches[1]&tb=1";s:40:"(.?.+?)/feed/(feed|rdf|rss|rss2|atom)/?$";s:47:"index.php?pagename=$matches[1]&feed=$matches[2]";s:35:"(.?.+?)/(feed|rdf|rss|rss2|atom)/?$";s:47:"index.php?pagename=$matches[1]&feed=$matches[2]";s:28:"(.?.+?)/page/?([0-9]{1,})/?$";s:48:"index.php?pagename=$matches[1]&paged=$matches[2]";s:35:"(.?.+?)/comment-page-([0-9]{1,})/?$";s:48:"index.php?pagename=$matches[1]&cpage=$matches[2]";s:24:"(.?.+?)(?:/([0-9]+))?/?$";s:47:"index.php?pagename=$matches[1]&page=$matches[2]";}', 'yes'), | |
| ('hack_file', '0', 'yes'), | |
| ('blog_charset', 'UTF-8', 'yes'), | |
| ('moderation_keys', '', 'no'), | |
| ('active_plugins', 'a:0:{}', 'yes'), | |
| ('category_base', '', 'yes'), | |
| ('ping_sites', 'http://rpc.pingomatic.com/', 'yes'), | |
| ('comment_max_links', '2', 'yes'), | |
| ('gmt_offset', '0', 'yes'), | |
| ('default_email_category', '1', 'yes'), | |
| ('recently_edited', '', 'no'), | |
| ('template', 'twentytwenty', 'yes'), | |
| ('stylesheet', 'twentytwenty', 'yes'), | |
| ('comment_whitelist', '1', 'yes'), | |
| ('blacklist_keys', '', 'no'), | |
| ('comment_registration', '0', 'yes'), | |
| ('html_type', 'text/html', 'yes'), | |
| ('use_trackback', '0', 'yes'), | |
| ('default_role', 'subscriber', 'yes'), | |
| ('db_version', '38590', 'yes'), | |
| ('uploads_use_yearmonth_folders', '1', 'yes'), | |
| ('upload_path', '', 'yes'), | |
| ('blog_public', '1', 'yes'), | |
| ('default_link_category', '2', 'yes'), | |
| ('show_on_front', 'posts', 'yes'), | |
| ('tag_base', '', 'yes'), | |
| ('show_avatars', '1', 'yes'), | |
| ('avatar_rating', 'G', 'yes'), | |
| ('upload_url_path', '', 'yes'), | |
| ('thumbnail_size_w', '150', 'yes'), | |
| ('thumbnail_size_h', '150', 'yes'), | |
| ('thumbnail_crop', '1', 'yes'), | |
| ('medium_size_w', '300', 'yes'), | |
| ('medium_size_h', '300', 'yes'), | |
| ('avatar_default', 'mystery', 'yes'), | |
| ('large_size_w', '1024', 'yes'), | |
| ('large_size_h', '1024', 'yes'), | |
| ('image_default_link_type', 'none', 'yes'), | |
| ('image_default_size', '', 'yes'), | |
| ('image_default_align', '', 'yes'), | |
| ('close_comments_for_old_posts', '0', 'yes'), | |
| ('close_comments_days_old', '14', 'yes'), | |
| ('thread_comments', '1', 'yes'), | |
| ('thread_comments_depth', '5', 'yes'), | |
| ('page_comments', '0', 'yes'), | |
| ('comments_per_page', '50', 'yes'), | |
| ('default_comments_page', 'newest', 'yes'), | |
| ('comment_order', 'asc', 'yes'), | |
| ('sticky_posts', 'a:0:{}', 'yes'), | |
| ('widget_categories', 'a:2:{i:2;a:4:{s:5:"title";s:0:"";s:5:"count";i:0;s:12:"hierarchical";i:0;s:8:"dropdown";i:0;}s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('widget_text', 'a:0:{}', 'yes'), | |
| ('widget_rss', 'a:0:{}', 'yes'), | |
| ('uninstall_plugins', 'a:0:{}', 'no'), | |
| ('timezone_string', '', 'yes'), | |
| ('page_for_posts', '0', 'yes'), | |
| ('page_on_front', '0', 'yes'), | |
| ('default_post_format', '0', 'yes'), | |
| ('link_manager_enabled', '0', 'yes'), | |
| ('finished_splitting_shared_terms', '1', 'yes'), | |
| ('site_icon', '0', 'yes'), | |
| ('medium_large_size_w', '768', 'yes'), | |
| ('medium_large_size_h', '0', 'yes'), | |
| ('initial_db_version', '38590', 'yes'), | |
| ('wp_user_roles', 'a:5:{s:13:"administrator";a:2:{s:4:"name";s:13:"Administrator";s:12:"capabilities";a:61:{s:13:"switch_themes";b:1;s:11:"edit_themes";b:1;s:16:"activate_plugins";b:1;s:12:"edit_plugins";b:1;s:10:"edit_users";b:1;s:10:"edit_files";b:1;s:14:"manage_options";b:1;s:17:"moderate_comments";b:1;s:17:"manage_categories";b:1;s:12:"manage_links";b:1;s:12:"upload_files";b:1;s:6:"import";b:1;s:15:"unfiltered_html";b:1;s:10:"edit_posts";b:1;s:17:"edit_others_posts";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_posts";b:1;s:10:"edit_pages";b:1;s:4:"read";b:1;s:8:"level_10";b:1;s:7:"level_9";b:1;s:7:"level_8";b:1;s:7:"level_7";b:1;s:7:"level_6";b:1;s:7:"level_5";b:1;s:7:"level_4";b:1;s:7:"level_3";b:1;s:7:"level_2";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:17:"edit_others_pages";b:1;s:20:"edit_published_pages";b:1;s:13:"publish_pages";b:1;s:12:"delete_pages";b:1;s:19:"delete_others_pages";b:1;s:22:"delete_published_pages";b:1;s:12:"delete_posts";b:1;s:19:"delete_others_posts";b:1;s:22:"delete_published_posts";b:1;s:20:"delete_private_posts";b:1;s:18:"edit_private_posts";b:1;s:18:"read_private_posts";b:1;s:20:"delete_private_pages";b:1;s:18:"edit_private_pages";b:1;s:18:"read_private_pages";b:1;s:12:"delete_users";b:1;s:12:"create_users";b:1;s:17:"unfiltered_upload";b:1;s:14:"edit_dashboard";b:1;s:14:"update_plugins";b:1;s:14:"delete_plugins";b:1;s:15:"install_plugins";b:1;s:13:"update_themes";b:1;s:14:"install_themes";b:1;s:11:"update_core";b:1;s:10:"list_users";b:1;s:12:"remove_users";b:1;s:13:"promote_users";b:1;s:18:"edit_theme_options";b:1;s:13:"delete_themes";b:1;s:6:"export";b:1;}}s:6:"editor";a:2:{s:4:"name";s:6:"Editor";s:12:"capabilities";a:34:{s:17:"moderate_comments";b:1;s:17:"manage_categories";b:1;s:12:"manage_links";b:1;s:12:"upload_files";b:1;s:15:"unfiltered_html";b:1;s:10:"edit_posts";b:1;s:17:"edit_others_posts";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_posts";b:1;s:10:"edit_pages";b:1;s:4:"read";b:1;s:7:"level_7";b:1;s:7:"level_6";b:1;s:7:"level_5";b:1;s:7:"level_4";b:1;s:7:"level_3";b:1;s:7:"level_2";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:17:"edit_others_pages";b:1;s:20:"edit_published_pages";b:1;s:13:"publish_pages";b:1;s:12:"delete_pages";b:1;s:19:"delete_others_pages";b:1;s:22:"delete_published_pages";b:1;s:12:"delete_posts";b:1;s:19:"delete_others_posts";b:1;s:22:"delete_published_posts";b:1;s:20:"delete_private_posts";b:1;s:18:"edit_private_posts";b:1;s:18:"read_private_posts";b:1;s:20:"delete_private_pages";b:1;s:18:"edit_private_pages";b:1;s:18:"read_private_pages";b:1;}}s:6:"author";a:2:{s:4:"name";s:6:"Author";s:12:"capabilities";a:10:{s:12:"upload_files";b:1;s:10:"edit_posts";b:1;s:20:"edit_published_posts";b:1;s:13:"publish_posts";b:1;s:4:"read";b:1;s:7:"level_2";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:12:"delete_posts";b:1;s:22:"delete_published_posts";b:1;}}s:11:"contributor";a:2:{s:4:"name";s:11:"Contributor";s:12:"capabilities";a:5:{s:10:"edit_posts";b:1;s:4:"read";b:1;s:7:"level_1";b:1;s:7:"level_0";b:1;s:12:"delete_posts";b:1;}}s:10:"subscriber";a:2:{s:4:"name";s:10:"Subscriber";s:12:"capabilities";a:2:{s:4:"read";b:1;s:7:"level_0";b:1;}}}', 'yes'), | |
| ('fresh_site', '1', 'yes'), | |
| ('widget_search', 'a:2:{i:2;a:1:{s:5:"title";s:0:"";}s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('widget_recent-posts', 'a:2:{i:2;a:2:{s:5:"title";s:0:"";s:6:"number";i:5;}s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('widget_recent-comments', 'a:2:{i:2;a:2:{s:5:"title";s:0:"";s:6:"number";i:5;}s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('widget_archives', 'a:2:{i:2;a:3:{s:5:"title";s:0:"";s:5:"count";i:0;s:8:"dropdown";i:0;}s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('widget_meta', 'a:2:{i:2;a:1:{s:5:"title";s:0:"";}s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('sidebars_widgets', 'a:5:{s:19:"wp_inactive_widgets";a:0:{}s:9:"sidebar-1";a:6:{i:0;s:8:"search-2";i:1;s:14:"recent-posts-2";i:2;s:17:"recent-comments-2";i:3;s:10:"archives-2";i:4;s:12:"categories-2";i:5;s:6:"meta-2";}s:9:"sidebar-2";a:0:{}s:9:"sidebar-3";a:0:{}s:13:"array_version";i:3;}', 'yes'), | |
| ('widget_pages', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('widget_calendar', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('widget_media_audio', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('widget_media_image', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('widget_media_video', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('widget_tag_cloud', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('widget_nav_menu', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('widget_custom_html', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'), | |
| ('cron', 'a:2:{i:1506996627;a:3:{s:16:"wp_version_check";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:10:"twicedaily";s:4:"args";a:0:{}s:8:"interval";i:43200;}}s:17:"wp_update_plugins";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:10:"twicedaily";s:4:"args";a:0:{}s:8:"interval";i:43200;}}s:16:"wp_update_themes";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:10:"twicedaily";s:4:"args";a:0:{}s:8:"interval";i:43200;}}}s:7:"version";i:2;}', 'yes'), | |
| ('theme_mods_twentyseventeen', 'a:1:{s:18:"custom_css_post_id";i:-1;}', 'yes'), | |
| ('_transient_is_multi_author', '0', 'yes'), | |
| ('_transient_twentyseventeen_categories', '1', 'yes'); | |
| /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; | |
| /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; | |
| /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment