/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50553
 Source Host           : localhost:3306
 Source Schema         : wish

 Target Server Type    : MySQL
 Target Server Version : 50553
 File Encoding         : 65001

 Date: 24/11/2018 17:40:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for wish_admin
-- ----------------------------
DROP TABLE IF EXISTS `wish_admin`;
CREATE TABLE `wish_admin`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pass_word` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `salt` int(4) NOT NULL,
  `role_id` int(10) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wish_admin
-- ----------------------------
INSERT INTO `wish_admin` VALUES (1, 'admin', '5b0b833b7875626ad68a0a6c9b3ccf22', 3720, 1);
INSERT INTO `wish_admin` VALUES (2, 'test', '5b0b833b7875626ad68a0a6c9b3ccf22', 3720, 2);

-- ----------------------------
-- Table structure for wish_auth
-- ----------------------------
DROP TABLE IF EXISTS `wish_auth`;
CREATE TABLE `wish_auth`  (
  `id` smallint(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `module` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模块',
  `controller` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '控制器',
  `action` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '操作名称',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '描述',
  `sort` smallint(5) UNSIGNED NOT NULL DEFAULT 999 COMMENT '越小越在前面',
  `pid` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上级ID',
  `is_menu` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1为是菜单，2为不是菜单',
  `nav_pid` int(10) NOT NULL COMMENT '导航上一层',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 81 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wish_auth
-- ----------------------------
INSERT INTO `wish_auth` VALUES (1, 'admin', '', '', '主页', 0, 0, 1, 0);
INSERT INTO `wish_auth` VALUES (2, 'admin', 'index', 'index', '欢迎页面', 999, 1, 1, 1);
INSERT INTO `wish_auth` VALUES (3, 'admin', '', '', '系统管理', 3, 0, 1, 1);
INSERT INTO `wish_auth` VALUES (69, 'admin', 'system', 'index', '配置列表', 999, 3, 1, 3);
INSERT INTO `wish_auth` VALUES (74, 'admin', 'article', 'del', '文章删除', 999, 73, 0, 73);
INSERT INTO `wish_auth` VALUES (73, 'admin', 'article', 'index', '文章列表', 999, 68, 1, 68);
INSERT INTO `wish_auth` VALUES (72, 'admin', 'system', 'update', '配置更新', 999, 69, 0, 69);
INSERT INTO `wish_auth` VALUES (68, 'admin', '', '', '网站设置', 2, 0, 1, 0);
INSERT INTO `wish_auth` VALUES (75, 'admin', 'article', 'update', '文章编辑', 999, 73, 0, 73);
INSERT INTO `wish_auth` VALUES (76, 'admin', 'article', 'detail', '文章详情', 999, 73, 0, 73);
INSERT INTO `wish_auth` VALUES (77, 'admin', 'article', 'add', '文章添加', 999, 73, 0, 73);
INSERT INTO `wish_auth` VALUES (14, 'admin', '', '', '网站内容', 1, 0, 1, 1);
INSERT INTO `wish_auth` VALUES (42, 'admin', 'install', 'update_status', '声学安装审核', 999, 14, 0, 40);
INSERT INTO `wish_auth` VALUES (41, 'admin', 'install', 'del', '声学安装删除', 999, 14, 0, 40);
INSERT INTO `wish_auth` VALUES (40, 'admin', 'install', 'index', '声学安装列表', 999, 14, 1, 14);
INSERT INTO `wish_auth` VALUES (20, 'admin', 'nav', 'index', '首页导航列表', 999, 68, 1, 68);
INSERT INTO `wish_auth` VALUES (21, 'admin', 'nav', 'del', '首页导航删除', 999, 14, 0, 20);
INSERT INTO `wish_auth` VALUES (22, 'admin', 'nav', 'update', '首页导航编辑', 999, 14, 0, 20);
INSERT INTO `wish_auth` VALUES (23, 'admin', 'nav', 'detail', '首页导航详情', 999, 14, 0, 20);
INSERT INTO `wish_auth` VALUES (24, 'admin', 'nav', 'add', '首页导航添加', 999, 14, 0, 20);
INSERT INTO `wish_auth` VALUES (25, 'admin', 'ad', 'index', '首页滚动列表', 999, 68, 1, 68);
INSERT INTO `wish_auth` VALUES (26, 'admin', 'ad', 'del', '首页滚动删除', 999, 14, 0, 25);
INSERT INTO `wish_auth` VALUES (27, 'admin', 'ad', 'update', '首页滚动编辑', 999, 14, 0, 25);
INSERT INTO `wish_auth` VALUES (28, 'admin', 'ad', 'detail', '首页滚动详情', 999, 14, 0, 25);
INSERT INTO `wish_auth` VALUES (29, 'admin', 'ad', 'add', '首页滚动添加', 999, 14, 0, 25);
INSERT INTO `wish_auth` VALUES (43, 'admin', 'install', 'detail', '声学安装详情', 999, 14, 0, 40);
INSERT INTO `wish_auth` VALUES (34, 'admin', 'admin', 'edit_password', '修改密码', 999, 35, 1, 35);
INSERT INTO `wish_auth` VALUES (35, 'admin', '', '', '设置', 4, 0, 1, 1);
INSERT INTO `wish_auth` VALUES (36, 'admin', 'engineering', 'index', '工程信息列表', 999, 14, 1, 14);
INSERT INTO `wish_auth` VALUES (37, 'admin', 'engineering', 'del', '工程信息删除', 999, 14, 0, 36);
INSERT INTO `wish_auth` VALUES (38, 'admin', 'engineering', 'update_status', '工程信息审核', 999, 14, 0, 36);
INSERT INTO `wish_auth` VALUES (39, 'admin', 'engineering', 'detail', '工程信息详情', 999, 14, 0, 36);
INSERT INTO `wish_auth` VALUES (44, 'admin', 'design', 'index', '声学设计列表', 999, 14, 1, 14);
INSERT INTO `wish_auth` VALUES (45, 'admin', 'design', 'del', '声学设计删除', 999, 14, 0, 44);
INSERT INTO `wish_auth` VALUES (46, 'admin', 'design', 'update_status', '声学设计审核', 999, 14, 0, 44);
INSERT INTO `wish_auth` VALUES (47, 'admin', 'design', 'detail', '声学设计详情', 999, 14, 0, 44);
INSERT INTO `wish_auth` VALUES (48, 'admin', 'material', 'index', '隔音材料列表', 999, 14, 1, 14);
INSERT INTO `wish_auth` VALUES (49, 'admin', 'material', 'del', '隔音材料删除', 999, 14, 0, 48);
INSERT INTO `wish_auth` VALUES (50, 'admin', 'material', 'update_status', '隔音材料审核', 999, 14, 0, 48);
INSERT INTO `wish_auth` VALUES (51, 'admin', 'material', 'detail', '隔音材料详情', 999, 14, 0, 48);
INSERT INTO `wish_auth` VALUES (52, 'admin', 'program', 'index', '隔音方案列表', 999, 14, 1, 14);
INSERT INTO `wish_auth` VALUES (53, 'admin', 'program', 'del', '隔音方案删除', 999, 14, 0, 52);
INSERT INTO `wish_auth` VALUES (54, 'admin', 'program', 'update_status', '隔音方案审核', 999, 14, 0, 52);
INSERT INTO `wish_auth` VALUES (55, 'admin', 'program', 'detail', '隔音方案详情', 999, 14, 0, 52);
INSERT INTO `wish_auth` VALUES (56, 'admin', 'profession', 'index', '隔音专家列表', 999, 14, 1, 14);
INSERT INTO `wish_auth` VALUES (57, 'admin', 'profession', 'del', '隔音专家删除', 999, 14, 0, 56);
INSERT INTO `wish_auth` VALUES (58, 'admin', 'profession', 'update_status', '隔音专家审核', 999, 14, 0, 56);
INSERT INTO `wish_auth` VALUES (59, 'admin', 'profession', 'detail', '隔音专家详情', 999, 14, 0, 56);
INSERT INTO `wish_auth` VALUES (60, 'admin', 'video', 'index', '声学小视频列表', 999, 14, 1, 14);
INSERT INTO `wish_auth` VALUES (61, 'admin', 'video', 'del', '声学小视频删除', 999, 14, 0, 60);
INSERT INTO `wish_auth` VALUES (62, 'admin', 'video', 'update_status', '声学小视频审核', 999, 14, 0, 60);
INSERT INTO `wish_auth` VALUES (63, 'admin', 'video', 'detail', '声学小视频详情', 999, 14, 0, 60);
INSERT INTO `wish_auth` VALUES (64, 'admin', 'pic', 'index', '秀图列表', 999, 14, 1, 14);
INSERT INTO `wish_auth` VALUES (65, 'admin', 'pic', 'del', '秀图删除', 999, 14, 0, 64);
INSERT INTO `wish_auth` VALUES (66, 'admin', 'pic', 'update_status', '秀图审核', 999, 14, 0, 64);
INSERT INTO `wish_auth` VALUES (67, 'admin', 'pic', 'detail', '秀图详情', 999, 14, 0, 64);
INSERT INTO `wish_auth` VALUES (78, 'admin', 'user', 'index', '用户列表', 1, 14, 1, 14);
INSERT INTO `wish_auth` VALUES (79, 'admin', 'user', 'detail', '用户详情', 2, 78, 0, 78);
INSERT INTO `wish_auth` VALUES (80, 'admin', 'user', 'update_status', '用户状态更新', 999, 78, 0, 78);

-- ----------------------------
-- Table structure for wish_nav
-- ----------------------------
DROP TABLE IF EXISTS `wish_nav`;
CREATE TABLE `wish_nav`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '导航名字',
  `logo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图表',
  `sort` int(10) NOT NULL COMMENT '排序越少越前',
  `module` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '跳转链接',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wish_nav
-- ----------------------------
INSERT INTO `wish_nav` VALUES (1, '工程信息', '\\uploads\\20181120\\ae942174825fb4c82d3744ad5de0cd75.png', 999, 'engineering');
INSERT INTO `wish_nav` VALUES (2, '声学安装', '\\uploads\\20181120\\6166b358c251bc2a46b8b16dc6d2f4e1.png', 999, 'install');
INSERT INTO `wish_nav` VALUES (3, '声学设计', '\\uploads\\20181120\\2ffb781cf7cfcd57a3040a9c029f0208.png', 999, 'design');
INSERT INTO `wish_nav` VALUES (4, '隔音方案', '\\uploads\\20181120\\4e1c20296d1c061103e56243af2ae24d.png', 999, 'program');
INSERT INTO `wish_nav` VALUES (5, '隔音专家', '\\uploads\\20181120\\abcb86a7cae37b28c968048cda4721c3.png', 999, 'profession');
INSERT INTO `wish_nav` VALUES (6, '秀图', '\\uploads\\20181120\\5a81e7084f4ee34def7d5fefae094689.png', 999, 'pic');
INSERT INTO `wish_nav` VALUES (7, '声学小视频', '\\uploads\\20181120\\14060236b9ef2ed703653c969b5f7d34.png', 999, 'video');
INSERT INTO `wish_nav` VALUES (8, '隔音材料', '\\uploads\\20181120\\1df27e20939e933a102c3db73dfc3f82.png', 999, 'material');

-- ----------------------------
-- Table structure for wish_role
-- ----------------------------
DROP TABLE IF EXISTS `wish_role`;
CREATE TABLE `wish_role`  (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '角色名称',
  `status` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态，1为正常，2为关闭',
  `remark` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  `rule` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '规则ID，逗号分割',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wish_role
-- ----------------------------
INSERT INTO `wish_role` VALUES (1, '管理员', 1, '超级管理员', '1');
INSERT INTO `wish_role` VALUES (2, '测试管理员', 1, '测试管理员', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,33,34,35,36,37,38,39');

-- ----------------------------
-- Table structure for wish_system
-- ----------------------------
DROP TABLE IF EXISTS `wish_system`;
CREATE TABLE `wish_system`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `alias` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of wish_system
-- ----------------------------
INSERT INTO `wish_system` VALUES (1, '网站名字', '卖鱼工作室', 'SITE_NAME');
INSERT INTO `wish_system` VALUES (2, '版权所有', '卖鱼工作室', 'COPYRIGHT');

SET FOREIGN_KEY_CHECKS = 1;