kubernetes部署数据库审核系统Yearning
sql初始化 数据库名称必须是 Yearning
/*
Navicat Premium Data Transfer
Source Server : Yearning
Source Server Type : MySQL
Source Server Version : 50721
Source Host : 127.0.0.1:3306
Source Schema : Yearning
Target Server Type : MySQL
Target Server Version : 50721
File Encoding : 65001
Date: 12/09/2018 17:30:24
*/
SET NAMES utf8mb4;
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(80) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- 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 COLLATE=utf8_bin;
-- ----------------------------
-- 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) COLLATE utf8_bin NOT NULL,
`content_type_id` int(11) NOT NULL,
`codename` varchar(100) COLLATE utf8_bin 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=55 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for core_account
-- ----------------------------
DROP TABLE IF EXISTS `core_account`;
CREATE TABLE `core_account` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`password` varchar(128) COLLATE utf8_bin NOT NULL,
`last_login` datetime(6) DEFAULT NULL,
`is_superuser` tinyint(1) NOT NULL,
`username` varchar(150) COLLATE utf8_bin NOT NULL,
`first_name` varchar(30) COLLATE utf8_bin NOT NULL,
`last_name` varchar(150) COLLATE utf8_bin NOT NULL,
`email` varchar(254) COLLATE utf8_bin NOT NULL,
`is_staff` tinyint(1) NOT NULL,
`is_active` tinyint(1) NOT NULL,
`date_joined` datetime(6) NOT NULL,
`group` varchar(40) COLLATE utf8_bin NOT NULL,
`department` varchar(40) COLLATE utf8_bin NOT NULL,
`auth_group` longtext COLLATE utf8_bin DEFAULT NULL,
`real_name` varchar(100) COLLATE utf8_bin DEFAULT '请添加真实姓名' NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for core_account_groups
-- ----------------------------
DROP TABLE IF EXISTS `core_account_groups`;
CREATE TABLE `core_account_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `core_account_groups_account_id_group_id_9e3c433f_uniq` (`account_id`,`group_id`),
KEY `core_account_groups_group_id_ffac212f_fk_auth_group_id` (`group_id`),
CONSTRAINT `core_account_groups_account_id_3bd74ec9_fk_core_account_id` FOREIGN KEY (`account_id`) REFERENCES `core_account` (`id`),
CONSTRAINT `core_account_groups_group_id_ffac212f_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for core_account_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `core_account_user_permissions`;
CREATE TABLE `core_account_user_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `core_account_user_permis_account_id_permission_id_5d993b63_uniq` (`account_id`,`permission_id`),
KEY `core_account_user_pe_permission_id_6e106098_fk_auth_perm` (`permission_id`),
CONSTRAINT `core_account_user_pe_account_id_9fe697ec_fk_core_acco` FOREIGN KEY (`account_id`) REFERENCES `core_account` (`id`),
CONSTRAINT `core_account_user_pe_permission_id_6e106098_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for core_applygrained
-- ----------------------------
DROP TABLE IF EXISTS `core_applygrained`;
CREATE TABLE `core_applygrained` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) COLLATE utf8_bin NOT NULL,
`permissions` longtext COLLATE utf8_bin NOT NULL,
`work_id` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`status` int(11) DEFAULT NULL,
`auth_group` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`real_name` varchar(100) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `core_applygrained_username_01d55fc9` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for core_databaselist
-- ----------------------------
DROP TABLE IF EXISTS `core_databaselist`;
CREATE TABLE `core_databaselist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`connection_name` varchar(50) COLLATE utf8_bin NOT NULL,
`computer_room` varchar(50) COLLATE utf8_bin NOT NULL,
`ip` varchar(100) COLLATE utf8_bin NOT NULL,
`username` varchar(150) COLLATE utf8_bin NOT NULL,
`port` int(11) NOT NULL,
`password` varchar(500) COLLATE utf8_bin NOT NULL,
`before` longtext COLLATE utf8_bin,
`after` longtext COLLATE utf8_bin,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for core_globalpermissions
-- ----------------------------
DROP TABLE IF EXISTS `core_globalpermissions`;
CREATE TABLE `core_globalpermissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`authorization` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`inception` longtext COLLATE utf8_bin,
`ldap` longtext COLLATE utf8_bin,
`message` longtext COLLATE utf8_bin,
`other` longtext COLLATE utf8_bin,
PRIMARY KEY (`id`),
KEY `core_globalpermissions_authorization_b3bfe975` (`authorization`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for core_grained
-- ----------------------------
DROP TABLE IF EXISTS `core_grained`;
CREATE TABLE `core_grained` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) COLLATE utf8_bin NOT NULL,
`permissions` longtext COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`),
KEY `core_grained_username_4cd48d82` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for core_query_order
-- ----------------------------
DROP TABLE IF EXISTS `core_query_order`;
CREATE TABLE `core_query_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`work_id` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`username` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`date` varchar(50) COLLATE utf8_bin NOT NULL,
`instructions` longtext COLLATE utf8_bin,
`query_per` smallint(6),
`computer_room` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`connection_name` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`export` smallint(6),
`audit` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`time` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`real_name` varchar(100) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `core_query_order_work_id_1ae60daa` (`work_id`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for core_querypermissions
-- ----------------------------
DROP TABLE IF EXISTS `core_querypermissions`;
CREATE TABLE `core_querypermissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`work_id` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`username` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`statements` longtext COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`),
KEY `core_querypermissions_work_id_da29a27b` (`work_id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for core_sqlorder
-- ----------------------------
DROP TABLE IF EXISTS `core_sqlorder`;
CREATE TABLE `core_sqlorder` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`work_id` varchar(50) COLLATE utf8_bin NOT NULL,
`username` varchar(50) COLLATE utf8_bin NOT NULL,
`status` int(11) NOT NULL,
`type` smallint(6) NOT NULL,
`backup` smallint(6) NOT NULL,
`bundle_id` int(11) DEFAULT NULL,
`date` varchar(100) COLLATE utf8_bin NOT NULL,
`basename` varchar(50) COLLATE utf8_bin NOT NULL,
`sql` longtext COLLATE utf8_bin NOT NULL,
`text` longtext COLLATE utf8_bin NOT NULL,
`assigned` varchar(50) COLLATE utf8_bin NOT NULL,
`delay` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`rejected` longtext COLLATE utf8_bin NOT NULL,
`real_name` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`executor` varchar(50) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `core_sqlorder_bundle_id_3d5581f1` (`bundle_id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for core_sqlrecord
-- ----------------------------
DROP TABLE IF EXISTS `core_sqlrecord`;
CREATE TABLE `core_sqlrecord` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`state` varchar(100) COLLATE utf8_bin NOT NULL,
`sql` longtext COLLATE utf8_bin NOT NULL,
`error` longtext COLLATE utf8_bin,
`workid` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`affectrow` varchar(100) COLLATE utf8_bin DEFAULT NULL,
`sequence` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`SQLSHA1` longtext COLLATE utf8_bin,
`execute_time` varchar(150) COLLATE utf8_bin DEFAULT NULL,
`backup_dbname` varchar(100) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for core_todolist
-- ----------------------------
DROP TABLE IF EXISTS `core_todolist`;
CREATE TABLE `core_todolist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) COLLATE utf8_bin NOT NULL,
`content` varchar(200) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for django_content_type
-- ----------------------------
DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app_label` varchar(100) COLLATE utf8_bin NOT NULL,
`model` varchar(100) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for django_migrations
-- ----------------------------
DROP TABLE IF EXISTS `django_migrations`;
CREATE TABLE `django_migrations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app` varchar(255) COLLATE utf8_bin NOT NULL,
`name` varchar(255) COLLATE utf8_bin NOT NULL,
`applied` datetime(6) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
BEGIN;
INSERT INTO `core_grained` VALUES (29, 'admin', '{\'ddl\': \'0\', \'ddlcon\': [], \'dml\': \'0\', \'dmlcon\': [], \'dic\': \'0\', \'diccon\': [], \'dicedit\': \'0\', \'user\': \'1\', \'base\': \'1\', \'dicexport\': \'0\', \'person\': [], \'query\': \'0\', \'querycon\': []}');
INSERT INTO `core_globalpermissions` VALUES (2, 'global', '{\'host\': \'\', \'port\': \'\', \'user\': \'\', \'password\': \'\', \'back_host\': \'\', \'back_port\': \'\', \'back_user\': \'\', \'back_password\': \'\'}', '{\'type\': \'1\', \'host\': \'\', \'sc\': \'\', \'domain\': \'\', \'user\': \'\', \'password\': \'\'}', '{\'webhook\': \'\', \'smtp_host\': \'\', \'smtp_port\': \'\', \'user\': \'\', \'password\': \'\', \'to_user\': \'\', \'mail\': False, \'ding\': False, \'ssl\': False}', '{\'limit\': \'\', \'con_room\': [\'AWS\', \'Aliyun\', \'Own\', \'Other\'], \'foce\': \'\', \'multi\': False, \'query\': False, \'sensitive_list\': [], \'sensitive\': \'\', \'exclued_db_list\': [], \'exclued_db\': \'\', \'email_suffix_list\': [], \'email_suffix\': \'\'}');
INSERT INTO `core_account` VALUES (1, 'pbkdf2_sha256$100000$Dy6mFniGxTZa$YBQ9cX0iPQvTYp06C5ZiVgXICTHNTiwWhWYnRmcqjHY=', NULL, 0, 'admin', '', '', '', 1, 1, '2018-07-26 07:15:33.931971', 'admin', '', 'admin', '');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;
deployment
apiVersion: apps/v1beta1
kind: Deployment
metadata:
name: yearning
labels:
name: yearning
spec:
template:
metadata:
name: yearning
labels:
name: yearning
spec:
containers:
- name: yearning
image: registry.cn-hangzhou.aliyuncs.com/cookie/yearning:latest
imagePullPolicy: IfNotPresent
env:
- name: HOST
value: "sql.test.gloabl"
- name: MYSQL_ADDR
value: "172.16.7.3"
- name: MYSQL_USER
value: "yearning"
- name: MYSQL_PASSWORD
value: "1qaz@WSX"
ports:
- name: http
containerPort: 8000
service
apiVersion: v1
kind: Service
metadata:
name: yearning
labels:
name: yearning
spec:
type: NodePort
ports:
- name: tcp
port: 8000
nodePort: 30012
targetPort: 8000
selector:
name: yearning
验证
默认账号：admin，默认密码：Yearning_admin
