text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : localhost_3306
  Source Server Version : 50547
  Source Host           : localhost:3306
  Source Database       : tp10
  
  Target Server Type    : MYSQL
  Target Server Version : 50547
  File Encoding         : 65001
  
  Date: 2016-09-18 18:18:16
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for auth_group
  -- ----------------------------
  DROP TABLE IF EXISTS `auth_group`;
  CREATE TABLE `auth_group` (
    `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    `title` char(100) NOT NULL DEFAULT '',
    `status` tinyint(1) NOT NULL DEFAULT '1',
    `rules` char(80) NOT NULL DEFAULT '',
    `description` text COMMENT '描述',
    `create_time` int(11) NOT NULL,
    `update_time` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of auth_group
  -- ----------------------------
  INSERT INTO `auth_group` VALUES ('1', '管理员', '1', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,1,20', '', '0', '1466780039');
  INSERT INTO `auth_group` VALUES ('6', '初级管理员', '1', '6,1,2,13,3,4', '初级管理员', '1466910557', '1474193271');
  
  -- ----------------------------
  -- Table structure for auth_group_access
  -- ----------------------------
  DROP TABLE IF EXISTS `auth_group_access`;
  CREATE TABLE `auth_group_access` (
    `uid` mediumint(8) unsigned NOT NULL,
    `group_id` mediumint(8) unsigned NOT NULL,
    UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
    KEY `uid` (`uid`),
    KEY `group_id` (`group_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of auth_group_access
  -- ----------------------------
  INSERT INTO `auth_group_access` VALUES ('1', '1');
  INSERT INTO `auth_group_access` VALUES ('1', '6');
  INSERT INTO `auth_group_access` VALUES ('12', '6');
  
  -- ----------------------------
  -- Table structure for auth_rule
  -- ----------------------------
  DROP TABLE IF EXISTS `auth_rule`;
  CREATE TABLE `auth_rule` (
    `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
    `name` char(80) NOT NULL DEFAULT '',
    `title` char(20) NOT NULL DEFAULT '',
    `type` tinyint(1) NOT NULL DEFAULT '1',
    `status` tinyint(1) NOT NULL DEFAULT '1',
    `condition` char(100) NOT NULL DEFAULT '',
    `create_time` int(11) NOT NULL,
    `update_time` int(11) NOT NULL,
    `pid` mediumint(8) unsigned NOT NULL,
    `path` varchar(100) NOT NULL,
    `sort` int(11) NOT NULL DEFAULT '0',
    `is_show` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否显示',
    `icon` varchar(30) NOT NULL COMMENT '图标',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of auth_rule
  -- ----------------------------
  INSERT INTO `auth_rule` VALUES ('1', 'admin/main/index', '控制面板', '1', '1', '', '0', '0', '0', '0', '1', '1', '');
  INSERT INTO `auth_rule` VALUES ('2', '', '系统', '1', '1', '', '0', '1466909995', '0', '0', '200', '1', '');
  INSERT INTO `auth_rule` VALUES ('3', 'admin/auth_group/index', '角色管理', '1', '1', '', '0', '0', '2', '0-2', '1', '1', '');
  INSERT INTO `auth_rule` VALUES ('4', 'admin/auth_rule/index', '权限列表', '1', '1', '', '0', '1466746258', '2', '0-2', '2', '1', '');
  INSERT INTO `auth_rule` VALUES ('5', 'admin/auth_rule/add', '添加权限', '1', '1', '', '0', '1466686168', '4', '0-2-4', '1', '0', '');
  INSERT INTO `auth_rule` VALUES ('6', 'admin/user/logout', '退出登录', '1', '1', '', '0', '0', '0', '0', '0', '0', '');
  INSERT INTO `auth_rule` VALUES ('7', 'admin/auth_group/add', '添加角色', '1', '1', '', '0', '0', '3', '0-2-3', '0', '0', '');
  INSERT INTO `auth_rule` VALUES ('8', 'admin/auth_group/edit', '编辑角色', '1', '1', '', '0', '0', '3', '0-2-3', '0', '0', '');
  INSERT INTO `auth_rule` VALUES ('9', 'admin/auth_group/del', '删除角色', '1', '1', '', '0', '0', '3', '0-2-3', '0', '0', '');
  INSERT INTO `auth_rule` VALUES ('10', 'admin/auth_rule/edit', '编辑权限', '1', '1', '', '0', '1466686416', '4', '0-2-4', '2', '0', '');
  INSERT INTO `auth_rule` VALUES ('11', 'admin/user/changePwd', '修改密码', '1', '1', '', '1466688085', '1466688085', '0', '0', '0', '0', '');
  INSERT INTO `auth_rule` VALUES ('12', 'admin/auth_group/resource', '资源管理', '1', '1', '', '1466688887', '1466688887', '3', '0-2-3', '0', '0', '');
  INSERT INTO `auth_rule` VALUES ('13', 'admin/user/index', '用户管理', '1', '1', '', '1466778713', '1466778747', '2', '0-2', '0', '1', '');
  INSERT INTO `auth_rule` VALUES ('14', 'admin/user/edit', '编辑用户', '1', '1', '', '1466779374', '1466779374', '13', '0-2-13', '0', '0', '');
  INSERT INTO `auth_rule` VALUES ('15', 'admin/user/del', '删除用户', '1', '1', '', '1466779400', '1466779400', '13', '0-2-13', '0', '0', '');
  INSERT INTO `auth_rule` VALUES ('16', 'admin/user/add', '添加用户', '1', '1', '', '1466780028', '1466780028', '13', '0-2-13', '0', '0', '');
  INSERT INTO `auth_rule` VALUES ('17', 'admin/auth_rule/del', '删除权限', '1', '1', '', '1466911172', '1466911172', '4', '0-2-4', '0', '0', '');
  INSERT INTO `auth_rule` VALUES ('20', '', '测试', '1', '1', '', '1474171193', '1474171193', '0', '0', '2', '1', 'fa fa-mars-double');
  
  -- ----------------------------
  -- Table structure for document
  -- ----------------------------
  DROP TABLE IF EXISTS `document`;
  CREATE TABLE `document` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(255) NOT NULL COMMENT '标题',
    `content` text NOT NULL COMMENT '文章内容',
    `thumb` varchar(255) NOT NULL DEFAULT '' COMMENT '文章缩略图',
    `cid` int(11) unsigned NOT NULL COMMENT '文章分类id',
    `click` int(11) unsigned DEFAULT '0' COMMENT '文章点击量',
    `create_time` int(11) NOT NULL,
    `update_time` int(11) NOT NULL,
    `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
    `description` varchar(255) NOT NULL COMMENT '描述',
    `keyword` varchar(255) NOT NULL COMMENT '关键词',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='文章表';
  
  -- ----------------------------
  -- Records of document
  -- ----------------------------
  INSERT INTO `document` VALUES ('2', 'tp5开发的auth权限管理系统的教程（一）【微信部落】', '<p>\r\n	最近一直在看tp5的开发手册，光说不练假把式，实践才能出真知，于是就用tp5写了个auth权限的后台管理系统，这绝对是熟悉一个框架最快的方式了。看到有人下载程序后，却跑不起来，下面我简单讲一下如何把程序运行起来。\r\n</p>\r\n<p>\r\n	下载地址：<a class=\"ke-insertfile\" href=\"https://github.com/ningbnii/auth_tp5\" target=\"_blank\">https://github.com/ningbnii/auth_tp5</a> \r\n</p>\r\n<p>\r\n	将程序下载到本地后，搭建一个虚拟机，配置个域名，<span style=\"color:#E53333;\">注意：<span style=\"color:#000000;\">将虚拟机的路径指到public下面，然后导入数据库，修改数据库的配置</span></span> \r\n</p>\r\n<p>\r\n	<span style=\"color:#E53333;\"><span style=\"color:#000000;\"> 别忘了去下载tp5的核心类库，tp5核心类库下载地址：<a class=\"ke-insertfile\" href=\"https://github.com/top-think/framework\" target=\"_blank\">https://github.com/top-think/framework</a></span></span> \r\n</p>\r\n<p>\r\n	<span style=\"color:#E53333;\"> <span style=\"color:#000000;\">项目后台地址：http://域名/admin</span><br />\r\n</span> \r\n</p>\r\n<p>\r\n	<span style=\"color:#E53333;\"><span style=\"color:#000000;\"> 用户名：admin<br />\r\n</span></span> \r\n</p>\r\n<p>\r\n	<span style=\"color:#E53333;\"><span style=\"color:#000000;\"> 密码：123456<br />\r\n</span></span> \r\n</p>', '/uploads/image/20160705/20160705190810_58454.jpg', '11', '136', '1467648657', '1467716892', '1', '最近一直在看tp5的开发手册，光说不练假把式，实践才能出真知，于是就用tp5写了个auth权限的后台管理系统，这绝对是熟悉一个框架最快的方式了。', 'thinkphp5,教程,auth,后台管理系统');
  INSERT INTO `document` VALUES ('3', '用CSS3实现带小三角形的div框', '<p>\r\n	下面用CSS3分别实现向上、下、左、右的三角形\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<pre class=\"brush:css;toolbar:false;\">/*箭头向上*/\r\n.arrow-up {\r\n    width:0; \r\n    height:0; \r\n    border-left:30px solid transparent;\r\n    border-right:30px solid transparent;\r\n    border-bottom:30px solid #fff;\r\n&nbsp;&nbsp;&nbsp; border-top:0px;\r\n&nbsp;}\r\n    \r\n /*箭头向下*/\r\n.arrow-down {\r\n    width:0; \r\n    height:0; \r\n    border-left:20px solid transparent;\r\n    border-right:20px solid transparent;\r\n    border-top:20px solid #0066cc;\r\n&nbsp;&nbsp;&nbsp; border-down:0px;\r\n&nbsp;}\r\n    \r\n /*箭头向左*/\r\n.arrow-left {\r\n    width:0; \r\n    height:0; \r\n    border-top:30px solid transparent;\r\n    border-bottom:30px solid transparent; \r\n    border-right:30px solid yellow; \r\n&nbsp;&nbsp;&nbsp; border-left:0px;\r\n}\r\n   \r\n/*箭头向右*/\r\n.arrow-right {\r\n    width:0; \r\n    height:0; \r\n    border-top:50px solid transparent;\r\n    border-bottom: 50px solid transparent;\r\n    border-left: 50px solid green;\r\n&nbsp;&nbsp;&nbsp; border-right:0px;\r\n&nbsp;}</pre>\r\n<div>\r\n	<br />\r\n</div>', '/uploads/image/20160705/20160705183107_92285.jpg', '7', '9', '1467714683', '1467714733', '1', '用CSS3实现带小三角形的div框', '用CSS3实现带小三角形的div框');
  INSERT INTO `document` VALUES ('4', 'html5 canvas俄罗斯方块', '<p>\r\n	<img src=\"/uploads/image/20160705/20160705183417_30138.jpg\" alt=\"\" />\r\n</p>\r\n<p>\r\n	<img src=\"/uploads/image/20160705/20160705183504_61456.jpg\" alt=\"\" />\r\n</p>', '/uploads/image/20160705/20160705183258_74986.jpg', '6', '19', '1467714906', '1467714906', '1', 'html5 canvas俄罗斯方块游戏源码', 'html5,canvas,俄罗斯方块');
  INSERT INTO `document` VALUES ('5', 'ionic的ion-infinite-scroll在加载的时候会请求两次', '<p>\r\n	ionic的ion-infinite-scroll在加载的时候会请求两次，这好像是ionic的一个bug，没找到解决方案<span style=\"line-height:1.5;\"></span>\r\n</p>\r\n<pre class=\"prettyprint lang-js\">currentPage = 1  \r\n$scope.hasMoreData = true;\r\n  $scope.loadMore = function(){\r\n      currentPage ++;\r\n      Search.lists($scope.keyword, currentPage,function(res){\r\n        if(res.status == 200){\r\n          if(res.data.produce){\r\n            for (var i = 0; i &lt; res.data.produce.length; i++) { $scope.produces.push(res.data.produce[i]); console.log($scope.produces); } }else{ $scope.hasMoreData = false; } } }); $scope.$broadcast(\'scroll.infiniteScrollComplete\'); }</pre>', '', '2', '33', '1467715432', '1467715478', '1', 'ionic的ion-infinite-scroll在加载的时候会请求两次', 'ionic,ion-infinite-scroll,请求两次');
  INSERT INTO `document` VALUES ('6', 'ionic,隐藏底部导航栏', '<span style=\"color:#333333;font-family:\'microsoft yahei\';font-size:14px;line-height:1.5;background-color:#FFFFFF;\">1.在标签ion-tabs中添加：ng-class=”{‘tabs-item-hide’: $root.hideTabs}”</span><br />\r\n<p>\r\n	<span style=\"font-size:14px;line-height:21px;\"><span style=\"color:#333333;font-family:\'microsoft yahei\';line-height:26px;background-color:#FFFFFF;\">2.添加angularjs的指令，源码如下：</span></span>\r\n</p>\r\n<p>\r\n	<span style=\"font-size:14px;line-height:21px;\"></span>\r\n</p>\r\n<pre class=\"prettyprint lang-js\">//app已经在其他文件中指定，如var app = angular.module(\"starter\",[\"ionic\"])\r\napp.directive(\'hideTabs\', function($rootScope) {\r\n    return {\r\n        restrict: \'A\',\r\n        link: function(scope, element, attributes) {\r\n            scope.$on(\'$ionicView.beforeEnter\', function() {\r\n                scope.$watch(attributes.hideTabs, function(value){\r\n                    $rootScope.hideTabs = value;\r\n                });\r\n            });\r\n\r\n            scope.$on(\'$ionicView.beforeLeave\', function() {\r\n                $rootScope.hideTabs = false;\r\n            });\r\n        }\r\n    };\r\n});</pre>\r\n<span style=\"color:#333333;font-family:\'microsoft yahei\';font-size:14px;line-height:26px;background-color:#FFFFFF;\">3.在你想要隐藏的界面标签 ion-view添加表达式hide-tabs=”true”,</span>', '', '8', '12', '1467715644', '1467715644', '1', 'ionic 进入二级目录以后隐藏底部导航栏（tabs）', 'ionic 进入二级目录以后隐藏底部导航栏（tabs）');
  INSERT INTO `document` VALUES ('7', 'ng-repeat错误【Duplicate Key in Repeater】', '<p>\r\n	<img src=\"/uploads/image/20160705/20160705185102_71623.jpg\" alt=\"\" />\r\n</p>\r\n<p>\r\n	<img src=\"/uploads/image/20160705/20160705185159_70446.jpg\" alt=\"\" />\r\n</p>', '', '8', '11', '1467715945', '1467715945', '1', 'ng-repeat错误【Duplicate Key in Repeater】', 'ionic,ng-repeat,Duplicate Key in Repeater');
  INSERT INTO `document` VALUES ('8', 'ionic轮播图不循环轮播', '<p>\r\n	<span style=\"color:#333333;font-family:\'Helvetica Neue\', \'Luxi Sans\', \'DejaVu Sans\', Tahoma, \'Hiragino Sans GB\', STHeiti;font-size:15px;line-height:25.5px;background-color:#FFFFFF;\">ng-repeat的数据是延迟加载过来的。当img没有渲染完是不能工作的。像下面这样修改一下就可以了</span>\r\n</p>\r\n<p>\r\n	<span style=\"color:#333333;font-family:\'Helvetica Neue\', \'Luxi Sans\', \'DejaVu Sans\', Tahoma, \'Hiragino Sans GB\', STHeiti;font-size:15px;line-height:25.5px;background-color:#FFFFFF;\"><ion-slide-box <span=\"\" style=\"color: rgb(229, 51, 51);\">ng-if=\"banners\"</span>&nbsp;on-slide-changed=\"slideHasChanged($index)\" auto-play=\"true\" does-continue=\"true\" slide-interval=2000 show-pager=\"true\" pager-click=\"pageClick(index)\" active-slide=\"model.activeIndex\" delegate-handle=\"delegateHandler\"&gt;\r\n</p>', '', '8', '30', '1467716002', '1467716002', '1', 'ionic,轮播图,不循环轮播', 'ionic,轮播图,不循环轮播');
  INSERT INTO `document` VALUES ('9', 'ionic 禁用 <ion-content> 内容滚动', '<pre class=\"prettyprint lang-js\"><img src=\"/uploads/image/20160705/20160705185613_32401.png\" alt=\"\" /> </pre>', '', '2', '20', '1467716058', '1467716176', '1', 'ionic 禁用 <ion-content> 内容滚动', 'ionic 禁用 <ion-content> 内容滚动');
  INSERT INTO `document` VALUES ('10', 'linux计划任务cron', '<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	cron是一个Linux下的后台进程，用来定期的执行一些任务。因为我用的是Ubuntu，所以这篇文章中的所有命令也只能保证在Ubuntu下有效，但其他系统应该也差不多。（Centos 下用crond代替cron）\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	想要让cron执行你指定的任务，首先就要编辑crontab文件。crontab是一个文本文件，用来存放你要运行的命令。你可以以下命令\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<div class=\"dp-highlighter\" style=\"font-family:Consolas, \'Courier New\', Courier, mono, serif;color:#333333;margin:18px 0px !important;background-color:#E7E5DC;\">\r\n	<div class=\"bar\">\r\n		<div class=\"tools\" style=\"padding:3px;font-weight:bold;font-size:9px;font-family:Verdana, Geneva, Arial, Helvetica, sans-serif;color:black;margin:0px;background-color:#F8F8F8;\">\r\n			Shell代码\r\n		</div>\r\n	</div>\r\n	<ol class=\"dp-default\" style=\"color:#2B91AF;font-size:1em;background-color:#FFFFFF;\">\r\n		<li style=\"color:#5C5C5C;font-size:1em;background-color:#FAFAFA;\">\r\n			<span style=\"color:black;background-color:inherit;\"><span style=\"background-color:inherit;\">crontab&nbsp;-e</span></span>\r\n		</li>\r\n	</ol>\r\n</div>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	来打开你的用户所属的crontab文件。第一次用这个命令，会让你选择文本编辑器，我选的是vim。选定的编辑器也可以使用\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<div class=\"dp-highlighter\" style=\"font-family:Consolas, \'Courier New\', Courier, mono, serif;color:#333333;margin:18px 0px !important;background-color:#E7E5DC;\">\r\n	<div class=\"bar\">\r\n		<div class=\"tools\" style=\"padding:3px;font-weight:bold;font-size:9px;font-family:Verdana, Geneva, Arial, Helvetica, sans-serif;color:black;margin:0px;background-color:#F8F8F8;\">\r\n			Shell代码\r\n		</div>\r\n	</div>\r\n	<ol class=\"dp-default\" style=\"color:#2B91AF;font-size:1em;background-color:#FFFFFF;\">\r\n		<li style=\"color:#5C5C5C;font-size:1em;background-color:#FAFAFA;\">\r\n			<span style=\"color:black;background-color:inherit;\"><span style=\"background-color:inherit;\">select-editor</span></span>\r\n		</li>\r\n	</ol>\r\n</div>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	命令来更改。这点命令行中已经有足够的提示，就不多说了。\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	打开后的crontab文件类似这种样子：\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<div class=\"dp-highlighter\" style=\"font-family:Consolas, \'Courier New\', Courier, mono, serif;color:#333333;margin:18px 0px !important;background-color:#E7E5DC;\">\r\n	<div class=\"bar\">\r\n		<div class=\"tools\" style=\"padding:3px;font-weight:bold;font-size:9px;font-family:Verdana, Geneva, Arial, Helvetica, sans-serif;color:black;margin:0px;background-color:#F8F8F8;\">\r\n			Shell代码\r\n		</div>\r\n	</div>\r\n	<ol class=\"dp-default\" style=\"color:#2B91AF;font-size:1em;background-color:#FFFFFF;\">\r\n		<li style=\"color:#5C5C5C;font-size:1em;background-color:#FAFAFA;\">\r\n			<span style=\"color:black;background-color:inherit;\"><span style=\"background-color:inherit;\">#&nbsp;m&nbsp;h&nbsp;&nbsp;dom&nbsp;mon&nbsp;dow&nbsp;&nbsp;&nbsp;command</span></span>\r\n		</li>\r\n		<li style=\"color:#5C5C5C;font-size:1em;background-color:#FAFAFA;\">\r\n			<span style=\"color:black;background-color:inherit;\">*/<span class=\"number\" style=\"color:#C00000;background-color:inherit;\">2</span><span style=\"background-color:inherit;\">&nbsp;*&nbsp;*&nbsp;*&nbsp;*&nbsp;date&nbsp;&gt;&gt;&nbsp;~/time.log</span></span>\r\n		</li>\r\n	</ol>\r\n</div>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	第二行是我为了测试写的一个定期任务，它的意思是，每隔两分钟就执行 date &gt;&gt; ~/time.log 命令（记录当前时间到time.log文件）。你可以把它加入你的crontab中，然后保存退出。\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	保存了crontab之后，我们还需要重启cron来应用这个计划任务。使用以下命令：\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<div class=\"dp-highlighter\" style=\"font-family:Consolas, \'Courier New\', Courier, mono, serif;color:#333333;margin:18px 0px !important;background-color:#E7E5DC;\">\r\n	<div class=\"bar\">\r\n		<div class=\"tools\" style=\"padding:3px;font-weight:bold;font-size:9px;font-family:Verdana, Geneva, Arial, Helvetica, sans-serif;color:black;margin:0px;background-color:#F8F8F8;\">\r\n			Shell代码\r\n		</div>\r\n	</div>\r\n	<ol class=\"dp-default\" style=\"color:#2B91AF;font-size:1em;background-color:#FFFFFF;\">\r\n		<li style=\"color:#5C5C5C;font-size:1em;background-color:#FAFAFA;\">\r\n			<span style=\"color:black;background-color:inherit;\"><span style=\"background-color:inherit;\">sudo&nbsp;service&nbsp;cron&nbsp;restart</span></span>\r\n		</li>\r\n	</ol>\r\n</div>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	查看cron 服务状态：\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	service cron status\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	启动cron：\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	service cron start\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	停止cron：\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	service cron stop\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	下面稍微解释下crontab中每行的含义。crontab中的每一行代表一个定期执行的任务，分为6个部分。前5个部分表示何时执行命令，最后一个部分表示执行的命令。每个部分以空格分隔，除了最后一个部分（命令）可以在内部使用空格之外，其他部分都不能使用空格。前5个部分分别代表：分钟，小时，天，月，星期，每个部分的取值范围如下：\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	分钟&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 - 59\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	小时&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 - 23\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	天&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 - 31\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	月&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 - 12\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	星期&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 - 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0表示星期天\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	除了这些固定值外，还可以配合星号（*），逗号（,），和斜线（/）来表示一些其他的含义：\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	星号&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 表示任意值，比如在小时部分填写 * 代表任意小时（每小时）\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	逗号&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 可以允许在一个部分中填写多个值，比如在分钟部分填写 1,3 表示一分钟或三分钟\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	斜线&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 一般配合 * 使用，代表每隔多长时间，比如在小时部分填写 */2 代表每隔两分钟。所以 */1 和 * 没有区别\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	*/2 可以看成是能被2整除的任意值。\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	以下是一些例子（省略了命令部分）：\r\n</p>\r\n<p style=\"color:#333333;font-family:Arial;font-size:14px;background-color:#FFFFFF;\">\r\n	<br />\r\n</p>\r\n<div class=\"dp-highlighter\" style=\"font-family:Consolas, \'Courier New\', Courier, mono, serif;color:#333333;margin:18px 0px !important;background-color:#E7E5DC;\">\r\n	<div class=\"bar\">\r\n		<div class=\"tools\" style=\"padding:3px;font-weight:bold;font-size:9px;font-family:Verdana, Geneva, Arial, Helvetica, sans-serif;color:black;margin:0px;background-color:#F8F8F8;\">\r\n			Crontab代码\r\n		</div>\r\n	</div>\r\n	<ol class=\"dp-default\" style=\"color:#2B91AF;font-size:1em;background-color:#FFFFFF;\">\r\n		<li style=\"color:#5C5C5C;font-size:1em;background-color:#FAFAFA;\">\r\n			<span style=\"color:black;background-color:inherit;\"><span style=\"background-color:inherit;\">*&nbsp;*&nbsp;*&nbsp;*&nbsp;*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;每隔一分钟执行一次任务</span></span>\r\n		</li>\r\n		<li style=\"color:#5C5C5C;font-size:1em;background-color:#FAFAFA;\">\r\n			<span style=\"color:black;background-color:inherit;\"><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">0</span><span style=\"background-color:inherit;\">&nbsp;*&nbsp;*&nbsp;*&nbsp;*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;每小时的</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">0</span><span style=\"background-color:inherit;\">点执行一次任务，比如</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">6</span><span style=\"background-color:inherit;\">:</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">00</span><span style=\"background-color:inherit;\">，</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">10</span><span style=\"background-color:inherit;\">:</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">00</span><span style=\"background-color:inherit;\"></span></span>\r\n		</li>\r\n		<li style=\"color:#5C5C5C;font-size:1em;background-color:#FAFAFA;\">\r\n			<span style=\"color:black;background-color:inherit;\"><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">6</span><span style=\"background-color:inherit;\">,</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">10</span><span style=\"background-color:inherit;\">&nbsp;*&nbsp;</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">2</span><span style=\"background-color:inherit;\">&nbsp;*&nbsp;*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;每个月</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">2</span><span style=\"background-color:inherit;\">号，每小时的</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">6</span><span style=\"background-color:inherit;\">分和</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">10</span><span style=\"background-color:inherit;\">分执行一次任务</span></span>\r\n		</li>\r\n		<li style=\"color:#5C5C5C;font-size:1em;background-color:#FAFAFA;\">\r\n			<span style=\"color:black;background-color:inherit;\">*/<span class=\"number\" style=\"color:#C00000;background-color:inherit;\">3</span><span style=\"background-color:inherit;\">,*/</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">5</span><span style=\"background-color:inherit;\">&nbsp;*&nbsp;*&nbsp;*&nbsp;*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;每隔</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">3</span><span style=\"background-color:inherit;\">分钟或</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">5</span><span style=\"background-color:inherit;\">分钟执行一次任务，比如</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">10</span><span style=\"background-color:inherit;\">:</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">03</span><span style=\"background-color:inherit;\">，</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">10</span><span style=\"background-color:inherit;\">:</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">05</span><span style=\"background-color:inherit;\">，</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">10</span><span style=\"background-color:inherit;\">:</span><span class=\"number\" style=\"color:#C00000;background-color:inherit;\">06</span></span>\r\n		</li>\r\n	</ol>\r\n</div>', '', '11', '20', '1467716309', '1467716309', '1', 'linux计划任务cron基础知识', 'linux计划任务,crontab');
  INSERT INTO `document` VALUES ('11', 'ubuntu下安装zend studio 10.6.0，并破解', '<p>\r\n	zend studio 10.6.0下载地址：\r\n</p>\r\n<p>\r\n	32位：<a href=\"http://downloads.zend.com/studio-eclipse/10.6.0/ZendStudio-10.6.0-linux.gtk.x86.tar.gz\" target=\"_blank\">http://downloads.zend.com/studio-eclipse/10.6.0/ZendStudio-10.6.0-linux.gtk.x86.tar.gz</a>\r\n</p>\r\n<p>\r\n	64位：<a href=\"http://downloads.zend.com/studio-eclipse/10.6.0/ZendStudio-10.6.0-linux.gtk.x86_64.tar.gz\" target=\"_blank\">http://downloads.zend.com/studio-eclipse/10.6.0/ZendStudio-10.6.0-linux.gtk.x86_64.tar.gz</a>\r\n</p>\r\n<p>\r\n	破解文件下载\r\n</p>\r\n<p>\r\n	<a href=\"http://pan.baidu.com/s/1dDitHAD\" target=\"_blank\">http://pan.baidu.com/s/1dDitHAD</a>\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	如果报错\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<pre>A Java Runtime Environment (JRE) or Java Development Kit (JDK) must be available <span style=\"color:#0000FF;line-height:1.5 !important;\">in</span><span style=\"line-height:1.5 !important;\"> order to run Eclipse \r\nNo Java </span><span style=\"color:#0000FF;line-height:1.5 !important;\">virtual</span><span style=\"line-height:1.5 !important;\"> machine was found after searching the following locations: </span>/home/crifan/develop/eclipse/eclipse/jre/bin/<span style=\"line-height:1.5 !important;\">java \r\njava </span><span style=\"color:#0000FF;line-height:1.5 !important;\">in</span> your current PATH</pre>\r\n<span>说明你没有安装java环境，执行下面命令</span>\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<pre>sudo apt-<span style=\"color:#0000FF;line-height:1.5 !important;\">get</span> install openjdk-<span style=\"color:#800080;line-height:1.5 !important;\">7</span>-jre</pre>\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	将破解文件复制到plugins目录下，覆盖同名文件\r\n</p>\r\n<p>\r\n	下面是注册码\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<pre class=\"prettyprint lang-js\">15BD3D9635621E3AD4AE0F243B9E76CCFF6383B0E254EF646FD47B1424832332148D73E944AC95FC2A22EAF9965FE00D0BBACAD80E4B73BCFD40AADBEBD606EA4C33A74AEBB140CFB189E545E351774B7A020CDBE4FD159CDFF00F3C6A08C6AAC1A4F811EDDCF59CAFD09D46C849CB780BF6EF5983D3AFC372FC2021714E6B0B</pre>\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	<br />\r\n</p>', '', '11', '17', '1467716370', '1467716370', '1', 'ubuntu下安装zend studio 10.6.0，并破解', 'ubuntu下安装zend studio 10.6.0，并破解');
  INSERT INTO `document` VALUES ('12', 'ubuntu下使用ssh连接vps', '<p>\r\n	安装openssh-client(ubuntu默认是安装的，如果没有则用下面的命令安装一下)\r\n</p>\r\n<p>\r\n	sudo apt-get install openssh-server\r\n</p>\r\n<p>\r\n	使用方法：\r\n</p>\r\n<p>\r\n	ssh username@ip\r\n</p>\r\n<div>\r\n	<br />\r\n</div>', '', '11', '12', '1467716394', '1467716394', '1', 'ubuntu下使用ssh连接vps', 'ubuntu下使用ssh连接vps');
  INSERT INTO `document` VALUES ('13', '利用linux的crontab自动生成sitemap.xml', '<p>\r\n	crontab介绍\r\n</p>\r\n<p>\r\n	crontab命令的功能是在一定的时间间隔调度一些命令的执行\r\n</p>\r\n<p>\r\n	在/etc/crontab文件中，存放有系统运行的一些调度程序。每个用户可以建立自己的调度crontab\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	crontab服务是linux的内置服务，但它不会开机自动启动。可以用下面的命令启动和停止该服务。\r\n</p>\r\n<pre class=\"prettyprint lang-js\">/sbin/service crond start\r\n/sbin/service crond stop\r\n/sbin/service crond restart\r\n/sbin/service crond reload\r\n</pre>\r\n<p>\r\n	以上1-4行分别为启动、停止、重启服务和重新加载配置。\r\n</p>\r\n<p>\r\n	要把crontab设置为开机自动启动，在/etc/rc.d/rc.local 脚本中加入 /sbin/service crond start\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	查看当前用户的crontab，输入crontab -l\r\n</p>\r\n<p>\r\n	编辑crontab，输入crontab -e\r\n</p>\r\n<p>\r\n	删除crontab，输入crontab -r\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	crontab -e添加的命令必须如下面的格式：\r\n</p>\r\n<p>\r\n	* * * * * command\r\n</p>\r\n<p>\r\n	其中前五个字段的含义依次是：\r\n</p>\r\n<p>\r\n	分钟：0-59\r\n</p>\r\n<p>\r\n	小时：0-23\r\n</p>\r\n<p>\r\n	日期：1-31\r\n</p>\r\n<p>\r\n	月份：1-12\r\n</p>\r\n<p>\r\n	星期：0-6（0表示周日）\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	利用linux的crontab自动生成sitemap.xml\r\n</p>\r\n<p>\r\n	00 12 * * * /usr/bin/curl \"http://www.wxbuluo.com/sitemap/createsitemap\"\r\n</p>\r\n<p>\r\n	每天12点会自动更新sitemap.xml\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	*/3 * * * * command\r\n</p>\r\n<p>\r\n	每隔三分钟执行一次命令\r\n</p>\r\n<div>\r\n	<br />\r\n</div>', '', '11', '14', '1467716432', '1467716432', '1', '利用linux的crontab自动生成sitemap.xml', 'linux,crontab,定时刷新网页,自动生成sitemap.xml');
  INSERT INTO `document` VALUES ('14', 'linux解压缩rar压缩文件', '<p>\r\n	安装linux下的winrar版本\r\n</p>\r\n<pre class=\"prettyprint lang-js\">wget http://www.rarsoft.com/rar/rarlinux-4.0.1.tar.gz\r\n\r\ntar -zxvf rarlinux-4.0.1.tar.gz\r\n\r\ncd rar\r\n\r\nmake</pre>\r\n<br />\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	看见下面这些信息就是安装成功了\r\n</p>\r\n<pre class=\"prettyprint lang-js\">mkdir -p /usr/local/bin\r\n\r\nmkdir -p /usr/local/lib\r\n\r\ncp rar unrar /usr/local/bin\r\n\r\ncp rarfiles.lst /etc</pre>\r\n<br />\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	解压缩到当前目录\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<pre class=\"prettyprint lang-js\">rar x your.rar</pre>\r\n<p>\r\n	<br />\r\n</p>', '', '11', '12', '1467716460', '1467716460', '1', 'linux解压缩rar压缩文件', 'linux,tar,解压缩rar文件');
  INSERT INTO `document` VALUES ('15', 'linux使用axel多线程下载百度网盘资源', '<p>\r\n	centos安装axel：\r\n</p>\r\n<p>\r\n	32位centos\r\n</p>\r\n<pre class=\"prettyprint lang-js\">wget -c http://pkgs.repoforge.org/axel/axel-2.4-1.el5.rf.i386.rpm\r\n\r\nrpm -ivh axel-2.4-1.el5.rf.i386.rpm</pre>\r\n<br />\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	64位centos\r\n</p>\r\n<pre class=\"prettyprint lang-js\">wget -c http://pkgs.repoforge.org/axel/axel-2.4-1.el5.rf.x86_64.rpm\r\n\r\nrpm -ivh axel-2.4-1.el5.rf.x86_64.rpm</pre>\r\n<br />\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	axel使用方法：\r\n</p>\r\n<p>\r\n	axel -n 9 \"百度网盘资源真实下载连接\"\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	百度网盘资源真实下载连接获取方法：\r\n</p>\r\n<p>\r\n	下载internet download manager，安装后使用chrome浏览器下载即可获取真实下载连接\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	<br />\r\n</p>', '', '11', '28', '1467716486', '1467716486', '1', 'linux使用axel多线程下载百度网盘资源', 'linux，axel，多线程下载百度网盘资源');
  INSERT INTO `document` VALUES ('16', 'mysql中将数据库中的表类型统一换成innodb', '<p>\r\n	<span style=\"font-family:SimSun;font-size:14px;\">use information_schema;</span>\r\n</p>\r\n<p>\r\n	<span style=\"font-family:SimSun;font-size:14px;\">SELECT GROUP_CONCAT(CONCAT( \'ALTER TABLE \' ,TABLE_NAME ,\' ENGINE=InnoDB; \') SEPARATOR \'\' ) FROM information_schema.TABLES WHERE TABLE_SCHEMA = \'weixin\' and ENGINE=\'myisam\';</span>\r\n</p>\r\n<p>\r\n	<span style=\"font-family:SimSun;font-size:14px;\"><br />\r\n</span>\r\n</p>\r\n<p>\r\n	<span style=\"font-size:14px;line-height:21px;\">执行上面的语句，</span><span style=\"font-size:14px;line-height:21px;font-family:SimSun;\">将返回的sql执行。</span>\r\n</p>\r\n<p>\r\n	<span style=\"font-size:14px;line-height:21px;\">当数据库中的表较多时，返回的结果会不完整，需要多次执行select语句，直到返回的结果为null为止。</span>\r\n</p>', '', '12', '39', '1467716714', '1467716714', '1', 'mysql中将数据库中的表类型统一换成innodb', 'mysql,innodb,myisam');
  INSERT INTO `document` VALUES ('17', 'mysql中快速插入百万条数据的方法', '<p>\r\n	由于测试，需要在mysql中插入百万条数据\r\n</p>\r\n<p>\r\n	现在表中有一万条数据，随机复制插入记录，快速达到一百万条\r\n</p>\r\n<p>\r\n	其中id是主键\r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<pre class=\"prettyprint lang-js\">insert into onethink_report (title,info,createtime,updatetime,click,username)\r\nSELECT title,info,createtime,updatetime,click,username FROM `onethink_report` WHERE id &gt;= (SELECT floor(RAND() * (SELECT MAX(id) FROM `onethink_report`))) ORDER BY id LIMIT 1000; </pre>\r\n<span>可以修改1000的数字，改为5000或者10000就可以快速达到一百万条数据了</span>\r\n<div>\r\n	<span><br />\r\n</span>\r\n</div>', '', '11', '88', '1467716735', '1467716735', '1', 'mysql中快速插入百万条数据的方法', 'mysql中快速插入百万条数据的方法');
  INSERT INTO `document` VALUES ('18', '【程序团购】本站全部源码只要39，助您快速上手tp5的开发', '<p>\r\n	是的，你没看错，本站全部源码只要39，是全部源码，包括前后台！写程序挺累的，相当于请我吃一顿饭了。这绝对是一次超值的投资，能让你快速上手tp5的开发，利用这套系统你可以快速的定制开发出你想要的任何功能，只有想不到，没有做不到，它的投资回报率绝对是无法预估的！你还等什么呢？\r\n</p>\r\n<p>\r\n	支付方式：支付宝支付\r\n</p>\r\n<p>\r\n	<img src=\"/uploads/image/20160708/20160708102646_10166.png\" alt=\"\" /> \r\n</p>\r\n<p>\r\n	<span style=\"color:#E53333;font-size:18px;\"><strong> 别忘记留言你的qq邮箱，程序以邮件方式发送到qq邮箱！另外我会将你拉到售后群中，由于tp5还没发布正式版，随着tp5的更新，程序可能会出现bug，这个你不用担心，我会持续更新程序！程序我会放在私有svn上面，方便更新</strong></span> \r\n</p>\r\n<p>\r\n	<br />\r\n</p>\r\n<p>\r\n	<span style=\"color:#E53333;font-size:18px;\"><strong>现在购买程序，送beyond admin后台ui系统！</strong></span> \r\n</p>\r\n<p>\r\n	<span style=\"color:#E53333;font-size:18px;\"><strong> <br />\r\n</strong></span> \r\n</p>\r\n<p>\r\n	<span style=\"color:#E53333;font-size:18px;\"><strong> <br />\r\n</strong></span> \r\n</p>', '/uploads/image/20160708/20160708101719_39961.jpg', '11', '92', '1467944905', '1468739309', '1', '是的，你没看错，本站全部源码只要39，是全部源码，包括前后台！这绝对是一次超值的投资，能让你快速上手tp5的开发，利用这套系统你可以快速的定制开发出你想要的任何功能，只有想不到，没有做不到，它的投资回报率绝对是无法预估的！你还等什么呢？', '程序团购,thinkphp博客程序');
  INSERT INTO `document` VALUES ('19', 'TP5+WORKERMAN聊天室', '<p>\r\n	项目测试地址：<a href=\"http://workerman.wxbuluo.com\" target=\"_blank\">http://workerman.wxbuluo.com</a> \r\n</p>\r\n<p>\r\n	本项目采用TP5+WORKERMAN开发，实现了群聊功能，下面还会实现私聊功能\r\n</p>\r\n<p>\r\n	本源码能够帮助想了解的朋友快速入门workerman，现在购买只需39元及可获取全部源码\r\n</p>\r\n<p>\r\n	支付方式：支付宝支付\r\n</p>\r\n<p>\r\n	<img src=\"/uploads/image/20160708/20160708102646_10166.png\" alt=\"\" /> \r\n</p>\r\n<p>\r\n	<span style=\"font-weight:700;color:#E53333;font-family:\'microsoft yahei\';font-size:18px;line-height:25.6px;background-color:#FFFFFF;\">别忘记在支付宝留言你的qq邮箱，程序以邮件方式发送到qq邮箱！程序我会放在私有svn上面，方便更新</span> \r\n</p>', '/uploads/image/20160709/20160709180826_53812.jpg', '11', '100', '1468059293', '1468897289', '1', '使用tp5和workerman开发的聊天室', 'tp5,workerman,聊天室');
  
  -- ----------------------------
  -- Table structure for document_category
  -- ----------------------------
  DROP TABLE IF EXISTS `document_category`;
  CREATE TABLE `document_category` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(30) NOT NULL COMMENT '分类名称',
    `is_show_menu` tinyint(1) DEFAULT '1' COMMENT '是否在菜单显示',
    `create_time` int(11) NOT NULL,
    `update_time` int(11) NOT NULL,
    `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
    `sort` int(11) NOT NULL COMMENT '排序',
    `url` varchar(255) NOT NULL DEFAULT '' COMMENT '跳转地址',
    `pid` int(11) unsigned NOT NULL COMMENT '上级分类ID',
    `path` varchar(100) NOT NULL,
    `keyword` varchar(255) NOT NULL COMMENT '关键词',
    `description` varchar(255) NOT NULL COMMENT '描述',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='文章分类表';
  
  -- ----------------------------
  -- Records of document_category
  -- ----------------------------
  INSERT INTO `document_category` VALUES ('2', 'php', '1', '1467293316', '1467700700', '1', '1', '', '0', '0', 'php,php教程', '关于php的学习经验总结，php学习教程分享');
  INSERT INTO `document_category` VALUES ('3', 'github', '1', '1467293729', '1467640717', '1', '2', 'https://github.com/ningbnii/auth_tp5', '0', '0', '', '');
  INSERT INTO `document_category` VALUES ('5', '前端', '1', '1467644654', '1467700849', '1', '3', '', '0', '0', '前端,css,html5,javascript,js,angularjs,vue,react,react native,webpack,gulp', '关于前端的学习经验总结，关于前端的学习教程分享，涉及css,html5,javascript,js,angularjs,vue,react,react native,webpack,gulp等方面');
  INSERT INTO `document_category` VALUES ('6', 'html5', '1', '1467644697', '1467700950', '1', '1', '', '5', '0-5', 'html5,html5学习,html5教程', ' 关于html5的学习经验总结，分享html5学习教程，涉及canvas游戏开发');
  INSERT INTO `document_category` VALUES ('7', 'css3', '1', '1467644737', '1467700998', '1', '2', '', '5', '0-5', 'css,css3,css3教程,css3总结', '关于css3的学习经验总结，分享css3相关的学习教程');
  INSERT INTO `document_category` VALUES ('8', 'ionic', '1', '1467644778', '1467701054', '1', '3', '', '5', '0-5', 'ionic,ionic开发app,ionic学习,ionic教程', '关于ionic的学习经验总结，分享ionic相关教程，分享ionic最新的作品');
  INSERT INTO `document_category` VALUES ('9', '程序团购', '1', '1467644852', '1467703295', '1', '4', '', '0', '0', '精品程序团购,程序团购,', '将精品程序在固定时间段进行团购');
  INSERT INTO `document_category` VALUES ('10', 'tp5', '1', '1467647444', '1467700749', '1', '1', '', '2', '0-2', 'tp5,thinkphp5,tp5教程', '关于tp5的学习经验总结，关于tp5的学习教程分享');
  INSERT INTO `document_category` VALUES ('11', 'linux', '1', '1467716250', '1467716250', '1', '0', '', '0', '0', 'linux,linux学习,linux教程', '学习linux的经验总结，分享linux学习教程');
  INSERT INTO `document_category` VALUES ('12', 'mysql', '1', '1467716620', '1467716620', '1', '0', '', '0', '0', 'mysql,mysql学习,mysql教程', '学习mysql的经验总结，分享mysql学习教程');
  
  -- ----------------------------
  -- Table structure for ucenter_member
  -- ----------------------------
  DROP TABLE IF EXISTS `ucenter_member`;
  CREATE TABLE `ucenter_member` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
    `username` char(16) NOT NULL COMMENT '用户名',
    `password` char(32) NOT NULL COMMENT '密码',
    `email` char(32) NOT NULL COMMENT '用户邮箱',
    `mobile` char(15) NOT NULL DEFAULT '' COMMENT '用户手机',
    `reg_ip` varchar(20) NOT NULL DEFAULT '0' COMMENT '注册IP',
    `last_login_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
    `last_login_ip` varchar(20) NOT NULL DEFAULT '0' COMMENT '最后登录IP',
    `status` tinyint(4) DEFAULT '0' COMMENT '用户状态',
    `create_time` int(11) NOT NULL,
    `update_time` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `username` (`username`),
    KEY `status` (`status`)
  ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='用户表';
  
  -- ----------------------------
  -- Records of ucenter_member
  -- ----------------------------
  INSERT INTO `ucenter_member` VALUES ('1', 'admin', '779d005fa526b871d424fcab8140582f', '296720094@qq.com', '18053449656', '0', '1474193415', '2130706433', '1', '0', '1474193415');
  INSERT INTO `ucenter_member` VALUES ('3', 'test123', '779d005fa526b871d424fcab8140582f', '', '', '127.0.0.1', '1474193287', '2130706433', '1', '1466910101', '1474193287');
  INSERT INTO `ucenter_member` VALUES ('12', 'test', '779d005fa526b871d424fcab8140582f', '', '', '127.0.0.1', '0', '0', '1', '1474193837', '1474193837');
  