/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 80012
Source Host           : 127.0.0.1:3306
Source Database       : jkcms

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

Date: 2019-10-10 21:23:46
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for auth_node
-- ----------------------------
DROP TABLE IF EXISTS `auth_node`;
CREATE TABLE `auth_node` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT NULL,
  `url` varchar(100) DEFAULT NULL,
  `parent_id` smallint(6) unsigned NOT NULL,
  `sort` smallint(6) unsigned DEFAULT NULL,
  `level` tinyint(1) unsigned NOT NULL,
  `is_menu` int(1) unsigned DEFAULT '1' COMMENT '是否是菜单',
  `icon` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of auth_node
-- ----------------------------
INSERT INTO `auth_node` VALUES ('1', '首页', null, '0', null, '0', '0', null);
INSERT INTO `auth_node` VALUES ('2', '文章管理', null, '1', '1', '1', '1', 'fa fa-newspaper-o');
INSERT INTO `auth_node` VALUES ('3', '会员管理', null, '1', '3', '1', '1', 'fa fa-users');
INSERT INTO `auth_node` VALUES ('37', '产品分类', 'product/category', '6', '9', '2', '1', '');
INSERT INTO `auth_node` VALUES ('5', '订单管理', null, '1', '9', '1', '0', 'fa fa-tags');
INSERT INTO `auth_node` VALUES ('6', '产品与服务', null, '1', '2', '1', '1', 'fa fa-shopping-cart');
INSERT INTO `auth_node` VALUES ('7', '系统管理', null, '1', '10', '1', '1', 'fa fa-cog');
INSERT INTO `auth_node` VALUES ('9', '管理员列表', 'auth/admList', '7', '1', '2', '1', null);
INSERT INTO `auth_node` VALUES ('10', '新建管理账号', 'auth/newadm', '7', '2', '2', '0', null);
INSERT INTO `auth_node` VALUES ('11', '添加管理员', 'auth/addadm', '7', '0', '2', '0', null);
INSERT INTO `auth_node` VALUES ('13', '修改管理员密码', 'auth/changepw', '7', '0', '2', '0', null);
INSERT INTO `auth_node` VALUES ('14', '管理组', 'auth/rolelist', '7', '3', '2', '1', null);
INSERT INTO `auth_node` VALUES ('15', '新建角色', 'auth/newrole', '7', '0', '2', '0', null);
INSERT INTO `auth_node` VALUES ('16', '添加角色', 'auth/addRole', '7', '0', '2', '0', null);
INSERT INTO `auth_node` VALUES ('17', '角色权限列表', 'auth/rolenode', '7', '0', '2', '0', null);
INSERT INTO `auth_node` VALUES ('18', '编辑权限', 'auth/editRoleNode', '7', '0', '2', '0', null);
INSERT INTO `auth_node` VALUES ('19', '增加权限节点', 'auth/addNode', '7', '0', '2', '0', null);
INSERT INTO `auth_node` VALUES ('20', '编辑角色', 'auth/role_Do', '7', '0', '2', '0', null);
INSERT INTO `auth_node` VALUES ('21', '账号管理', 'auth/adm_Do', '7', '0', '2', '0', null);
INSERT INTO `auth_node` VALUES ('22', '节点管理', 'auth/node_Do', '7', '0', '2', '0', null);
INSERT INTO `auth_node` VALUES ('23', '参数设置', 'system/config', '7', '0', '2', '1', null);
INSERT INTO `auth_node` VALUES ('24', '管理日志', 'auth/admLog', '7', '9', '2', '1', null);
INSERT INTO `auth_node` VALUES ('25', '产品与服务', 'product/index', '6', '0', '2', '1', '');
INSERT INTO `auth_node` VALUES ('26', '注册与关注', 'user/index', '3', '0', '2', '1', null);
INSERT INTO `auth_node` VALUES ('28', '订单列表', 'order/index', '5', '0', '2', '1', null);
INSERT INTO `auth_node` VALUES ('36', '界面风格', 'system/theme', '7', '0', '2', '1', '');
INSERT INTO `auth_node` VALUES ('30', '公告列表', 'article/notification', '2', '1', '2', '1', null);
INSERT INTO `auth_node` VALUES ('32', '留言与反馈', null, '1', '5', '1', '1', 'fa fa-ticket');
INSERT INTO `auth_node` VALUES ('33', '留言列表', 'article/feedback', '32', '1', '2', '1', '');
INSERT INTO `auth_node` VALUES ('34', '文章列表', 'article/index', '2', '0', '2', '1', null);
INSERT INTO `auth_node` VALUES ('35', '文章分类', 'article/category', '2', '0', '2', '1', null);
INSERT INTO `auth_node` VALUES ('4', '导航与广告', '', '1', '3', '1', '1', 'fa fa-users');
INSERT INTO `auth_node` VALUES ('38', '导航管理', 'other/navlist', '4', '0', '2', '1', '');
INSERT INTO `auth_node` VALUES ('39', '广告管理', 'other/adlist', '4', '0', '2', '1', '');
INSERT INTO `auth_node` VALUES ('8', '微信公众号设置', '', '1', '9', '1', '1', 'fa fa-tags');
INSERT INTO `auth_node` VALUES ('40', '关键字回复', '', '8', '0', '2', '1', '');
INSERT INTO `auth_node` VALUES ('41', '自定义菜单', null, '8', '0', '2', '1', null);
INSERT INTO `auth_node` VALUES ('42', '公众号配置', null, '8', '0', '2', '1', null);
INSERT INTO `auth_node` VALUES ('43', '消息管理', null, '8', '0', '2', '1', null);