/*
Navicat MySQL Data Transfer

Source Server         : ubuntu-jl
Source Server Version : 50722
Source Host           : 192.168.1.70:3306
Source Database       : calculation

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

Date: 2019-06-05 10:00:51
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for zh_permission
-- ----------------------------
DROP TABLE IF EXISTS `zh_permission`;
CREATE TABLE `zh_permission` (
  `id` int(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `name` varchar(30) NOT NULL COMMENT '权限名称',
  `controller` varchar(30) DEFAULT '' COMMENT '控制器名称',
  `action` varchar(30) DEFAULT '' COMMENT 'action名称',
  `pid` int(8) NOT NULL COMMENT '父ID',
  `icon_class` varchar(50) DEFAULT '' COMMENT '图标类名',
  `create_time` int(10) DEFAULT NULL COMMENT '创建时间',
  `isshow` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否展示该权限',
  PRIMARY KEY (`id`),
  KEY `idx_pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='权限数据表';

-- ----------------------------
-- Records of zh_permission
-- ----------------------------
INSERT INTO `zh_permission` VALUES ('11', '系统管理', '', '', '0', 'fa-cog', '8', '1');
INSERT INTO `zh_permission` VALUES ('12', '权限管理', 'permission', '', '11', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('14', '新增权限', 'permission', 'add', '12', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('15', '修改权限', 'permission', 'modify', '12', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('16', '删除权限', 'permission', 'delete', '12', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('17', '后台用户', '', '', '0', 'fa-user', '6', '1');
INSERT INTO `zh_permission` VALUES ('19', '用户列表', 'manager', '', '17', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('20', '权限组', 'group', '', '17', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('22', '新增用户组', 'group', 'add', '20', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('23', '修改用户组', 'group', 'modify', '20', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('24', 'sql执行', 'sql', '', '11', '', '0', '0');
INSERT INTO `zh_permission` VALUES ('25', '白名单管理', 'white-list', '', '11', '', '0', '0');
INSERT INTO `zh_permission` VALUES ('27', '新增白名单', 'white-list', 'add', '25', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('28', '修改白名单', 'white-list', 'modify', '25', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('29', '删除白名单', 'white-list', 'delete', '25', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('30', '修改管理员', 'manager', 'modify', '19', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('31', '消息管理', '', '', '0', 'fa-bell', '0', '0');
INSERT INTO `zh_permission` VALUES ('32', '消息列表', 'message', '', '31', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('33', '新增消息', 'message', 'add', '32', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('34', '修改消息', 'message', 'modify', '32', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('35', '删除消息', 'message', 'delete', '32', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('36', '日志列表', 'log', '', '11', '', '0', '0');
INSERT INTO `zh_permission` VALUES ('37', '客户管理', '', '', '0', 'fa-users', '10', '1');
INSERT INTO `zh_permission` VALUES ('38', '项目版客户', 'project', '', '37', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('39', '新增项目', 'project', 'add', '38', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('40', '修改项目', 'project', 'modify', '38', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('41', '删除项目', 'project', 'delete', '38', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('42', '项目账号列表', 'project', 'account', '38', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('43', '演示版客户', 'customer', 'demo', '37', '', '0', '0');
INSERT INTO `zh_permission` VALUES ('44', '工具', '', '', '0', 'fa-wrench', '9', '1');
INSERT INTO `zh_permission` VALUES ('45', '项目节', 'project-chapter', '', '44', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('46', '工程量清单', 'bill', '', '44', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('47', '项目标段列表', 'project', 'tender', '38', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('48', '企业版用户', 'enterprise', '', '37', '', '0', '0');
INSERT INTO `zh_permission` VALUES ('49', '新增企业', 'enterprise', 'add', '48', 'add', null, '1');
INSERT INTO `zh_permission` VALUES ('50', '修改企业', 'enterprise', 'modify', '48', 'modify', null, '1');
INSERT INTO `zh_permission` VALUES ('51', '删除企业', 'enterprise', 'delete', '48', 'delete', null, '1');
INSERT INTO `zh_permission` VALUES ('52', '企业设置', 'enterprise', 'setting', '48', '', null, '1');
INSERT INTO `zh_permission` VALUES ('53', '企业账号列表', 'enterprise', 'account', '48', 'account', null, '1');
INSERT INTO `zh_permission` VALUES ('54', '企业项目列表', 'enterprise', 'project', '48', '', null, '1');
INSERT INTO `zh_permission` VALUES ('55', '项目设置', 'project', 'setting', '38', 'setting', null, '1');
INSERT INTO `zh_permission` VALUES ('56', '标准清单', 'standard', '', '44', '', null, '1');
INSERT INTO `zh_permission` VALUES ('57', '报表', 'report', '', '44', '', '0', '1');
INSERT INTO `zh_permission` VALUES ('58', '删除管理员', 'manager', 'delete', '19', 'delete', null, '1');