Edit File by line
/home/barbar84/www/wp-conte.../plugins/sujqvwi/ShExBy/shex_roo.../var/softacul.../sp
File: sp.sql
[0] Fix | Delete
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
[1] Fix | Delete
SET time_zone = "+00:00";
[2] Fix | Delete
[3] Fix | Delete
[4] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
[5] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
[6] Fix | Delete
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
[7] Fix | Delete
/*!40101 SET NAMES utf8 */;
[8] Fix | Delete
[9] Fix | Delete
--
[10] Fix | Delete
-- Database: `sitepad`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `[[dbprefix]]commentmeta`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `[[dbprefix]]commentmeta` (
[20] Fix | Delete
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[21] Fix | Delete
`comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
[22] Fix | Delete
`meta_key` varchar(255) COLLATE [[collate]] DEFAULT NULL,
[23] Fix | Delete
`meta_value` longtext COLLATE [[collate]],
[24] Fix | Delete
PRIMARY KEY (`meta_id`),
[25] Fix | Delete
KEY `comment_id` (`comment_id`),
[26] Fix | Delete
KEY `meta_key` (`meta_key`(191))
[27] Fix | Delete
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=1 ;
[28] Fix | Delete
[29] Fix | Delete
-- --------------------------------------------------------
[30] Fix | Delete
[31] Fix | Delete
--
[32] Fix | Delete
-- Table structure for table `[[dbprefix]]comments`
[33] Fix | Delete
--
[34] Fix | Delete
[35] Fix | Delete
CREATE TABLE `[[dbprefix]]comments` (
[36] Fix | Delete
`comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[37] Fix | Delete
`comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
[38] Fix | Delete
`comment_author` tinytext COLLATE [[collate]] NOT NULL,
[39] Fix | Delete
`comment_author_email` varchar(100) COLLATE [[collate]] NOT NULL DEFAULT '',
[40] Fix | Delete
`comment_author_url` varchar(200) COLLATE [[collate]] NOT NULL DEFAULT '',
[41] Fix | Delete
`comment_author_IP` varchar(100) COLLATE [[collate]] NOT NULL DEFAULT '',
[42] Fix | Delete
`comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[43] Fix | Delete
`comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[44] Fix | Delete
`comment_content` text COLLATE [[collate]] NOT NULL,
[45] Fix | Delete
`comment_karma` int(11) NOT NULL DEFAULT '0',
[46] Fix | Delete
`comment_approved` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT '1',
[47] Fix | Delete
`comment_agent` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
[48] Fix | Delete
`comment_type` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT '',
[49] Fix | Delete
`comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
[50] Fix | Delete
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
[51] Fix | Delete
PRIMARY KEY (`comment_ID`),
[52] Fix | Delete
KEY `comment_post_ID` (`comment_post_ID`),
[53] Fix | Delete
KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
[54] Fix | Delete
KEY `comment_date_gmt` (`comment_date_gmt`),
[55] Fix | Delete
KEY `comment_parent` (`comment_parent`),
[56] Fix | Delete
KEY `comment_author_email` (`comment_author_email`(10))
[57] Fix | Delete
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=2 ;
[58] Fix | Delete
[59] Fix | Delete
-- --------------------------------------------------------
[60] Fix | Delete
[61] Fix | Delete
--
[62] Fix | Delete
-- Table structure for table `[[dbprefix]]links`
[63] Fix | Delete
--
[64] Fix | Delete
[65] Fix | Delete
CREATE TABLE `[[dbprefix]]links` (
[66] Fix | Delete
`link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[67] Fix | Delete
`link_url` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
[68] Fix | Delete
`link_name` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
[69] Fix | Delete
`link_image` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
[70] Fix | Delete
`link_target` varchar(25) COLLATE [[collate]] NOT NULL DEFAULT '',
[71] Fix | Delete
`link_description` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
[72] Fix | Delete
`link_visible` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT 'Y',
[73] Fix | Delete
`link_owner` bigint(20) unsigned NOT NULL DEFAULT '1',
[74] Fix | Delete
`link_rating` int(11) NOT NULL DEFAULT '0',
[75] Fix | Delete
`link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[76] Fix | Delete
`link_rel` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
[77] Fix | Delete
`link_notes` mediumtext COLLATE [[collate]] NOT NULL,
[78] Fix | Delete
`link_rss` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
[79] Fix | Delete
PRIMARY KEY (`link_id`),
[80] Fix | Delete
KEY `link_visible` (`link_visible`)
[81] Fix | Delete
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=1 ;
[82] Fix | Delete
[83] Fix | Delete
-- --------------------------------------------------------
[84] Fix | Delete
[85] Fix | Delete
--
[86] Fix | Delete
-- Table structure for table `[[dbprefix]]options`
[87] Fix | Delete
--
[88] Fix | Delete
[89] Fix | Delete
CREATE TABLE `[[dbprefix]]options` (
[90] Fix | Delete
`option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[91] Fix | Delete
`option_name` varchar(191) COLLATE [[collate]] NOT NULL DEFAULT '',
[92] Fix | Delete
`option_value` longtext COLLATE [[collate]] NOT NULL,
[93] Fix | Delete
`autoload` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT 'yes',
[94] Fix | Delete
PRIMARY KEY (`option_id`),
[95] Fix | Delete
UNIQUE KEY `option_name` (`option_name`)
[96] Fix | Delete
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=113 ;
[97] Fix | Delete
[98] Fix | Delete
--
[99] Fix | Delete
-- Dumping data for table `[[dbprefix]]options`
[100] Fix | Delete
--
[101] Fix | Delete
[102] Fix | Delete
INSERT INTO `[[dbprefix]]options` VALUES
[103] Fix | Delete
(1, 'siteurl', '[[softurl]]', 'yes'),
[104] Fix | Delete
(2, 'home', '[[softurl]]', 'yes'),
[105] Fix | Delete
(3, 'blogname', '[[site_name]]', 'yes'),
[106] Fix | Delete
(4, 'blogdescription', '[[site_desc]]', 'yes'),
[107] Fix | Delete
(5, 'users_can_register', '0', 'yes'),
[108] Fix | Delete
(6, 'admin_email', '[[admin_email]]', 'yes'),
[109] Fix | Delete
(7, 'start_of_week', '1', 'yes'),
[110] Fix | Delete
(8, 'use_balanceTags', '0', 'yes'),
[111] Fix | Delete
(9, 'use_smilies', '1', 'yes'),
[112] Fix | Delete
(10, 'require_name_email', '1', 'yes'),
[113] Fix | Delete
(11, 'comments_notify', '1', 'yes'),
[114] Fix | Delete
(12, 'posts_per_rss', '10', 'yes'),
[115] Fix | Delete
(13, 'rss_use_excerpt', '0', 'yes'),
[116] Fix | Delete
(14, 'mailserver_url', 'mail.example.com', 'yes'),
[117] Fix | Delete
(15, 'mailserver_login', 'login@example.com', 'yes'),
[118] Fix | Delete
(16, 'mailserver_pass', 'password', 'yes'),
[119] Fix | Delete
(17, 'mailserver_port', '110', 'yes'),
[120] Fix | Delete
(18, 'default_category', '1', 'yes'),
[121] Fix | Delete
(19, 'default_comment_status', 'open', 'yes'),
[122] Fix | Delete
(20, 'default_ping_status', 'open', 'yes'),
[123] Fix | Delete
(21, 'default_pingback_flag', '1', 'yes'),
[124] Fix | Delete
(22, 'posts_per_page', '10', 'yes'),
[125] Fix | Delete
(23, 'date_format', 'F j, Y', 'yes'),
[126] Fix | Delete
(24, 'time_format', 'g:i a', 'yes'),
[127] Fix | Delete
(25, 'links_updated_date_format', 'F j, Y g:i a', 'yes'),
[128] Fix | Delete
(26, 'comment_moderation', '0', 'yes'),
[129] Fix | Delete
(27, 'moderation_notify', '1', 'yes'),
[130] Fix | Delete
(28, 'permalink_structure', '/blog/%year%/%monthnum%/%day%/%postname%/', 'yes'),
[131] Fix | Delete
(29, 'rewrite_rules', '', 'yes'),
[132] Fix | Delete
(30, 'hack_file', '0', 'yes'),
[133] Fix | Delete
(31, 'blog_charset', 'UTF-8', 'yes'),
[134] Fix | Delete
(32, 'moderation_keys', '', 'no'),
[135] Fix | Delete
(33, 'active_plugins', '[[active_plugins]]', 'yes'),
[136] Fix | Delete
(34, 'category_base', '', 'yes'),
[137] Fix | Delete
(35, 'ping_sites', 'http://rpc.pingomatic.com/', 'yes'),
[138] Fix | Delete
(36, 'comment_max_links', '2', 'yes'),
[139] Fix | Delete
(37, 'gmt_offset', '0', 'yes'),
[140] Fix | Delete
(38, 'default_email_category', '1', 'yes'),
[141] Fix | Delete
(39, 'recently_edited', '', 'no'),
[142] Fix | Delete
(40, 'template', '[[theme_name]]', 'yes'),
[143] Fix | Delete
(41, 'stylesheet', '[[theme_name]]', 'yes'),
[144] Fix | Delete
(42, 'comment_whitelist', '1', 'yes'),
[145] Fix | Delete
(43, 'blacklist_keys', '', 'no'),
[146] Fix | Delete
(44, 'comment_registration', '0', 'yes'),
[147] Fix | Delete
(45, 'html_type', 'text/html', 'yes'),
[148] Fix | Delete
(46, 'use_trackback', '0', 'yes'),
[149] Fix | Delete
(47, 'default_role', 'subscriber', 'yes'),
[150] Fix | Delete
(48, 'db_version', '44719', 'yes'),
[151] Fix | Delete
(49, 'uploads_use_yearmonth_folders', '1', 'yes'),
[152] Fix | Delete
(50, 'upload_path', '', 'yes'),
[153] Fix | Delete
(51, 'blog_public', '1', 'yes'),
[154] Fix | Delete
(52, 'default_link_category', '2', 'yes'),
[155] Fix | Delete
(53, 'show_on_front', 'page', 'yes'),
[156] Fix | Delete
(54, 'tag_base', '', 'yes'),
[157] Fix | Delete
(55, 'show_avatars', '1', 'yes'),
[158] Fix | Delete
(56, 'avatar_rating', 'G', 'yes'),
[159] Fix | Delete
(57, 'upload_url_path','[[uploads_url]]','yes'),
[160] Fix | Delete
(58, 'thumbnail_size_w', '150', 'yes'),
[161] Fix | Delete
(59, 'thumbnail_size_h', '150', 'yes'),
[162] Fix | Delete
(60, 'thumbnail_crop', '1', 'yes'),
[163] Fix | Delete
(61, 'medium_size_w', '300', 'yes'),
[164] Fix | Delete
(62, 'medium_size_h', '300', 'yes'),
[165] Fix | Delete
(63, 'avatar_default', 'mystery', 'yes'),
[166] Fix | Delete
(64, 'large_size_w', '1024', 'yes'),
[167] Fix | Delete
(65, 'large_size_h', '1024', 'yes'),
[168] Fix | Delete
(66, 'image_default_link_type', 'none', 'yes'),
[169] Fix | Delete
(67, 'image_default_size', '', 'yes'),
[170] Fix | Delete
(68, 'image_default_align', '', 'yes'),
[171] Fix | Delete
(69, 'close_comments_for_old_posts', '0', 'yes'),
[172] Fix | Delete
(70, 'close_comments_days_old', '14', 'yes'),
[173] Fix | Delete
(71, 'thread_comments', '1', 'yes'),
[174] Fix | Delete
(72, 'thread_comments_depth', '5', 'yes'),
[175] Fix | Delete
(73, 'page_comments', '0', 'yes'),
[176] Fix | Delete
(74, 'comments_per_page', '50', 'yes'),
[177] Fix | Delete
(75, 'default_comments_page', 'newest', 'yes'),
[178] Fix | Delete
(76, 'comment_order', 'asc', 'yes'),
[179] Fix | Delete
(77, 'sticky_posts', 'a:0:{}', 'yes'),
[180] Fix | Delete
(78, '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'),
[181] Fix | Delete
(79, 'widget_text', 'a:0:{}', 'yes'),
[182] Fix | Delete
(80, 'widget_rss', 'a:0:{}', 'yes'),
[183] Fix | Delete
(81, 'uninstall_plugins', 'a:0:{}', 'no'),
[184] Fix | Delete
(82, 'timezone_string', '', 'yes'),
[185] Fix | Delete
(83, 'page_for_posts', '0', 'yes'),
[186] Fix | Delete
(84, 'page_on_front', '0', 'yes'),
[187] Fix | Delete
(85, 'default_post_format', '0', 'yes'),
[188] Fix | Delete
(86, 'link_manager_enabled', '0', 'yes'),
[189] Fix | Delete
(87, 'finished_splitting_shared_terms', '1', 'yes'),
[190] Fix | Delete
(88, 'site_icon', '0', 'yes'),
[191] Fix | Delete
(89, 'medium_large_size_w', '768', 'yes'),
[192] Fix | Delete
(90, 'medium_large_size_h', '0', 'yes'),
[193] Fix | Delete
(91, 'wp_page_for_privacy_policy', '3', 'yes'),
[194] Fix | Delete
(92, 'show_comments_cookies_opt_in', '1', 'yes'),
[195] Fix | Delete
(93, 'initial_db_version', '44719', 'yes'),
[196] Fix | Delete
(94, '[[dbprefix]]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'),
[197] Fix | Delete
(95, 'fresh_site', '1', 'yes'),
[198] Fix | Delete
(96, 'widget_search', 'a:2:{i:2;a:1:{s:5:"title";s:0:"";}s:12:"_multiwidget";i:1;}', 'yes'),
[199] Fix | Delete
(97, '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'),
[200] Fix | Delete
(98, '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'),
[201] Fix | Delete
(99, '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'),
[202] Fix | Delete
(100, 'widget_meta', 'a:2:{i:2;a:1:{s:5:"title";s:0:"";}s:12:"_multiwidget";i:1;}', 'yes'),
[203] Fix | Delete
(101, 'sidebars_widgets', 'a:3:{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:13:"array_version";i:3;}', 'yes'),
[204] Fix | Delete
(102, 'widget_pages', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
[205] Fix | Delete
(103, 'widget_calendar', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
[206] Fix | Delete
(104, 'widget_media_audio', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
[207] Fix | Delete
(105, 'widget_media_image', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
[208] Fix | Delete
(106, 'widget_media_gallery', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
[209] Fix | Delete
(107, 'widget_media_video', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
[210] Fix | Delete
(108, 'widget_tag_cloud', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
[211] Fix | Delete
(109, 'widget_nav_menu', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
[212] Fix | Delete
(110, 'widget_custom_html', 'a:1:{s:12:"_multiwidget";i:1;}', 'yes'),
[213] Fix | Delete
(111, 'cron', 'a:4:{i:[[timestamp]];a:4:{s:34:"wp_privacy_delete_old_export_files";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:6:"hourly";s:4:"args";a:0:{}s:8:"interval";i:3600;}}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;}}}i:[[timestamp]];a:2:{s:19:"wp_scheduled_delete";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:5:"daily";s:4:"args";a:0:{}s:8:"interval";i:86400;}}s:25:"delete_expired_transients";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:5:"daily";s:4:"args";a:0:{}s:8:"interval";i:86400;}}}i:[[timestamp]];a:1:{s:30:"wp_scheduled_auto_draft_delete";a:1:{s:32:"40cd750bba9870f18aada2478b24840a";a:3:{s:8:"schedule";s:5:"daily";s:4:"args";a:0:{}s:8:"interval";i:86400;}}}s:7:"version";i:2;}', 'yes'),
[214] Fix | Delete
(112, 'can_compress_scripts', '0', 'no'),
[215] Fix | Delete
(113, 'sp-login', '', 'no');
[216] Fix | Delete
-- --------------------------------------------------------
[217] Fix | Delete
[218] Fix | Delete
--
[219] Fix | Delete
-- Table structure for table `[[dbprefix]]postmeta`
[220] Fix | Delete
--
[221] Fix | Delete
[222] Fix | Delete
CREATE TABLE `[[dbprefix]]postmeta` (
[223] Fix | Delete
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[224] Fix | Delete
`post_id` bigint(20) unsigned NOT NULL DEFAULT '0',
[225] Fix | Delete
`meta_key` varchar(255) COLLATE [[collate]] DEFAULT NULL,
[226] Fix | Delete
`meta_value` longtext COLLATE [[collate]],
[227] Fix | Delete
PRIMARY KEY (`meta_id`),
[228] Fix | Delete
KEY `post_id` (`post_id`),
[229] Fix | Delete
KEY `meta_key` (`meta_key`(191))
[230] Fix | Delete
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=1 ;
[231] Fix | Delete
[232] Fix | Delete
[233] Fix | Delete
-- --------------------------------------------------------
[234] Fix | Delete
[235] Fix | Delete
--
[236] Fix | Delete
-- Table structure for table `[[dbprefix]]posts`
[237] Fix | Delete
--
[238] Fix | Delete
[239] Fix | Delete
CREATE TABLE `[[dbprefix]]posts` (
[240] Fix | Delete
`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[241] Fix | Delete
`post_author` bigint(20) unsigned NOT NULL DEFAULT '0',
[242] Fix | Delete
`post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[243] Fix | Delete
`post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[244] Fix | Delete
`post_content` longtext COLLATE [[collate]] NOT NULL,
[245] Fix | Delete
`post_title` text COLLATE [[collate]] NOT NULL,
[246] Fix | Delete
`post_excerpt` text COLLATE [[collate]] NOT NULL,
[247] Fix | Delete
`post_status` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT 'publish',
[248] Fix | Delete
`comment_status` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT 'open',
[249] Fix | Delete
`ping_status` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT 'open',
[250] Fix | Delete
`post_password` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
[251] Fix | Delete
`post_name` varchar(200) COLLATE [[collate]] NOT NULL DEFAULT '',
[252] Fix | Delete
`to_ping` text COLLATE [[collate]] NOT NULL,
[253] Fix | Delete
`pinged` text COLLATE [[collate]] NOT NULL,
[254] Fix | Delete
`post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[255] Fix | Delete
`post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[256] Fix | Delete
`post_content_filtered` longtext COLLATE [[collate]] NOT NULL,
[257] Fix | Delete
`post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
[258] Fix | Delete
`guid` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
[259] Fix | Delete
`menu_order` int(11) NOT NULL DEFAULT '0',
[260] Fix | Delete
`post_type` varchar(20) COLLATE [[collate]] NOT NULL DEFAULT 'post',
[261] Fix | Delete
`post_mime_type` varchar(100) COLLATE [[collate]] NOT NULL DEFAULT '',
[262] Fix | Delete
`comment_count` bigint(20) NOT NULL DEFAULT '0',
[263] Fix | Delete
PRIMARY KEY (`ID`),
[264] Fix | Delete
KEY `post_name` (`post_name`(191)),
[265] Fix | Delete
KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
[266] Fix | Delete
KEY `post_parent` (`post_parent`),
[267] Fix | Delete
KEY `post_author` (`post_author`)
[268] Fix | Delete
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=1 ;
[269] Fix | Delete
[270] Fix | Delete
--
[271] Fix | Delete
-- Table structure for table `[[dbprefix]]termmeta`
[272] Fix | Delete
--
[273] Fix | Delete
[274] Fix | Delete
CREATE TABLE `[[dbprefix]]termmeta` (
[275] Fix | Delete
`meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[276] Fix | Delete
`term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
[277] Fix | Delete
`meta_key` varchar(255) COLLATE [[collate]] DEFAULT NULL,
[278] Fix | Delete
`meta_value` longtext COLLATE [[collate]],
[279] Fix | Delete
PRIMARY KEY (`meta_id`),
[280] Fix | Delete
KEY `term_id` (`term_id`),
[281] Fix | Delete
KEY `meta_key` (`meta_key`(191))
[282] Fix | Delete
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=1 ;
[283] Fix | Delete
[284] Fix | Delete
-- --------------------------------------------------------
[285] Fix | Delete
[286] Fix | Delete
--
[287] Fix | Delete
-- Table structure for table `[[dbprefix]]terms`
[288] Fix | Delete
--
[289] Fix | Delete
[290] Fix | Delete
CREATE TABLE `[[dbprefix]]terms` (
[291] Fix | Delete
`term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[292] Fix | Delete
`name` varchar(200) COLLATE [[collate]] NOT NULL DEFAULT '',
[293] Fix | Delete
`slug` varchar(200) COLLATE [[collate]] NOT NULL DEFAULT '',
[294] Fix | Delete
`term_group` bigint(10) NOT NULL DEFAULT '0',
[295] Fix | Delete
PRIMARY KEY (`term_id`),
[296] Fix | Delete
KEY `slug` (`slug`(191)),
[297] Fix | Delete
KEY `name` (`name`(191))
[298] Fix | Delete
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=2 ;
[299] Fix | Delete
[300] Fix | Delete
--
[301] Fix | Delete
-- Dumping data for table `[[dbprefix]]terms`
[302] Fix | Delete
--
[303] Fix | Delete
[304] Fix | Delete
INSERT INTO `[[dbprefix]]terms` VALUES
[305] Fix | Delete
(1, 'Uncategorized', 'uncategorized', 0);
[306] Fix | Delete
[307] Fix | Delete
-- --------------------------------------------------------
[308] Fix | Delete
[309] Fix | Delete
--
[310] Fix | Delete
-- Table structure for table `[[dbprefix]]term_relationships`
[311] Fix | Delete
--
[312] Fix | Delete
[313] Fix | Delete
CREATE TABLE `[[dbprefix]]term_relationships` (
[314] Fix | Delete
`object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
[315] Fix | Delete
`term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
[316] Fix | Delete
`term_order` int(11) NOT NULL DEFAULT '0',
[317] Fix | Delete
PRIMARY KEY (`object_id`,`term_taxonomy_id`),
[318] Fix | Delete
KEY `term_taxonomy_id` (`term_taxonomy_id`)
[319] Fix | Delete
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]];
[320] Fix | Delete
[321] Fix | Delete
--
[322] Fix | Delete
-- Dumping data for table `[[dbprefix]]term_relationships`
[323] Fix | Delete
--
[324] Fix | Delete
[325] Fix | Delete
INSERT INTO `[[dbprefix]]term_relationships` VALUES
[326] Fix | Delete
(1, 1, 0);
[327] Fix | Delete
[328] Fix | Delete
-- --------------------------------------------------------
[329] Fix | Delete
[330] Fix | Delete
--
[331] Fix | Delete
-- Table structure for table `[[dbprefix]]term_taxonomy`
[332] Fix | Delete
--
[333] Fix | Delete
[334] Fix | Delete
CREATE TABLE `[[dbprefix]]term_taxonomy` (
[335] Fix | Delete
`term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[336] Fix | Delete
`term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
[337] Fix | Delete
`taxonomy` varchar(32) COLLATE [[collate]] NOT NULL DEFAULT '',
[338] Fix | Delete
`description` longtext COLLATE [[collate]] NOT NULL,
[339] Fix | Delete
`parent` bigint(20) unsigned NOT NULL DEFAULT '0',
[340] Fix | Delete
`count` bigint(20) NOT NULL DEFAULT '0',
[341] Fix | Delete
PRIMARY KEY (`term_taxonomy_id`),
[342] Fix | Delete
UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
[343] Fix | Delete
KEY `taxonomy` (`taxonomy`)
[344] Fix | Delete
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=2 ;
[345] Fix | Delete
[346] Fix | Delete
--
[347] Fix | Delete
-- Dumping data for table `[[dbprefix]]term_taxonomy`
[348] Fix | Delete
--
[349] Fix | Delete
[350] Fix | Delete
INSERT INTO `[[dbprefix]]term_taxonomy` VALUES
[351] Fix | Delete
(1, 1, 'category', '', 0, 1);
[352] Fix | Delete
[353] Fix | Delete
-- --------------------------------------------------------
[354] Fix | Delete
[355] Fix | Delete
--
[356] Fix | Delete
-- Table structure for table `[[dbprefix]]usermeta`
[357] Fix | Delete
--
[358] Fix | Delete
[359] Fix | Delete
CREATE TABLE `[[dbprefix]]usermeta` (
[360] Fix | Delete
`umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[361] Fix | Delete
`user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
[362] Fix | Delete
`meta_key` varchar(255) COLLATE [[collate]] DEFAULT NULL,
[363] Fix | Delete
`meta_value` longtext COLLATE [[collate]],
[364] Fix | Delete
PRIMARY KEY (`umeta_id`),
[365] Fix | Delete
KEY `user_id` (`user_id`),
[366] Fix | Delete
KEY `meta_key` (`meta_key`(191))
[367] Fix | Delete
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=16 ;
[368] Fix | Delete
[369] Fix | Delete
--
[370] Fix | Delete
-- Dumping data for table `[[dbprefix]]usermeta`
[371] Fix | Delete
--
[372] Fix | Delete
[373] Fix | Delete
INSERT INTO `[[dbprefix]]usermeta` VALUES
[374] Fix | Delete
(1, 1, 'nickname', '[[admin_username]]'),
[375] Fix | Delete
(2, 1, 'first_name', ''),
[376] Fix | Delete
(3, 1, 'last_name', ''),
[377] Fix | Delete
(4, 1, 'description', ''),
[378] Fix | Delete
(5, 1, 'rich_editing', 'true'),
[379] Fix | Delete
(6, 1, 'syntax_highlighting', 'true'),
[380] Fix | Delete
(7, 1, 'comment_shortcuts', 'false'),
[381] Fix | Delete
(8, 1, 'admin_color', 'fresh'),
[382] Fix | Delete
(9, 1, 'use_ssl', '0'),
[383] Fix | Delete
(10, 1, 'show_admin_bar_front', 'true'),
[384] Fix | Delete
(11, 1, 'locale', ''),
[385] Fix | Delete
(12, 1, '[[dbprefix]]capabilities', 'a:1:{s:13:"administrator";b:1;}'),
[386] Fix | Delete
(13, 1, '[[dbprefix]]user_level', '10'),
[387] Fix | Delete
(14, 1, 'dismissed_wp_pointers', ''),
[388] Fix | Delete
(15, 1, 'show_welcome_panel', '1');
[389] Fix | Delete
[390] Fix | Delete
-- --------------------------------------------------------
[391] Fix | Delete
[392] Fix | Delete
--
[393] Fix | Delete
-- Table structure for table `[[dbprefix]]users`
[394] Fix | Delete
--
[395] Fix | Delete
[396] Fix | Delete
CREATE TABLE `[[dbprefix]]users` (
[397] Fix | Delete
`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[398] Fix | Delete
`user_login` varchar(60) COLLATE [[collate]] NOT NULL DEFAULT '',
[399] Fix | Delete
`user_pass` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
[400] Fix | Delete
`user_nicename` varchar(50) COLLATE [[collate]] NOT NULL DEFAULT '',
[401] Fix | Delete
`user_email` varchar(100) COLLATE [[collate]] NOT NULL DEFAULT '',
[402] Fix | Delete
`user_url` varchar(100) COLLATE [[collate]] NOT NULL DEFAULT '',
[403] Fix | Delete
`user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
[404] Fix | Delete
`user_activation_key` varchar(255) COLLATE [[collate]] NOT NULL DEFAULT '',
[405] Fix | Delete
`user_status` int(11) NOT NULL DEFAULT '0',
[406] Fix | Delete
`display_name` varchar(250) COLLATE [[collate]] NOT NULL DEFAULT '',
[407] Fix | Delete
`spam` tinyint(2) NOT NULL DEFAULT '0',
[408] Fix | Delete
`deleted` tinyint(2) NOT NULL DEFAULT '0',
[409] Fix | Delete
PRIMARY KEY (`ID`),
[410] Fix | Delete
KEY `user_login_key` (`user_login`),
[411] Fix | Delete
KEY `user_nicename` (`user_nicename`),
[412] Fix | Delete
KEY `user_email` (`user_email`)
[413] Fix | Delete
) DEFAULT CHARSET=[[utf8]] COLLATE=[[collate]] AUTO_INCREMENT=2 ;
[414] Fix | Delete
[415] Fix | Delete
--
[416] Fix | Delete
-- Dumping data for table `[[dbprefix]]users`
[417] Fix | Delete
--
[418] Fix | Delete
[419] Fix | Delete
INSERT INTO `[[dbprefix]]users` VALUES
[420] Fix | Delete
(1, '[[admin_username]]', '[[admin_pass]]', '[[admin_username]]', '[[admin_email]]', '', '[[date_gmt]]', '', 0, '[[admin_username]]', 0, 0);
[421] Fix | Delete
[422] Fix | Delete
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
[423] Fix | Delete
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
[424] Fix | Delete
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
[425] Fix | Delete
[426] Fix | Delete
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function