Edit File by line
/home/barbar84/public_h.../wp-conte.../plugins/sujqvwi/ExeBy/smexe_ro.../var/softacul.../mt
File: mt.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: `soft_mt5213`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `mt_asset`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `mt_asset` (
[20] Fix | Delete
`asset_id` int(11) NOT NULL AUTO_INCREMENT,
[21] Fix | Delete
`asset_blog_id` int(11) NOT NULL,
[22] Fix | Delete
`asset_class` varchar(255) DEFAULT 'file',
[23] Fix | Delete
`asset_created_by` int(11) DEFAULT NULL,
[24] Fix | Delete
`asset_created_on` datetime DEFAULT NULL,
[25] Fix | Delete
`asset_description` mediumtext,
[26] Fix | Delete
`asset_file_ext` varchar(20) DEFAULT NULL,
[27] Fix | Delete
`asset_file_name` varchar(255) DEFAULT NULL,
[28] Fix | Delete
`asset_file_path` varchar(255) DEFAULT NULL,
[29] Fix | Delete
`asset_label` varchar(255) DEFAULT NULL,
[30] Fix | Delete
`asset_mime_type` varchar(255) DEFAULT NULL,
[31] Fix | Delete
`asset_modified_by` int(11) DEFAULT NULL,
[32] Fix | Delete
`asset_modified_on` datetime DEFAULT NULL,
[33] Fix | Delete
`asset_parent` int(11) DEFAULT NULL,
[34] Fix | Delete
`asset_url` varchar(255) DEFAULT NULL,
[35] Fix | Delete
PRIMARY KEY (`asset_id`),
[36] Fix | Delete
KEY `mt_asset_blog_class_date` (`asset_blog_id`,`asset_class`,`asset_created_on`),
[37] Fix | Delete
KEY `mt_asset_parent` (`asset_parent`),
[38] Fix | Delete
KEY `mt_asset_file_ext` (`asset_file_ext`),
[39] Fix | Delete
KEY `mt_asset_created_on` (`asset_created_on`),
[40] Fix | Delete
KEY `mt_asset_class` (`asset_class`),
[41] Fix | Delete
KEY `mt_asset_label` (`asset_label`),
[42] Fix | Delete
KEY `mt_asset_created_by` (`asset_created_by`)
[43] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[44] Fix | Delete
[45] Fix | Delete
-- --------------------------------------------------------
[46] Fix | Delete
[47] Fix | Delete
--
[48] Fix | Delete
-- Table structure for table `mt_asset_meta`
[49] Fix | Delete
--
[50] Fix | Delete
[51] Fix | Delete
CREATE TABLE `mt_asset_meta` (
[52] Fix | Delete
`asset_meta_asset_id` int(11) NOT NULL,
[53] Fix | Delete
`asset_meta_type` varchar(75) NOT NULL,
[54] Fix | Delete
`asset_meta_vchar` varchar(255) DEFAULT NULL,
[55] Fix | Delete
`asset_meta_vchar_idx` varchar(255) DEFAULT NULL,
[56] Fix | Delete
`asset_meta_vdatetime` datetime DEFAULT NULL,
[57] Fix | Delete
`asset_meta_vdatetime_idx` datetime DEFAULT NULL,
[58] Fix | Delete
`asset_meta_vinteger` int(11) DEFAULT NULL,
[59] Fix | Delete
`asset_meta_vinteger_idx` int(11) DEFAULT NULL,
[60] Fix | Delete
`asset_meta_vfloat` float DEFAULT NULL,
[61] Fix | Delete
`asset_meta_vfloat_idx` float DEFAULT NULL,
[62] Fix | Delete
`asset_meta_vblob` mediumblob,
[63] Fix | Delete
`asset_meta_vclob` mediumtext,
[64] Fix | Delete
PRIMARY KEY (`asset_meta_asset_id`,`asset_meta_type`),
[65] Fix | Delete
KEY `mt_asset_meta_type_vint` (`asset_meta_type`,`asset_meta_vinteger_idx`),
[66] Fix | Delete
KEY `mt_asset_meta_type_vflt` (`asset_meta_type`,`asset_meta_vfloat_idx`),
[67] Fix | Delete
KEY `mt_asset_meta_type_vdt` (`asset_meta_type`,`asset_meta_vdatetime_idx`),
[68] Fix | Delete
KEY `mt_asset_meta_type_vchar` (`asset_meta_type`,`asset_meta_vchar_idx`)
[69] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[70] Fix | Delete
[71] Fix | Delete
-- --------------------------------------------------------
[72] Fix | Delete
[73] Fix | Delete
--
[74] Fix | Delete
-- Table structure for table `mt_association`
[75] Fix | Delete
--
[76] Fix | Delete
[77] Fix | Delete
CREATE TABLE `mt_association` (
[78] Fix | Delete
`association_id` int(11) NOT NULL AUTO_INCREMENT,
[79] Fix | Delete
`association_author_id` int(11) DEFAULT '0',
[80] Fix | Delete
`association_blog_id` int(11) DEFAULT '0',
[81] Fix | Delete
`association_created_by` int(11) DEFAULT NULL,
[82] Fix | Delete
`association_created_on` datetime DEFAULT NULL,
[83] Fix | Delete
`association_group_id` int(11) DEFAULT '0',
[84] Fix | Delete
`association_modified_by` int(11) DEFAULT NULL,
[85] Fix | Delete
`association_modified_on` datetime DEFAULT NULL,
[86] Fix | Delete
`association_role_id` int(11) DEFAULT '0',
[87] Fix | Delete
`association_type` int(11) NOT NULL,
[88] Fix | Delete
PRIMARY KEY (`association_id`),
[89] Fix | Delete
KEY `mt_association_author_id` (`association_author_id`),
[90] Fix | Delete
KEY `mt_association_group_id` (`association_group_id`),
[91] Fix | Delete
KEY `mt_association_created_on` (`association_created_on`),
[92] Fix | Delete
KEY `mt_association_type` (`association_type`),
[93] Fix | Delete
KEY `mt_association_blog_id` (`association_blog_id`),
[94] Fix | Delete
KEY `mt_association_role_id` (`association_role_id`)
[95] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[96] Fix | Delete
[97] Fix | Delete
--
[98] Fix | Delete
-- Dumping data for table `mt_association`
[99] Fix | Delete
--
[100] Fix | Delete
[101] Fix | Delete
INSERT INTO `mt_association` VALUES
[102] Fix | Delete
(1, 1, 1, 1, '[[regtime]]', 0, NULL, '[[regtime]]', 1, 1);
[103] Fix | Delete
[104] Fix | Delete
-- --------------------------------------------------------
[105] Fix | Delete
[106] Fix | Delete
--
[107] Fix | Delete
-- Table structure for table `mt_author`
[108] Fix | Delete
--
[109] Fix | Delete
[110] Fix | Delete
CREATE TABLE `mt_author` (
[111] Fix | Delete
`author_id` int(11) NOT NULL AUTO_INCREMENT,
[112] Fix | Delete
`author_api_password` varchar(60) DEFAULT NULL,
[113] Fix | Delete
`author_auth_type` varchar(50) DEFAULT NULL,
[114] Fix | Delete
`author_basename` varchar(255) DEFAULT NULL,
[115] Fix | Delete
`author_can_create_blog` tinyint(4) DEFAULT NULL,
[116] Fix | Delete
`author_can_view_log` tinyint(4) DEFAULT NULL,
[117] Fix | Delete
`author_created_by` int(11) DEFAULT NULL,
[118] Fix | Delete
`author_created_on` datetime DEFAULT NULL,
[119] Fix | Delete
`author_date_format` varchar(30) DEFAULT 'relative',
[120] Fix | Delete
`author_email` varchar(127) DEFAULT NULL,
[121] Fix | Delete
`author_entry_prefs` varchar(255) DEFAULT NULL,
[122] Fix | Delete
`author_external_id` varchar(255) DEFAULT NULL,
[123] Fix | Delete
`author_hint` varchar(75) DEFAULT NULL,
[124] Fix | Delete
`author_is_superuser` tinyint(4) DEFAULT NULL,
[125] Fix | Delete
`author_locked_out_time` int(11) NOT NULL DEFAULT '0',
[126] Fix | Delete
`author_modified_by` int(11) DEFAULT NULL,
[127] Fix | Delete
`author_modified_on` datetime DEFAULT NULL,
[128] Fix | Delete
`author_name` varchar(255) NOT NULL,
[129] Fix | Delete
`author_nickname` varchar(255) DEFAULT NULL,
[130] Fix | Delete
`author_password` varchar(124) NOT NULL,
[131] Fix | Delete
`author_preferred_language` varchar(50) DEFAULT NULL,
[132] Fix | Delete
`author_public_key` mediumtext,
[133] Fix | Delete
`author_remote_auth_token` varchar(50) DEFAULT NULL,
[134] Fix | Delete
`author_remote_auth_username` varchar(50) DEFAULT NULL,
[135] Fix | Delete
`author_status` int(11) DEFAULT '1',
[136] Fix | Delete
`author_text_format` varchar(30) DEFAULT NULL,
[137] Fix | Delete
`author_type` smallint(6) NOT NULL DEFAULT '1',
[138] Fix | Delete
`author_url` varchar(255) DEFAULT NULL,
[139] Fix | Delete
`author_userpic_asset_id` int(11) DEFAULT NULL,
[140] Fix | Delete
PRIMARY KEY (`author_id`),
[141] Fix | Delete
KEY `mt_author_auth_type_name` (`author_auth_type`,`author_name`,`author_type`),
[142] Fix | Delete
KEY `mt_author_locked_out_time` (`author_locked_out_time`),
[143] Fix | Delete
KEY `mt_author_status` (`author_status`),
[144] Fix | Delete
KEY `mt_author_name` (`author_name`),
[145] Fix | Delete
KEY `mt_author_basename` (`author_basename`),
[146] Fix | Delete
KEY `mt_author_email` (`author_email`),
[147] Fix | Delete
KEY `mt_author_external_id` (`author_external_id`),
[148] Fix | Delete
KEY `mt_author_created_on` (`author_created_on`),
[149] Fix | Delete
KEY `mt_author_type` (`author_type`)
[150] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[151] Fix | Delete
[152] Fix | Delete
--
[153] Fix | Delete
-- Dumping data for table `mt_author`
[154] Fix | Delete
--
[155] Fix | Delete
[156] Fix | Delete
INSERT INTO `mt_author` VALUES
[157] Fix | Delete
(1, '[[author_api_password]]', 'MT', '[[admin_basename]]', NULL, NULL, 1, '[[regtime]]', 'relative', '[[admin_email]]', NULL, '', NULL, NULL, 0, NULL, '[[regtime]]', '[[admin_username]]', '[[admin_fname]][[admin_lname]]', '[[admin_pass]]', 'en-us', NULL, NULL, NULL, 1, NULL, 1, NULL, NULL);
[158] Fix | Delete
[159] Fix | Delete
-- --------------------------------------------------------
[160] Fix | Delete
[161] Fix | Delete
--
[162] Fix | Delete
-- Table structure for table `mt_author_meta`
[163] Fix | Delete
--
[164] Fix | Delete
[165] Fix | Delete
CREATE TABLE `mt_author_meta` (
[166] Fix | Delete
`author_meta_author_id` int(11) NOT NULL,
[167] Fix | Delete
`author_meta_type` varchar(75) NOT NULL,
[168] Fix | Delete
`author_meta_vchar` varchar(255) DEFAULT NULL,
[169] Fix | Delete
`author_meta_vchar_idx` varchar(255) DEFAULT NULL,
[170] Fix | Delete
`author_meta_vdatetime` datetime DEFAULT NULL,
[171] Fix | Delete
`author_meta_vdatetime_idx` datetime DEFAULT NULL,
[172] Fix | Delete
`author_meta_vinteger` int(11) DEFAULT NULL,
[173] Fix | Delete
`author_meta_vinteger_idx` int(11) DEFAULT NULL,
[174] Fix | Delete
`author_meta_vfloat` float DEFAULT NULL,
[175] Fix | Delete
`author_meta_vfloat_idx` float DEFAULT NULL,
[176] Fix | Delete
`author_meta_vblob` mediumblob,
[177] Fix | Delete
`author_meta_vclob` mediumtext,
[178] Fix | Delete
PRIMARY KEY (`author_meta_author_id`,`author_meta_type`),
[179] Fix | Delete
KEY `mt_author_meta_type_vint` (`author_meta_type`,`author_meta_vinteger_idx`),
[180] Fix | Delete
KEY `mt_author_meta_type_vflt` (`author_meta_type`,`author_meta_vfloat_idx`),
[181] Fix | Delete
KEY `mt_author_meta_type_vdt` (`author_meta_type`,`author_meta_vdatetime_idx`),
[182] Fix | Delete
KEY `mt_author_meta_type_vchar` (`author_meta_type`,`author_meta_vchar_idx`)
[183] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[184] Fix | Delete
[185] Fix | Delete
--
[186] Fix | Delete
-- Dumping data for table `mt_author_meta`
[187] Fix | Delete
--
[188] Fix | Delete
[189] Fix | Delete
INSERT INTO `mt_author_meta` VALUES
[190] Fix | Delete
(1, 'favorite_websites', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'BIN:SERG\0\0\0\0\0\0\0A\0\0\0-\0\0\01', NULL),
[191] Fix | Delete
(1, 'widgets', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'BIN:SERG\0\0\0\0\0\0\0H\0\0\0\0\0\0dashboard:user:1H\0\0\0\0\0\0\rthis_is_you-1H\0\0\0\0\0\0order-\0\0\01\0\0\0set-\0\0\0main\0\0\0favorite_blogsH\0\0\0\0\0\0order-\0\0\02\0\0\0paramH\0\0\0\0\0\0tab-\0\0\0website\0\0\0set-\0\0\0main\0\0\0mt_newsH\0\0\0\0\0\0order-\0\0\03\0\0\0set-\0\0\0sidebar', NULL);
[192] Fix | Delete
[193] Fix | Delete
-- --------------------------------------------------------
[194] Fix | Delete
[195] Fix | Delete
--
[196] Fix | Delete
-- Table structure for table `mt_author_summary`
[197] Fix | Delete
--
[198] Fix | Delete
[199] Fix | Delete
CREATE TABLE `mt_author_summary` (
[200] Fix | Delete
`author_summary_author_id` int(11) NOT NULL,
[201] Fix | Delete
`author_summary_type` varchar(75) NOT NULL,
[202] Fix | Delete
`author_summary_class` varchar(75) NOT NULL,
[203] Fix | Delete
`author_summary_vchar_idx` varchar(255) DEFAULT NULL,
[204] Fix | Delete
`author_summary_vinteger_idx` int(11) DEFAULT NULL,
[205] Fix | Delete
`author_summary_vblob` mediumblob,
[206] Fix | Delete
`author_summary_vclob` mediumtext,
[207] Fix | Delete
`author_summary_expired` smallint(6) DEFAULT NULL,
[208] Fix | Delete
PRIMARY KEY (`author_summary_author_id`,`author_summary_type`),
[209] Fix | Delete
KEY `mt_author_summary_class_vint` (`author_summary_class`,`author_summary_vinteger_idx`),
[210] Fix | Delete
KEY `mt_author_summary_id_class` (`author_summary_author_id`,`author_summary_class`),
[211] Fix | Delete
KEY `mt_author_summary_class_vchar` (`author_summary_class`,`author_summary_vchar_idx`)
[212] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[213] Fix | Delete
[214] Fix | Delete
-- --------------------------------------------------------
[215] Fix | Delete
[216] Fix | Delete
--
[217] Fix | Delete
-- Table structure for table `mt_blog`
[218] Fix | Delete
--
[219] Fix | Delete
[220] Fix | Delete
CREATE TABLE `mt_blog` (
[221] Fix | Delete
`blog_id` int(11) NOT NULL AUTO_INCREMENT,
[222] Fix | Delete
`blog_allow_anon_comments` tinyint(4) DEFAULT NULL,
[223] Fix | Delete
`blog_allow_comment_html` tinyint(4) DEFAULT NULL,
[224] Fix | Delete
`blog_allow_commenter_regist` tinyint(4) DEFAULT NULL,
[225] Fix | Delete
`blog_allow_comments_default` tinyint(4) DEFAULT NULL,
[226] Fix | Delete
`blog_allow_pings` tinyint(4) DEFAULT NULL,
[227] Fix | Delete
`blog_allow_pings_default` tinyint(4) DEFAULT NULL,
[228] Fix | Delete
`blog_allow_reg_comments` tinyint(4) DEFAULT NULL,
[229] Fix | Delete
`blog_allow_unreg_comments` tinyint(4) DEFAULT NULL,
[230] Fix | Delete
`blog_archive_path` varchar(255) DEFAULT NULL,
[231] Fix | Delete
`blog_archive_tmpl_category` varchar(255) DEFAULT NULL,
[232] Fix | Delete
`blog_archive_tmpl_daily` varchar(255) DEFAULT NULL,
[233] Fix | Delete
`blog_archive_tmpl_individual` varchar(255) DEFAULT NULL,
[234] Fix | Delete
`blog_archive_tmpl_monthly` varchar(255) DEFAULT NULL,
[235] Fix | Delete
`blog_archive_tmpl_weekly` varchar(255) DEFAULT NULL,
[236] Fix | Delete
`blog_archive_type` varchar(255) DEFAULT NULL,
[237] Fix | Delete
`blog_archive_type_preferred` varchar(25) DEFAULT NULL,
[238] Fix | Delete
`blog_archive_url` varchar(255) DEFAULT NULL,
[239] Fix | Delete
`blog_autodiscover_links` tinyint(4) DEFAULT NULL,
[240] Fix | Delete
`blog_autolink_urls` tinyint(4) DEFAULT NULL,
[241] Fix | Delete
`blog_basename_limit` smallint(6) DEFAULT NULL,
[242] Fix | Delete
`blog_cc_license` varchar(255) DEFAULT NULL,
[243] Fix | Delete
`blog_children_modified_on` datetime DEFAULT NULL,
[244] Fix | Delete
`blog_class` varchar(255) DEFAULT 'blog',
[245] Fix | Delete
`blog_content_css` varchar(255) DEFAULT NULL,
[246] Fix | Delete
`blog_convert_paras` varchar(30) DEFAULT NULL,
[247] Fix | Delete
`blog_convert_paras_comments` varchar(30) DEFAULT NULL,
[248] Fix | Delete
`blog_created_by` int(11) DEFAULT NULL,
[249] Fix | Delete
`blog_created_on` datetime DEFAULT NULL,
[250] Fix | Delete
`blog_custom_dynamic_templates` varchar(25) DEFAULT 'none',
[251] Fix | Delete
`blog_date_language` varchar(5) DEFAULT NULL,
[252] Fix | Delete
`blog_days_on_index` int(11) DEFAULT NULL,
[253] Fix | Delete
`blog_description` mediumtext,
[254] Fix | Delete
`blog_email_new_comments` tinyint(4) DEFAULT NULL,
[255] Fix | Delete
`blog_email_new_pings` tinyint(4) DEFAULT NULL,
[256] Fix | Delete
`blog_entries_on_index` int(11) DEFAULT NULL,
[257] Fix | Delete
`blog_file_extension` varchar(10) DEFAULT NULL,
[258] Fix | Delete
`blog_google_api_key` varchar(32) DEFAULT NULL,
[259] Fix | Delete
`blog_internal_autodiscovery` tinyint(4) DEFAULT NULL,
[260] Fix | Delete
`blog_is_dynamic` tinyint(4) DEFAULT NULL,
[261] Fix | Delete
`blog_junk_folder_expiry` int(11) DEFAULT NULL,
[262] Fix | Delete
`blog_junk_score_threshold` float DEFAULT NULL,
[263] Fix | Delete
`blog_language` varchar(5) DEFAULT NULL,
[264] Fix | Delete
`blog_manual_approve_commenters` tinyint(4) DEFAULT NULL,
[265] Fix | Delete
`blog_moderate_pings` tinyint(4) DEFAULT NULL,
[266] Fix | Delete
`blog_moderate_unreg_comments` tinyint(4) DEFAULT NULL,
[267] Fix | Delete
`blog_modified_by` int(11) DEFAULT NULL,
[268] Fix | Delete
`blog_modified_on` datetime DEFAULT NULL,
[269] Fix | Delete
`blog_mt_update_key` varchar(30) DEFAULT NULL,
[270] Fix | Delete
`blog_name` varchar(255) NOT NULL,
[271] Fix | Delete
`blog_old_style_archive_links` tinyint(4) DEFAULT NULL,
[272] Fix | Delete
`blog_parent_id` int(11) DEFAULT NULL,
[273] Fix | Delete
`blog_ping_blogs` tinyint(4) DEFAULT NULL,
[274] Fix | Delete
`blog_ping_google` tinyint(4) DEFAULT NULL,
[275] Fix | Delete
`blog_ping_others` mediumtext,
[276] Fix | Delete
`blog_ping_technorati` tinyint(4) DEFAULT NULL,
[277] Fix | Delete
`blog_ping_weblogs` tinyint(4) DEFAULT NULL,
[278] Fix | Delete
`blog_remote_auth_token` varchar(50) DEFAULT NULL,
[279] Fix | Delete
`blog_require_comment_emails` tinyint(4) DEFAULT NULL,
[280] Fix | Delete
`blog_sanitize_spec` varchar(255) DEFAULT NULL,
[281] Fix | Delete
`blog_server_offset` float DEFAULT NULL,
[282] Fix | Delete
`blog_site_path` varchar(255) DEFAULT NULL,
[283] Fix | Delete
`blog_site_url` varchar(255) DEFAULT NULL,
[284] Fix | Delete
`blog_sort_order_comments` varchar(8) DEFAULT NULL,
[285] Fix | Delete
`blog_sort_order_posts` varchar(8) DEFAULT NULL,
[286] Fix | Delete
`blog_status_default` smallint(6) DEFAULT NULL,
[287] Fix | Delete
`blog_theme_id` varchar(255) DEFAULT NULL,
[288] Fix | Delete
`blog_use_comment_confirmation` tinyint(4) DEFAULT NULL,
[289] Fix | Delete
`blog_use_revision` tinyint(4) DEFAULT NULL,
[290] Fix | Delete
`blog_welcome_msg` mediumtext,
[291] Fix | Delete
`blog_words_in_excerpt` smallint(6) DEFAULT NULL,
[292] Fix | Delete
PRIMARY KEY (`blog_id`),
[293] Fix | Delete
KEY `mt_blog_name` (`blog_name`),
[294] Fix | Delete
KEY `mt_blog_class` (`blog_class`),
[295] Fix | Delete
KEY `mt_blog_parent_id` (`blog_parent_id`)
[296] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[297] Fix | Delete
[298] Fix | Delete
--
[299] Fix | Delete
-- Dumping data for table `mt_blog`
[300] Fix | Delete
--
[301] Fix | Delete
[302] Fix | Delete
INSERT INTO `mt_blog` VALUES
[303] Fix | Delete
(1, NULL, 1, 1, 1, 1, 1, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, 'Page', '', NULL, NULL, 1, 100, NULL, '[[regtime]]', 'website', NULL, 'richtext', '1', 1, '[[regtime]]', 'none', 'en-us', 0, '[[site_desc]]', 1, 1, 10, 'html', NULL, 0, NULL, 14, 0, 'en-us', NULL, 1, 2, NULL, '[[regtime]]', NULL, '[[site_name]]', NULL, NULL, 0, 0, NULL, 0, 0, NULL, 0, '0', 0, '[[wwwdir]]', '[[wwwurl]]/', 'ascend', 'descend', 2, 'classic_website', 1, 1, NULL, 40);
[304] Fix | Delete
[305] Fix | Delete
-- --------------------------------------------------------
[306] Fix | Delete
[307] Fix | Delete
--
[308] Fix | Delete
-- Table structure for table `mt_blog_meta`
[309] Fix | Delete
--
[310] Fix | Delete
[311] Fix | Delete
CREATE TABLE `mt_blog_meta` (
[312] Fix | Delete
`blog_meta_blog_id` int(11) NOT NULL,
[313] Fix | Delete
`blog_meta_type` varchar(75) NOT NULL,
[314] Fix | Delete
`blog_meta_vchar` varchar(255) DEFAULT NULL,
[315] Fix | Delete
`blog_meta_vchar_idx` varchar(255) DEFAULT NULL,
[316] Fix | Delete
`blog_meta_vdatetime` datetime DEFAULT NULL,
[317] Fix | Delete
`blog_meta_vdatetime_idx` datetime DEFAULT NULL,
[318] Fix | Delete
`blog_meta_vinteger` int(11) DEFAULT NULL,
[319] Fix | Delete
`blog_meta_vinteger_idx` int(11) DEFAULT NULL,
[320] Fix | Delete
`blog_meta_vfloat` float DEFAULT NULL,
[321] Fix | Delete
`blog_meta_vfloat_idx` float DEFAULT NULL,
[322] Fix | Delete
`blog_meta_vblob` mediumblob,
[323] Fix | Delete
`blog_meta_vclob` mediumtext,
[324] Fix | Delete
PRIMARY KEY (`blog_meta_blog_id`,`blog_meta_type`),
[325] Fix | Delete
KEY `mt_blog_meta_type_vint` (`blog_meta_type`,`blog_meta_vinteger_idx`),
[326] Fix | Delete
KEY `mt_blog_meta_type_vflt` (`blog_meta_type`,`blog_meta_vfloat_idx`),
[327] Fix | Delete
KEY `mt_blog_meta_type_vdt` (`blog_meta_type`,`blog_meta_vdatetime_idx`),
[328] Fix | Delete
KEY `mt_blog_meta_type_vchar` (`blog_meta_type`,`blog_meta_vchar_idx`)
[329] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[330] Fix | Delete
[331] Fix | Delete
--
[332] Fix | Delete
-- Dumping data for table `mt_blog_meta`
[333] Fix | Delete
--
[334] Fix | Delete
[335] Fix | Delete
INSERT INTO `mt_blog_meta` VALUES
[336] Fix | Delete
(1, 'commenter_authenticators', 'MovableType,LiveJournal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
[337] Fix | Delete
(1, 'follow_auth_links', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
[338] Fix | Delete
(1, 'nofollow_urls', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
[339] Fix | Delete
(1, 'page_layout', 'layout-wtt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
[340] Fix | Delete
[341] Fix | Delete
-- --------------------------------------------------------
[342] Fix | Delete
[343] Fix | Delete
--
[344] Fix | Delete
-- Table structure for table `mt_category`
[345] Fix | Delete
--
[346] Fix | Delete
[347] Fix | Delete
CREATE TABLE `mt_category` (
[348] Fix | Delete
`category_id` int(11) NOT NULL AUTO_INCREMENT,
[349] Fix | Delete
`category_allow_pings` tinyint(4) DEFAULT '0',
[350] Fix | Delete
`category_author_id` int(11) DEFAULT NULL,
[351] Fix | Delete
`category_basename` varchar(255) DEFAULT NULL,
[352] Fix | Delete
`category_blog_id` int(11) NOT NULL,
[353] Fix | Delete
`category_class` varchar(255) DEFAULT 'category',
[354] Fix | Delete
`category_created_by` int(11) DEFAULT NULL,
[355] Fix | Delete
`category_created_on` datetime DEFAULT NULL,
[356] Fix | Delete
`category_description` mediumtext,
[357] Fix | Delete
`category_label` varchar(100) NOT NULL,
[358] Fix | Delete
`category_modified_by` int(11) DEFAULT NULL,
[359] Fix | Delete
`category_modified_on` datetime DEFAULT NULL,
[360] Fix | Delete
`category_parent` int(11) DEFAULT '0',
[361] Fix | Delete
`category_ping_urls` mediumtext,
[362] Fix | Delete
PRIMARY KEY (`category_id`),
[363] Fix | Delete
KEY `mt_category_blog_basename` (`category_blog_id`,`category_basename`),
[364] Fix | Delete
KEY `mt_category_parent` (`category_parent`),
[365] Fix | Delete
KEY `mt_category_class` (`category_class`),
[366] Fix | Delete
KEY `mt_category_blog_class` (`category_blog_id`,`category_class`),
[367] Fix | Delete
KEY `mt_category_label` (`category_label`),
[368] Fix | Delete
KEY `mt_category_blog_id` (`category_blog_id`)
[369] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[370] Fix | Delete
[371] Fix | Delete
-- --------------------------------------------------------
[372] Fix | Delete
[373] Fix | Delete
--
[374] Fix | Delete
-- Table structure for table `mt_category_meta`
[375] Fix | Delete
--
[376] Fix | Delete
[377] Fix | Delete
CREATE TABLE `mt_category_meta` (
[378] Fix | Delete
`category_meta_category_id` int(11) NOT NULL,
[379] Fix | Delete
`category_meta_type` varchar(75) NOT NULL,
[380] Fix | Delete
`category_meta_vchar` varchar(255) DEFAULT NULL,
[381] Fix | Delete
`category_meta_vchar_idx` varchar(255) DEFAULT NULL,
[382] Fix | Delete
`category_meta_vdatetime` datetime DEFAULT NULL,
[383] Fix | Delete
`category_meta_vdatetime_idx` datetime DEFAULT NULL,
[384] Fix | Delete
`category_meta_vinteger` int(11) DEFAULT NULL,
[385] Fix | Delete
`category_meta_vinteger_idx` int(11) DEFAULT NULL,
[386] Fix | Delete
`category_meta_vfloat` float DEFAULT NULL,
[387] Fix | Delete
`category_meta_vfloat_idx` float DEFAULT NULL,
[388] Fix | Delete
`category_meta_vblob` mediumblob,
[389] Fix | Delete
`category_meta_vclob` mediumtext,
[390] Fix | Delete
PRIMARY KEY (`category_meta_category_id`,`category_meta_type`),
[391] Fix | Delete
KEY `mt_category_meta_type_vint` (`category_meta_type`,`category_meta_vinteger_idx`),
[392] Fix | Delete
KEY `mt_category_meta_type_vflt` (`category_meta_type`,`category_meta_vfloat_idx`),
[393] Fix | Delete
KEY `mt_category_meta_type_vdt` (`category_meta_type`,`category_meta_vdatetime_idx`),
[394] Fix | Delete
KEY `mt_category_meta_type_vchar` (`category_meta_type`,`category_meta_vchar_idx`)
[395] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[396] Fix | Delete
[397] Fix | Delete
-- --------------------------------------------------------
[398] Fix | Delete
[399] Fix | Delete
--
[400] Fix | Delete
-- Table structure for table `mt_comment`
[401] Fix | Delete
--
[402] Fix | Delete
[403] Fix | Delete
CREATE TABLE `mt_comment` (
[404] Fix | Delete
`comment_id` int(11) NOT NULL AUTO_INCREMENT,
[405] Fix | Delete
`comment_author` varchar(100) DEFAULT NULL,
[406] Fix | Delete
`comment_blog_id` int(11) NOT NULL,
[407] Fix | Delete
`comment_commenter_id` int(11) DEFAULT NULL,
[408] Fix | Delete
`comment_created_by` int(11) DEFAULT NULL,
[409] Fix | Delete
`comment_created_on` datetime DEFAULT NULL,
[410] Fix | Delete
`comment_email` varchar(127) DEFAULT NULL,
[411] Fix | Delete
`comment_entry_id` int(11) NOT NULL,
[412] Fix | Delete
`comment_ip` varchar(50) DEFAULT NULL,
[413] Fix | Delete
`comment_junk_log` mediumtext,
[414] Fix | Delete
`comment_junk_score` float DEFAULT NULL,
[415] Fix | Delete
`comment_junk_status` smallint(6) DEFAULT '1',
[416] Fix | Delete
`comment_last_moved_on` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
[417] Fix | Delete
`comment_modified_by` int(11) DEFAULT NULL,
[418] Fix | Delete
`comment_modified_on` datetime DEFAULT NULL,
[419] Fix | Delete
`comment_parent_id` int(11) DEFAULT NULL,
[420] Fix | Delete
`comment_text` mediumtext,
[421] Fix | Delete
`comment_url` varchar(255) DEFAULT NULL,
[422] Fix | Delete
`comment_visible` tinyint(4) DEFAULT NULL,
[423] Fix | Delete
PRIMARY KEY (`comment_id`),
[424] Fix | Delete
KEY `mt_comment_blog_stat` (`comment_blog_id`,`comment_junk_status`,`comment_created_on`),
[425] Fix | Delete
KEY `mt_comment_commenter_id` (`comment_commenter_id`),
[426] Fix | Delete
KEY `mt_comment_dd_coment_vis_mod` (`comment_visible`,`comment_modified_on`),
[427] Fix | Delete
KEY `mt_comment_visible_date` (`comment_visible`,`comment_created_on`),
[428] Fix | Delete
KEY `mt_comment_author` (`comment_author`),
[429] Fix | Delete
KEY `mt_comment_entry_visible` (`comment_entry_id`,`comment_visible`,`comment_created_on`),
[430] Fix | Delete
KEY `mt_comment_email` (`comment_email`),
[431] Fix | Delete
KEY `mt_comment_blog_junk_stat` (`comment_blog_id`,`comment_junk_status`,`comment_last_moved_on`),
[432] Fix | Delete
KEY `mt_comment_blog_visible` (`comment_blog_id`,`comment_visible`,`comment_created_on`,`comment_id`),
[433] Fix | Delete
KEY `mt_comment_last_moved_on` (`comment_last_moved_on`),
[434] Fix | Delete
KEY `mt_comment_blog_ip_date` (`comment_blog_id`,`comment_ip`,`comment_created_on`),
[435] Fix | Delete
KEY `mt_comment_blog_visible_entry` (`comment_blog_id`,`comment_visible`,`comment_entry_id`),
[436] Fix | Delete
KEY `mt_comment_blog_url` (`comment_blog_id`,`comment_visible`,`comment_url`)
[437] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[438] Fix | Delete
[439] Fix | Delete
-- --------------------------------------------------------
[440] Fix | Delete
[441] Fix | Delete
--
[442] Fix | Delete
-- Table structure for table `mt_comment_meta`
[443] Fix | Delete
--
[444] Fix | Delete
[445] Fix | Delete
CREATE TABLE `mt_comment_meta` (
[446] Fix | Delete
`comment_meta_comment_id` int(11) NOT NULL,
[447] Fix | Delete
`comment_meta_type` varchar(75) NOT NULL,
[448] Fix | Delete
`comment_meta_vchar` varchar(255) DEFAULT NULL,
[449] Fix | Delete
`comment_meta_vchar_idx` varchar(255) DEFAULT NULL,
[450] Fix | Delete
`comment_meta_vdatetime` datetime DEFAULT NULL,
[451] Fix | Delete
`comment_meta_vdatetime_idx` datetime DEFAULT NULL,
[452] Fix | Delete
`comment_meta_vinteger` int(11) DEFAULT NULL,
[453] Fix | Delete
`comment_meta_vinteger_idx` int(11) DEFAULT NULL,
[454] Fix | Delete
`comment_meta_vfloat` float DEFAULT NULL,
[455] Fix | Delete
`comment_meta_vfloat_idx` float DEFAULT NULL,
[456] Fix | Delete
`comment_meta_vblob` mediumblob,
[457] Fix | Delete
`comment_meta_vclob` mediumtext,
[458] Fix | Delete
PRIMARY KEY (`comment_meta_comment_id`,`comment_meta_type`),
[459] Fix | Delete
KEY `mt_comment_meta_type_vint` (`comment_meta_type`,`comment_meta_vinteger_idx`),
[460] Fix | Delete
KEY `mt_comment_meta_type_vflt` (`comment_meta_type`,`comment_meta_vfloat_idx`),
[461] Fix | Delete
KEY `mt_comment_meta_type_vdt` (`comment_meta_type`,`comment_meta_vdatetime_idx`),
[462] Fix | Delete
KEY `mt_comment_meta_type_vchar` (`comment_meta_type`,`comment_meta_vchar_idx`)
[463] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[464] Fix | Delete
[465] Fix | Delete
-- --------------------------------------------------------
[466] Fix | Delete
[467] Fix | Delete
--
[468] Fix | Delete
-- Table structure for table `mt_config`
[469] Fix | Delete
--
[470] Fix | Delete
[471] Fix | Delete
CREATE TABLE `mt_config` (
[472] Fix | Delete
`config_id` int(11) NOT NULL AUTO_INCREMENT,
[473] Fix | Delete
`config_data` mediumtext,
[474] Fix | Delete
PRIMARY KEY (`config_id`)
[475] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
[476] Fix | Delete
[477] Fix | Delete
--
[478] Fix | Delete
-- Dumping data for table `mt_config`
[479] Fix | Delete
--
[480] Fix | Delete
[481] Fix | Delete
INSERT INTO `mt_config` VALUES
[482] Fix | Delete
(1, 'MTReleaseNumber 13\nMTVersion 5.2\nPluginSchemaVersion stylecatcher=1.0\nPluginSchemaVersion multiblog=2.3\nPluginSchemaVersion WidgetManager=1.1\nPluginSchemaVersion formattedtext=1.00\nSchemaVersion 5.0036\n');
[483] Fix | Delete
[484] Fix | Delete
-- --------------------------------------------------------
[485] Fix | Delete
[486] Fix | Delete
--
[487] Fix | Delete
-- Table structure for table `mt_entry`
[488] Fix | Delete
--
[489] Fix | Delete
[490] Fix | Delete
CREATE TABLE `mt_entry` (
[491] Fix | Delete
`entry_id` int(11) NOT NULL AUTO_INCREMENT,
[492] Fix | Delete
`entry_allow_comments` tinyint(4) DEFAULT NULL,
[493] Fix | Delete
`entry_allow_pings` tinyint(4) DEFAULT NULL,
[494] Fix | Delete
`entry_atom_id` varchar(255) DEFAULT NULL,
[495] Fix | Delete
`entry_author_id` int(11) NOT NULL,
[496] Fix | Delete
`entry_authored_on` datetime DEFAULT NULL,
[497] Fix | Delete
`entry_basename` varchar(255) DEFAULT NULL,
[498] Fix | Delete
`entry_blog_id` int(11) NOT NULL,
[499] Fix | Delete
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function