/*
Navicat MySQL Data Transfer
Source Server : 10.80.2.7
Source Server Version : 50173
Source Host : 10.80.2.7:3306
Source Database : azkaban
Target Server Type : MYSQL
Target Server Version : 50173
File Encoding : 65001
Date: 2017-03-02 10:31:41
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `group`
-- ----------------------------
DROP TABLE IF EXISTS `group`;
CREATE TABLE `group` (
`name` varchar(255) NOT NULL,
`create_time` varchar(255) DEFAULT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of group
-- ----------------------------
INSERT INTO `group` VALUES ('admin', null);
INSERT INTO `group` VALUES ('azkaban', null);
INSERT INTO `group` VALUES ('test1', null);
-- ----------------------------
-- Table structure for `group_role`
-- ----------------------------
DROP TABLE IF EXISTS `group_role`;
CREATE TABLE `group_role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_name` varchar(255) DEFAULT NULL,
`role_name` varchar(255) DEFAULT NULL,
`create_time` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of group_role
-- ----------------------------
INSERT INTO `group_role` VALUES ('3', 'admin', 'admin', null);
-- ----------------------------
-- Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`name` varchar(255) NOT NULL,
`create_time` varchar(255) DEFAULT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('admin', null);
INSERT INTO `role` VALUES ('azkaban', null);
INSERT INTO `role` VALUES ('test1', null);
-- ----------------------------
-- Table structure for `role_permission`
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`role_name` varchar(255) DEFAULT NULL,
`permission` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of role_permission
-- ----------------------------
INSERT INTO `role_permission` VALUES ('1', 'admin', 'ADMIN');
INSERT INTO `role_permission` VALUES ('2', 'azkaban', 'ADMIN');
INSERT INTO `role_permission` VALUES ('4', 'test1', 'WRITE');
-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`name` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`email` varchar(255) DEFAULT NULL,
`create_time` varchar(255) DEFAULT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('azkaban', 'azkaban', null, null);
INSERT INTO `user` VALUES ('admin', 'admin', null, null);
INSERT INTO `user` VALUES ('test1', 'test1', null, null);
-- ----------------------------
-- Table structure for `user_group`
-- ----------------------------
DROP TABLE IF EXISTS `user_group`;
CREATE TABLE `user_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_name` varchar(255) DEFAULT NULL,
`user_name` varchar(255) DEFAULT NULL,
`create_time` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of user_group
-- ----------------------------
INSERT INTO `user_group` VALUES ('3', 'admin', 'admin', null);
-- ----------------------------
-- Table structure for `user_role`
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(255) DEFAULT NULL,
`role_name` varchar(255) DEFAULT NULL,
`create_time` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of user_role
-- ----------------------------
INSERT INTO `user_role` VALUES ('1', 'admin', 'admin', null);
INSERT INTO `user_role` VALUES ('2', 'azkaban', 'azkaban', null);
INSERT INTO `user_role` VALUES ('3', 'test1', 'test1', null);
