/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50540
Source Host           : localhost:3306
Source Database       : cthink

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

Date: 2017-03-03 18:43:41
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `cthink_article`
-- ----------------------------
DROP TABLE IF EXISTS `cthink_article`;
CREATE TABLE `cthink_article` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '文章id，文章编号',
  `category_id` int(11) NOT NULL COMMENT '文章分类',
  `title` char(100) NOT NULL DEFAULT '' COMMENT '文章标题',
  `keywords` char(80) NOT NULL,
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '文章摘要',
  `content` text NOT NULL COMMENT '文章内容',
  `cover` int(11) NOT NULL DEFAULT '0' COMMENT '文章封面',
  `isrecomm` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否推荐。1为普通，2为推荐',
  `link` varchar(100) NOT NULL DEFAULT '' COMMENT '文章外链地址',
  `view` int(10) NOT NULL DEFAULT '0' COMMENT '浏览量',
  `comment` int(10) NOT NULL DEFAULT '0' COMMENT '评论数量',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态，1正常，2停用禁止被浏览',
  `ctime` int(10) NOT NULL,
  `utime` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cate_and_status` (`category_id`,`status`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cthink_article
-- ----------------------------
INSERT INTO `cthink_article` VALUES ('3', '40', 'fdsafdsa', '萨德,制裁韩国', '', '<p>fsafdsa</p>', '10', '2', '', '0', '0', '1', '1488533089', '1488533089');
INSERT INTO `cthink_article` VALUES ('4', '44', 'fdsafwe', 'fdasfdsafdsa', '', '<p><img src=\"http://www.cthink.dev/public/uploads/2017/03-03/a6c3d0af4a4ea91bed3c7cd9365d3fdf.jpg\" width=\"800\" height=\"533\" border=\"0\" hspace=\"0\" vspace=\"0\" title=\"\" style=\"width: 800px; height: 533px;\"/>fdsafdsafdsafdsa</p>', '11', '1', '', '0', '0', '1', '1488533115', '1488534157');

-- ----------------------------
-- Table structure for `cthink_attach`
-- ----------------------------
DROP TABLE IF EXISTS `cthink_attach`;
CREATE TABLE `cthink_attach` (
  `attach_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '附件ID',
  `app_name` char(15) DEFAULT 'attach' COMMENT '应用名称',
  `table` char(15) DEFAULT NULL COMMENT '表名',
  `row_id` int(11) DEFAULT NULL COMMENT '管理的内容ID',
  `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户UID',
  `ctime` int(11) NOT NULL COMMENT '上传时间',
  `name` varchar(255) DEFAULT NULL COMMENT '附件名称',
  `type` varchar(255) DEFAULT NULL COMMENT '附件格式',
  `size` varchar(20) DEFAULT NULL COMMENT '附件大小',
  `extension` varchar(20) DEFAULT NULL COMMENT '附件扩展名',
  `md5` varchar(64) DEFAULT NULL COMMENT '图片的md5值',
  `hash` varchar(64) DEFAULT NULL COMMENT '附件哈希值',
  `private` tinyint(1) DEFAULT '0' COMMENT '是否私有（即对其他人不可见）',
  `is_del` tinyint(1) DEFAULT '0' COMMENT '统一的is_del',
  `save_path` varchar(255) DEFAULT NULL COMMENT '保存路径',
  `save_name` varchar(255) DEFAULT NULL COMMENT '保存名称',
  `save_domain` tinyint(3) DEFAULT '0' COMMENT '附件保存的域ID（用于拆分附件存储到不同的服务器）',
  `from` tinyint(3) NOT NULL COMMENT '来源类型，0：网站；1：手机网页版；2：android；3：iphone',
  `width` int(11) DEFAULT '0' COMMENT '图片宽度',
  `height` int(11) DEFAULT '0' COMMENT '图片高度',
  `mime` char(20) DEFAULT NULL,
  PRIMARY KEY (`attach_id`),
  KEY `userId` (`uid`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cthink_attach
-- ----------------------------
INSERT INTO `cthink_attach` VALUES ('1', 'public', null, null, '0', '1488425135', '4.jpg', 'application/octet-stream', '51290', 'jpg', '58aa40a666839f89fcde1f3846d91c21', '94ca4bfe82c6a08ae976c7330072a156a2686ad1', '0', '0', '2017/03-02', '92cc8bffa79edcff648d2f3a632daf3c.jpg', '0', '0', '650', '510', 'image/jpeg');
INSERT INTO `cthink_attach` VALUES ('2', 'public', null, null, '0', '1488426503', '1.2.3.4.5.6.png', 'application/octet-stream', '168669', 'png', '6614efe2e38a0b4ac9a843e65719e49b', 'da11b8631e3a1698c38c80b252459c3519ae1afe', '0', '0', '2017/03-02', '05e5d485381757e23e06b8934a9a841e.png', '0', '0', '605', '427', 'image/jpeg');
INSERT INTO `cthink_attach` VALUES ('3', 'public', null, null, '0', '1488426738', '3.jpg', 'application/octet-stream', '63155', 'jpg', '49c9323094934f7bb76f6f912abae5ee', 'f6eca840ce12e398c86a40a67216bea4800eda08', '0', '0', '2017/03-02', 'af896d8824a78ccc3152f2305d237b0b.jpg', '0', '0', '685', '474', 'image/jpeg');
INSERT INTO `cthink_attach` VALUES ('4', 'public', null, null, '0', '1488426805', '5.jpg', 'application/octet-stream', '55222', 'jpg', '4ea77e2b536d31f595a847be96309f7a', '5f5f0573c378826e7c490673240d6a426f88d9bf', '0', '0', '2017/03-02', 'e160bf7cb1254f0a884016101dfcff19.jpg', '0', '0', '820', '542', 'image/jpeg');
INSERT INTO `cthink_attach` VALUES ('5', 'public', null, null, '0', '1488427084', '2.png', 'application/octet-stream', '179533', 'png', 'acd996fa77084fe3857d79c2cc23e73b', '367ee3f0400b48bf399d06931ee9644e76ccd1d2', '0', '0', '2017/03-02', '5e69a12c08d4ae0ecacc78a4467a46c9.png', '0', '0', '599', '415', 'image/jpeg');
INSERT INTO `cthink_attach` VALUES ('6', 'public', null, null, '0', '1488525505', '6c8554e687134bc983b9997816261e31.jpg', 'application/octet-stream', '29758', 'jpg', '12e5fd472a374f3f0fb33dda593e2901', '1802113aebe1902413a425885b177cff2b1899a2', '0', '0', '2017/03-03', '613c892fb71ce02c7bf5841a1a0be74a.jpg', '0', '0', '300', '500', 'image/jpeg');
INSERT INTO `cthink_attach` VALUES ('7', 'public', null, null, '0', '1488530785', '4.jpg', 'application/octet-stream', '80679', 'jpg', '2ca76832785a235e1ba7f457a1bd39cb', '7d7f4eaebb26eecef6e9bbf880b31b542b9c18c1', '0', '0', '2017/03-03', '3d346e40ac850b0e53d11cd71b4c4f42.jpg', '0', '0', '700', '1050', 'image/jpeg');
INSERT INTO `cthink_attach` VALUES ('8', 'public', null, null, '0', '1488530819', '6.jpg', 'application/octet-stream', '60863', 'jpg', 'e97978ee7ad93e1cc1424dfffa1fa508', '0ac911f9760d1d4683d931057eaea65b5c4c8cbb', '0', '0', '2017/03-03', 'f69ed56254800967486bd61f05181b62.jpg', '0', '0', '700', '1050', 'image/jpeg');
INSERT INTO `cthink_attach` VALUES ('9', 'public', null, null, '0', '1488530882', '1.jpg', 'application/octet-stream', '72988', 'jpg', '5ce8b708585af1ad32c01b578625ad6a', 'fa0ed317852eb44e844e9840603a3ca86e8d0434', '0', '0', '2017/03-03', '2bea5cf00d6e31f0f2a2afe0989fe089.jpg', '0', '0', '700', '1050', 'image/jpeg');
INSERT INTO `cthink_attach` VALUES ('10', 'public', null, null, '0', '1488531036', '1.jpg', 'application/octet-stream', '156417', 'jpg', '66a7ac4c4adf6440bc859654e7f931a4', '1c6f59e5366cd60558315815daaa0151d4c83618', '0', '0', '2017/03-03', '53ee4ec2e4c6c6db61769d277b0b857e.jpg', '0', '0', '1024', '681', 'image/jpeg');
INSERT INTO `cthink_attach` VALUES ('11', 'public', null, null, '0', '1488533111', '2.jpeg', 'application/octet-stream', '290321', 'jpeg', 'c64537a5c4bc0470f10bebd1e21168d7', '3357cc2d8059fb33c53cd414e241d386b84d0507', '0', '0', '2017/03-03', '23d56efe4229cc95ccf3c13a8e99b79c.jpeg', '0', '0', '1024', '747', 'image/jpeg');
INSERT INTO `cthink_attach` VALUES ('12', 'public', null, null, '0', '1488533482', '1.jpg', 'application/octet-stream', '156419', 'jpg', 'cae4dbc70369698636dcfbd23108e20f', 'd08e5693c0a5487365e67d536c46fb353af49bb6', '0', '0', '2017/03-03', 'a6c3d0af4a4ea91bed3c7cd9365d3fdf.jpg', '0', '0', '1024', '681', 'image/jpeg');

-- ----------------------------
-- Table structure for `cthink_auth_group`
-- ----------------------------
DROP TABLE IF EXISTS `cthink_auth_group`;
CREATE TABLE `cthink_auth_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(100) NOT NULL DEFAULT '',
  `module` char(30) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `type` tinyint(4) NOT NULL,
  `rules` char(200) NOT NULL DEFAULT '',
  `info` char(100) NOT NULL DEFAULT '' COMMENT '组描述',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cthink_auth_group
-- ----------------------------
INSERT INTO `cthink_auth_group` VALUES ('32', '编辑管理员', 'admin', '1', '1', '326,327,328,329,330,331,333,334,337,338,339,342,343,344', '主要编辑文章的管理员');
INSERT INTO `cthink_auth_group` VALUES ('31', '系统管理员1', 'admin', '1', '1', '302,303,304,305,306,307,308,309,310,312,313,314,315,316,317,318,319,320', '存放管理员用户的组');

-- ----------------------------
-- Table structure for `cthink_auth_group_access`
-- ----------------------------
DROP TABLE IF EXISTS `cthink_auth_group_access`;
CREATE TABLE `cthink_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 cthink_auth_group_access
-- ----------------------------
INSERT INTO `cthink_auth_group_access` VALUES ('13', '32');

-- ----------------------------
-- Table structure for `cthink_auth_member`
-- ----------------------------
DROP TABLE IF EXISTS `cthink_auth_member`;
CREATE TABLE `cthink_auth_member` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) NOT NULL,
  `nickname` varchar(32) NOT NULL,
  `password` varchar(64) NOT NULL,
  `phone` varchar(16) NOT NULL DEFAULT '',
  `email` varchar(32) NOT NULL DEFAULT '' COMMENT '邮箱',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户启用禁用状态，1启用，2为禁用',
  `is_remove` tinyint(11) NOT NULL DEFAULT '0' COMMENT '是否删除，0为未删除，1为删除',
  `login_count` smallint(6) NOT NULL DEFAULT '0',
  `last_login_time` int(11) NOT NULL DEFAULT '0',
  `last_login_ip` varchar(16) NOT NULL DEFAULT '0.0.0.0',
  `ctime` int(11) NOT NULL,
  `utime` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=107 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cthink_auth_member
-- ----------------------------
INSERT INTO `cthink_auth_member` VALUES ('13', 'zhanghd', 'zhanghd', 'a6eacfbac7f5858f2d67323921f58d1f', '13520714345', '328380798@qq.com', '1', '0', '15', '1488164741', '127.0.0.1', '1487665364', '1487665364');
INSERT INTO `cthink_auth_member` VALUES ('1', 'admin', '管理员', 'a6eacfbac7f5858f2d67323921f58d1f', '13520714345', 'zhanghd1987@foxmail.com', '1', '0', '23', '1488510979', '127.0.0.1', '1487665409', '1487665409');
INSERT INTO `cthink_auth_member` VALUES ('100', 'zhanghd775', '半瓶矿泉水', 'a6eacfbac7f5858f2d67323921f58d1f', '13580456987', 'aaa@qq.com', '1', '0', '0', '0', '0.0.0.0', '0', '0');
INSERT INTO `cthink_auth_member` VALUES ('101', 'zhanghd7751', '半瓶矿泉水1', 'a6eacfbac7f5858f2d67323921f58d1f', '13580456982', 'aaeea@qq.com', '1', '0', '0', '0', '0.0.0.0', '0', '0');
INSERT INTO `cthink_auth_member` VALUES ('102', 'zhanghd7751', '半瓶矿泉水1', 'a6eacfbac7f5858f2d67323921f58d1f', '13580456982', 'aaeea@qq.com', '1', '0', '0', '0', '0.0.0.0', '0', '0');
INSERT INTO `cthink_auth_member` VALUES ('103', 'zhanghd7751', '半瓶矿泉水1', 'a6eacfbac7f5858f2d67323921f58d1f', '13580456982', 'aaeea@qq.com', '1', '0', '0', '0', '0.0.0.0', '0', '0');

-- ----------------------------
-- Table structure for `cthink_auth_rule`
-- ----------------------------
DROP TABLE IF EXISTS `cthink_auth_rule`;
CREATE TABLE `cthink_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
  `module` varchar(20) NOT NULL COMMENT '规则所属module',
  `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '1-url;2-主菜单',
  `name` char(80) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '规则中文描述',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否有效(0:无效,1:有效)',
  `condition` varchar(300) NOT NULL DEFAULT '' COMMENT '规则附加条件',
  PRIMARY KEY (`id`),
  KEY `module` (`module`,`status`,`type`)
) ENGINE=MyISAM AUTO_INCREMENT=358 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cthink_auth_rule
-- ----------------------------
INSERT INTO `cthink_auth_rule` VALUES ('326', 'admin', '1', 'admin/AuthMember/index', '管理员管理', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('327', 'admin', '1', 'admin/AuthGroup/index', '角色管理', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('328', 'admin', '1', 'admin/Menu/index', '菜单管理', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('329', 'admin', '1', 'admin/AuthMenber/add', '添加管理员', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('330', 'admin', '1', 'admin/AuthMenber/edit', '编辑管理员', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('331', 'admin', '1', 'admin/AuthMenber/remove', '删除管理员', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('332', 'admin', '1', 'admin/AuthMenber/state', '启用禁用管理员', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('333', 'admin', '1', 'admin/AuthGroup/add', '添加角色', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('334', 'admin', '1', 'admin/AuthGroup/edit', '编辑角色', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('335', 'admin', '1', 'admin/AuthGroup/remove', '删除角色', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('336', 'admin', '1', 'admin/AuthGroup/state', '启用和禁用角色', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('337', 'admin', '1', 'admin/Menu/add', '添加菜单', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('338', 'admin', '1', 'admin/Menu/edit', '编辑菜单', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('339', 'admin', '1', 'admin/Menu/remove', '删除菜单', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('340', 'admin', '1', 'admin/Menu/state', '启用和禁用菜单', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('341', 'admin', '1', 'admin/Menu/msort', '排序', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('342', 'admin', '2', 'admin/AuthMenber/index', '系统管理', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('343', 'admin', '2', 'admin/Index/index', '首页管理', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('344', 'admin', '1', 'admin/Index/home', '首页', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('345', 'admin', '1', 'admin/Author/access', '角色授权', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('346', 'admin', '1', 'admin/Author/member', '成员授权', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('347', 'admin', '1', 'admin/Category/index', '分类管理', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('348', 'admin', '1', 'admin/Category/add', '添加分类', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('349', 'admin', '1', 'admin/Category/edit', '编辑分类', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('350', 'admin', '1', 'admin/Category/remove', '删除分类', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('351', 'admin', '2', 'admin/Category/index', '内容管理', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('352', 'admin', '1', 'admin/Category/state', '启用和禁用分类', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('353', 'admin', '1', 'admin/Article/index', '文章管理', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('354', 'admin', '1', 'admin/Article/add', '添加文章', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('355', 'admin', '1', 'admin/Article/edit', '编辑文章', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('356', 'admin', '1', 'admin/Article/remove', '删除文章', '1', '');
INSERT INTO `cthink_auth_rule` VALUES ('357', 'admin', '1', 'admin/Article/state', '状态设置', '1', '');

-- ----------------------------
-- Table structure for `cthink_category`
-- ----------------------------
DROP TABLE IF EXISTS `cthink_category`;
CREATE TABLE `cthink_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类ID',
  `title` varchar(50) NOT NULL COMMENT '标题',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级分类ID',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序（同级有效）',
  `meta_title` varchar(50) NOT NULL DEFAULT '' COMMENT 'SEO的网页标题',
  `keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '关键字',
  `description` varchar(255) NOT NULL DEFAULT '' COMMENT '描述',
  `check` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '发布的文章是否需要审核',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '数据状态，1为启用，2为禁用',
  `icon` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类图标',
  `ctime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `utime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COMMENT='分类表';

-- ----------------------------
-- Records of cthink_category
-- ----------------------------
INSERT INTO `cthink_category` VALUES ('39', '手机', '0', '2', '', '', '', '0', '1', '0', '0', '0');
INSERT INTO `cthink_category` VALUES ('40', '电脑', '0', '1', '', '', '', '0', '1', '0', '0', '0');
INSERT INTO `cthink_category` VALUES ('41', '移动', '39', '5', '', '', '', '0', '1', '0', '0', '0');
INSERT INTO `cthink_category` VALUES ('42', '联通', '39', '4', '', '', '', '0', '1', '0', '0', '0');
INSERT INTO `cthink_category` VALUES ('43', '电信', '39', '3', '', '', '', '0', '1', '0', '0', '0');
INSERT INTO `cthink_category` VALUES ('44', 'iphone7', '41', '1', '', '', '', '0', '1', '0', '0', '0');
INSERT INTO `cthink_category` VALUES ('45', 'iphone6', '41', '2', '', '', '', '0', '1', '0', '0', '0');
INSERT INTO `cthink_category` VALUES ('46', 'iphone8', '41', '1', '', '', '', '0', '1', '0', '0', '0');
INSERT INTO `cthink_category` VALUES ('47', 'iphone7plus', '44', '1', '', '', '', '0', '1', '0', '0', '0');
INSERT INTO `cthink_category` VALUES ('48', '管理员默认组', '44', '2', '', '', '', '0', '1', '2', '0', '0');
INSERT INTO `cthink_category` VALUES ('50', '管理员默认组', '0', '0', '', '', '', '0', '1', '2', '0', '0');

-- ----------------------------
-- Table structure for `cthink_menu`
-- ----------------------------
DROP TABLE IF EXISTS `cthink_menu`;
CREATE TABLE `cthink_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文档ID',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级分类ID',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序（同级有效）',
  `url` char(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `hide` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否隐藏',
  `tip` varchar(255) NOT NULL DEFAULT '' COMMENT '提示',
  `group` varchar(50) DEFAULT '' COMMENT '分组',
  `is_dev` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否仅开发者模式可见',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态,默认为1 开启，2为禁用',
  `icon` varchar(40) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=270 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cthink_menu
-- ----------------------------
INSERT INTO `cthink_menu` VALUES ('239', '管理员管理', '1', '0', 'AuthMember/index', '0', '', '系统管理', '0', '1', 'fa fa-user');
INSERT INTO `cthink_menu` VALUES ('240', '角色管理', '1', '0', 'AuthGroup/index', '0', '', '系统管理', '0', '1', 'fa fa-group');
INSERT INTO `cthink_menu` VALUES ('241', '菜单管理', '1', '0', 'Menu/index', '0', '', '系统管理', '0', '1', 'fa fa-navicon');
INSERT INTO `cthink_menu` VALUES ('242', '添加管理员', '239', '0', 'AuthMenber/add', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('243', '编辑管理员', '239', '0', 'AuthMenber/edit', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('244', '删除管理员', '239', '0', 'AuthMenber/remove', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('245', '启用禁用管理员', '239', '0', 'AuthMenber/state', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('246', '添加角色', '240', '0', 'AuthGroup/add', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('247', '编辑角色', '240', '0', 'AuthGroup/edit', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('248', '删除角色', '240', '0', 'AuthGroup/remove', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('249', '启用和禁用角色', '240', '0', 'AuthGroup/state', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('250', '添加菜单', '241', '0', 'Menu/add', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('251', '编辑菜单', '241', '0', 'Menu/edit', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('252', '删除菜单', '241', '0', 'Menu/remove', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('253', '启用和禁用菜单', '241', '0', 'Menu/state', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('254', '排序', '241', '0', 'Menu/msort', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('1', '系统管理', '0', '2', 'AuthMenber/index', '0', '', '系统管理', '0', '1', 'fa fa-cogs');
INSERT INTO `cthink_menu` VALUES ('255', '首页管理', '0', '1', 'Index/index', '0', '', '主页', '0', '1', 'fa fa-home');
INSERT INTO `cthink_menu` VALUES ('256', '首页', '255', '0', 'Index/home', '0', '', '主页', '0', '1', 'fa fa-home');
INSERT INTO `cthink_menu` VALUES ('257', '角色授权', '240', '0', 'Author/access', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('258', '成员授权', '240', '0', 'Author/member', '0', '', '系统管理', '0', '1', '');
INSERT INTO `cthink_menu` VALUES ('259', '内容管理', '0', '3', 'Category/index', '0', '', '内容', '0', '1', 'fa fa-tasks');
INSERT INTO `cthink_menu` VALUES ('260', '分类管理', '259', '0', 'Category/index', '0', '', '内容', '0', '1', 'fa fa-list');
INSERT INTO `cthink_menu` VALUES ('261', '添加分类', '260', '0', 'Category/add', '0', '', '内容', '0', '1', 'fa fa-plus');
INSERT INTO `cthink_menu` VALUES ('262', '编辑分类', '260', '1', 'Category/edit', '0', '', '内容', '0', '1', 'fa fa-edit');
INSERT INTO `cthink_menu` VALUES ('263', '删除分类', '260', '2', 'Category/remove', '0', '', '内容', '0', '1', 'fa fa-close');
INSERT INTO `cthink_menu` VALUES ('264', '启用和禁用分类', '260', '3', 'Category/state', '0', '', '内容', '0', '1', 'fa fa-check');
INSERT INTO `cthink_menu` VALUES ('265', '文章管理', '259', '0', 'Article/index', '0', '', '内容', '0', '1', 'fa fa-text-width');
INSERT INTO `cthink_menu` VALUES ('266', '添加文章', '265', '0', 'Article/add', '0', '', '内容', '0', '1', 'fa fa-home');
INSERT INTO `cthink_menu` VALUES ('267', '编辑文章', '265', '0', 'Article/edit', '0', '', '内容', '0', '1', 'fa fa-home');
INSERT INTO `cthink_menu` VALUES ('268', '删除文章', '265', '0', 'Article/remove', '0', '', '内容', '0', '1', 'fa fa-plus');
INSERT INTO `cthink_menu` VALUES ('269', '状态设置', '265', '0', 'Article/state', '0', '', '内容', '0', '1', 'fa fa-cogs');