/*
Navicat MySQL Data Transfer
Source Server : 192.168.223.111_devops
Source Server Version : 50727
Source Host : 192.168.223.111:3306
Source Database : devops
Target Server Type : MYSQL
Target Server Version : 50727
File Encoding : 65001
Date: 2020-04-30 10:23:29
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auth_group
-- ----------------------------
-- ----------------------------
-- Table structure for auth_group_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auth_group_permissions
-- ----------------------------
-- ----------------------------
-- Table structure for auth_permission
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`content_type_id` int(11) NOT NULL,
`codename` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auth_permission
-- ----------------------------
INSERT INTO `auth_permission` VALUES ('1', 'Can add permission', '1', 'add_permission');
INSERT INTO `auth_permission` VALUES ('2', 'Can change permission', '1', 'change_permission');
INSERT INTO `auth_permission` VALUES ('3', 'Can delete permission', '1', 'delete_permission');
INSERT INTO `auth_permission` VALUES ('4', 'Can view permission', '1', 'view_permission');
INSERT INTO `auth_permission` VALUES ('5', 'Can add group', '2', 'add_group');
INSERT INTO `auth_permission` VALUES ('6', 'Can change group', '2', 'change_group');
INSERT INTO `auth_permission` VALUES ('7', 'Can delete group', '2', 'delete_group');
INSERT INTO `auth_permission` VALUES ('8', 'Can view group', '2', 'view_group');
INSERT INTO `auth_permission` VALUES ('9', 'Can add user', '3', 'add_user');
INSERT INTO `auth_permission` VALUES ('10', 'Can change user', '3', 'change_user');
INSERT INTO `auth_permission` VALUES ('11', 'Can delete user', '3', 'delete_user');
INSERT INTO `auth_permission` VALUES ('12', 'Can view user', '3', 'view_user');
INSERT INTO `auth_permission` VALUES ('13', 'Can add content type', '4', 'add_contenttype');
INSERT INTO `auth_permission` VALUES ('14', 'Can change content type', '4', 'change_contenttype');
INSERT INTO `auth_permission` VALUES ('15', 'Can delete content type', '4', 'delete_contenttype');
INSERT INTO `auth_permission` VALUES ('16', 'Can view content type', '4', 'view_contenttype');
INSERT INTO `auth_permission` VALUES ('17', 'Can add session', '5', 'add_session');
INSERT INTO `auth_permission` VALUES ('18', 'Can change session', '5', 'change_session');
INSERT INTO `auth_permission` VALUES ('19', 'Can delete session', '5', 'delete_session');
INSERT INTO `auth_permission` VALUES ('20', 'Can view session', '5', 'view_session');
INSERT INTO `auth_permission` VALUES ('21', 'Can add 主机组', '6', 'add_hostgroup');
INSERT INTO `auth_permission` VALUES ('22', 'Can change 主机组', '6', 'change_hostgroup');
INSERT INTO `auth_permission` VALUES ('23', 'Can delete 主机组', '6', 'delete_hostgroup');
INSERT INTO `auth_permission` VALUES ('24', 'Can view 主机组', '6', 'view_hostgroup');
INSERT INTO `auth_permission` VALUES ('25', 'Can add 主机账户', '7', 'add_remoteuser');
INSERT INTO `auth_permission` VALUES ('26', 'Can change 主机账户', '7', 'change_remoteuser');
INSERT INTO `auth_permission` VALUES ('27', 'Can delete 主机账户', '7', 'delete_remoteuser');
INSERT INTO `auth_permission` VALUES ('28', 'Can view 主机账户', '7', 'view_remoteuser');
INSERT INTO `auth_permission` VALUES ('29', 'Can add 远程主机', '8', 'add_remoteuserbindhost');
INSERT INTO `auth_permission` VALUES ('30', 'Can change 远程主机', '8', 'change_remoteuserbindhost');
INSERT INTO `auth_permission` VALUES ('31', 'Can delete 远程主机', '8', 'delete_remoteuserbindhost');
INSERT INTO `auth_permission` VALUES ('32', 'Can view 远程主机', '8', 'view_remoteuserbindhost');
INSERT INTO `auth_permission` VALUES ('33', 'Can add 主机详细', '9', 'add_serverdetail');
INSERT INTO `auth_permission` VALUES ('34', 'Can change 主机详细', '9', 'change_serverdetail');
INSERT INTO `auth_permission` VALUES ('35', 'Can delete 主机详细', '9', 'delete_serverdetail');
INSERT INTO `auth_permission` VALUES ('36', 'Can view 主机详细', '9', 'view_serverdetail');
INSERT INTO `auth_permission` VALUES ('37', 'Can add 用户组', '10', 'add_group');
INSERT INTO `auth_permission` VALUES ('38', 'Can change 用户组', '10', 'change_group');
INSERT INTO `auth_permission` VALUES ('39', 'Can delete 用户组', '10', 'delete_group');
INSERT INTO `auth_permission` VALUES ('40', 'Can view 用户组', '10', 'view_group');
INSERT INTO `auth_permission` VALUES ('41', 'Can add 用户日志', '11', 'add_loginlog');
INSERT INTO `auth_permission` VALUES ('42', 'Can change 用户日志', '11', 'change_loginlog');
INSERT INTO `auth_permission` VALUES ('43', 'Can delete 用户日志', '11', 'delete_loginlog');
INSERT INTO `auth_permission` VALUES ('44', 'Can view 用户日志', '11', 'view_loginlog');
INSERT INTO `auth_permission` VALUES ('45', 'Can add 权限', '12', 'add_permission');
INSERT INTO `auth_permission` VALUES ('46', 'Can change 权限', '12', 'change_permission');
INSERT INTO `auth_permission` VALUES ('47', 'Can delete 权限', '12', 'delete_permission');
INSERT INTO `auth_permission` VALUES ('48', 'Can view 权限', '12', 'view_permission');
INSERT INTO `auth_permission` VALUES ('49', 'Can add 用户', '13', 'add_user');
INSERT INTO `auth_permission` VALUES ('50', 'Can change 用户', '13', 'change_user');
INSERT INTO `auth_permission` VALUES ('51', 'Can delete 用户', '13', 'delete_user');
INSERT INTO `auth_permission` VALUES ('52', 'Can view 用户', '13', 'view_user');
INSERT INTO `auth_permission` VALUES ('53', 'Can add 在线会话日志', '14', 'add_terminallog');
INSERT INTO `auth_permission` VALUES ('54', 'Can change 在线会话日志', '14', 'change_terminallog');
INSERT INTO `auth_permission` VALUES ('55', 'Can delete 在线会话日志', '14', 'delete_terminallog');
INSERT INTO `auth_permission` VALUES ('56', 'Can view 在线会话日志', '14', 'view_terminallog');
INSERT INTO `auth_permission` VALUES ('57', 'Can add 在线会话', '15', 'add_terminalsession');
INSERT INTO `auth_permission` VALUES ('58', 'Can change 在线会话', '15', 'change_terminalsession');
INSERT INTO `auth_permission` VALUES ('59', 'Can delete 在线会话', '15', 'delete_terminalsession');