/* 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', '');