Calculation/sql/data/zh_group.sql

/*
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:05:38
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for zh_group
-- ----------------------------
DROP TABLE IF EXISTS `zh_group`;
CREATE TABLE `zh_group` (
  `id` int(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `name` varchar(30) NOT NULL COMMENT '角色名称',
  `permission` text NOT NULL COMMENT '权限ID',
  `create_time` int(10) NOT NULL COMMENT '创建时间',
  `remark` varchar(30) DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='角色数据表';

-- ----------------------------
-- Records of zh_group
-- ----------------------------
INSERT INTO `zh_group` VALUES ('1', '超级管理员', 'all', '1506764405', '');
INSERT INTO `zh_group` VALUES ('6', '管理员', '11,12,14,15,16,25,27,28,29,17,19,37,38,39,40,41,42,47,55', '1507793004', '备注内容1');
INSERT INTO `zh_group` VALUES ('7', '销售人员', '37,38,40,42,47', '1552617131', '');