SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;
-- Database: `soft_mt5213`
-- --------------------------------------------------------
-- Table structure for table `mt_asset`
CREATE TABLE `mt_asset` (
`asset_id` int(11) NOT NULL AUTO_INCREMENT,
`asset_blog_id` int(11) NOT NULL,
`asset_class` varchar(255) DEFAULT 'file',
`asset_created_by` int(11) DEFAULT NULL,
`asset_created_on` datetime DEFAULT NULL,
`asset_description` mediumtext,
`asset_file_ext` varchar(20) DEFAULT NULL,
`asset_file_name` varchar(255) DEFAULT NULL,
`asset_file_path` varchar(255) DEFAULT NULL,
`asset_label` varchar(255) DEFAULT NULL,
`asset_mime_type` varchar(255) DEFAULT NULL,
`asset_modified_by` int(11) DEFAULT NULL,
`asset_modified_on` datetime DEFAULT NULL,
`asset_parent` int(11) DEFAULT NULL,
`asset_url` varchar(255) DEFAULT NULL,
PRIMARY KEY (`asset_id`),
KEY `mt_asset_blog_class_date` (`asset_blog_id`,`asset_class`,`asset_created_on`),
KEY `mt_asset_parent` (`asset_parent`),
KEY `mt_asset_file_ext` (`asset_file_ext`),
KEY `mt_asset_created_on` (`asset_created_on`),
KEY `mt_asset_class` (`asset_class`),
KEY `mt_asset_label` (`asset_label`),
KEY `mt_asset_created_by` (`asset_created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `mt_asset_meta`
CREATE TABLE `mt_asset_meta` (
`asset_meta_asset_id` int(11) NOT NULL,
`asset_meta_type` varchar(75) NOT NULL,
`asset_meta_vchar` varchar(255) DEFAULT NULL,
`asset_meta_vchar_idx` varchar(255) DEFAULT NULL,
`asset_meta_vdatetime` datetime DEFAULT NULL,
`asset_meta_vdatetime_idx` datetime DEFAULT NULL,
`asset_meta_vinteger` int(11) DEFAULT NULL,
`asset_meta_vinteger_idx` int(11) DEFAULT NULL,
`asset_meta_vfloat` float DEFAULT NULL,
`asset_meta_vfloat_idx` float DEFAULT NULL,
`asset_meta_vblob` mediumblob,
`asset_meta_vclob` mediumtext,
PRIMARY KEY (`asset_meta_asset_id`,`asset_meta_type`),
KEY `mt_asset_meta_type_vint` (`asset_meta_type`,`asset_meta_vinteger_idx`),
KEY `mt_asset_meta_type_vflt` (`asset_meta_type`,`asset_meta_vfloat_idx`),
KEY `mt_asset_meta_type_vdt` (`asset_meta_type`,`asset_meta_vdatetime_idx`),
KEY `mt_asset_meta_type_vchar` (`asset_meta_type`,`asset_meta_vchar_idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `mt_association`
CREATE TABLE `mt_association` (
`association_id` int(11) NOT NULL AUTO_INCREMENT,
`association_author_id` int(11) DEFAULT '0',
`association_blog_id` int(11) DEFAULT '0',
`association_created_by` int(11) DEFAULT NULL,
`association_created_on` datetime DEFAULT NULL,
`association_group_id` int(11) DEFAULT '0',
`association_modified_by` int(11) DEFAULT NULL,
`association_modified_on` datetime DEFAULT NULL,
`association_role_id` int(11) DEFAULT '0',
`association_type` int(11) NOT NULL,
PRIMARY KEY (`association_id`),
KEY `mt_association_author_id` (`association_author_id`),
KEY `mt_association_group_id` (`association_group_id`),
KEY `mt_association_created_on` (`association_created_on`),
KEY `mt_association_type` (`association_type`),
KEY `mt_association_blog_id` (`association_blog_id`),
KEY `mt_association_role_id` (`association_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- Dumping data for table `mt_association`
INSERT INTO `mt_association` VALUES
(1, 1, 1, 1, '[[regtime]]', 0, NULL, '[[regtime]]', 1, 1);
-- --------------------------------------------------------
-- Table structure for table `mt_author`
CREATE TABLE `mt_author` (
`author_id` int(11) NOT NULL AUTO_INCREMENT,
`author_api_password` varchar(60) DEFAULT NULL,
`author_auth_type` varchar(50) DEFAULT NULL,
`author_basename` varchar(255) DEFAULT NULL,
`author_can_create_blog` tinyint(4) DEFAULT NULL,
`author_can_view_log` tinyint(4) DEFAULT NULL,
`author_created_by` int(11) DEFAULT NULL,
`author_created_on` datetime DEFAULT NULL,
`author_date_format` varchar(30) DEFAULT 'relative',
`author_email` varchar(127) DEFAULT NULL,
`author_entry_prefs` varchar(255) DEFAULT NULL,
`author_external_id` varchar(255) DEFAULT NULL,
`author_hint` varchar(75) DEFAULT NULL,
`author_is_superuser` tinyint(4) DEFAULT NULL,
`author_locked_out_time` int(11) NOT NULL DEFAULT '0',
`author_modified_by` int(11) DEFAULT NULL,
`author_modified_on` datetime DEFAULT NULL,
`author_name` varchar(255) NOT NULL,
`author_nickname` varchar(255) DEFAULT NULL,
`author_password` varchar(124) NOT NULL,
`author_preferred_language` varchar(50) DEFAULT NULL,
`author_public_key` mediumtext,
`author_remote_auth_token` varchar(50) DEFAULT NULL,
`author_remote_auth_username` varchar(50) DEFAULT NULL,
`author_status` int(11) DEFAULT '1',
`author_text_format` varchar(30) DEFAULT NULL,
`author_type` smallint(6) NOT NULL DEFAULT '1',
`author_url` varchar(255) DEFAULT NULL,
`author_userpic_asset_id` int(11) DEFAULT NULL,
PRIMARY KEY (`author_id`),
KEY `mt_author_auth_type_name` (`author_auth_type`,`author_name`,`author_type`),
KEY `mt_author_locked_out_time` (`author_locked_out_time`),
KEY `mt_author_status` (`author_status`),
KEY `mt_author_name` (`author_name`),
KEY `mt_author_basename` (`author_basename`),
KEY `mt_author_email` (`author_email`),
KEY `mt_author_external_id` (`author_external_id`),
KEY `mt_author_created_on` (`author_created_on`),
KEY `mt_author_type` (`author_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- Dumping data for table `mt_author`
INSERT INTO `mt_author` VALUES
(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);
-- --------------------------------------------------------
-- Table structure for table `mt_author_meta`
CREATE TABLE `mt_author_meta` (
`author_meta_author_id` int(11) NOT NULL,
`author_meta_type` varchar(75) NOT NULL,
`author_meta_vchar` varchar(255) DEFAULT NULL,
`author_meta_vchar_idx` varchar(255) DEFAULT NULL,
`author_meta_vdatetime` datetime DEFAULT NULL,
`author_meta_vdatetime_idx` datetime DEFAULT NULL,
`author_meta_vinteger` int(11) DEFAULT NULL,
`author_meta_vinteger_idx` int(11) DEFAULT NULL,
`author_meta_vfloat` float DEFAULT NULL,
`author_meta_vfloat_idx` float DEFAULT NULL,
`author_meta_vblob` mediumblob,
`author_meta_vclob` mediumtext,
PRIMARY KEY (`author_meta_author_id`,`author_meta_type`),
KEY `mt_author_meta_type_vint` (`author_meta_type`,`author_meta_vinteger_idx`),
KEY `mt_author_meta_type_vflt` (`author_meta_type`,`author_meta_vfloat_idx`),
KEY `mt_author_meta_type_vdt` (`author_meta_type`,`author_meta_vdatetime_idx`),
KEY `mt_author_meta_type_vchar` (`author_meta_type`,`author_meta_vchar_idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `mt_author_meta`
INSERT INTO `mt_author_meta` VALUES
(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),
(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);
-- --------------------------------------------------------
-- Table structure for table `mt_author_summary`
CREATE TABLE `mt_author_summary` (
`author_summary_author_id` int(11) NOT NULL,
`author_summary_type` varchar(75) NOT NULL,
`author_summary_class` varchar(75) NOT NULL,
`author_summary_vchar_idx` varchar(255) DEFAULT NULL,
`author_summary_vinteger_idx` int(11) DEFAULT NULL,
`author_summary_vblob` mediumblob,
`author_summary_vclob` mediumtext,
`author_summary_expired` smallint(6) DEFAULT NULL,
PRIMARY KEY (`author_summary_author_id`,`author_summary_type`),
KEY `mt_author_summary_class_vint` (`author_summary_class`,`author_summary_vinteger_idx`),
KEY `mt_author_summary_id_class` (`author_summary_author_id`,`author_summary_class`),
KEY `mt_author_summary_class_vchar` (`author_summary_class`,`author_summary_vchar_idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `mt_blog`
`blog_id` int(11) NOT NULL AUTO_INCREMENT,
`blog_allow_anon_comments` tinyint(4) DEFAULT NULL,
`blog_allow_comment_html` tinyint(4) DEFAULT NULL,
`blog_allow_commenter_regist` tinyint(4) DEFAULT NULL,
`blog_allow_comments_default` tinyint(4) DEFAULT NULL,
`blog_allow_pings` tinyint(4) DEFAULT NULL,
`blog_allow_pings_default` tinyint(4) DEFAULT NULL,
`blog_allow_reg_comments` tinyint(4) DEFAULT NULL,
`blog_allow_unreg_comments` tinyint(4) DEFAULT NULL,
`blog_archive_path` varchar(255) DEFAULT NULL,
`blog_archive_tmpl_category` varchar(255) DEFAULT NULL,
`blog_archive_tmpl_daily` varchar(255) DEFAULT NULL,
`blog_archive_tmpl_individual` varchar(255) DEFAULT NULL,
`blog_archive_tmpl_monthly` varchar(255) DEFAULT NULL,
`blog_archive_tmpl_weekly` varchar(255) DEFAULT NULL,
`blog_archive_type` varchar(255) DEFAULT NULL,
`blog_archive_type_preferred` varchar(25) DEFAULT NULL,
`blog_archive_url` varchar(255) DEFAULT NULL,
`blog_autodiscover_links` tinyint(4) DEFAULT NULL,
`blog_autolink_urls` tinyint(4) DEFAULT NULL,
`blog_basename_limit` smallint(6) DEFAULT NULL,
`blog_cc_license` varchar(255) DEFAULT NULL,
`blog_children_modified_on` datetime DEFAULT NULL,
`blog_class` varchar(255) DEFAULT 'blog',
`blog_content_css` varchar(255) DEFAULT NULL,
`blog_convert_paras` varchar(30) DEFAULT NULL,
`blog_convert_paras_comments` varchar(30) DEFAULT NULL,
`blog_created_by` int(11) DEFAULT NULL,
`blog_created_on` datetime DEFAULT NULL,
`blog_custom_dynamic_templates` varchar(25) DEFAULT 'none',
`blog_date_language` varchar(5) DEFAULT NULL,
`blog_days_on_index` int(11) DEFAULT NULL,
`blog_description` mediumtext,
`blog_email_new_comments` tinyint(4) DEFAULT NULL,
`blog_email_new_pings` tinyint(4) DEFAULT NULL,
`blog_entries_on_index` int(11) DEFAULT NULL,
`blog_file_extension` varchar(10) DEFAULT NULL,
`blog_google_api_key` varchar(32) DEFAULT NULL,
`blog_internal_autodiscovery` tinyint(4) DEFAULT NULL,
`blog_is_dynamic` tinyint(4) DEFAULT NULL,
`blog_junk_folder_expiry` int(11) DEFAULT NULL,
`blog_junk_score_threshold` float DEFAULT NULL,
`blog_language` varchar(5) DEFAULT NULL,
`blog_manual_approve_commenters` tinyint(4) DEFAULT NULL,
`blog_moderate_pings` tinyint(4) DEFAULT NULL,
`blog_moderate_unreg_comments` tinyint(4) DEFAULT NULL,
`blog_modified_by` int(11) DEFAULT NULL,
`blog_modified_on` datetime DEFAULT NULL,
`blog_mt_update_key` varchar(30) DEFAULT NULL,
`blog_name` varchar(255) NOT NULL,
`blog_old_style_archive_links` tinyint(4) DEFAULT NULL,
`blog_parent_id` int(11) DEFAULT NULL,
`blog_ping_blogs` tinyint(4) DEFAULT NULL,
`blog_ping_google` tinyint(4) DEFAULT NULL,
`blog_ping_others` mediumtext,
`blog_ping_technorati` tinyint(4) DEFAULT NULL,
`blog_ping_weblogs` tinyint(4) DEFAULT NULL,
`blog_remote_auth_token` varchar(50) DEFAULT NULL,
`blog_require_comment_emails` tinyint(4) DEFAULT NULL,
`blog_sanitize_spec` varchar(255) DEFAULT NULL,
`blog_server_offset` float DEFAULT NULL,
`blog_site_path` varchar(255) DEFAULT NULL,
`blog_site_url` varchar(255) DEFAULT NULL,
`blog_sort_order_comments` varchar(8) DEFAULT NULL,
`blog_sort_order_posts` varchar(8) DEFAULT NULL,
`blog_status_default` smallint(6) DEFAULT NULL,
`blog_theme_id` varchar(255) DEFAULT NULL,
`blog_use_comment_confirmation` tinyint(4) DEFAULT NULL,
`blog_use_revision` tinyint(4) DEFAULT NULL,
`blog_welcome_msg` mediumtext,
`blog_words_in_excerpt` smallint(6) DEFAULT NULL,
KEY `mt_blog_name` (`blog_name`),
KEY `mt_blog_class` (`blog_class`),
KEY `mt_blog_parent_id` (`blog_parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- Dumping data for table `mt_blog`
INSERT INTO `mt_blog` VALUES
(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);
-- --------------------------------------------------------
-- Table structure for table `mt_blog_meta`
CREATE TABLE `mt_blog_meta` (
`blog_meta_blog_id` int(11) NOT NULL,
`blog_meta_type` varchar(75) NOT NULL,
`blog_meta_vchar` varchar(255) DEFAULT NULL,
`blog_meta_vchar_idx` varchar(255) DEFAULT NULL,
`blog_meta_vdatetime` datetime DEFAULT NULL,
`blog_meta_vdatetime_idx` datetime DEFAULT NULL,
`blog_meta_vinteger` int(11) DEFAULT NULL,
`blog_meta_vinteger_idx` int(11) DEFAULT NULL,
`blog_meta_vfloat` float DEFAULT NULL,
`blog_meta_vfloat_idx` float DEFAULT NULL,
`blog_meta_vblob` mediumblob,
`blog_meta_vclob` mediumtext,
PRIMARY KEY (`blog_meta_blog_id`,`blog_meta_type`),
KEY `mt_blog_meta_type_vint` (`blog_meta_type`,`blog_meta_vinteger_idx`),
KEY `mt_blog_meta_type_vflt` (`blog_meta_type`,`blog_meta_vfloat_idx`),
KEY `mt_blog_meta_type_vdt` (`blog_meta_type`,`blog_meta_vdatetime_idx`),
KEY `mt_blog_meta_type_vchar` (`blog_meta_type`,`blog_meta_vchar_idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `mt_blog_meta`
INSERT INTO `mt_blog_meta` VALUES
(1, 'commenter_authenticators', 'MovableType,LiveJournal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1, 'follow_auth_links', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(1, 'nofollow_urls', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL),
(1, 'page_layout', 'layout-wtt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
-- Table structure for table `mt_category`
CREATE TABLE `mt_category` (
`category_id` int(11) NOT NULL AUTO_INCREMENT,
`category_allow_pings` tinyint(4) DEFAULT '0',
`category_author_id` int(11) DEFAULT NULL,
`category_basename` varchar(255) DEFAULT NULL,
`category_blog_id` int(11) NOT NULL,
`category_class` varchar(255) DEFAULT 'category',
`category_created_by` int(11) DEFAULT NULL,
`category_created_on` datetime DEFAULT NULL,
`category_description` mediumtext,
`category_label` varchar(100) NOT NULL,
`category_modified_by` int(11) DEFAULT NULL,
`category_modified_on` datetime DEFAULT NULL,
`category_parent` int(11) DEFAULT '0',
`category_ping_urls` mediumtext,
PRIMARY KEY (`category_id`),
KEY `mt_category_blog_basename` (`category_blog_id`,`category_basename`),
KEY `mt_category_parent` (`category_parent`),
KEY `mt_category_class` (`category_class`),
KEY `mt_category_blog_class` (`category_blog_id`,`category_class`),
KEY `mt_category_label` (`category_label`),
KEY `mt_category_blog_id` (`category_blog_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `mt_category_meta`
CREATE TABLE `mt_category_meta` (
`category_meta_category_id` int(11) NOT NULL,
`category_meta_type` varchar(75) NOT NULL,
`category_meta_vchar` varchar(255) DEFAULT NULL,
`category_meta_vchar_idx` varchar(255) DEFAULT NULL,
`category_meta_vdatetime` datetime DEFAULT NULL,
`category_meta_vdatetime_idx` datetime DEFAULT NULL,
`category_meta_vinteger` int(11) DEFAULT NULL,
`category_meta_vinteger_idx` int(11) DEFAULT NULL,
`category_meta_vfloat` float DEFAULT NULL,
`category_meta_vfloat_idx` float DEFAULT NULL,
`category_meta_vblob` mediumblob,
`category_meta_vclob` mediumtext,
PRIMARY KEY (`category_meta_category_id`,`category_meta_type`),
KEY `mt_category_meta_type_vint` (`category_meta_type`,`category_meta_vinteger_idx`),
KEY `mt_category_meta_type_vflt` (`category_meta_type`,`category_meta_vfloat_idx`),
KEY `mt_category_meta_type_vdt` (`category_meta_type`,`category_meta_vdatetime_idx`),
KEY `mt_category_meta_type_vchar` (`category_meta_type`,`category_meta_vchar_idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `mt_comment`
CREATE TABLE `mt_comment` (
`comment_id` int(11) NOT NULL AUTO_INCREMENT,
`comment_author` varchar(100) DEFAULT NULL,
`comment_blog_id` int(11) NOT NULL,
`comment_commenter_id` int(11) DEFAULT NULL,
`comment_created_by` int(11) DEFAULT NULL,
`comment_created_on` datetime DEFAULT NULL,
`comment_email` varchar(127) DEFAULT NULL,
`comment_entry_id` int(11) NOT NULL,
`comment_ip` varchar(50) DEFAULT NULL,
`comment_junk_log` mediumtext,
`comment_junk_score` float DEFAULT NULL,
`comment_junk_status` smallint(6) DEFAULT '1',
`comment_last_moved_on` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
`comment_modified_by` int(11) DEFAULT NULL,
`comment_modified_on` datetime DEFAULT NULL,
`comment_parent_id` int(11) DEFAULT NULL,
`comment_text` mediumtext,
`comment_url` varchar(255) DEFAULT NULL,
`comment_visible` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`comment_id`),
KEY `mt_comment_blog_stat` (`comment_blog_id`,`comment_junk_status`,`comment_created_on`),
KEY `mt_comment_commenter_id` (`comment_commenter_id`),
KEY `mt_comment_dd_coment_vis_mod` (`comment_visible`,`comment_modified_on`),
KEY `mt_comment_visible_date` (`comment_visible`,`comment_created_on`),
KEY `mt_comment_author` (`comment_author`),
KEY `mt_comment_entry_visible` (`comment_entry_id`,`comment_visible`,`comment_created_on`),
KEY `mt_comment_email` (`comment_email`),
KEY `mt_comment_blog_junk_stat` (`comment_blog_id`,`comment_junk_status`,`comment_last_moved_on`),
KEY `mt_comment_blog_visible` (`comment_blog_id`,`comment_visible`,`comment_created_on`,`comment_id`),
KEY `mt_comment_last_moved_on` (`comment_last_moved_on`),
KEY `mt_comment_blog_ip_date` (`comment_blog_id`,`comment_ip`,`comment_created_on`),
KEY `mt_comment_blog_visible_entry` (`comment_blog_id`,`comment_visible`,`comment_entry_id`),
KEY `mt_comment_blog_url` (`comment_blog_id`,`comment_visible`,`comment_url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `mt_comment_meta`
CREATE TABLE `mt_comment_meta` (
`comment_meta_comment_id` int(11) NOT NULL,
`comment_meta_type` varchar(75) NOT NULL,
`comment_meta_vchar` varchar(255) DEFAULT NULL,
`comment_meta_vchar_idx` varchar(255) DEFAULT NULL,
`comment_meta_vdatetime` datetime DEFAULT NULL,
`comment_meta_vdatetime_idx` datetime DEFAULT NULL,
`comment_meta_vinteger` int(11) DEFAULT NULL,
`comment_meta_vinteger_idx` int(11) DEFAULT NULL,
`comment_meta_vfloat` float DEFAULT NULL,
`comment_meta_vfloat_idx` float DEFAULT NULL,
`comment_meta_vblob` mediumblob,
`comment_meta_vclob` mediumtext,
PRIMARY KEY (`comment_meta_comment_id`,`comment_meta_type`),
KEY `mt_comment_meta_type_vint` (`comment_meta_type`,`comment_meta_vinteger_idx`),
KEY `mt_comment_meta_type_vflt` (`comment_meta_type`,`comment_meta_vfloat_idx`),
KEY `mt_comment_meta_type_vdt` (`comment_meta_type`,`comment_meta_vdatetime_idx`),
KEY `mt_comment_meta_type_vchar` (`comment_meta_type`,`comment_meta_vchar_idx`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `mt_config`
CREATE TABLE `mt_config` (
`config_id` int(11) NOT NULL AUTO_INCREMENT,
`config_data` mediumtext,
PRIMARY KEY (`config_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- Dumping data for table `mt_config`
INSERT INTO `mt_config` VALUES
(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');
-- --------------------------------------------------------
-- Table structure for table `mt_entry`
CREATE TABLE `mt_entry` (
`entry_id` int(11) NOT NULL AUTO_INCREMENT,
`entry_allow_comments` tinyint(4) DEFAULT NULL,
`entry_allow_pings` tinyint(4) DEFAULT NULL,
`entry_atom_id` varchar(255) DEFAULT NULL,
`entry_author_id` int(11) NOT NULL,
`entry_authored_on` datetime DEFAULT NULL,
`entry_basename` varchar(255) DEFAULT NULL,
`entry_blog_id` int(11) NOT NULL,