MyThink_old
/
mythink.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50547
Source Host           : localhost:3306
Source Database       : mythink

Target Server Type    : MYSQL
Target Server Version : 50547
File Encoding         : 65001

Date: 2017-03-22 00:09:33
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for mt_addon
-- ----------------------------
DROP TABLE IF EXISTS `mt_addon`;
CREATE TABLE `mt_addon` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(40) NOT NULL COMMENT '插件名或标识',
  `title` varchar(20) NOT NULL DEFAULT '' COMMENT '中文名',
  `description` text COMMENT '插件描述',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `config` text COMMENT '配置',
  `author` varchar(40) DEFAULT '' COMMENT '作者',
  `version` varchar(20) DEFAULT '' COMMENT '版本号',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '安装时间',
  `has_adminlist` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否有后台列表',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='插件表';

-- ----------------------------
-- Records of mt_addon
-- ----------------------------
INSERT INTO `mt_addon` VALUES ('1', 'Editor', '前台编辑器', '用于增强整站长文本的输入和显示', '1', '{\"editor_type\":\"1\",\"editor_wysiwyg\":1,\"editor_height\":\"300px\",\"editor_resize_type\":\"1\"}', 'thinkphp', '0.1', '1453363163', '0');
INSERT INTO `mt_addon` VALUES ('2', 'EditorForAdmin', '后台编辑器', '用于增强整站长文本的输入和显示', '1', '{\"editor_type\":\"2\",\"editor_wysiwyg\":\"1\",\"editor_markdownpreview\":\"1\",\"editor_height\":\"300px\",\"editor_resize_type\":\"1\"}', 'thinkphp', '0.2', '1453363165', '0');
INSERT INTO `mt_addon` VALUES ('3', 'Email', '邮件插件', '实现系统发邮件功能', '1', '{\"status\":\"1\",\"MAIL_SMTP_TYPE\":\"1\",\"MAIL_SMTP_SECURE\":\"0\",\"MAIL_SMTP_PORT\":\"25\",\"MAIL_SMTP_HOST\":\"smtp.qq.com\",\"MAIL_SMTP_USER\":\"\",\"MAIL_SMTP_PASS\":\"\",\"default\":\"\"}', 'CoreThink', '1.0', '1453363167', '0');
INSERT INTO `mt_addon` VALUES ('4', 'SocialComment', '通用社交化评论', '集成了各种社交化评论插件，轻松集成到系统中。', '0', '{\"comment_type\":\"1\",\"comment_uid_youyan\":\"90040\",\"comment_short_name_duoshuo\":\"\",\"comment_form_pos_duoshuo\":\"buttom\",\"comment_data_list_duoshuo\":\"10\",\"comment_data_order_duoshuo\":\"asc\"}', 'thinkphp', '0.1', '1453363170', '0');
INSERT INTO `mt_addon` VALUES ('5', 'SyncLogin', '第三方账号登陆', '第三方账号登陆', '1', '{\"type\":null,\"meta\":\"\",\"WeixinKEY\":\"\",\"WeixinSecret\":\"\",\"QqKEY\":\"\",\"QqSecret\":\"\",\"SinaKEY\":\"\",\"SinaSecret\":\"\",\"RenrenKEY\":\"\",\"RenrenSecret\":\"\"}', 'CoreThink', '0.1', '1453363172', '1');

-- ----------------------------
-- Table structure for mt_addon_hook
-- ----------------------------
DROP TABLE IF EXISTS `mt_addon_hook`;
CREATE TABLE `mt_addon_hook` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(40) NOT NULL DEFAULT '' COMMENT '钩子名称',
  `description` text COMMENT '描述',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '类型',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `addons` varchar(255) NOT NULL DEFAULT '' COMMENT '钩子挂载的插件 ''，''分割',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='插件钩子';

-- ----------------------------
-- Records of mt_addon_hook
-- ----------------------------
INSERT INTO `mt_addon_hook` VALUES ('1', 'pageHeader', '页面header钩子，一般用于加载插件CSS文件和代码', '1', '1453359611', '', '1');
INSERT INTO `mt_addon_hook` VALUES ('2', 'pageFooter', '页面footer钩子，一般用于加载插件JS文件和JS代码', '1', '1453358880', 'ReturnTop', '1');
INSERT INTO `mt_addon_hook` VALUES ('3', 'documentEditForm', '添加编辑表单的 扩展内容钩子', '1', '0', 'Attachment', '1');
INSERT INTO `mt_addon_hook` VALUES ('4', 'documentDetailAfter', '文档末尾显示', '1', '0', 'Attachment,SocialComment', '1');
INSERT INTO `mt_addon_hook` VALUES ('5', 'documentDetailBefore', '页面内容前显示用钩子', '1', '0', '', '1');
INSERT INTO `mt_addon_hook` VALUES ('7', 'documentEditFormContent', '添加编辑表单的内容显示钩子', '1', '0', 'Editor', '1');
INSERT INTO `mt_addon_hook` VALUES ('8', 'adminArticleEdit', '后台内容编辑页编辑器', '1', '1378982734', 'EditorForAdmin', '1');
INSERT INTO `mt_addon_hook` VALUES ('9', 'AdminIndex', '首页小格子个性化显示', '1', '1382596073', 'SiteStat,SystemInfo,DevTeam', '1');
INSERT INTO `mt_addon_hook` VALUES ('10', 'topicComment', '评论提交方式扩展钩子。', '1', '1380163518', 'Editor', '1');
INSERT INTO `mt_addon_hook` VALUES ('11', 'app_begin', '应用开始', '2', '1384481614', '', '1');

-- ----------------------------
-- Table structure for mt_addon_sync_login
-- ----------------------------
DROP TABLE IF EXISTS `mt_addon_sync_login`;
CREATE TABLE `mt_addon_sync_login` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `uid` int(11) unsigned NOT NULL COMMENT '用户ID',
  `type` varchar(15) NOT NULL DEFAULT '' COMMENT '类别',
  `openid` varchar(64) NOT NULL DEFAULT '' COMMENT 'OpenID',
  `access_token` varchar(64) NOT NULL DEFAULT '' COMMENT 'AccessToken',
  `refresh_token` varchar(64) NOT NULL DEFAULT '' COMMENT 'RefreshToken',
  `ctime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `utime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='第三方登陆插件表';

-- ----------------------------
-- Records of mt_addon_sync_login
-- ----------------------------

-- ----------------------------
-- Table structure for mt_admin
-- ----------------------------
DROP TABLE IF EXISTS `mt_admin`;
CREATE TABLE `mt_admin` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员ID',
  `username` varchar(32) DEFAULT NULL COMMENT '管理员账号',
  `password` varchar(36) DEFAULT NULL COMMENT '管理员密码',
  `login_time` int(11) DEFAULT NULL COMMENT '最后登录时间',
  `login_count` mediumint(8) NOT NULL COMMENT '登录次数',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '账户状态，禁用为0   启用为1',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `last_login_ip` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='管理用户表';

-- ----------------------------
-- Records of mt_admin
-- ----------------------------
INSERT INTO `mt_admin` VALUES ('1', 'admin', '21232f297a57a5a743894a0e4a801fc3', '1474375300', '445', '1', '1451616852', '0.0.0.0');
INSERT INTO `mt_admin` VALUES ('2', 'ceshi', '21232f297a57a5a743894a0e4a801fc3', '1452355449', '6', '1', '1451981700', '0.0.0.0');
INSERT INTO `mt_admin` VALUES ('3', 'ceshi2', '21232f297a57a5a743894a0e4a801fc3', '1452927862', '4', '1', '1451981664', '0.0.0.0');
INSERT INTO `mt_admin` VALUES ('4', 'ceshi3', '21232f297a57a5a743894a0e4a801fc3', '1452003624', '0', '1', '1452004827', null);

-- ----------------------------
-- Table structure for mt_article
-- ----------------------------
DROP TABLE IF EXISTS `mt_article`;
CREATE TABLE `mt_article` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文档ID',
  `title` char(80) NOT NULL DEFAULT '' COMMENT '标题',
  `category_id` int(10) unsigned NOT NULL COMMENT '所属分类',
  `img` varchar(255) DEFAULT NULL COMMENT '缩略图',
  `keyword` varchar(255) DEFAULT NULL COMMENT '关键词',
  `description` char(140) DEFAULT '' COMMENT '描述',
  `position` varchar(50) DEFAULT '' COMMENT '推荐位',
  `sort` int(10) DEFAULT '0' COMMENT '排序',
  `link` varchar(100) DEFAULT NULL COMMENT '外链',
  `tag` varchar(255) DEFAULT NULL COMMENT '标签',
  `content` text COMMENT '内容',
  `writer` int(10) DEFAULT '0' COMMENT '作者',
  `view` int(10) unsigned DEFAULT '0' COMMENT '浏览量',
  `comment` int(10) unsigned DEFAULT '0' COMMENT '评论数',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `ding` tinyint(4) DEFAULT '0' COMMENT '顶贴',
  `cai` tinyint(4) DEFAULT '0' COMMENT '踩贴',
  `display` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '可见性',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '数据状态',
  PRIMARY KEY (`id`),
  KEY `idx_category_status` (`category_id`,`status`),
  KEY `idx_status_type_pid` (`status`,`writer`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='文档表';

-- ----------------------------
-- Records of mt_article
-- ----------------------------
INSERT INTO `mt_article` VALUES ('1', 'MyThink0.1开发版发布2', '8', '111.gif', 'Mythink,thinkphp', '12312', '1,2,3', '12', '', '2', '&lt;p style=&quot;vertical-align:baseline;text-indent:2em;font-family:\'Classic Grotesque W01\', \'Hiragino Sans GB\', \'Microsoft YaHei\', STHeiti, \'WenQuanYi Micro Hei\', Arial, SimSun, sans-serif;font-size:16px;background-color:#FFFFFF;&quot;&gt;\r\n	在维基百科上出现相关文章，El Reg网站本周报道之后，维基媒体基金会公布了来自奈特基金会的25万美元捐款。这是总耗资250万美元项目的第一阶段。\r\n&lt;/p&gt;\r\n&lt;p class=&quot;f_center&quot; style=&quot;vertical-align:baseline;text-indent:2em;font-family:\'Classic Grotesque W01\', \'Hiragino Sans GB\', \'Microsoft YaHei\', STHeiti, \'WenQuanYi Micro Hei\', Arial, SimSun, sans-serif;font-size:16px;background-color:#FFFFFF;&quot;&gt;\r\n	&lt;a target=&quot;_blank&quot; href=&quot;http://static.cnbetacdn.com/article/2016/0215/40a5fc9d94b8c13.jpg&quot;&gt;&lt;img src=&quot;http://static.cnbetacdn.com/thumb/article/2016/0215/40a5fc9d94b8c13.jpg_600x600.jpg&quot; /&gt;&lt;/a&gt; \r\n&lt;/p&gt;\r\n&lt;p class=&quot;f_center&quot; style=&quot;vertical-align:baseline;text-indent:2em;font-family:\'Classic Grotesque W01\', \'Hiragino Sans GB\', \'Microsoft YaHei\', STHeiti, \'WenQuanYi Micro Hei\', Arial, SimSun, sans-serif;font-size:16px;background-color:#FFFFFF;&quot;&gt;\r\n	早前英国媒体The Register曾经曝光的维基百科“知识引擎”设计文档\r\n&lt;/p&gt;\r\n&lt;p style=&quot;vertical-align:baseline;text-indent:2em;font-family:\'Classic Grotesque W01\', \'Hiragino Sans GB\', \'Microsoft YaHei\', STHeiti, \'WenQuanYi Micro Hei\', Arial, SimSun, sans-serif;font-size:16px;background-color:#FFFFFF;&quot;&gt;\r\n	这笔捐款给知识引擎项目提供了第一阶段资金。知识引擎的目标是帮助用户通过互联网发现可靠、可信的信息。换句话说，这将带来搜索功能。\r\n&lt;/p&gt;\r\n&lt;p style=&quot;vertical-align:baseline;text-indent:2em;font-family:\'Classic Grotesque W01\', \'Hiragino Sans GB\', \'Microsoft YaHei\', STHeiti, \'WenQuanYi Micro Hei\', Arial, SimSun, sans-serif;font-size:16px;background-color:#FFFFFF;&quot;&gt;\r\n	第一阶段的工作包括探索未来维基百科网站的形态，研究如何打通从搜索到内容呈现的通路，并通过运营商和OEM厂商去整合这一知识引擎。\r\n&lt;/p&gt;\r\n&lt;p style=&quot;vertical-align:baseline;text-indent:2em;font-family:\'Classic Grotesque W01\', \'Hiragino Sans GB\', \'Microsoft YaHei\', STHeiti, \'WenQuanYi Micro Hei\', Arial, SimSun, sans-serif;font-size:16px;background-color:#FFFFFF;&quot;&gt;\r\n	维基媒体基金会表示，这一项目的最大风险在于谷歌或雅虎“可能突然向类似项目投入资源”。第一阶段，即“发现阶段”的工作将从今年8月31日开始，持续12个月。\r\n&lt;/p&gt;\r\n&lt;p style=&quot;vertical-align:baseline;text-indent:2em;font-family:\'Classic Grotesque W01\', \'Hiragino Sans GB\', \'Microsoft YaHei\', STHeiti, \'WenQuanYi Micro Hei\', Arial, SimSun, sans-serif;font-size:16px;background-color:#FFFFFF;&quot;&gt;\r\n	威尔士则试图打消维基百科社区的担忧，即维基媒体基金会将基于知识引擎去开发商业搜索引擎。他表示，这种说法是“谎言”。\r\n&lt;/p&gt;', '1', '192', '0', '1454378254', '1455527844', '0', '0', '0', '-1');
INSERT INTO `mt_article` VALUES ('2', 'MyThink0.2开发版发布', '2', null, 'Mythink,thinkphp', '期待已久的MyThink最新版发布', '', '0', '', '', '124213', '1', '8', '0', '1454378254', '1454378254', '0', '0', '1', '1');
INSERT INTO `mt_article` VALUES ('3', 'MyThink0.3开发版发布', '1', null, 'Mythink,thinkphp', '期待已久的MyThink最新版发布', '', '0', '', '', '345435', '1', '8', '0', '1454378254', '1454378254', '0', '0', '1', '1');
INSERT INTO `mt_article` VALUES ('4', 'MyThink0.4开发版发布', '1', null, 'Mythink,thinkphp', '期待已久的MyThink最新版发布', '', '0', '', '', '123123', '1', '8', '0', '1454378254', '1454378254', '0', '0', '1', '1');
INSERT INTO `mt_article` VALUES ('5', 'MyThink1.0开发版发布qq', '6', null, 'Mythink,thinkphp', '期待已久的MyThink最新版发布', '1,2,3', '0', '', '1', '32423斯蒂芬', '1', '159', '0', '1454378254', '1455526871', '0', '0', '1', '1');
INSERT INTO `mt_article` VALUES ('6', '测试文章发布功能', '1', null, '关键词', '描述', '1', '0', '', '', '内容', '0', '228', '0', '1455528609', '1455598222', '0', '0', '1', '1');

-- ----------------------------
-- Table structure for mt_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `mt_auth_group`;
CREATE TABLE `mt_auth_group` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(100) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `rules` char(80) NOT NULL DEFAULT '',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户组';

-- ----------------------------
-- Records of mt_auth_group
-- ----------------------------
INSERT INTO `mt_auth_group` VALUES ('1', '超级管理员', '1', '1,2,3,4,5,6,7,15,8,9,14,31,10,17,18,19,24,25,27,26,28,29,11,20,21,12,35,16,33,34', '1451616852');
INSERT INTO `mt_auth_group` VALUES ('2', '频道管理员', '1', '5,6,7,15,8,9,14,31,10,17,18,19,24,25,27,26,28,29,11,20,21,12,35,22,23', '1451617852');
INSERT INTO `mt_auth_group` VALUES ('3', '文章编辑', '1', '5,6,7,15,8,14,31,10,17,18,19,24,25,27,26,28,29', '1451618259');

-- ----------------------------
-- Table structure for mt_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `mt_auth_group_access`;
CREATE TABLE `mt_auth_group_access` (
  `uid` smallint(5) unsigned NOT NULL,
  `group_id` smallint(5) unsigned NOT NULL,
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户和组对应关系';

-- ----------------------------
-- Records of mt_auth_group_access
-- ----------------------------
INSERT INTO `mt_auth_group_access` VALUES ('1', '1');
INSERT INTO `mt_auth_group_access` VALUES ('2', '2');
INSERT INTO `mt_auth_group_access` VALUES ('3', '3');
INSERT INTO `mt_auth_group_access` VALUES ('4', '3');

-- ----------------------------
-- Table structure for mt_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `mt_auth_rule`;
CREATE TABLE `mt_auth_rule` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(80) NOT NULL DEFAULT '',
  `ico` varchar(32) DEFAULT 'icon-heart',
  `title` varchar(20) NOT NULL DEFAULT '',
  `type` tinyint(1) NOT NULL DEFAULT '1',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `condition` char(100) NOT NULL DEFAULT '',
  `pid` smallint(5) NOT NULL COMMENT '父级ID',
  `sort` tinyint(4) NOT NULL DEFAULT '50' COMMENT '排序',
  `display` int(1) DEFAULT '1' COMMENT '导航显示',
  `create_time` int(11) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COMMENT='认证规则';

-- ----------------------------
-- Records of mt_auth_rule
-- ----------------------------
INSERT INTO `mt_auth_rule` VALUES ('1', 'Manager', 'icon-graduation-cap', '角色', '1', '1', '', '0', '7', '1', '1451596437');
INSERT INTO `mt_auth_rule` VALUES ('2', 'Manager/index', 'icon-group', '管理员列表', '1', '1', '', '1', '1', '1', '1451596437');
INSERT INTO `mt_auth_rule` VALUES ('3', 'Manager/auth_group', 'icon-cubes', '用户组', '1', '1', '', '1', '2', '1', '1451939984');
INSERT INTO `mt_auth_rule` VALUES ('4', 'Manager/auth_rule', 'icon-eye', '权限菜单', '1', '1', '', '1', '3', '1', '1451939984');
INSERT INTO `mt_auth_rule` VALUES ('5', 'Article', 'icon-file-text', '内容', '1', '1', '', '0', '3', '1', '1452002257');
INSERT INTO `mt_auth_rule` VALUES ('6', 'Article/index', 'icon-files-o', '文章列表', '1', '1', '', '5', '1', '1', '1452147314');
INSERT INTO `mt_auth_rule` VALUES ('7', 'Article/add', 'icon-file-text-o', '添加文章', '1', '1', '', '5', '2', '1', '1452147332');
INSERT INTO `mt_auth_rule` VALUES ('8', 'Index', 'icon-home', '开始', '1', '1', '', '0', '1', '1', '1452147332');
INSERT INTO `mt_auth_rule` VALUES ('9', 'Index/log', 'icon-pencil-square-o', '日志管理', '1', '1', '', '8', '2', '1', '1452147332');
INSERT INTO `mt_auth_rule` VALUES ('10', 'Category', 'icon-th-list', '栏目', '1', '1', '', '0', '2', '1', '1452147332');
INSERT INTO `mt_auth_rule` VALUES ('11', 'User', 'icon-user', '用户', '1', '1', '', '0', '4', '1', '1452147332');
INSERT INTO `mt_auth_rule` VALUES ('12', 'Pay', 'icon-shopping-cart', '订单', '1', '1', '', '0', '5', '1', '1452147332');
INSERT INTO `mt_auth_rule` VALUES ('13', 'Manager/group_add', 'icon-group', '添加用户组', '1', '1', '', '3', '50', '1', '1452147332');
INSERT INTO `mt_auth_rule` VALUES ('14', 'Index/index', 'icon-bar-chart-o', '网站概况', '1', '1', '', '8', '1', '1', '1452751478');
INSERT INTO `mt_auth_rule` VALUES ('15', 'Article/recycle', 'icon-trash-o', '回收站', '1', '1', '', '5', '3', '1', '1452755068');
INSERT INTO `mt_auth_rule` VALUES ('16', 'Addon', 'icon-puzzle-piece', '插件', '1', '1', '', '0', '6', '1', '1452778981');
INSERT INTO `mt_auth_rule` VALUES ('17', 'Category/index', 'icon-sitemap', '栏目列表', '1', '1', '', '10', '1', '1', '1452778981');
INSERT INTO `mt_auth_rule` VALUES ('18', 'Category/tag', 'icon-tags', '标签列表', '1', '1', '', '10', '5', '1', '1452838159');
INSERT INTO `mt_auth_rule` VALUES ('19', 'Category/link', 'icon-link', '友情链接', '1', '1', '', '10', '9', '1', '1452838192');
INSERT INTO `mt_auth_rule` VALUES ('20', 'User/index', 'icon-users', '用户列表', '1', '1', '', '11', '1', '1', '1452778981');
INSERT INTO `mt_auth_rule` VALUES ('21', 'User/add', 'icon-user', '添加用户', '1', '1', '', '11', '2', '1', '1452778981');
INSERT INTO `mt_auth_rule` VALUES ('22', 'Config', 'icon-cog', '设置', '1', '1', '', '0', '8', '1', '1452778981');
INSERT INTO `mt_auth_rule` VALUES ('23', 'Config/index', 'icon-sliders', '基本配置', '1', '1', '', '22', '1', '1', '1452778989');
INSERT INTO `mt_auth_rule` VALUES ('24', 'Category/linkadd', 'icon-heart', '添加友情链接', '1', '1', '', '10', '10', '0', '1453097804');
INSERT INTO `mt_auth_rule` VALUES ('25', 'Category/linkedit', 'icon-heart', '编辑友情链接', '1', '1', '', '10', '11', '0', '1453097841');
INSERT INTO `mt_auth_rule` VALUES ('27', 'Category/cateadd', 'icon-heart', '添加栏目', '1', '1', '', '10', '2', '0', '1453098944');
INSERT INTO `mt_auth_rule` VALUES ('26', 'Category/linkdel', 'icon-heart', '删除友情链接', '1', '1', '', '10', '12', '0', '1453097916');
INSERT INTO `mt_auth_rule` VALUES ('30', 'Database/export', 'icon-database', '数据库管理', '1', '1', '', '22', '2', '1', '1453169190');
INSERT INTO `mt_auth_rule` VALUES ('28', 'Category/cateedit', 'icon-heart', '编辑栏目', '1', '1', '', '10', '3', '0', '1453099079');
INSERT INTO `mt_auth_rule` VALUES ('29', 'Category/catedel', 'icon-heart', '删除栏目', '1', '1', '', '10', '4', '0', '1453099125');
INSERT INTO `mt_auth_rule` VALUES ('31', 'Index/visitor', 'icon-heart', '访问统计', '1', '1', '', '8', '3', '1', '1453099125');
INSERT INTO `mt_auth_rule` VALUES ('32', 'Database/import', 'icon-heart', '数据库导入', '1', '1', '', '22', '50', '0', '1453099325');
INSERT INTO `mt_auth_rule` VALUES ('33', 'Addon/Index', 'icon-filter', '插件列表', '1', '1', '', '16', '1', '1', '1453099525');
INSERT INTO `mt_auth_rule` VALUES ('34', 'Addon/config', 'icon-heart', '插件配置', '1', '1', '', '16', '50', '0', '1453099525');
INSERT INTO `mt_auth_rule` VALUES ('35', 'Pay/index', 'icon-heart', '订单列表', '1', '1', '', '12', '50', '1', '1453099525');
INSERT INTO `mt_auth_rule` VALUES ('36', 'Addon/hooks', 'icon-anchor', '钩子管理', '1', '1', '', '16', '2', '1', '1453099525');
INSERT INTO `mt_auth_rule` VALUES ('37', 'Config/uploader', 'icon-heart', '附件配置', '1', '1', '', '22', '50', '1', '1453364076');

-- ----------------------------
-- Table structure for mt_category
-- ----------------------------
DROP TABLE IF EXISTS `mt_category`;
CREATE TABLE `mt_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类ID',
  `pid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父分类ID',
  `group` tinyint(4) NOT NULL DEFAULT '0' COMMENT '分组',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '分类模型',
  `title` varchar(32) NOT NULL DEFAULT '' COMMENT '分类名称',
  `url` varchar(127) NOT NULL COMMENT '链接地址',
  `keyword` varchar(32) NOT NULL DEFAULT '' COMMENT '关键词',
  `desc` varchar(32) NOT NULL DEFAULT '' COMMENT '栏目简介',
  `content` text NOT NULL COMMENT '栏目内容',
  `post_auth` tinyint(4) NOT NULL DEFAULT '0' COMMENT '投稿权限',
  `img` varchar(32) NOT NULL DEFAULT '' COMMENT '缩略图',
  `ctime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `utime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `sort` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='栏目分类表';

-- ----------------------------
-- Records of mt_category
-- ----------------------------
INSERT INTO `mt_category` VALUES ('1', '0', '0', '0', '技术', '', 'php', '', '', '0', '', '0', '0', '0', '0');
INSERT INTO `mt_category` VALUES ('2', '0', '0', '0', '分享', '', '', '', '', '0', '', '0', '0', '0', '0');
INSERT INTO `mt_category` VALUES ('3', '0', '0', '0', '备忘录', '', '', '', '', '0', '', '0', '0', '0', '0');
INSERT INTO `mt_category` VALUES ('4', '0', '0', '0', '杂谈', '', '', '', '', '0', '', '0', '0', '0', '0');
INSERT INTO `mt_category` VALUES ('5', '0', '0', '0', '留言板', '', '', '', '', '0', '', '0', '0', '0', '0');
INSERT INTO `mt_category` VALUES ('6', '1', '0', '0', '子菜单1', '', '', '', '', '0', '', '0', '0', '0', '0');
INSERT INTO `mt_category` VALUES ('7', '1', '0', '0', '子菜单2', '', '', '', '', '0', '', '0', '0', '0', '0');
INSERT INTO `mt_category` VALUES ('8', '2', '0', '0', '子菜单1', '', '', '', '', '0', '', '0', '0', '0', '0');

-- ----------------------------
-- Table structure for mt_config
-- ----------------------------
DROP TABLE IF EXISTS `mt_config`;
CREATE TABLE `mt_config` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `data` varchar(255) DEFAULT NULL,
  `groupid` int(4) NOT NULL DEFAULT '0',
  `desc` varchar(255) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COMMENT='全局配置参数表';

-- ----------------------------
-- Records of mt_config
-- ----------------------------
INSERT INTO `mt_config` VALUES ('1', 'c_title', 'MyThink-通用后台管理', '1', null);
INSERT INTO `mt_config` VALUES ('2', 'c_keyword', 'mythink,thinkphp,php,auth', '1', null);
INSERT INTO `mt_config` VALUES ('3', 'c_desc', '基于thinkphp 3.2.3的通用后台管理系统', '1', null);
INSERT INTO `mt_config` VALUES ('4', 'c_weburl', 'http://127.0.0.1', '1', null);
INSERT INTO `mt_config` VALUES ('5', 'c_email', 'admin@admin.com', '1', null);
INSERT INTO `mt_config` VALUES ('6', 'c_copy', '吉语科技 ©  LIMITED 2016 版权所有', '1', null);
INSERT INTO `mt_config` VALUES ('7', 'c_tongji', '', '1', null);
INSERT INTO `mt_config` VALUES ('8', 'c_isoff', '1', '1', null);
INSERT INTO `mt_config` VALUES ('9', 'c_offdesc', '网站暂停服务，系统升级中……', '1', null);
INSERT INTO `mt_config` VALUES ('10', 'maxSize', '31457280', '2', '文件上传的最大文件大小（以字节为单位），0为不限大小');
INSERT INTO `mt_config` VALUES ('11', 'rootPath', './Uploads/', '2', '文件上传保存的根路径');
INSERT INTO `mt_config` VALUES ('12', 'savePath', '', '2', '文件上传的保存路径（相对于根路径）');
INSERT INTO `mt_config` VALUES ('13', 'exts', 'gif,jpg,png,jpeg,bmp,doc,xls,ppt,zip', '2', '允许上传的文件后缀（留空为不限制），使用数组或者逗号分隔的字符串设置，默认为空');
INSERT INTO `mt_config` VALUES ('14', '1', '', '6', null);
INSERT INTO `mt_config` VALUES ('15', '2', '', '6', null);
INSERT INTO `mt_config` VALUES ('16', '3', 'gif,jpg,png,jpeg,bmp,doc,xls,ppt,zip', '6', null);
INSERT INTO `mt_config` VALUES ('17', '4', '', '6', null);
INSERT INTO `mt_config` VALUES ('18', '5', 'true', '6', null);
INSERT INTO `mt_config` VALUES ('19', '6', ' array(\'date\',\'Ymd\')', '6', null);
INSERT INTO `mt_config` VALUES ('20', 'c_tel', '110', '1', '');
INSERT INTO `mt_config` VALUES ('21', 'c_address', '郑州', '1', null);
INSERT INTO `mt_config` VALUES ('22', 'c_icp', '1234567890', '1', null);
INSERT INTO `mt_config` VALUES ('23', 'c_user', '1', '1', null);
INSERT INTO `mt_config` VALUES ('24', 'c_Lyzm', '1', '1', null);
INSERT INTO `mt_config` VALUES ('25', 'c_Ryzm', '1', '1', null);
INSERT INTO `mt_config` VALUES ('26', 'c_Nword', '艾滋病|共产党', '1', null);
INSERT INTO `mt_config` VALUES ('27', 'c_cookie', 'GfTpnY5Sv', '1', null);
INSERT INTO `mt_config` VALUES ('28', 'baidu_api', 'http://data.zz.baidu.com/urls?site=www.fuzhen.com&token=H8etpDaorKvv1AAZ', '4', null);
INSERT INTO `mt_config` VALUES ('30', 'baidu_autopost', '<script>(function(){var bp=document.createElement(\'script\');bp.src=\'//push.zhanzhang.baidu.com/push.js\';var s=document.getElementsByTagName(\"script\")[0];s.parentNode.insertBefore(bp,s)})();</script>', '4', null);
INSERT INTO `mt_config` VALUES ('29', 'baidu_articlenum', '16926', '4', null);

-- ----------------------------
-- Table structure for mt_link
-- ----------------------------
DROP TABLE IF EXISTS `mt_link`;
CREATE TABLE `mt_link` (
  `id` int(20) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '网址',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '网址名称',
  `img` varchar(255) NOT NULL DEFAULT '' COMMENT '缩略图',
  `description` varchar(255) NOT NULL COMMENT '描述',
  `status` int(20) NOT NULL DEFAULT '1' COMMENT '显示/隐藏',
  `owner` varchar(20) NOT NULL DEFAULT '' COMMENT '拥有者',
  `sort` int(11) NOT NULL DEFAULT '50' COMMENT '排序',
  `time` int(11) NOT NULL DEFAULT '0' COMMENT '添加时间',
  PRIMARY KEY (`id`),
  KEY `link_visible` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='友情链接';

-- ----------------------------
-- Records of mt_link
-- ----------------------------
INSERT INTO `mt_link` VALUES ('1', 'www.jifuns.com', '吉趣网', '/uploads/2016-01-23/56a2fe6b5e0c1.jpg', '吉语自天成，妙手偶得之', '1', '', '1', '1452845284');
INSERT INTO `mt_link` VALUES ('2', 'www.baidu.com', '百毒', '/uploads/2016-01-22/56a1a0a93f172.bmp', '百毒不侵', '1', '', '2', '1452845284');

-- ----------------------------
-- Table structure for mt_spider
-- ----------------------------
DROP TABLE IF EXISTS `mt_spider`;
CREATE TABLE `mt_spider` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `time` int(10) DEFAULT NULL,
  `Google` int(10) DEFAULT '0',
  `GoogleAdsense` int(10) DEFAULT '0',
  `Baidu` int(10) DEFAULT '0',
  `Sogou` int(10) DEFAULT '0',
  `Sogouweb` int(10) DEFAULT '0',
  `soso` int(10) DEFAULT '0',
  `360Spider` int(10) DEFAULT '0',
  `Yahoo` int(10) DEFAULT '0',
  `MSN` int(10) DEFAULT '0',
  `msnbot` int(10) DEFAULT '0',
  `Sohu` int(10) DEFAULT '0',
  `Yodao` int(10) DEFAULT '0',
  `Twiceler` int(10) DEFAULT '0',
  `Alexa_` int(10) DEFAULT '0',
  `Alexa` int(10) DEFAULT '0',
  `other` int(10) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=71 DEFAULT CHARSET=utf8 COMMENT='蜘蛛统计';

-- ----------------------------
-- Records of mt_spider
-- ----------------------------
INSERT INTO `mt_spider` VALUES ('1', '1446739200', '416', '1', '23', '0', '0', '0', '70', '0', '0', '0', '0', '0', '0', '0', '0', '256');
INSERT INTO `mt_spider` VALUES ('2', '1446825600', '1660', '0', '112', '0', '0', '0', '167', '4', '0', '0', '0', '0', '0', '0', '0', '1110');
INSERT INTO `mt_spider` VALUES ('3', '1446912000', '3984', '0', '80', '0', '0', '0', '159', '1', '0', '0', '0', '0', '0', '0', '0', '992');
INSERT INTO `mt_spider` VALUES ('4', '1446998400', '8442', '0', '56', '0', '0', '0', '205', '3', '0', '0', '0', '0', '0', '0', '0', '1008');
INSERT INTO `mt_spider` VALUES ('5', '1447084800', '9381', '0', '68', '0', '1', '0', '157', '1', '0', '0', '0', '0', '0', '0', '0', '1144');
INSERT INTO `mt_spider` VALUES ('6', '1447171200', '0', '0', '238', '0', '7', '0', '280', '0', '0', '0', '0', '0', '0', '0', '0', '1398');
INSERT INTO `mt_spider` VALUES ('7', '1447257600', '0', '0', '102', '0', '1', '0', '264', '5', '0', '0', '0', '0', '0', '0', '0', '1260');
INSERT INTO `mt_spider` VALUES ('8', '1447344000', '1', '0', '112', '0', '1', '0', '220', '4', '0', '0', '0', '0', '0', '0', '0', '1007');
INSERT INTO `mt_spider` VALUES ('9', '1447430400', '0', '0', '146', '0', '2', '0', '276', '1', '0', '0', '0', '0', '0', '0', '0', '898');
INSERT INTO `mt_spider` VALUES ('10', '1447516800', '0', '0', '67', '0', '0', '0', '121', '233', '0', '0', '0', '0', '0', '0', '0', '884');
INSERT INTO `mt_spider` VALUES ('11', '1447603200', '1', '0', '158', '0', '2', '0', '227', '16', '0', '0', '0', '0', '0', '0', '0', '1054');
INSERT INTO `mt_spider` VALUES ('12', '1447689600', '0', '0', '105', '0', '0', '0', '237', '7', '0', '0', '0', '0', '0', '0', '0', '1163');
INSERT INTO `mt_spider` VALUES ('13', '1447776000', '0', '0', '159', '0', '1', '0', '449', '4', '0', '0', '0', '0', '0', '0', '0', '884');
INSERT INTO `mt_spider` VALUES ('14', '1447862400', '0', '0', '185', '0', '1', '0', '236', '3', '0', '0', '0', '0', '0', '0', '0', '931');
INSERT INTO `mt_spider` VALUES ('15', '1447948800', '0', '0', '142', '0', '1', '0', '280', '5', '0', '0', '0', '0', '0', '0', '0', '1514');
INSERT INTO `mt_spider` VALUES ('16', '1448035200', '1', '0', '448', '0', '1', '0', '208', '5', '0', '0', '0', '0', '0', '0', '0', '964');
INSERT INTO `mt_spider` VALUES ('17', '1448121600', '0', '0', '127', '0', '1', '0', '41', '14', '0', '0', '0', '0', '0', '0', '0', '1184');
INSERT INTO `mt_spider` VALUES ('18', '1448208000', '0', '0', '157', '0', '0', '0', '301', '10', '0', '0', '0', '0', '0', '0', '0', '1359');
INSERT INTO `mt_spider` VALUES ('19', '1448294400', '0', '0', '153', '0', '2', '0', '259', '1', '0', '0', '0', '0', '0', '0', '0', '1483');
INSERT INTO `mt_spider` VALUES ('20', '1448380800', '0', '0', '171', '0', '1', '0', '226', '16', '0', '0', '0', '0', '0', '0', '0', '1283');
INSERT INTO `mt_spider` VALUES ('21', '1448467200', '0', '0', '372', '0', '0', '0', '258', '5', '0', '0', '0', '0', '0', '0', '0', '1318');
INSERT INTO `mt_spider` VALUES ('22', '1448553600', '0', '0', '151', '0', '2', '0', '363', '2', '0', '0', '0', '0', '0', '0', '0', '1846');
INSERT INTO `mt_spider` VALUES ('23', '1448640000', '0', '0', '304', '0', '1', '0', '157', '1', '0', '0', '0', '0', '0', '0', '0', '1227');
INSERT INTO `mt_spider` VALUES ('24', '1448726400', '0', '0', '156', '0', '2', '0', '197', '2', '0', '0', '0', '0', '0', '0', '0', '1172');
INSERT INTO `mt_spider` VALUES ('25', '1448812800', '0', '0', '442', '0', '1', '0', '337', '3', '0', '0', '0', '0', '0', '0', '0', '1395');
INSERT INTO `mt_spider` VALUES ('26', '1448899200', '0', '0', '449', '0', '3', '0', '79', '8', '0', '0', '0', '0', '0', '1', '0', '3418');
INSERT INTO `mt_spider` VALUES ('27', '1448985600', '0', '0', '299', '0', '1', '0', '97', '10', '0', '0', '0', '0', '0', '0', '0', '1107');
INSERT INTO `mt_spider` VALUES ('28', '1449072000', '0', '0', '248', '0', '1', '0', '357', '9', '0', '0', '0', '0', '0', '0', '0', '1545');
INSERT INTO `mt_spider` VALUES ('29', '1449158400', '0', '0', '251', '0', '1', '0', '168', '2', '0', '0', '0', '0', '0', '0', '0', '1229');
INSERT INTO `mt_spider` VALUES ('30', '1449244800', '0', '0', '306', '0', '1', '0', '211', '5', '0', '0', '0', '0', '0', '0', '0', '1606');
INSERT INTO `mt_spider` VALUES ('31', '1449331200', '0', '0', '345', '0', '1', '0', '255', '2', '0', '0', '0', '0', '0', '0', '0', '1766');
INSERT INTO `mt_spider` VALUES ('32', '1449417600', '0', '0', '306', '0', '1', '0', '69', '1', '0', '0', '0', '0', '0', '0', '0', '1745');
INSERT INTO `mt_spider` VALUES ('33', '1449504000', '0', '0', '412', '0', '1', '0', '179', '2', '0', '0', '0', '0', '0', '0', '0', '1705');
INSERT INTO `mt_spider` VALUES ('34', '1449590400', '0', '0', '284', '0', '0', '0', '168', '3', '0', '0', '0', '0', '0', '0', '0', '1061');
INSERT INTO `mt_spider` VALUES ('35', '1449676800', '0', '0', '239', '0', '2', '0', '138', '7', '0', '0', '0', '0', '0', '0', '0', '1522');
INSERT INTO `mt_spider` VALUES ('36', '1449763200', '0', '0', '172', '0', '1', '0', '98', '1', '0', '0', '0', '0', '0', '0', '0', '948');
INSERT INTO `mt_spider` VALUES ('37', '1449849600', '0', '0', '230', '0', '1', '0', '315', '23', '0', '0', '0', '0', '0', '0', '0', '1651');
INSERT INTO `mt_spider` VALUES ('38', '1449936000', '0', '0', '1888', '0', '1', '0', '145', '14', '0', '0', '0', '0', '0', '0', '0', '928');
INSERT INTO `mt_spider` VALUES ('39', '1450022400', '0', '0', '583', '0', '2', '0', '153', '15', '0', '0', '0', '0', '0', '0', '0', '997');
INSERT INTO `mt_spider` VALUES ('40', '1450108800', '0', '0', '275', '0', '2', '0', '234', '9', '0', '0', '0', '0', '0', '0', '0', '1468');
INSERT INTO `mt_spider` VALUES ('41', '1450195200', '1', '0', '441', '0', '3', '0', '286', '23', '0', '0', '0', '0', '0', '0', '0', '1142');
INSERT INTO `mt_spider` VALUES ('42', '1450281600', '0', '0', '245', '0', '8', '0', '228', '13', '0', '0', '0', '0', '0', '0', '0', '1068');
INSERT INTO `mt_spider` VALUES ('43', '1450368000', '0', '0', '687', '0', '7', '0', '247', '4', '0', '0', '0', '0', '0', '0', '0', '1344');
INSERT INTO `mt_spider` VALUES ('44', '1450454400', '0', '0', '1754', '0', '170', '0', '189', '7', '0', '0', '0', '0', '0', '0', '0', '1260');
INSERT INTO `mt_spider` VALUES ('45', '1450540800', '0', '0', '759', '0', '693', '0', '197', '5', '0', '0', '0', '0', '0', '0', '0', '1286');
INSERT INTO `mt_spider` VALUES ('46', '1450627200', '0', '0', '714', '0', '773', '0', '117', '4', '0', '0', '0', '0', '0', '0', '0', '1380');
INSERT INTO `mt_spider` VALUES ('47', '1450713600', '0', '0', '1347', '0', '483', '0', '117', '4', '0', '0', '0', '0', '0', '0', '0', '1833');
INSERT INTO `mt_spider` VALUES ('48', '1450800000', '0', '0', '1861', '0', '682', '0', '95', '4', '1', '0', '0', '0', '0', '0', '0', '1434');
INSERT INTO `mt_spider` VALUES ('49', '1450886400', '0', '0', '3645', '0', '100', '0', '123', '5', '0', '0', '0', '0', '0', '0', '0', '1695');
INSERT INTO `mt_spider` VALUES ('50', '1450972800', '0', '0', '4168', '0', '8', '0', '134', '2', '0', '0', '0', '0', '0', '0', '0', '1788');
INSERT INTO `mt_spider` VALUES ('51', '1451059200', '0', '0', '2446', '0', '6', '0', '125', '46', '0', '0', '0', '0', '0', '0', '0', '2082');
INSERT INTO `mt_spider` VALUES ('52', '1451145600', '0', '0', '818', '0', '6', '0', '73', '6', '0', '0', '0', '0', '0', '0', '0', '1472');
INSERT INTO `mt_spider` VALUES ('53', '1451232000', '0', '0', '1771', '0', '9', '0', '104', '2', '0', '0', '0', '0', '0', '0', '0', '1122');
INSERT INTO `mt_spider` VALUES ('54', '1451318400', '0', '0', '1873', '0', '18', '0', '149', '14', '0', '0', '0', '0', '0', '0', '0', '1468');
INSERT INTO `mt_spider` VALUES ('55', '1451404800', '0', '0', '3215', '0', '23', '0', '143', '28', '0', '0', '0', '0', '0', '0', '0', '1920');
INSERT INTO `mt_spider` VALUES ('56', '1451491200', '0', '0', '3066', '0', '230', '0', '133', '13', '0', '0', '0', '0', '0', '0', '0', '1689');
INSERT INTO `mt_spider` VALUES ('57', '1451577600', '0', '0', '2911', '0', '18', '0', '305', '20', '0', '0', '0', '0', '0', '0', '0', '1811');
INSERT INTO `mt_spider` VALUES ('58', '1451664000', '0', '0', '3176', '0', '7', '0', '85', '74', '0', '0', '0', '0', '0', '0', '0', '1720');
INSERT INTO `mt_spider` VALUES ('59', '1451750400', '0', '0', '3764', '0', '8', '0', '94', '27', '0', '0', '0', '0', '0', '0', '0', '2317');
INSERT INTO `mt_spider` VALUES ('60', '1451836800', '0', '3', '2317', '0', '7', '0', '123', '32', '0', '0', '0', '0', '0', '0', '0', '2434');
INSERT INTO `mt_spider` VALUES ('61', '1451923200', '0', '0', '1445', '0', '172', '0', '256', '131', '0', '0', '0', '0', '0', '0', '0', '1329');
INSERT INTO `mt_spider` VALUES ('62', '1452009600', '0', '0', '1140', '0', '691', '0', '42', '66', '0', '0', '0', '0', '0', '0', '0', '2693');
INSERT INTO `mt_spider` VALUES ('63', '1452096000', '0', '0', '1513', '0', '895', '0', '100', '94', '0', '0', '0', '0', '0', '0', '0', '2038');
INSERT INTO `mt_spider` VALUES ('64', '1452182400', '0', '0', '2165', '0', '979', '0', '165', '85', '0', '0', '0', '0', '0', '0', '0', '2349');
INSERT INTO `mt_spider` VALUES ('65', '1452268800', '0', '0', '1722', '0', '702', '0', '335', '30', '0', '0', '0', '0', '0', '0', '0', '2104');
INSERT INTO `mt_spider` VALUES ('66', '1452355200', '0', '0', '2060', '0', '776', '0', '39', '31', '0', '0', '0', '0', '0', '0', '0', '2026');
INSERT INTO `mt_spider` VALUES ('67', '1452441600', '0', '0', '1688', '0', '914', '0', '373', '45', '0', '0', '0', '0', '0', '0', '0', '2707');
INSERT INTO `mt_spider` VALUES ('68', '1452528000', '0', '0', '1623', '0', '736', '0', '55', '79', '0', '0', '0', '0', '0', '0', '0', '1948');
INSERT INTO `mt_spider` VALUES ('69', '1452614400', '6', '0', '2386', '0', '804', '0', '235', '130', '0', '0', '0', '0', '0', '0', '0', '2601');
INSERT INTO `mt_spider` VALUES ('70', '1452700800', '14', '0', '1730', '0', '89', '0', '296', '319', '0', '0', '0', '0', '0', '0', '0', '2395');

-- ----------------------------
-- Table structure for mt_tag
-- ----------------------------
DROP TABLE IF EXISTS `mt_tag`;
CREATE TABLE `mt_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(64) NOT NULL COMMENT 'tag标签名称',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='文章标签';

-- ----------------------------
-- Records of mt_tag
-- ----------------------------
INSERT INTO `mt_tag` VALUES ('1', '学习笔记');
INSERT INTO `mt_tag` VALUES ('2', '生活随笔');
INSERT INTO `mt_tag` VALUES ('3', '热点分享');
INSERT INTO `mt_tag` VALUES ('4', '程序相关');
INSERT INTO `mt_tag` VALUES ('5', 'PHP');
INSERT INTO `mt_tag` VALUES ('6', '.NET');
INSERT INTO `mt_tag` VALUES ('7', '系统');

-- ----------------------------
-- Table structure for mt_visitor
-- ----------------------------
DROP TABLE IF EXISTS `mt_visitor`;
CREATE TABLE `mt_visitor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` int(11) NOT NULL,
  `count` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='网站访问量表';

-- ----------------------------
-- Records of mt_visitor
-- ----------------------------
INSERT INTO `mt_visitor` VALUES ('1', '1452700800', '8');
INSERT INTO `mt_visitor` VALUES ('2', '1452787200', '52');
INSERT INTO `mt_visitor` VALUES ('3', '1452873600', '5');
INSERT INTO `mt_visitor` VALUES ('4', '1453046400', '4');
INSERT INTO `mt_visitor` VALUES ('5', '1453132800', '38');
INSERT INTO `mt_visitor` VALUES ('6', '1453219200', '5');
INSERT INTO `mt_visitor` VALUES ('7', '1453305600', '2');
INSERT INTO `mt_visitor` VALUES ('8', '1453392000', '1');
INSERT INTO `mt_visitor` VALUES ('9', '1453478400', '1');
INSERT INTO `mt_visitor` VALUES ('10', '1453651200', '2');
INSERT INTO `mt_visitor` VALUES ('11', '1453737600', '2');
INSERT INTO `mt_visitor` VALUES ('12', '1453824000', '1');
INSERT INTO `mt_visitor` VALUES ('13', '1453996800', '32');
INSERT INTO `mt_visitor` VALUES ('14', '1454083200', '3');
INSERT INTO `mt_visitor` VALUES ('15', '1454256000', '1');
INSERT INTO `mt_visitor` VALUES ('16', '1454342400', '1');
INSERT INTO `mt_visitor` VALUES ('17', '1455465600', '3');
INSERT INTO `mt_visitor` VALUES ('18', '1455638400', '1');
INSERT INTO `mt_visitor` VALUES ('19', '1456329600', '1');
INSERT INTO `mt_visitor` VALUES ('20', '1456588800', '1');
INSERT INTO `mt_visitor` VALUES ('21', '1456848000', '1');
INSERT INTO `mt_visitor` VALUES ('22', '1458057600', '1');
INSERT INTO `mt_visitor` VALUES ('23', '1458316800', '1');
INSERT INTO `mt_visitor` VALUES ('24', '1459526400', '1');
INSERT INTO `mt_visitor` VALUES ('25', '1459785600', '1');
INSERT INTO `mt_visitor` VALUES ('26', '1460217600', '1');
INSERT INTO `mt_visitor` VALUES ('27', '1464364800', '1');
INSERT INTO `mt_visitor` VALUES ('28', '1465228800', '1');
INSERT INTO `mt_visitor` VALUES ('29', '1468339200', '2');
INSERT INTO `mt_visitor` VALUES ('30', '1473177600', '1');
INSERT INTO `mt_visitor` VALUES ('31', '1473696000', '1');
INSERT INTO `mt_visitor` VALUES ('32', '1473782400', '1');
INSERT INTO `mt_visitor` VALUES ('33', '1474300800', '1');
INSERT INTO `mt_visitor` VALUES ('34', '1474560000', '1');
INSERT INTO `mt_visitor` VALUES ('35', '1474819200', '1');