devops/schema/reghao_devops_rdb.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost-mysql
 Source Server Type    : MySQL
 Source Server Version : 50732
 Source Host           : 127.0.0.1:3306
 Source Schema         : reghao_devops_rdb

 Target Server Type    : MySQL
 Target Server Version : 50732
 File Encoding         : 65001

 Date: 17/10/2021 16:52:35
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for app_building
-- ----------------------------
DROP TABLE IF EXISTS `app_building`;
CREATE TABLE `app_building` (
  `id` int(11) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `app_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `repo_branch` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `build_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `build_result` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `build_time` datetime(6) DEFAULT NULL,
  `commit_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commit_time` datetime(6) DEFAULT NULL,
  `env` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `app_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `build_log_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `app_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `http_port` int(11) DEFAULT NULL,
  `package_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of app_building
-- ----------------------------
BEGIN;
INSERT INTO `app_building` VALUES (7902, '2021-06-28 16:12:02.034396', b'0', '2021-10-12 14:09:39.809972', 'content', 'develop', '管理员', '成功', '2021-10-12 14:09:39.765950', '068cf51d', '2021-10-09 17:41:02.000000', 'test', 'dotnetCore', '616526a348b8a6568bf84a9e', '内容服务', 8002, 'docker.alpha.iquizoo.com/iq3x/content:068cf51d');
INSERT INTO `app_building` VALUES (7903, '2021-06-28 16:12:02.050938', b'0', '2021-09-22 09:48:56.135104', 'dnkt', 'develop', '管理员', '成功', '2021-09-22 09:48:56.076977', '14a2b5b7', '2021-08-19 14:48:44.000000', 'test', 'npm', '614a8b88aa66c6724dc95fca', '大脑课堂', 8081, 'docker.alpha.iquizoo.com/iq3x/dnkt:14a2b5b7');
INSERT INTO `app_building` VALUES (7904, '2021-06-28 16:12:02.063070', b'0', '2021-06-28 16:12:02.063109', 'file', 'develop', NULL, NULL, NULL, NULL, NULL, 'test', 'dotnetCore', NULL, '文件服务', 8004, NULL);
INSERT INTO `app_building` VALUES (7905, '2021-06-28 16:12:02.075125', b'0', '2021-10-15 15:34:06.435521', 'user', 'develop', '管理员', '成功', '2021-10-15 15:34:06.371572', 'a31f5bae', '2021-10-15 15:31:34.000000', 'test', 'dotnetCore', '61692eeec96c1c3de1ede525', '用户服务', 8001, 'docker.alpha.iquizoo.com/iq3x/user:a31f5bae');
INSERT INTO `app_building` VALUES (7906, '2021-06-28 16:12:02.088139', b'0', '2021-10-12 14:09:50.655693', 'data', 'develop', '管理员', '成功', '2021-10-12 14:09:50.649568', '89f9d61f', '2021-09-30 14:24:14.000000', 'test', 'dotnetCore', '616526ae48b8a6568bf84aa1', '数据服务', 8006, 'docker.alpha.iquizoo.com/iq3x/data:89f9d61f');
INSERT INTO `app_building` VALUES (7907, '2021-06-28 16:12:02.101431', b'0', '2021-10-15 18:15:48.218277', 'dnkt-mgr', 'develop', '管理员', '成功', '2021-10-15 18:15:48.207744', 'b7554706', '2021-09-18 15:31:30.000000', 'test', 'npm', '616954d47390355152417da1', '大脑课堂后台', 8083, 'docker.alpha.iquizoo.com/iq3x/dnkt-mgr:b7554706');
INSERT INTO `app_building` VALUES (7908, '2021-06-28 16:12:02.114041', b'0', '2021-10-13 18:05:33.396892', 'cloud', 'develop', '管理员', '成功', '2021-10-13 18:05:33.324626', '6de93a55', '2021-08-11 16:32:11.000000', 'test', 'npm', '6166af6db373517ff4ad0866', '智慧云', 8086, 'docker.alpha.iquizoo.com/iq3x/cloud:6de93a55');
INSERT INTO `app_building` VALUES (7910, '2021-06-28 16:12:02.139767', b'0', '2021-06-28 16:12:02.139812', 'nzwl', 'develop', NULL, NULL, NULL, NULL, NULL, 'test', 'npm', NULL, '脑智未来', 8088, NULL);
INSERT INTO `app_building` VALUES (7911, '2021-06-28 16:12:02.151855', b'0', '2021-06-28 16:12:02.151905', 'timuke', 'develop', NULL, NULL, NULL, NULL, NULL, 'test', 'npm', NULL, '题目壳', 8085, NULL);
INSERT INTO `app_building` VALUES (7912, '2021-06-28 16:12:02.165815', b'0', '2021-09-23 15:11:06.557145', 'dnkt-jigou', 'develop', '管理员', '成功', '2021-09-23 15:11:06.510363', '736ace93', '2020-09-02 11:34:13.000000', 'test', 'npm', '614c288ab62e831f59c598d3', '大脑课堂机构版', 8082, 'docker.alpha.iquizoo.com/iq3x/dnkt-jigou:736ace93');
INSERT INTO `app_building` VALUES (7913, '2021-06-28 16:12:02.177591', b'0', '2021-06-28 16:12:02.177673', 'jigou-mgr', 'develop', NULL, NULL, NULL, NULL, NULL, 'test', 'npm', NULL, '机构版后台', 8084, NULL);
INSERT INTO `app_building` VALUES (7914, '2021-06-28 16:12:02.189282', b'0', '2021-09-29 09:12:51.192983', 'auth', 'develop', '管理员', '成功', '2021-09-29 09:12:51.185031', '64927ca1', '2021-09-29 09:07:51.000000', 'test', 'dotnetCore', '6153bd93ce8a1134a8db6e08', '认证服务', 5000, 'docker.alpha.iquizoo.com/iq3x/auth:64927ca1');
INSERT INTO `app_building` VALUES (7915, '2021-06-28 16:12:02.200865', b'0', '2021-06-28 16:12:02.200913', 'gateway', 'develop', NULL, NULL, NULL, NULL, NULL, 'test', 'dotnetCore', NULL, '网关', 8000, NULL);
INSERT INTO `app_building` VALUES (7916, '2021-06-28 16:12:02.215065', b'0', '2021-06-28 16:12:02.215115', 'task', 'develop', NULL, NULL, NULL, NULL, NULL, 'test', 'dotnetCore', NULL, '定时任务', 8005, NULL);
INSERT INTO `app_building` VALUES (7917, '2021-06-28 16:12:02.228742', b'0', '2021-09-28 16:05:53.999132', 'external', 'develop', '管理员', '成功', '2021-09-28 16:05:53.962881', '28f9aa9c', '2021-09-28 16:04:57.000000', 'test', 'dotnetCore', '6152cce156b1c530af4b3088', '外部内容服务', 8008, 'docker.alpha.iquizoo.com/iq3x/external:28f9aa9c');
INSERT INTO `app_building` VALUES (7918, '2021-06-28 16:12:02.241280', b'0', '2021-06-28 16:12:02.241322', 'system-config', 'develop', NULL, NULL, NULL, NULL, NULL, 'test', 'dotnetCore', NULL, '系统配置服务', 8007, NULL);
INSERT INTO `app_building` VALUES (7919, '2021-06-28 16:12:02.253646', b'0', '2021-10-08 16:32:33.438573', 'calscore', 'develop', '管理员', '成功', '2021-10-08 16:32:33.413132', 'e38404e2', '2021-10-08 16:31:30.000000', 'test', 'dotnetCore', '61600221cdacbb1e3d59c9df', '算分服务', 8003, 'docker.alpha.iquizoo.com/iq3x/calculate-score:e38404e2');
INSERT INTO `app_building` VALUES (7920, '2021-06-28 16:12:02.265516', b'0', '2021-10-15 09:52:42.264016', 'calscore-prod', 'master', '管理员', '成功', '2021-10-15 09:52:42.228317', 'aa186cb3', '2021-10-14 20:55:00.000000', 'prod', 'dotnetCore', '6168deea767848041bdee8e7', '算分服务', 8003, 'docker.iquizoo.com/iq3x/calscore-prod:aa186cb3');
INSERT INTO `app_building` VALUES (7921, '2021-06-28 16:12:02.277830', b'0', '2021-08-04 10:04:41.884994', 'system-config-prod', 'master', '管理员', '成功', '2021-08-04 10:04:41.877743', 'f0aef026', '2021-08-04 10:03:46.000000', 'prod', 'dotnetCore', '6109f5b96b7a2d1141365529', '系统配置服务', 8007, 'docker.iquizoo.com/iq3x/system-config-prod:f0aef026');
INSERT INTO `app_building` VALUES (7922, '2021-06-28 16:12:02.290563', b'0', '2021-09-10 16:02:36.488808', 'external-prod', 'master', '管理员', '成功', '2021-09-10 16:02:36.376360', 'bc502352', '2021-09-09 11:31:44.000000', 'prod', 'dotnetCore', '613b111c162a961ac14f71c9', '外部内容服务', 8008, 'docker.iquizoo.com/iq3x/external-prod:bc502352');
INSERT INTO `app_building` VALUES (7923, '2021-06-28 16:12:02.303039', b'0', '2021-06-28 16:12:02.303106', 'task-prod', 'master', NULL, NULL, NULL, NULL, NULL, 'prod', 'dotnetCore', NULL, '定时任务', 8005, NULL);
INSERT INTO `app_building` VALUES (7924, '2021-06-28 16:12:02.315126', b'0', '2021-08-04 11:57:18.509934', 'gateway-prod', 'master', '管理员', '成功', '2021-08-04 11:57:18.500498', '0877e671', '2021-08-04 11:56:33.000000', 'prod', 'dotnetCore', '610a101e6b7a2d114136553d', '网关', 8000, 'docker.iquizoo.com/iq3x/gateway-prod:0877e671');
INSERT INTO `app_building` VALUES (7925, '2021-06-28 16:12:02.327294', b'0', '2021-08-13 18:51:53.578410', 'auth-prod', 'master', '管理员', '成功', '2021-08-13 18:51:53.567394', '17514dae', '2021-08-13 17:37:45.000000', 'prod', 'dotnetCore', '61164ec90ad88403b04fc836', '认证服务', 5000, 'docker.iquizoo.com/iq3x/auth-prod:17514dae');
INSERT INTO `app_building` VALUES (7926, '2021-06-28 16:12:02.339320', b'0', '2021-06-28 16:12:02.339366', 'jigou-mgr-prod', 'master', NULL, NULL, NULL, NULL, NULL, 'prod', 'npm', NULL, '机构版后台', 8084, NULL);
INSERT INTO `app_building` VALUES (7927, '2021-06-28 16:12:02.351557', b'0', '2021-06-28 16:12:02.351615', 'dnkt-jigou-prod', 'master', NULL, NULL, NULL, NULL, NULL, 'prod', 'npm', NULL, '大脑课堂机构版', 8082, NULL);
INSERT INTO `app_building` VALUES (7928, '2021-06-28 16:12:02.363466', b'0', '2021-06-28 16:12:02.363509', 'timuke-prod', 'master', NULL, NULL, NULL, NULL, NULL, 'prod', 'npm', NULL, '题目壳', 8085, NULL);
INSERT INTO `app_building` VALUES (7929, '2021-06-28 16:12:02.375625', b'0', '2021-10-15 18:21:59.264424', 'content-prod', 'master', '管理员', '成功', '2021-10-15 18:21:59.257514', 'e6d69112', '2021-10-15 18:13:53.000000', 'prod', 'dotnetCore', '616956476d14d02409f6357d', '内容服务', 8002, 'docker.iquizoo.com/iq3x/content-prod:e6d69112');
INSERT INTO `app_building` VALUES (7930, '2021-06-28 16:12:02.387972', b'0', '2021-10-13 20:10:50.022421', 'dnkt-prod', 'master', '管理员', '成功', '2021-10-13 20:10:50.016089', 'e9e18ccc', '2021-10-13 20:05:24.000000', 'prod', 'npm', '6166cccab829f20b80a8c7c5', '大脑课堂', 8081, 'docker.iquizoo.com/iq3x/dnkt-prod:e9e18ccc');
INSERT INTO `app_building` VALUES (7931, '2021-06-28 16:12:02.400025', b'0', '2021-06-28 16:12:02.400072', 'file-prod', 'master', NULL, NULL, NULL, NULL, NULL, 'prod', 'dotnetCore', NULL, '文件服务', 8004, NULL);
INSERT INTO `app_building` VALUES (7932, '2021-06-28 16:12:02.414038', b'0', '2021-10-15 11:59:40.240226', 'user-prod', 'master', '管理员', '成功', '2021-10-15 11:59:40.196466', '7fbda974', '2021-10-15 11:57:47.000000', 'prod', 'dotnetCore', '6168fcac767848041bdee8f6', '用户服务', 8001, 'docker.iquizoo.com/iq3x/user-prod:7fbda974');
INSERT INTO `app_building` VALUES (7933, '2021-06-28 16:12:02.425406', b'0', '2021-10-15 12:16:37.391166', 'data-prod', 'master', '管理员', '成功', '2021-10-15 12:16:37.328995', '4ff98140', '2021-10-15 12:14:08.000000', 'prod', 'dotnetCore', '616900a58e9bc114deb42476', '数据服务', 8006, 'docker.iquizoo.com/iq3x/data-prod:4ff98140');
INSERT INTO `app_building` VALUES (7934, '2021-06-28 16:12:02.437285', b'0', '2021-10-15 10:39:15.234257', 'dnkt-mgr-prod', 'master', '管理员', '成功', '2021-10-15 10:39:15.226986', 'f3d5217f', '2021-10-15 09:56:39.000000', 'prod', 'npm', '6168e9d3767848041bdee8f1', '大脑课堂后台', 8083, 'docker.iquizoo.com/iq3x/dnkt-mgr-prod:f3d5217f');
INSERT INTO `app_building` VALUES (7935, '2021-06-28 16:12:02.449213', b'0', '2021-10-13 20:22:47.724205', 'nzwl-prod', 'master', '管理员', '成功', '2021-10-13 20:22:47.687158', '01a3435a', '2021-10-13 20:21:09.000000', 'prod', 'npm', '6166cf97b829f20b80a8c8d0', '脑智未来', 8088, 'docker.iquizoo.com/iq3x/nzwl-prod:01a3435a');
INSERT INTO `app_building` VALUES (7936, '2021-06-28 16:12:02.461558', b'0', '2021-10-15 18:21:16.846107', 'cloud-prod', 'master', '管理员', '成功', '2021-10-15 18:21:16.805732', 'def1c6cf', '2021-10-15 18:11:24.000000', 'prod', 'npm', '6169561c6d14d02409f63579', '智慧云', 8086, 'docker.iquizoo.com/iq3x/cloud-prod:def1c6cf');
INSERT INTO `app_building` VALUES (7937, '2021-06-28 16:12:02.473950', b'0', '2021-06-28 16:12:02.474001', 'dnkt-bplus', 'bplus', NULL, NULL, NULL, NULL, NULL, 'test', 'npm', NULL, '大脑课堂bplus', 8087, NULL);
INSERT INTO `app_building` VALUES (7938, '2021-06-28 16:12:02.486307', b'0', '2021-08-05 11:21:54.378479', 'dnkt-bplus-prod', 'bplus', '管理员', '成功', '2021-08-05 11:21:54.318239', 'ac783cdd', '2021-08-05 11:21:31.000000', 'prod', 'npm', '610b5952dbb10e4288ab3159', '大脑课堂bplus', 8087, 'docker.iquizoo.com/iq3x/dnkt-bplus-prod:ac783cdd');
INSERT INTO `app_building` VALUES (7939, '2021-06-28 16:12:02.497838', b'0', '2021-10-15 14:50:50.316028', 'data-uat', 'master', '管理员', '成功', '2021-10-15 14:50:50.299760', '4ff98140', '2021-10-15 12:14:08.000000', 'uat', 'dotnetCore', '616924ca836b4c25e6914301', '数据服务', 8006, 'docker.alpha.iquizoo.com/iq3x/data-uat:4ff98140');
INSERT INTO `app_building` VALUES (7940, '2021-06-28 16:12:02.509389', b'0', '2021-09-29 18:16:46.819477', 'base', 'develop', '管理员', '成功', '2021-09-29 18:16:46.713683', 'ee3a344c', '2021-09-29 18:08:35.000000', 'test', 'dotnetCore', '61543d0ecc5a1f2416eedbea', '基础服务', 8009, 'docker.alpha.iquizoo.com/iq3x/base:ee3a344c');
INSERT INTO `app_building` VALUES (7941, '2021-06-28 16:12:02.520446', b'0', '2021-09-09 13:35:43.247496', 'external-uat', 'master', '管理员', '成功', '2021-09-09 13:35:43.235580', 'bc502352', '2021-09-09 11:31:44.000000', 'uat', 'dotnetCore', '61399d2f5712f86eb01d3124', '外部内容服务', 8008, 'docker.alpha.iquizoo.com/iq3x/external-uat:bc502352');
INSERT INTO `app_building` VALUES (7942, '2021-06-28 16:12:02.532666', b'0', '2021-07-28 13:44:06.981646', 'base-uat', 'master', '管理员', '成功', '2021-07-28 13:44:06.971038', '3fbee2a5', '2021-07-28 13:11:46.000000', 'uat', 'dotnetCore', '6100eea63174f976f9aefa18', '基础服务', 8009, 'docker.alpha.iquizoo.com/iq3x/base-uat:3fbee2a5');
INSERT INTO `app_building` VALUES (7943, '2021-06-28 16:12:02.544213', b'0', '2021-10-15 14:52:27.272587', 'user-uat', 'master', '管理员', '成功', '2021-10-15 14:52:27.264669', '7fbda974', '2021-10-15 11:57:47.000000', 'uat', 'dotnetCore', '6169252b836b4c25e6914306', '用户服务', 8001, 'docker.alpha.iquizoo.com/iq3x/user-uat:7fbda974');
INSERT INTO `app_building` VALUES (7944, '2021-06-28 16:12:02.555719', b'0', '2021-07-28 19:04:35.411482', 'task-uat', 'master', '管理员', '成功', '2021-07-28 19:04:35.236090', 'de37e4c6', '2021-07-28 13:24:09.000000', 'uat', 'dotnetCore', '610139c3f43236069220e3b8', '定时任务', 8005, 'docker.alpha.iquizoo.com/iq3x/task-uat:de37e4c6');
INSERT INTO `app_building` VALUES (7945, '2021-06-28 16:12:02.567034', b'0', '2021-06-28 16:12:02.567061', 'sysconfig-uat', 'master', NULL, NULL, NULL, NULL, NULL, 'uat', 'dotnetCore', NULL, '系统配置服务', 8007, NULL);
INSERT INTO `app_building` VALUES (7946, '2021-06-28 16:12:02.580255', b'0', '2021-10-11 15:22:59.698615', 'calscore-uat', 'master', '管理员', '成功', '2021-10-11 15:22:59.689750', '8b5958ea', '2021-09-30 16:54:45.000000', 'uat', 'dotnetCore', '6163e65388d11d3be6e15e6c', '算分服务', 8003, 'docker.alpha.iquizoo.com/iq3x/calscore-uat:8b5958ea');
INSERT INTO `app_building` VALUES (7947, '2021-06-28 16:12:02.591307', b'0', '2021-06-28 16:12:02.591327', 'gateway-uat', 'master', NULL, NULL, NULL, NULL, NULL, 'uat', 'dotnetCore', NULL, '网关', 8000, NULL);
INSERT INTO `app_building` VALUES (7948, '2021-06-28 16:12:02.601837', b'0', '2021-08-13 17:38:37.193529', 'auth-uat', 'master', '管理员', '成功', '2021-08-13 17:38:37.152629', '17514dae', '2021-08-13 17:37:45.000000', 'uat', 'dotnetCore', '61163d9d0ad88403b04fc829', '认证服务', 5000, 'docker.alpha.iquizoo.com/iq3x/auth-uat:17514dae');
INSERT INTO `app_building` VALUES (7949, '2021-06-28 16:12:02.611337', b'0', '2021-10-15 18:15:27.417700', 'content-uat', 'master', '管理员', '成功', '2021-10-15 18:15:27.361439', 'e6d69112', '2021-10-15 18:13:53.000000', 'uat', 'dotnetCore', '616954bf7390355152417d9e', '内容服务', 8002, 'docker.alpha.iquizoo.com/iq3x/content-uat:e6d69112');
INSERT INTO `app_building` VALUES (7950, '2021-06-28 16:12:02.623013', b'0', '2021-09-10 14:33:42.767624', 'file-uat', 'master', '管理员', '成功', '2021-09-10 14:33:42.704095', 'ac2d75b4', '2021-05-13 18:27:28.000000', 'uat', 'dotnetCore', '613afc46162a961ac14f71c5', '文件服务', 8004, 'docker.alpha.iquizoo.com/iq3x/file-uat:ac2d75b4');
INSERT INTO `app_building` VALUES (10402, '2021-08-03 13:13:22.098703', b'0', '2021-08-03 13:15:03.211963', 'base-prod', 'master', '管理员', '成功', '2021-08-03 13:15:03.204416', '8749ba0d', '2021-08-02 18:12:50.000000', 'prod', 'dotnetCore', '6108d0d7b24fbd456733392f', '基础服务', 8009, 'docker.iquizoo.com/iq3x/base-prod:8749ba0d');
INSERT INTO `app_building` VALUES (10752, '2021-09-17 11:01:28.054453', b'0', '2021-10-13 19:42:34.223574', 'dnkt-uat', 'master', '管理员', '成功', '2021-10-13 19:42:34.147273', 'c79742ea', '2021-10-13 19:41:44.000000', 'uat', 'npm', '6166c62ab829f20b80a8c56c', '大脑课堂', 8081, 'docker.alpha.iquizoo.com/iq3x/dnkt-uat:c79742ea');
INSERT INTO `app_building` VALUES (10753, '2021-09-17 11:02:04.444076', b'0', '2021-10-15 10:22:49.269394', 'dnkt-mgr-uat', 'master', '管理员', '成功', '2021-10-15 10:22:49.258267', 'f3d5217f', '2021-10-15 09:56:39.000000', 'uat', 'npm', '6168e5f9767848041bdee8ec', '大脑课堂后台', 8083, 'docker.alpha.iquizoo.com/iq3x/dnkt-mgr-uat:f3d5217f');
INSERT INTO `app_building` VALUES (10852, '2021-09-18 09:40:03.040071', b'0', '2021-10-14 08:56:00.273565', 'content-dev', 'develop', '管理员', '成功', '2021-10-14 08:56:00.233665', 'c37f4ba9', '2021-10-12 16:33:42.000000', 'dev', 'dotnetCore', '6167802047511d0849088b7e', '内容服务', 8002, 'localhost:5000/reghao/content-dev:c37f4ba9');
INSERT INTO `app_building` VALUES (10853, '2021-09-18 09:40:26.395809', b'0', '2021-10-14 20:24:59.598747', 'dnkt-dev', 'develop', '管理员', '成功', '2021-10-14 20:24:59.593305', 'ea29d88a', '2021-10-08 15:43:09.000000', 'dev', 'npm', '6168219bb1b0842ce135b37f', '大脑课堂', 8081, 'localhost:5000/reghao/dnkt-dev:ea29d88a');
INSERT INTO `app_building` VALUES (10952, '2021-09-18 10:47:14.798128', b'0', '2021-10-13 18:47:19.319681', 'nzwl-uat', 'master', '管理员', '成功', '2021-10-13 18:47:19.313159', '62673cd2', '2021-10-13 18:34:04.000000', 'uat', 'npm', '6166b937b373517ff4ad09e1', '脑智未来', 8088, 'docker.alpha.iquizoo.com/iq3x/nzwl-uat:62673cd2');
INSERT INTO `app_building` VALUES (11102, '2021-09-23 09:51:32.303328', b'0', '2021-09-29 10:17:54.680301', 'dnkt-admin', 'develop', '管理员', '成功', '2021-09-29 10:17:54.675064', '22aea58f', '2021-09-29 09:52:12.000000', 'test', 'npm', '6153ccd2ce8a1134a8db7115', '大脑课堂新后台', 8089, 'docker.alpha.iquizoo.com/iq3x/dnkt-admin:22aea58f');
INSERT INTO `app_building` VALUES (11103, '2021-09-23 09:51:53.268677', b'0', '2021-09-28 10:38:40.834033', 'dnkt-admin-uat', 'master', '管理员', '成功', '2021-09-28 10:38:40.799091', '40613e25', '2021-08-02 17:42:12.000000', 'uat', 'npm', '615280301ca1cd7df7911bba', '大脑课堂新后台', 8089, 'docker.alpha.iquizoo.com/iq3x/dnkt-admin-uat:40613e25');
INSERT INTO `app_building` VALUES (11252, '2021-09-24 09:43:40.324939', b'0', '2021-10-14 13:53:27.330846', 'dmaster', 'master', '管理员', '失败', '2021-10-13 18:18:14.565445', '2961e8a9', '2021-09-24 22:08:00.000000', 'dev', 'maven', '6166b266b373517ff4ad098c', 'devops 系统', 4020, NULL);
INSERT INTO `app_building` VALUES (11253, '2021-09-24 09:43:53.558300', b'0', '2021-10-14 13:53:44.742952', 'dagent', 'master', '管理员', '失败', '2021-10-13 18:18:06.843260', '2961e8a9', '2021-09-24 22:08:00.000000', 'dev', 'maven', '6166b25eb373517ff4ad0986', '机器节点', 0, NULL);
INSERT INTO `app_building` VALUES (11352, '2021-10-13 18:00:34.866424', b'0', '2021-10-14 15:58:31.626914', 'cloud-uat', 'master', '管理员', '成功', '2021-10-14 15:58:31.619366', 'eb03a877', '2021-10-14 15:57:32.000000', 'uat', 'npm', '6167e3277995f93fc3d5302f', '智慧云', 8086, 'docker.alpha.iquizoo.com/iq3x/cloud-uat:eb03a877');
COMMIT;

-- ----------------------------
-- Table structure for app_config
-- ----------------------------
DROP TABLE IF EXISTS `app_config`;
CREATE TABLE `app_config` (
  `id` bigint(20) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `app_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `app_repo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `app_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `repo_branch` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pack_script` text COLLATE utf8mb4_unicode_ci,
  `compile_home` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code_dirname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `env` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `health_check` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `http_port` int(11) DEFAULT NULL,
  `compiler_config_id` bigint(20) DEFAULT NULL,
  `packer_config_id` bigint(20) DEFAULT NULL,
  `repo_auth_config_id` bigint(20) DEFAULT NULL,
  `exec_bin_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `app_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dirname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_qngy5r8xn572dmyxh01ubyoe9` (`app_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of app_config
-- ----------------------------
BEGIN;
INSERT INTO `app_config` VALUES (43, '2021-02-09 21:06:41.000000', b'0', '2021-06-28 11:43:10.133198', 'content', 'https://codeup.aliyun.com/5f1f8daf6207a1a8b17f6742/background/ContentService.git', 'dotnetCore', 'develop', 'FROM debian10/dotnetcore/rt/content:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./bin/Debug/net5.0/publish/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.ContentService.dll\"]', '/IQuizoo.ContentService', 'ContentService', 'test', '/health', 8002, 7, 117, 36, '', '内容服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (45, '2021-02-09 21:36:40.000000', b'0', '2021-06-28 11:42:45.249205', 'dnkt', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.Game.git', 'npm', 'develop', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8081/\' /etc/nginx/conf.d/http.conf\nCOPY ./dist-test /opt/webroot/', '/', 'IQuizoo.Game', 'test', '/', 8081, 40, 117, 4, NULL, '大脑课堂', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (52, '2021-02-20 09:21:29.000000', b'0', '2021-06-28 11:43:06.573851', 'file', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/FileService.git', 'dotnetCore', 'develop', 'FROM debian10/dotnetcore/rt/file:5\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./bin/Debug/net5.0/publish/ .\r\n\r\nENTRYPOINT [\"dotnet\", \"Com.IQuizoo.FileService.dll\"]', '/Com.IQuizoo.FileService', 'FileService', 'test', '/health', 8004, 7, 117, 4, '', '文件服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (54, '2021-02-20 09:37:29.000000', b'0', '2021-06-27 15:10:15.032066', 'user', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/UserService.git', 'dotnetCore', 'develop', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./bin/Debug/net5.0/publish/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.UserService.dll\"]', '/IQuizoo.UserService', 'UserService', 'test', '/health', 8001, 7, 117, 4, '', '用户服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (56, '2021-02-20 09:37:34.000000', b'0', '2021-06-28 11:43:03.119180', 'data', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/DataService.git', 'dotnetCore', 'develop', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./bin/Debug/net5.0/publish/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.DataService.dll\"]', '/IQuizoo.DataService', 'DataService', 'test', '/health', 8006, 7, 117, 4, '', '数据服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (58, '2021-02-20 09:37:42.000000', b'0', '2021-09-23 14:50:12.077229', 'dnkt-mgr', 'https://codeup.aliyun.com/5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.BMS.git', 'npm', 'develop', 'FROM debian10/nginx\r\n\r\nRUN sed -i \'s/8080/8083/\' /etc/nginx/conf.d/http.conf\r\nRUN mkdir -p /opt/webroot/src\r\nRUN mkdir -p /opt/webroot/start\r\n\r\nCOPY src /opt/webroot/src\r\nCOPY start /opt/webroot/start\r\n\r\nRUN cp /opt/webroot/src/config.js.test /opt/webroot/src/config.js\r\nRUN cp /opt/webroot/src/controller/oidcconfig.js.test /opt/webroot/src/controller/oidcconfig.js', '/', 'IQuizoo.BMS', 'test', '/', 8083, 40, 117, 36, '', '大脑课堂后台', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (60, '2021-02-20 09:37:47.000000', b'0', '2021-10-13 18:04:41.087138', 'cloud', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.AdminSys.git', 'npm', 'develop', 'FROM debian10/nginx\r\n\r\nRUN sed -i \'s/8080/8086/\' /etc/nginx/conf.d/http.conf\r\nCOPY ./dist-test /opt/webroot/\r\n', '/', 'IQuizoo.AdminSys', 'test', '/', 8086, 40, 117, 4, '', '智慧云', NULL, NULL, '');
INSERT INTO `app_config` VALUES (152, '2021-05-08 14:50:19.715000', b'0', '2021-06-28 11:43:23.386996', 'nzwl', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.C-terminal.git', 'npm', 'develop', 'FROM debian10/nginx\r\n\r\nRUN sed -i \'s/8080/8088/\' /etc/nginx/conf.d/http.conf\r\nCOPY ./dist-test /opt/webroot/', '/', 'IQuizoo.C-terminal', 'test', 'http://cterminal.alpha.iquizoo.com', 8088, 40, 117, 4, '', '脑智未来', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (153, '2021-02-27 00:41:08.000000', b'0', '2021-06-28 11:42:49.119423', 'timuke', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.QuestionShell.git', 'npm', 'develop', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8085/\' /etc/nginx/conf.d/http.conf\nCOPY ./dist-prod /opt/webroot/\n', '/', 'IQuizoo.QuestionShell', 'test', '/', 8085, 40, 117, 4, NULL, '题目壳', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (155, '2021-02-27 00:41:24.000000', b'0', '2021-06-28 11:42:52.437619', 'dnkt-jigou', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.Game.Institution.git', 'npm', 'develop', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8082/\' /etc/nginx/conf.d/http.conf\nCOPY ./dist-test /opt/webroot/\n', '/', 'IQuizoo.Game.Institution', 'test', '/', 8082, 40, 117, 4, NULL, '大脑课堂机构版', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (157, '2021-02-27 00:41:33.000000', b'0', '2021-06-28 11:42:56.582885', 'jigou-mgr', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.BMS.Institution.git', 'npm', 'develop', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8084/\' /etc/nginx/conf.d/http.conf\nRUN sed -i \'s/index /try_files $uri $uri\\/ \\//\' /etc/nginx/conf.d/http.conf\nCOPY ./dist-test /opt/webroot/', '/', 'IQuizoo.BMS.Institution', 'test', '/', 8084, 40, 117, 4, NULL, '机构版后台', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (159, '2021-02-27 01:07:20.000000', b'0', '2021-06-28 11:43:13.363019', 'auth', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/AuthService.git', 'dotnetCore', 'develop', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./bin/Debug/net5.0/publish/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.IdentityService.dll\"]', '/IQuizoo.IdentityService', 'AuthService', 'test', '/health', 5000, 7, 117, 4, '', '认证服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (161, '2021-02-27 01:07:28.000000', b'0', '2021-06-28 11:43:16.866772', 'gateway', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/Gateway.git', 'dotnetCore', 'develop', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./bin/Debug/net5.0/publish/ .\r\nENTRYPOINT [\"dotnet\", \"Com.IQuizoo.Gateway.dll\"]', '/Com.IQuizoo.Gateway', 'Gateway', 'test', '/health', 8000, 7, 117, 4, '', '网关', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (163, '2021-02-27 01:07:44.000000', b'0', '2021-06-28 11:43:33.976450', 'task', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/TaskCenter.git', 'dotnetCore', 'develop', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./bin/Debug/net5.0/publish/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.TimingTasks.dll\"]', '/4-Presentation/IQuizoo.TimingTasks', 'TaskCenter', 'test', '/health', 8005, 7, 117, 4, '', '定时任务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (165, '2021-02-27 01:08:30.000000', b'0', '2021-06-27 15:27:15.609511', 'external', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/ExternalService.git', 'dotnetCore', 'develop', 'FROM debian10/dotnetcore/rt/content:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./bin/Debug/net5.0/publish/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.ExternalServices.dll\"]', '/4-Presentation/IQuizoo.ExternalServices', 'ExternalService', 'test', '/health', 8008, 7, 117, 4, '', '外部服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (167, '2021-02-27 01:08:39.000000', b'0', '2021-06-28 11:43:30.801420', 'sysconfig', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/SystemConfigService.git', 'dotnetCore', 'develop', 'FROM debian10/dotnetcore/rt/content:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./bin/Debug/net5.0/publish/ .\r\nENTRYPOINT [\"dotnet\", \"Com.IQuizoo.SystemConfigService.dll\"]', '/4-ConfigPresentation/Com.IQuizoo.SystemConfigService', 'SystemConfigService', 'test', '/health', 8007, 7, 117, 4, '', '系统配置服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (169, '2021-02-27 01:09:10.000000', b'0', '2021-06-28 11:43:20.238807', 'calscore', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/CalculateScoreService.git', 'dotnetCore', 'develop', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nENV ASPNETCORE_ENVIRONMENT Production\r\nENV ASPNETCORE_URLS http://172.16.45.65:8003;\r\n\r\nWORKDIR /app\r\nCOPY ./bin/Debug/net5.0/publish/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.CalculateScoreService.dll\"]', '/IQuizoo.CalculateScoreService', 'CalculateScoreService', 'test', '/health', 8003, 7, 117, 4, '', '算分服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (171, '2021-02-27 03:51:17.000000', b'0', '2021-02-27 03:51:17.000000', 'calscore-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/CalculateScoreService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\n\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\n    && echo \'Asia/Shanghai\' >/etc/timezone\n\nENV ASPNETCORE_ENVIRONMENT Production\nENV ASPNETCORE_URLS http://172.16.45.65:8003;\n\nWORKDIR /app\nCOPY ./bin/Debug/net5.0/publish/ .\nENTRYPOINT [\"dotnet\", \"IQuizoo.CalculateScoreService.dll\"]', '/IQuizoo.CalculateScoreService', 'CalculateScoreService', 'prod', 'http://calc.health.iquizoo.cn/health', 8003, 7, 214, 4, NULL, '算分服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (176, '2021-02-27 04:04:20.000000', b'0', '2021-02-27 04:04:20.000000', 'sysconfig-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/SystemConfigService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt/content:5.0\n\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\n    && echo \'Asia/Shanghai\' >/etc/timezone\n\nWORKDIR /app\nCOPY ./bin/Debug/net5.0/publish/ .\nENTRYPOINT [\"dotnet\", \"Com.IQuizoo.SystemConfigService.dll\"]', '/4-ConfigPresentation/Com.IQuizoo.SystemConfigService', 'SystemConfigService', 'prod', 'http://systemconfig.health.iquizoo.cn/health', 8007, 7, 214, 4, NULL, '系统配置服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (177, '2021-02-27 04:04:39.000000', b'0', '2021-02-27 04:04:39.000000', 'external-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/ExternalService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt/content:5.0\n\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\n    && echo \'Asia/Shanghai\' >/etc/timezone\n\nWORKDIR /app\nCOPY ./bin/Debug/net5.0/publish/ .\nENTRYPOINT [\"dotnet\", \"IQuizoo.ExternalServices.dll\"]', '/4-Presentation/IQuizoo.ExternalServices', 'ExternalService', 'prod', 'http://external.health.iquizoo.cn/health', 8008, 7, 214, 4, NULL, '外部内容服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (179, '2021-02-27 04:05:00.000000', b'0', '2021-02-27 04:05:00.000000', 'task-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/TaskCenter.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\n\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\n    && echo \'Asia/Shanghai\' >/etc/timezone\n\nWORKDIR /app\nCOPY ./bin/Debug/net5.0/publish/ .\nENTRYPOINT [\"dotnet\", \"IQuizoo.TimingTasks.dll\"]', '/4-Presentation/IQuizoo.TimingTasks', 'TaskCenter', 'prod', 'http://task.health.iquizoo.cn/health', 8005, 7, 214, 4, NULL, '定时任务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (181, '2021-02-27 04:05:12.000000', b'0', '2021-08-03 13:23:24.373995', 'gateway-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/Gateway.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./bin/Debug/net5.0/publish/ .\r\nENTRYPOINT [\"dotnet\", \"Com.IQuizoo.Gateway.dll\"]', '/Com.IQuizoo.Gateway', 'Gateway', 'prod', 'http://gateway.health.iquizoo.cn/health', 8000, 7, 214, 4, '', '网关', NULL, NULL, '');
INSERT INTO `app_config` VALUES (183, '2021-02-27 04:05:20.000000', b'0', '2021-02-27 04:05:20.000000', 'auth-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/AuthService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\n\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\n    && echo \'Asia/Shanghai\' >/etc/timezone\n\nWORKDIR /app\nCOPY ./bin/Debug/net5.0/publish/ .\nENTRYPOINT [\"dotnet\", \"IQuizoo.IdentityService.dll\"]', '/IQuizoo.IdentityService', 'AuthService', 'prod', 'http://auth.health.iquizoo.cn/health', 5000, 7, 214, 4, NULL, '认证服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (185, '2021-02-27 04:05:30.000000', b'0', '2021-02-27 04:05:30.000000', 'jigou-mgr-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.BMS.Institution.git', 'npm', 'master', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8084/\' /etc/nginx/conf.d/http.conf\nRUN sed -i \'s/index /try_files $uri $uri\\/ \\//\' /etc/nginx/conf.d/http.conf\nCOPY ./dist-prod /opt/webroot/', '/', 'IQuizoo.BMS.Institution', 'prod', '/', 8084, 40, 214, 4, NULL, '机构版后台', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (187, '2021-02-27 04:05:37.000000', b'0', '2021-02-27 04:05:37.000000', 'dnkt-jigou-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.Game.Institution.git', 'npm', 'master', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8082/\' /etc/nginx/conf.d/http.conf\nCOPY ./dist-prod /opt/webroot/\n', '/', 'IQuizoo.Game.Institution', 'prod', '/', 8082, 40, 214, 4, NULL, '大脑课堂机构版', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (189, '2021-02-27 04:05:58.000000', b'0', '2021-02-27 04:05:58.000000', 'timuke-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.QuestionShell.git', 'npm', 'master', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8085/\' /etc/nginx/conf.d/http.conf\nCOPY ./dist-prod /opt/webroot/\n', '/', 'IQuizoo.QuestionShell', 'prod', '/', 8085, 40, 214, 4, NULL, '题目壳', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (191, '2021-02-27 04:06:08.000000', b'0', '2021-02-27 04:06:08.000000', 'content-prod', 'https://codeup.aliyun.com/5f1f8daf6207a1a8b17f6742/background/ContentService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt/content:5.0\n\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\n    && echo \'Asia/Shanghai\' >/etc/timezone\n\nWORKDIR /app\nCOPY ./bin/Debug/net5.0/publish/ .\nENTRYPOINT [\"dotnet\", \"IQuizoo.ContentService.dll\"]', '/IQuizoo.ContentService', 'ContentService', 'prod', 'http://content.health.iquizoo.cn/health', 8002, 7, 214, 36, NULL, '内容服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (193, '2021-02-27 04:06:15.000000', b'0', '2021-02-27 04:06:15.000000', 'dnkt-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.Game.git', 'npm', 'master', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8081/\' /etc/nginx/conf.d/http.conf\nCOPY ./dist-prod /opt/webroot/\n', '/', 'IQuizoo.Game', 'prod', '/', 8081, 40, 214, 4, NULL, '大脑课堂', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (195, '2021-02-27 04:06:25.000000', b'0', '2021-02-27 04:06:25.000000', 'file-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/FileService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt/file:5\n\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\n    && echo \'Asia/Shanghai\' >/etc/timezone\n\nWORKDIR /app\nCOPY ./bin/Debug/net5.0/publish/ .\n\nENTRYPOINT [\"dotnet\", \"Com.IQuizoo.FileService.dll\"]', '/Com.IQuizoo.FileService', 'FileService', 'prod', 'http://file.health.iquizoo.cn/health', 8004, 7, 214, 4, NULL, '文件服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (197, '2021-02-27 04:06:35.000000', b'0', '2021-02-27 04:06:35.000000', 'user-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/UserService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\n\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\n    && echo \'Asia/Shanghai\' >/etc/timezone\n\nWORKDIR /app\nCOPY ./bin/Debug/net5.0/publish/ .\nENTRYPOINT [\"dotnet\", \"IQuizoo.UserService.dll\"]', '/IQuizoo.UserService', 'UserService', 'prod', 'http://user.health.iquizoo.cn/health', 8001, 7, 214, 4, NULL, '用户服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (199, '2021-02-27 04:06:43.000000', b'0', '2021-02-27 04:06:43.000000', 'data-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/DataService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\n\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\n    && echo \'Asia/Shanghai\' >/etc/timezone\n\nWORKDIR /app\nCOPY ./bin/Debug/net5.0/publish/ .\nENTRYPOINT [\"dotnet\", \"IQuizoo.DataService.dll\"]', '/IQuizoo.DataService', 'DataService', 'prod', 'http://data.health.iquizoo.cn/health', 8006, 7, 214, 4, NULL, '数据服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (201, '2021-02-27 04:06:51.000000', b'0', '2021-02-27 04:06:51.000000', 'dnkt-mgr-prod', 'https://codeup.aliyun.com/5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.BMS.git', 'npm', 'master', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8083/\' /etc/nginx/conf.d/http.conf\nRUN mkdir -p /opt/webroot/src\nRUN mkdir -p /opt/webroot/start\n\nCOPY src /opt/webroot/src\nCOPY start /opt/webroot/start\n\nRUN cp /opt/webroot/src/config.js.prod /opt/webroot/src/config.js\nRUN cp /opt/webroot/src/controller/oidcconfig.js.prod /opt/webroot/src/controller/oidcconfig.js', '/', 'IQuizoo.BMS', 'prod', '/', 8083, 40, 214, 36, NULL, '大脑课堂后台', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (202, '2021-05-12 13:42:50.673000', b'0', '2021-05-12 13:42:50.673000', 'nzwl-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.C-terminal.git', 'npm', 'master', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8088/\' /etc/nginx/conf.d/http.conf\nCOPY ./dist-prod /opt/webroot/', '/', 'IQuizoo.C-terminal', 'prod', '/', 8088, 40, 214, 4, NULL, '脑智未来', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (203, '2021-02-27 04:06:58.000000', b'0', '2021-08-03 17:58:46.505677', 'cloud-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.AdminSys.git', 'npm', 'master', 'FROM debian10/nginx\r\n\r\nRUN sed -i \'s/8080/8086/\' /etc/nginx/conf.d/http.conf\r\nCOPY ./dist-prod /opt/webroot/', '/', 'IQuizoo.AdminSys', 'prod', '/', 8086, 40, 214, 4, '', '智慧云', NULL, NULL, '');
INSERT INTO `app_config` VALUES (208, '2021-03-01 10:25:08.000000', b'0', '2021-06-28 11:43:00.124504', 'dnkt-bplus', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.Game.git', 'npm', 'bplus', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8087/\' /etc/nginx/conf.d/http.conf\nCOPY ./dist-test /opt/webroot/\n', '/', 'IQuizoo.Game', 'test', '/', 8087, 40, 117, 4, NULL, '大脑课堂bplus', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (212, '2021-03-01 14:11:01.000000', b'0', '2021-03-01 14:11:01.000000', 'dnkt-bplus-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.Game.git', 'npm', 'bplus', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8087/\' /etc/nginx/conf.d/http.conf\nCOPY ./dist-prod /opt/webroot/\n', '/', 'IQuizoo.Game', 'prod', '/', 8087, 40, 214, 4, NULL, '大脑课堂bplus', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (6911, '2021-06-27 14:41:41.255538', b'0', '2021-06-27 15:25:49.326110', 'data-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/DataService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./app/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.DataService.dll\"]', '/', 'DataService', 'uat', '/health', 8006, 7002, 117, 4, '', '数据服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (7361, '2021-06-27 15:20:20.935420', b'0', '2021-06-28 11:42:34.602000', 'base', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/BaseService.git', 'dotnetCore', 'develop', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./app/ .\r\n\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.BaseService.dll\"]', '/', 'BaseService', 'test', '/health', 8009, 7002, 117, 4, '', '基础服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (7452, '2021-06-27 15:36:51.432507', b'0', '2021-06-27 15:45:18.515632', 'external-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/ExternalService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt/content:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./app/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.ExternalServices.dll\"]', '/', 'ExternalService', 'uat', '/health', 8008, 7002, 117, 4, '', '外部内容服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (7453, '2021-06-27 15:37:28.833241', b'0', '2021-06-27 15:46:03.430644', 'base-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/BaseService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./app/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.BaseService.dll\"]', '/', 'BaseService', 'uat', '/health', 8009, 7002, 117, 4, '', '基础服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (7454, '2021-06-27 15:37:39.492298', b'0', '2021-06-27 15:46:14.177383', 'user-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/UserService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./app/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.UserService.dll\"]', '/', 'UserService', 'uat', '/health', 8001, 7002, 117, 4, '', '用户服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (7455, '2021-06-27 15:38:05.188869', b'0', '2021-06-27 15:46:24.645760', 'task-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/TaskCenter.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./app/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.TimingTasks.dll\"]', '/', 'TaskCenter', 'uat', '/health', 8005, 7002, 117, 4, '', '定时任务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (7456, '2021-06-27 15:38:17.711576', b'0', '2021-06-27 15:46:36.360854', 'sysconfig-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/SystemConfigService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt/content:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./app/ .\r\nENTRYPOINT [\"dotnet\", \"Com.IQuizoo.SystemConfigService.dll\"]', '/', 'SystemConfigService', 'uat', '/health', 8007, 7002, 117, 4, '', '系统配置服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (7457, '2021-06-27 15:38:32.302730', b'0', '2021-06-27 15:57:56.040195', 'calscore-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/CalculateScoreService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./app/ .\r\n\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.CalculateScoreService.dll\"]', '/', 'CalculateScoreService', 'uat', '/health', 8003, 7002, 117, 4, '', '算分服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (7458, '2021-06-27 15:41:54.285721', b'0', '2021-06-27 15:47:12.578467', 'gateway-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/Gateway.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./app/ .\r\nENTRYPOINT [\"dotnet\", \"Com.IQuizoo.Gateway.dll\"]', '/', 'Gateway', 'uat', '/health', 8000, 7002, 117, 4, '', '网关', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (7459, '2021-06-27 15:42:03.202724', b'0', '2021-06-27 15:47:24.414653', 'auth-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/AuthService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\n\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\n    && echo \'Asia/Shanghai\' >/etc/timezone\n\nWORKDIR /app\nCOPY ./app/ .\n\nENTRYPOINT [\"dotnet\", \"IQuizoo.IdentityService.dll\"]', '/', 'AuthService', 'uat', '/health', 5000, 7002, 117, 4, '', '认证服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (7460, '2021-06-27 15:42:17.288125', b'0', '2021-06-27 15:45:37.459829', 'content-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/ContentService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt/content:5.0\n\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\n    && echo \'Asia/Shanghai\' >/etc/timezone\n\nWORKDIR /app\nCOPY ./app/ .\n\nENTRYPOINT [\"dotnet\", \"IQuizoo.ContentService.dll\"]', '/', 'ContentService', 'uat', '/health', 8002, 7002, 117, 4, '', '内容服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (7461, '2021-06-27 15:42:26.501265', b'0', '2021-06-27 15:44:52.051680', 'file-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/FileService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt/file:5\n\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\n    && echo \'Asia/Shanghai\' >/etc/timezone\n\nWORKDIR /app\nCOPY ./app/ .\n\nENTRYPOINT [\"dotnet\", \"Com.IQuizoo.FileService.dll\"]', '/', 'FileService', 'uat', '/health', 8004, 7002, 117, 4, '', '文件服务', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (10352, '2021-08-03 13:13:22.075115', b'0', '2021-08-03 13:14:05.833775', 'base-prod', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/background/BaseService.git', 'dotnetCore', 'master', 'FROM debian10/dotnetcore/rt:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./app/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.BaseService.dll\"]', '/', 'BaseService', 'prod', '/health', 8009, 7002, 214, 4, '', '基础服务', NULL, NULL, '');
INSERT INTO `app_config` VALUES (10702, '2021-09-17 11:01:28.024522', b'0', '2021-09-17 11:01:28.024548', 'dnkt-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.Game.git', 'npm', 'master', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8081/\' /etc/nginx/conf.d/http.conf\nCOPY ./dist-uat /opt/webroot/', '/', 'IQuizoo.Game', 'uat', '/', 8081, 40, 117, 4, NULL, '大脑课堂', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (10703, '2021-09-17 11:02:04.433878', b'0', '2021-09-17 11:02:04.433901', 'dnkt-mgr-uat', 'https://codeup.aliyun.com/5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.BMS.git', 'npm', 'master', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8083/\' /etc/nginx/conf.d/http.conf\nRUN mkdir -p /opt/webroot/src\nRUN mkdir -p /opt/webroot/start\n\nCOPY src /opt/webroot/src\nCOPY start /opt/webroot/start\n\nRUN cp /opt/webroot/src/config.js.uat /opt/webroot/src/config.js\nRUN cp /opt/webroot/src/controller/oidcconfig.js.uat /opt/webroot/src/controller/oidcconfig.js', '/', 'IQuizoo.BMS', 'uat', '/', 8083, 40, 117, 36, '', '大脑课堂后台', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (10802, '2021-09-18 09:40:03.007481', b'0', '2021-10-14 13:49:00.399026', 'content-dev', 'https://codeup.aliyun.com/5f1f8daf6207a1a8b17f6742/background/ContentService.git', 'dotnetCore', 'develop', 'FROM debian10/dotnetcore/rt/content:5.0\r\n\r\nRUN cp /usr/share/zoneinfo/Asia/Shanghai /etc/localtime \\\r\n    && echo \'Asia/Shanghai\' >/etc/timezone\r\n\r\nWORKDIR /app\r\nCOPY ./bin/Debug/net5.0/publish/ .\r\nENTRYPOINT [\"dotnet\", \"IQuizoo.ContentService.dll\"]', '/IQuizoo.ContentService', 'ContentService', 'dev', '/health', 8002, 7, 6, 36, '', '内容服务', NULL, NULL, '');
INSERT INTO `app_config` VALUES (10803, '2021-09-18 09:40:26.382859', b'0', '2021-09-24 14:04:10.881169', 'dnkt-dev', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.Game.git', 'npm', 'develop', 'FROM debian10/nginx\r\n\r\nRUN sed -i \'s/8080/8081/\' /etc/nginx/conf.d/http.conf\r\nCOPY ./dist-test /opt/webroot/', '/', 'IQuizoo.Game', 'dev', '/', 8081, 40, 6, 4, '', '大脑课堂', NULL, NULL, '');
INSERT INTO `app_config` VALUES (10902, '2021-09-18 10:47:14.765393', b'0', '2021-09-18 10:47:14.765430', 'nzwl-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.C-terminal.git', 'npm', 'master', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8088/\' /etc/nginx/conf.d/http.conf\nCOPY ./dist-uat /opt/webroot/', '/', 'IQuizoo.C-terminal', 'uat', 'http://cterminal.alpha.iquizoo.com', 8088, 40, 117, 4, '', '脑智未来', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (11052, '2021-09-23 09:51:32.279236', b'0', '2021-09-29 10:17:03.060175', 'dnkt-admin', 'https://codeup.aliyun.com/5f1f8daf6207a1a8b17f6742/FrontEnd/iquizoo.admin.git', 'npm', 'develop', 'FROM debian10/nginx1\r\n\r\nRUN sed -i \'s/8080/8089/\' /etc/nginx/conf.d/http.conf\r\nCOPY ./dist-test /opt/webroot/', '/', 'iquizoo.admin', 'test', '/', 8089, 40, 117, 36, '', '大脑课堂新后台', NULL, NULL, '');
INSERT INTO `app_config` VALUES (11053, '2021-09-23 09:51:53.251988', b'0', '2021-09-23 09:51:53.251996', 'dnkt-admin-uat', 'https://codeup.aliyun.com/5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.BMS.git', 'npm', 'master', 'FROM debian10/nginx\r\n\r\nRUN sed -i \'s/8080/8083/\' /etc/nginx/conf.d/http.conf\r\nRUN mkdir -p /opt/webroot/src\r\nRUN mkdir -p /opt/webroot/start\r\n\r\nCOPY src /opt/webroot/src\r\nCOPY start /opt/webroot/start\r\n\r\nRUN cp /opt/webroot/src/config.js.test /opt/webroot/src/config.js\r\nRUN cp /opt/webroot/src/controller/oidcconfig.js.test /opt/webroot/src/controller/oidcconfig.js', '/', 'iquizoo.admin', 'uat', '/', 8089, 40, 117, 36, '', '大脑课堂新后台', NULL, NULL, NULL);
INSERT INTO `app_config` VALUES (11203, '2021-09-24 09:43:40.322646', b'0', '2021-10-14 13:53:27.316343', 'dmaster', 'http://git.reghao.cn/reghao/autodop.git', 'maven', 'master', '', '/', 'autodop', 'dev', '/', 4020, 100, 102, 99, '', 'devops 系统', NULL, NULL, '');
INSERT INTO `app_config` VALUES (11204, '2021-09-24 09:43:53.537861', b'0', '2021-10-14 13:53:44.734158', 'dagent', 'http://git.reghao.cn/reghao/autodop.git', 'maven', 'master', '', '/', 'autodop', 'dev', '/', 0, 100, 102, 99, '', '机器节点', NULL, NULL, '');
INSERT INTO `app_config` VALUES (11302, '2021-10-13 18:00:34.848198', b'0', '2021-10-13 18:04:26.843657', 'cloud-uat', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.AdminSys.git', 'npm', 'master', 'FROM debian10/nginx\r\n\r\nRUN sed -i \'s/8080/8086/\' /etc/nginx/conf.d/http.conf\r\nCOPY ./dist-uat /opt/webroot/\r\n', '/', 'IQuizoo.AdminSys', 'uat', '/', 8086, 40, 117, 4, '', '智慧云', NULL, NULL, '');
COMMIT;

-- ----------------------------
-- Table structure for app_config_deploy_configs
-- ----------------------------
DROP TABLE IF EXISTS `app_config_deploy_configs`;
CREATE TABLE `app_config_deploy_configs` (
  `app_config_id` bigint(20) NOT NULL,
  `machine_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pack_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_home` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_script` text COLLATE utf8mb4_unicode_ci,
  `machine_ipv4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unpack_script` text COLLATE utf8mb4_unicode_ci,
  KEY `FK3unmj2udtl4fyf1guke9576gn` (`app_config_id`),
  CONSTRAINT `FK3unmj2udtl4fyf1guke9576gn` FOREIGN KEY (`app_config_id`) REFERENCES `app_config` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of app_config_deploy_configs
-- ----------------------------
BEGIN;
INSERT INTO `app_config_deploy_configs` VALUES (58, '5d1a727991f34d3a9c1220a1899e6ebd', 'docker', NULL, 'afasdf', '192.168.0.111', NULL);
INSERT INTO `app_config_deploy_configs` VALUES (10803, '5d1a727991f34d3a9c1220a1899e6ebd', 'docker', NULL, '{\r\n    \"Env\":[\r\n    ],\r\n    \"HostConfig\":{\r\n        \"NetworkMode\":\"host\",\r\n        \"RestartPolicy\": {\r\n            \"Name\":\"on-failure\",\r\n            \"MaximumRetryCount\":5\r\n        }\r\n    }\r\n}', '192.168.0.111', NULL);
INSERT INTO `app_config_deploy_configs` VALUES (10802, '5d1a727991f34d3a9c1220a1899e6ebd', 'docker', NULL, '{\r\n    \"Env\":[\r\n      \"ASPNETCORE_ENVIRONMENT=Staging\",\r\n      \"ASPNETCORE_URLS=http://192.168.0.197:8002;https://192.168.0.197:8102\"\r\n    ],\r\n    \"HostConfig\":{\r\n        \"NetworkMode\":\"host\",\r\n        \"RestartPolicy\": {\r\n            \"Name\":\"on-failure\",\r\n            \"MaximumRetryCount\":5\r\n        }\r\n    }\r\n}', '192.168.0.111', NULL);
COMMIT;

-- ----------------------------
-- Table structure for app_config_log_configs
-- ----------------------------
DROP TABLE IF EXISTS `app_config_log_configs`;
CREATE TABLE `app_config_log_configs` (
  `app_config_id` int(11) NOT NULL,
  `is_dir` bit(1) DEFAULT NULL,
  `level` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of app_config_log_configs
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for app_config_notify_groups
-- ----------------------------
DROP TABLE IF EXISTS `app_config_notify_groups`;
CREATE TABLE `app_config_notify_groups` (
  `app_config_id` int(11) NOT NULL,
  `notify_groups_id` int(11) NOT NULL,
  KEY `FKtiaeklq0eax4ckt7vbrcwrkjn` (`notify_groups_id`),
  CONSTRAINT `FKtiaeklq0eax4ckt7vbrcwrkjn` FOREIGN KEY (`notify_groups_id`) REFERENCES `notify_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of app_config_notify_groups
-- ----------------------------
BEGIN;
INSERT INTO `app_config_notify_groups` VALUES (54, 6252);
INSERT INTO `app_config_notify_groups` VALUES (6911, 6252);
INSERT INTO `app_config_notify_groups` VALUES (165, 6252);
INSERT INTO `app_config_notify_groups` VALUES (7361, 6252);
INSERT INTO `app_config_notify_groups` VALUES (45, 6252);
INSERT INTO `app_config_notify_groups` VALUES (153, 6252);
INSERT INTO `app_config_notify_groups` VALUES (155, 6252);
INSERT INTO `app_config_notify_groups` VALUES (157, 6252);
INSERT INTO `app_config_notify_groups` VALUES (208, 6252);
INSERT INTO `app_config_notify_groups` VALUES (56, 6252);
INSERT INTO `app_config_notify_groups` VALUES (52, 6252);
INSERT INTO `app_config_notify_groups` VALUES (43, 6252);
INSERT INTO `app_config_notify_groups` VALUES (159, 6252);
INSERT INTO `app_config_notify_groups` VALUES (161, 6252);
INSERT INTO `app_config_notify_groups` VALUES (169, 6252);
INSERT INTO `app_config_notify_groups` VALUES (152, 6252);
INSERT INTO `app_config_notify_groups` VALUES (167, 6252);
INSERT INTO `app_config_notify_groups` VALUES (163, 6252);
INSERT INTO `app_config_notify_groups` VALUES (10803, 6252);
INSERT INTO `app_config_notify_groups` VALUES (10802, 6252);
COMMIT;

-- ----------------------------
-- Table structure for app_config_notify_receivers
-- ----------------------------
DROP TABLE IF EXISTS `app_config_notify_receivers`;
CREATE TABLE `app_config_notify_receivers` (
  `app_config_id` int(11) NOT NULL,
  `notify_type` varchar(255) NOT NULL,
  `receiver` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of app_config_notify_receivers
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for app_deploying
-- ----------------------------
DROP TABLE IF EXISTS `app_deploying`;
CREATE TABLE `app_deploying` (
  `id` int(11) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `app_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `build_log_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deploy_result` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_deploy` bit(1) DEFAULT NULL,
  `machine_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `machine_ipv4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deploy_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deploy_time` datetime(6) DEFAULT NULL,
  `app_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `app_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `env` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `package_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commit_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of app_deploying
-- ----------------------------
BEGIN;
INSERT INTO `app_deploying` VALUES (7952, '2021-06-28 16:12:02.654317', b'0', '2021-10-15 18:15:48.243878', 'dnkt-mgr', '616954d47390355152417da1', NULL, NULL, '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111', NULL, NULL, '大脑课堂后台', 'npm', 'test', NULL, NULL);
INSERT INTO `app_deploying` VALUES (7953, '2021-06-28 16:12:02.665688', b'0', '2021-06-28 16:12:02.665711', 'cterminal', NULL, NULL, NULL, '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111', NULL, NULL, '脑智未来', 'npm', 'test', NULL, NULL);
INSERT INTO `app_deploying` VALUES (7954, '2021-06-28 16:12:02.677205', b'0', '2021-10-15 14:50:50.338336', 'data-uat', '616924ca836b4c25e6914301', NULL, NULL, '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111', NULL, NULL, '数据服务', 'dotnetCore', 'uat', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for app_running
-- ----------------------------
DROP TABLE IF EXISTS `app_running`;
CREATE TABLE `app_running` (
  `id` int(11) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `app_id` varchar(255) DEFAULT NULL,
  `app_name` varchar(255) DEFAULT NULL,
  `app_type` varchar(255) DEFAULT NULL,
  `env` varchar(255) DEFAULT NULL,
  `machine_id` varchar(255) DEFAULT NULL,
  `machine_ipv4` varchar(255) DEFAULT NULL,
  `build_log_id` varchar(255) DEFAULT NULL,
  `is_running` bit(1) DEFAULT NULL,
  `last_check` datetime(6) DEFAULT NULL,
  `package_path` varchar(255) DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `start_time` datetime(6) DEFAULT NULL,
  `health_check` varchar(255) DEFAULT NULL,
  `http_port` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of app_running
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for build_dir
-- ----------------------------
DROP TABLE IF EXISTS `build_dir`;
CREATE TABLE `build_dir` (
  `id` bigint(20) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `avail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dir_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `machine_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `used` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `machine_ipv4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mounted_on` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_hk1kw8yctt67349i4kaougm5e` (`machine_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of build_dir
-- ----------------------------
BEGIN;
INSERT INTO `build_dir` VALUES (47, '2021-02-10 02:20:46.000000', b'0', '2021-09-18 23:04:31.659895', '73580MiB', '/home/reghao/opt/data/autodop', '5d1a727991f34d3a9c1220a1899e6ebd', '88956MiB', '192.168.0.111', '/home', '294.29GiB', '');
COMMIT;

-- ----------------------------
-- Table structure for compiler_config
-- ----------------------------
DROP TABLE IF EXISTS `compiler_config`;
CREATE TABLE `compiler_config` (
  `id` bigint(20) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `compile_cmd` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `home_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `machine_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `machine_ipv4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_8qb44ffa5pma9xekiphefr9sp` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of compiler_config
-- ----------------------------
BEGIN;
INSERT INTO `compiler_config` VALUES (6, '2021-04-16 09:35:16.000000', b'0', '2021-06-07 15:56:16.205351', '', '', 'docker', 'docker', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111');
INSERT INTO `compiler_config` VALUES (7, '2021-02-07 17:38:09.000000', b'0', '2021-02-07 17:38:09.000000', '/home/reghao/dev/env/dotnet/dotnet-sdk-5.0.100-linux-x64/dotnet publish', NULL, 'dotnet5-dev', 'shell', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111');
INSERT INTO `compiler_config` VALUES (40, '2021-02-08 16:54:06.000000', b'0', '2021-06-07 15:53:27.676372', '', '', 'NoNeedCompile', 'no_need_compile', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111');
INSERT INTO `compiler_config` VALUES (100, '2021-02-21 13:36:15.000000', b'0', '2021-06-07 15:56:01.673488', '', '/home/reghao/dev/env/java/maven/maven-3.6.0', 'maven-test', 'maven', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111');
INSERT INTO `compiler_config` VALUES (132, '2021-02-24 22:36:47.000000', b'0', '2021-02-24 22:36:47.000000', 'npm i && npm run build:prod', NULL, 'npm-dev', 'shell', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111');
INSERT INTO `compiler_config` VALUES (7002, '2021-06-27 14:44:58.964540', b'0', '2021-06-27 14:44:58.964548', '/home/reghao/dev/env/dotnet/dotnet-sdk-5.0.100-linux-x64/dotnet publish -c Release --output app', '', 'dotnet-publish', 'shell', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111');
COMMIT;

-- ----------------------------
-- Table structure for ding_account
-- ----------------------------
DROP TABLE IF EXISTS `ding_account`;
CREATE TABLE `ding_account` (
  `id` int(11) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `is_default` bit(1) DEFAULT NULL,
  `notify_account_id` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `personal` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of ding_account
-- ----------------------------
BEGIN;
INSERT INTO `ding_account` VALUES (6652, '2021-06-24 15:54:15.936573', b'0', '2021-06-24 15:54:15.936621', b'0', 'ding-monitor', 'SEC4d7e0c126147b3679c4d15e47dc26311ca053bd47b21f4025832a6e246a93ec4', 'ding-monitor', NULL);
INSERT INTO `ding_account` VALUES (6702, '2021-06-24 15:54:55.341385', b'0', '2021-06-24 15:54:55.341439', b'0', 'ding-build', 'none', 'ding-build', NULL);
COMMIT;

-- ----------------------------
-- Table structure for email_account
-- ----------------------------
DROP TABLE IF EXISTS `email_account`;
CREATE TABLE `email_account` (
  `id` int(11) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `personal` varchar(255) DEFAULT NULL,
  `smtp` varchar(255) DEFAULT NULL,
  `is_default` bit(1) DEFAULT NULL,
  `notify_account_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of email_account
-- ----------------------------
BEGIN;
INSERT INTO `email_account` VALUES (6052, '2021-06-23 14:36:55.308971', b'0', '2021-06-23 14:36:55.309020', 'gjs@gsh1990', 'gisgit@163.com', 'devops@iquizoo', 'smtp.163.com', b'1', '163mail');
COMMIT;

-- ----------------------------
-- Table structure for machine_host
-- ----------------------------
DROP TABLE IF EXISTS `machine_host`;
CREATE TABLE `machine_host` (
  `id` int(11) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `boot_time` bigint(20) NOT NULL,
  `env` varchar(255) DEFAULT NULL,
  `last_check` bigint(20) NOT NULL,
  `machine_id` varchar(255) NOT NULL,
  `machine_ipv4` varchar(255) DEFAULT NULL,
  `os_arch` varchar(255) DEFAULT NULL,
  `os_name` varchar(255) DEFAULT NULL,
  `os_version` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `port` int(11) DEFAULT NULL,
  `rsa_prikey` text,
  `username` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_lo1x88vamyh2o34gdap4aw7jr` (`machine_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of machine_host
-- ----------------------------
BEGIN;
INSERT INTO `machine_host` VALUES (12552, '2021-10-16 22:48:10.534756', b'0', '2021-10-17 15:01:51.194580', 1633954063, 'test', 1634454111192, '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111', 'amd64', 'Linux', '5.4.150-1-MANJARO', 'gsh', 22, '', 'reghao', 'Offline');
COMMIT;

-- ----------------------------
-- Table structure for machine_host_notify_groups
-- ----------------------------
DROP TABLE IF EXISTS `machine_host_notify_groups`;
CREATE TABLE `machine_host_notify_groups` (
  `machine_host_id` int(11) NOT NULL,
  `notify_groups_id` int(11) NOT NULL,
  KEY `FKfvgerhymyvga49188493fj1bt` (`notify_groups_id`),
  CONSTRAINT `FKfvgerhymyvga49188493fj1bt` FOREIGN KEY (`notify_groups_id`) REFERENCES `notify_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of machine_host_notify_groups
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for machine_info
-- ----------------------------
DROP TABLE IF EXISTS `machine_info`;
CREATE TABLE `machine_info` (
  `id` int(11) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `arch` varchar(255) DEFAULT NULL,
  `boot_time` bigint(20) NOT NULL,
  `byte_order` varchar(255) DEFAULT NULL,
  `logical_core` int(11) NOT NULL,
  `machine_id` varchar(255) DEFAULT NULL,
  `machine_ipv4` varchar(255) DEFAULT NULL,
  `mem_total` bigint(20) NOT NULL,
  `model_name` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `physical_core` int(11) NOT NULL,
  `swap_total` bigint(20) NOT NULL,
  `vendor` varchar(255) DEFAULT NULL,
  `version` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of machine_info
-- ----------------------------
BEGIN;
INSERT INTO `machine_info` VALUES (12502, '2021-10-16 22:48:10.504462', b'0', '2021-10-16 23:06:39.673994', 'amd64', 1633954063, 'little', 8, '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111', 16663228416, 'Intel(R) Core(TM) i7-4800MQ CPU @ 2.70GHz', 'Linux', 4, 0, 'GenuineIntel', '5.4.150-1-MANJARO');
COMMIT;

-- ----------------------------
-- Table structure for machine_info_disk_infos
-- ----------------------------
DROP TABLE IF EXISTS `machine_info_disk_infos`;
CREATE TABLE `machine_info_disk_infos` (
  `machine_info_id` int(11) NOT NULL,
  `disk_path` varchar(255) DEFAULT NULL,
  `fs_type` varchar(255) DEFAULT NULL,
  `inode_total` bigint(20) NOT NULL,
  `mounted_on` varchar(255) DEFAULT NULL,
  `total` bigint(20) NOT NULL,
  KEY `FKjn32n1mvn6uuiqn0n6uwrqe2i` (`machine_info_id`),
  CONSTRAINT `FKjn32n1mvn6uuiqn0n6uwrqe2i` FOREIGN KEY (`machine_info_id`) REFERENCES `machine_info` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of machine_info_disk_infos
-- ----------------------------
BEGIN;
INSERT INTO `machine_info_disk_infos` VALUES (12502, '', 'ext4', 0, '/', 157459890176);
INSERT INTO `machine_info_disk_infos` VALUES (12502, '', 'ext4', 0, '/boot', 511647744);
INSERT INTO `machine_info_disk_infos` VALUES (12502, '', 'ext4', 0, '/home', 315993423872);
INSERT INTO `machine_info_disk_infos` VALUES (12502, '', 'ext4', 0, '/home/reghao/data', 235214622720);
INSERT INTO `machine_info_disk_infos` VALUES (12502, '', 'vfat', 0, '/boot/efi', 132135936);
COMMIT;

-- ----------------------------
-- Table structure for machine_info_network_infos
-- ----------------------------
DROP TABLE IF EXISTS `machine_info_network_infos`;
CREATE TABLE `machine_info_network_infos` (
  `machine_info_id` int(11) NOT NULL,
  `iface` varchar(255) DEFAULT NULL,
  `ipv4` varchar(255) DEFAULT NULL,
  `ipv6` varchar(255) DEFAULT NULL,
  `mac` varchar(255) DEFAULT NULL,
  `public_ipv4` varchar(255) DEFAULT NULL,
  KEY `FKfs6r0haxt8dx5ak8wp91pwojn` (`machine_info_id`),
  CONSTRAINT `FKfs6r0haxt8dx5ak8wp91pwojn` FOREIGN KEY (`machine_info_id`) REFERENCES `machine_info` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of machine_info_network_infos
-- ----------------------------
BEGIN;
INSERT INTO `machine_info_network_infos` VALUES (12502, 'wlp3s0', '192.168.0.111', 'fe80:0:0:0:a8ec:92fb:1b59:96f4%wlp3s0', 'e8-2a-ea-7c-4a-a2', '110.184.66.247');
COMMIT;

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int(11) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pid` int(11) DEFAULT NULL,
  `pos` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_enabled` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of menu
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES (152, '2021-05-11 15:20:06.022212', b'0', '2021-07-21 11:46:59.271151', 'layui-icon layui-icon-home', 0, 1, '主页', 'page', '/home', b'1');
INSERT INTO `menu` VALUES (153, '2021-05-11 15:20:06.023637', b'0', '2021-09-17 10:47:19.830466', 'fa fa-cog', 0, 6, '系统管理', 'dir', '#', b'1');
INSERT INTO `menu` VALUES (154, '2021-05-11 15:20:06.040161', b'0', '2021-05-19 14:05:42.646522', 'layui-icon layui-icon-user\n', 9452, 3, '用户管理', 'page', '/rbac/user', b'1');
INSERT INTO `menu` VALUES (155, '2021-05-11 15:20:06.041503', b'0', '2021-05-11 15:20:06.041529', 'layui-icon layui-icon-release\n', 9452, 2, '角色管理', 'page', '/rbac/role', b'1');
INSERT INTO `menu` VALUES (156, '2021-05-11 15:20:06.042662', b'0', '2021-05-19 16:14:04.207084', 'layui-icon layui-icon-release\n', 9452, 1, '资源管理', 'page', '/rbac/menu', b'1');
INSERT INTO `menu` VALUES (302, '2021-05-13 10:31:09.179446', b'0', '2021-07-21 11:46:59.273299', 'layui-icon layui-icon-app', 0, 3, '应用', 'dir', '#', b'1');
INSERT INTO `menu` VALUES (303, '2021-05-13 10:34:32.400476', b'0', '2021-10-14 10:16:53.078797', 'layui-icon layui-icon-face-smile', 302, 3, '构建部署', 'page', '/app/build', b'1');
INSERT INTO `menu` VALUES (305, '2021-05-13 10:38:19.945521', b'0', '2021-10-14 10:16:53.079793', 'layui-icon layui-icon-set', 302, 2, '应用配置', 'page', 'app/config/app', b'1');
INSERT INTO `menu` VALUES (502, '2021-05-17 18:08:58.040642', b'0', '2021-05-17 18:08:58.040717', 'layui-icon layui-icon-set', 302, 1, '构建配置', 'dir', '#', b'1');
INSERT INTO `menu` VALUES (503, '2021-05-17 18:10:42.043424', b'0', '2021-05-17 18:10:42.043453', 'layui-icon layui-icon-set', 502, 1, '构建目录', 'page', '/app/config/build/dir', b'1');
INSERT INTO `menu` VALUES (703, '2021-05-19 14:22:12.166310', b'0', '2021-07-12 11:14:59.899202', 'layui-icon layui-icon-release\n', 153, 3, '备份还原', 'page', '/sys/bak', b'1');
INSERT INTO `menu` VALUES (704, '2021-05-19 14:22:22.845883', b'0', '2021-09-17 10:47:19.831765', 'layui-icon layui-icon-release', 0, 5, '通知配置', 'dir', '#', b'1');
INSERT INTO `menu` VALUES (752, '2021-05-19 16:00:10.445920', b'0', '2021-07-12 11:14:59.900378', 'layui-icon layui-icon-release\n', 153, 4, 'JVM 状态', 'page', '/sys/jvmstatus', b'1');
INSERT INTO `menu` VALUES (802, '2021-05-20 13:44:18.715247', b'0', '2021-05-20 13:44:18.715323', 'layui-icon layui-icon-set', 502, 2, '仓库认证', 'page', '/app/config/build/repoauth', b'1');
INSERT INTO `menu` VALUES (803, '2021-05-20 13:44:42.119999', b'0', '2021-05-20 13:44:42.120040', 'layui-icon layui-icon-set', 502, 3, '应用编译', 'page', '/app/config/build/compiler', b'1');
INSERT INTO `menu` VALUES (804, '2021-05-20 13:45:11.729758', b'0', '2021-05-20 13:45:11.729792', 'layui-icon layui-icon-set', 502, 4, '应用打包', 'page', '/app/config/build/packer', b'1');
INSERT INTO `menu` VALUES (805, '2021-05-20 13:48:04.812581', b'0', '2021-10-14 10:16:53.080378', 'layui-icon layui-icon-face-smile', 302, 4, '构建历史', 'page', '/app/log/build', b'1');
INSERT INTO `menu` VALUES (809, '2021-05-20 13:53:46.834540', b'0', '2021-10-14 10:16:53.081010', 'layui-icon layui-icon-face-smile', 302, 5, '应用状态', 'page', '/app/status', b'1');
INSERT INTO `menu` VALUES (810, '2021-05-20 13:54:34.299197', b'0', '2021-07-21 11:46:59.275648', 'fa fa-server', 0, 2, '机器', 'dir', '#', b'1');
INSERT INTO `menu` VALUES (811, '2021-05-20 13:55:24.546804', b'0', '2021-05-20 13:55:24.546861', 'fa fa-server', 810, 1, '机器节点', 'page', '/machine/host', b'1');
INSERT INTO `menu` VALUES (1502, '2021-06-04 09:22:16.495701', b'0', '2021-09-17 10:47:19.832798', 'layui-icon layui-icon-face-smile', 0, 4, '监控', 'dir', '#', b'1');
INSERT INTO `menu` VALUES (1503, '2021-06-04 09:23:17.107389', b'0', '2021-06-04 09:23:17.107416', 'layui-icon layui-icon-face-smile', 1502, 1, '任务列表', 'page', '/monitor/job', b'1');
INSERT INTO `menu` VALUES (1505, '2021-06-04 09:25:31.980410', b'0', '2021-06-04 09:25:31.980453', 'layui-icon layui-icon-face-smile', 810, 2, '机器状态', 'page', '/machine/status', b'1');
INSERT INTO `menu` VALUES (2252, '2021-06-11 10:47:25.635127', b'0', '2021-07-12 11:16:00.527986', 'layui-icon layui-icon-face-smile', 9502, 1, '运行日志', 'page', '/sys/log/runtime', b'1');
INSERT INTO `menu` VALUES (2253, '2021-06-11 10:48:03.515580', b'0', '2021-07-12 11:16:14.394649', 'layui-icon layui-icon-face-smile', 9502, 2, '访问日志', 'page', '/sys/log/access111', b'1');
INSERT INTO `menu` VALUES (5952, '2021-06-23 09:42:26.433061', b'0', '2021-06-23 09:42:26.433072', 'layui-icon layui-icon-face-smile', 704, 2, '邮件账户', 'page', '/sys/notify/email', b'1');
INSERT INTO `menu` VALUES (5953, '2021-06-23 09:42:50.055301', b'0', '2021-06-23 09:42:50.055313', 'layui-icon layui-icon-face-smile', 704, 4, '短信账户', 'page', '/sys/notify/sms', b'1');
INSERT INTO `menu` VALUES (6102, '2021-06-23 17:01:09.479385', b'0', '2021-06-23 17:01:09.479414', 'layui-icon layui-icon-face-smile', 704, 1, '通知组', 'page', '/sys/notify/receiver', b'1');
INSERT INTO `menu` VALUES (6752, '2021-06-24 16:26:23.732725', b'0', '2021-06-24 16:26:23.732739', 'layui-icon layui-icon-face-smile', 704, 3, '钉钉账户', 'page', '/sys/notify/ding', b'1');
INSERT INTO `menu` VALUES (9452, '2021-07-12 10:42:34.160548', b'0', '2021-09-17 10:47:19.833721', 'layui-icon layui-icon-face-smile', 0, 7, '权限用户', 'dir', '#', b'1');
INSERT INTO `menu` VALUES (9502, '2021-07-12 11:14:59.922658', b'0', '2021-07-12 11:14:59.922697', 'layui-icon layui-icon-face-smile', 153, 1, '日志', 'dir', '#', b'1');
COMMIT;

-- ----------------------------
-- Table structure for notify_group
-- ----------------------------
DROP TABLE IF EXISTS `notify_group`;
CREATE TABLE `notify_group` (
  `id` int(11) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `notify_account_id` varchar(255) DEFAULT NULL,
  `notify_type` varchar(255) NOT NULL,
  `group_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of notify_group
-- ----------------------------
BEGIN;
INSERT INTO `notify_group` VALUES (6202, '2021-06-23 18:54:48.901548', b'0', '2021-06-23 18:55:42.112446', 'ding-monitor', 'ding', '监控报警');
INSERT INTO `notify_group` VALUES (6252, '2021-06-23 20:11:38.665377', b'0', '2021-06-23 20:11:38.665404', 'ding-build', 'ding', 'dev 构建部署');
COMMIT;

-- ----------------------------
-- Table structure for notify_group_receivers
-- ----------------------------
DROP TABLE IF EXISTS `notify_group_receivers`;
CREATE TABLE `notify_group_receivers` (
  `notify_group_id` int(11) NOT NULL,
  `receivers` varchar(255) DEFAULT NULL,
  KEY `FKklnixcshml36k5rjehl3nt0us` (`notify_group_id`),
  CONSTRAINT `FKklnixcshml36k5rjehl3nt0us` FOREIGN KEY (`notify_group_id`) REFERENCES `notify_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of notify_group_receivers
-- ----------------------------
BEGIN;
INSERT INTO `notify_group_receivers` VALUES (6202, 'https://oapi.dingtalk.com/robot/send?access_token=94efee0f4d97698042cac79f292837e3c359fd786191061e8969335d0115049d');
INSERT INTO `notify_group_receivers` VALUES (6252, 'https://oapi.dingtalk.com/robot/send?access_token=ba9cf0d846cff8c471168e0d2f91ec0c44645a086cf5e4e421697c9b0c606bd2');
COMMIT;

-- ----------------------------
-- Table structure for packer_config
-- ----------------------------
DROP TABLE IF EXISTS `packer_config`;
CREATE TABLE `packer_config` (
  `id` bigint(20) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `machine_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `machine_ipv4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_ilu7yfvuir3cvd8oqiemwrqh8` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of packer_config
-- ----------------------------
BEGIN;
INSERT INTO `packer_config` VALUES (6, '2021-02-07 17:37:59.000000', b'0', '2021-02-07 17:37:59.000000', 'docker-dev', 'localhost:5000/reghao', 'docker', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111');
INSERT INTO `packer_config` VALUES (102, '2021-02-22 15:30:26.000000', b'0', '2021-02-22 15:30:26.000000', 'zip-dev', '/', 'zip', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111');
INSERT INTO `packer_config` VALUES (117, '2021-02-24 13:49:09.000000', b'0', '2021-02-24 13:49:09.000000', 'docker-test', 'docker.alpha.iquizoo.com/iq3x', 'docker', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111');
INSERT INTO `packer_config` VALUES (214, '2021-03-01 14:11:22.000000', b'0', '2021-03-01 14:11:22.000000', 'docker-prod', 'docker.iquizoo.com/iq3x', 'docker', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111');
COMMIT;

-- ----------------------------
-- Table structure for repo_auth_config
-- ----------------------------
DROP TABLE IF EXISTS `repo_auth_config`;
CREATE TABLE `repo_auth_config` (
  `id` bigint(20) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `auth_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rsa_prikey` text COLLATE utf8mb4_unicode_ci,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_4ni08l74bwgnnpnjowa6hvx2p` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of repo_auth_config
-- ----------------------------
BEGIN;
INSERT INTO `repo_auth_config` VALUES (4, '2021-02-07 11:36:12.000000', b'0', '2021-06-07 15:31:23.330827', 'ssh', 'git-codeup', '', '-----BEGIN RSA PRIVATE KEY-----\r\nMIIJKQIBAAKCAgEA2jLie77gTk9fXBa4l+bP2uocJiv89SD1qIxEUkwW4BlGvLRU\r\nB6a1IbUnV98152r0PLnzprI3p5XIgtck+G6JHtiiyYpdpHVCHdL3GW2HQ4co340y\r\nzFHVbCear6KCLIItBetchzMJCPbAMXSdPAJ95WNZqLSPZQdQ1VB/aaq7kmAXdYMw\r\na4ySn3t/F5/FHpZ5+hpzQpZNO2rXpUg6/0nG9XT9PEJKZNtOJXLb8D8a1bkj+Zqq\r\nl6btVQOxs+E4dNbEQ57ZZI1d1f56XflYUXYFXKXf74pqEjXH3eimyEtdHX52RsAr\r\n5pue8T5gx55WUyKFIan8r5+E1MLtrHFIgw02d/mEk4CBrDibS2M6hTg1aEsqkDA0\r\n/9pPPWpYAsKPwYW5Le12wxFLbLQeCWUjR5Qg4fZbCik0vL4CmrLnWCoEd6mcjcJI\r\nEybsRBHDS46mPuRPVxWUOSMno7JGFvzD0neYt3b5uHJ2ByQUAgh5k395GvG5d7jX\r\nbo4knwaMhu/SUi/HXFD1suOoGHS9B5L8Lf3uUF+eOK7+myqqMcBofvnmZfli/UVG\r\ngwQy610AxOzjkxXuXLTk0nea4vbhbvCSzmmMixJyFdl+D8XP6ZhveKZGDmihujfT\r\nS3lw89KKLRpWvVVz92gO9EiWaA4kfnJTP0k2mrw2zNuBf7jbJH+OeQwISE8CAwEA\r\nAQKCAgA7kPaZN5N+bVaoCh/cgAswRQboOMv2k0fc+mXQXatFBEF2VHg4Gn+KMy0J\r\nZQsPIPiJ922XjUF6Q36YkWkrVOmj/Rn7kQVdVxF0mNoSG/94JNa4qJA8jP6JZwpo\r\ndiG5StRFsGnzErCdvNbc6WvfLQL3czbPwnL+7o9XnIEb9Jr+K7NbxjOauKZyWUFp\r\nzpj+b6/e4gejHur4lINIQL6yYI6rBYP4RlSO0fu0Z3W5UVDfFYrHojx95/kUY0zI\r\nwWwrIVI075GDTMBYIf9/1gkRO/ncv/+xIgUw8XOdldyqA0DpQ1PAnsedTdCHJTNA\r\na24/hcX4WbJ8szyM5KYDlG1qMVozx2ErDyLbVVcWdcO7RsoP4QSc8asEw/GEFkvd\r\nwroltR5HLTx2Ze+Xg/Dz+zmrQLslEsPYfsGQI8rqlk3M9CBtouu9k4AKD8hO+Nqg\r\nEmgkfQgMxQM/yR9rVvmf37STjAAoporzhCBtrplFF/osFXlFfEon6WVEAjBpE6t8\r\nxO9R0GW9A5QCujCCUMfdJGX5j1PsYr2G/xTUEhiLbVClaplZw/mP5rz+YdoQTNhi\r\naMyBtwF1emTfXt/iCOiETKBV1vBe1npU4Fl8qbijEMEmk5NgxS4jV4RXIZqi+FvO\r\nxMT1anrczGUdRSqvpghZ669Vww9sJxb8nGxghG83oVIJ/OT8uQKCAQEA77aJLH2w\r\nAArsSo/zhPK0LqjqjM+y4os/GjTQ4AFpzKVyhTu2Yh6h59K3vEErLzJEvn1fqVs6\r\n+raFC8elrSNclZ39Y5SCTS1GUxafSBExEDjuBAGLirAazoRcRtCmbpo5k/ACdsye\r\nyY5AYva2W8gZJcTbnwHxKtuFmWaj9oiVXxboEiQqf9W+xGGbOTJJPPRa6AvXZyaC\r\noxzoI3uIM3CzRLKg0ETufWYmsfF58TmIhJ0GK0ShidwpPZwtrdd/T6NXiYU6/McP\r\nfQ50t+vGXsJBSAJaPrVb2Z6rBVbFCd7VZKoyD90oQYwDacs0d6McKcr+Jeqa7clC\r\n90EnTm3nB0bKEwKCAQEA6QYjnzW6/5DRYidmLfRLsskT06yjc4Ey/Jax+9r9M4Su\r\nm4/OZF5LXrIkxS1IarxdOvGF44KU/SlWU2WmTDWaYQ57jA0+66fMzmCJWOipiPyk\r\nm2Gk/ZleW6pky6oQe3gi7f1rMIFUywFVDY+9reVOeEvyv17oCiZL3S2qE18wrZw+\r\ne4CGoIfk4aYLjCd5Y9jsfGUnRzA8fSBRadA0/JfywxCMEpsG2007KUhlXbIMAWky\r\nxHzHsMkdcfnQyniJgY+3gfulLgqQkmYu7f2Ec7OH3VCgLpRVKSzzk/fv4DkHuoZi\r\n7KZ57vlEn20xe2DcEtNvDIeja7H04q/7GFlX9EIQVQKCAQEAoR7d4KuyarTs0ckj\r\n80520Y3z6SWJpT/W8DRj2MzaYhUqfmb+VcElLf6yRLTA4/4zup3meJy7bdzUXHCa\r\n6V8FUgNZV19wnZM624ovEW+MvMynHsYzFsr7mafZpjeERn8fCFKgNV2ftPYKTPpq\r\n5BIA5SQGQkA564aVq+ATgReY3ss0vUzVzArNKI46mR01oOTVXXboF4sI7730QjU7\r\n/OdZd2lhMdvDOUI57AzU29DB8/DfPqHouhLjHWgmQ9y+07aElgiY92KNBI984Ep3\r\nkSWcX1xFcDTSQdmmNfZ2hgXjBMBo2cTa1APaH3fYEjnuKiEo5i9kZ0OJ4UtHsi2o\r\nxXlNRQKCAQA68eSc53iQIU/15kWApmVnqlmrl+YY17vQDUakkPavy4Znr27kEL48\r\nDBAlGJlS9qcWu/XEYUnS6Fv/6JyydnTAzGsQOGGMNvwl0GGt7dzE3DO/YmncBKnL\r\nwkSRCEn3EaK0VQCCWpTabVHYhl3S2UiKQZv8MMO9nYZfQqfdEp07rWRY1WA4x2ds\r\ndRZCs9GPIlZf+S6AYYFLnZs6iwJ8SuuL0Gm+YxzO6LBodvm9Q8aprLS841uYKqea\r\nJzlbnjYaYgJnjQJxrRZ5EgQZC6IvqmBZ6YU7gyYvrkFHUtaI/6Qm2Mu5VTtO6hsj\r\nwPldXlkNIhLbNoxuN6vck+uOczs+fF+pAoIBAQDYs+x0O2m5ly30uy9xQgsJoDZW\r\ne4DH2uhrpQt6JMGLDIFaSPS7/UGBF98XWW2t+Uo70kFo7rkGqP0P+3aMwGJuUJXX\r\nWvcMejp29K6hIZVhSSkJqiCVt6OTTyGSMwY7KCdiAXNVIPEdeeEWy7Y84e2iyLTc\r\nGWAOPQC53m7eQO+KKQY1y7XaS8EfAq65CNNADgX4S542T/qraDLZjD2buahQt3ku\r\nGK7njMx16ts+WPCjztxTlJ2L9MJZZj/xU9q3xMx3ax34Dj0CeW63YU6sDntXjqhE\r\nuL5BJxHtwoAkt96WrK35P14zGX7pHhkR/IL7Ub/2kpa0+D6RehdjBK2NH7h3\r\n-----END RSA PRIVATE KEY-----', 'git', '');
INSERT INTO `repo_auth_config` VALUES (36, '2020-10-21 18:24:33.000000', b'0', '2020-10-21 18:24:33.000000', 'http', 'git-codeup-http', '6wNSPZH4', NULL, 'git', 'azygjs');
INSERT INTO `repo_auth_config` VALUES (99, '2021-02-21 13:33:22.000000', b'0', '2021-06-17 22:41:16.215268', 'http', 'git-reghao', 'gsh', '', 'git', 'reghao');
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(11) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES (52, '2021-05-11 15:20:05.958407', b'0', '2021-07-12 11:19:41.558512', 'ROLE_ADMIN', '管理员', '具有所有访问权限');
INSERT INTO `role` VALUES (53, '2021-05-11 15:20:05.959707', b'0', '2021-05-11 15:20:05.959727', 'ROLE_USER', '用户', '具有最基本的访问权限');
INSERT INTO `role` VALUES (202, '2021-05-11 19:08:52.083053', b'0', '2021-06-10 15:33:37.816616', 'ROLE_BACKEND', '后端开发', '');
INSERT INTO `role` VALUES (252, '2021-05-11 19:13:33.632519', b'0', '2021-06-10 15:34:46.823274', 'ROLE_FRONTEND', '前端开发', '');
INSERT INTO `role` VALUES (352, '2021-05-13 10:59:19.220410', b'0', '2021-05-13 10:59:19.220456', 'ROLE_TEST', '测试', '');
COMMIT;

-- ----------------------------
-- Table structure for role_menu
-- ----------------------------
DROP TABLE IF EXISTS `role_menu`;
CREATE TABLE `role_menu` (
  `role_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL,
  PRIMARY KEY (`role_id`,`menu_id`),
  KEY `FKfg4e2mb2318tph615gh44ll3` (`menu_id`),
  CONSTRAINT `FKfg4e2mb2318tph615gh44ll3` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`id`),
  CONSTRAINT `FKqyvxw2gg2qk0wld3bqfcb58vq` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of role_menu
-- ----------------------------
BEGIN;
INSERT INTO `role_menu` VALUES (52, 152);
INSERT INTO `role_menu` VALUES (53, 152);
INSERT INTO `role_menu` VALUES (202, 152);
INSERT INTO `role_menu` VALUES (252, 152);
INSERT INTO `role_menu` VALUES (352, 152);
INSERT INTO `role_menu` VALUES (52, 153);
INSERT INTO `role_menu` VALUES (52, 154);
INSERT INTO `role_menu` VALUES (52, 155);
INSERT INTO `role_menu` VALUES (52, 156);
INSERT INTO `role_menu` VALUES (52, 302);
INSERT INTO `role_menu` VALUES (202, 302);
INSERT INTO `role_menu` VALUES (252, 302);
INSERT INTO `role_menu` VALUES (52, 303);
INSERT INTO `role_menu` VALUES (202, 303);
INSERT INTO `role_menu` VALUES (252, 303);
INSERT INTO `role_menu` VALUES (52, 305);
INSERT INTO `role_menu` VALUES (202, 305);
INSERT INTO `role_menu` VALUES (52, 502);
INSERT INTO `role_menu` VALUES (52, 503);
INSERT INTO `role_menu` VALUES (52, 703);
INSERT INTO `role_menu` VALUES (52, 704);
INSERT INTO `role_menu` VALUES (52, 752);
INSERT INTO `role_menu` VALUES (52, 802);
INSERT INTO `role_menu` VALUES (52, 803);
INSERT INTO `role_menu` VALUES (52, 804);
INSERT INTO `role_menu` VALUES (52, 805);
INSERT INTO `role_menu` VALUES (52, 809);
INSERT INTO `role_menu` VALUES (202, 809);
INSERT INTO `role_menu` VALUES (52, 810);
INSERT INTO `role_menu` VALUES (52, 811);
INSERT INTO `role_menu` VALUES (52, 1502);
INSERT INTO `role_menu` VALUES (52, 1503);
INSERT INTO `role_menu` VALUES (52, 1505);
INSERT INTO `role_menu` VALUES (52, 2252);
INSERT INTO `role_menu` VALUES (52, 2253);
INSERT INTO `role_menu` VALUES (52, 5952);
INSERT INTO `role_menu` VALUES (52, 5953);
INSERT INTO `role_menu` VALUES (52, 6102);
INSERT INTO `role_menu` VALUES (52, 6752);
INSERT INTO `role_menu` VALUES (52, 9452);
INSERT INTO `role_menu` VALUES (52, 9502);
COMMIT;

-- ----------------------------
-- Table structure for seq
-- ----------------------------
DROP TABLE IF EXISTS `seq`;
CREATE TABLE `seq` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of seq
-- ----------------------------
BEGIN;
INSERT INTO `seq` VALUES (12651);
COMMIT;

-- ----------------------------
-- Table structure for sms_account
-- ----------------------------
DROP TABLE IF EXISTS `sms_account`;
CREATE TABLE `sms_account` (
  `id` int(11) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `sprdid` varchar(255) DEFAULT NULL,
  `scorpid` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `is_default` bit(1) DEFAULT NULL,
  `notify_account_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sms_account
-- ----------------------------
BEGIN;
INSERT INTO `sms_account` VALUES (6002, '2021-06-23 14:27:38.409105', b'0', '2021-06-23 14:27:38.409132', 'azy2018Iquizoo', 'dlazykj0', '1012818', '', 'http://cf.51welink.com/submitdata/service.asmx/g_Submit', b'1', 'welinkSMS');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `is_delete` bit(1) DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `avatar_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` int(11) NOT NULL,
  `nickname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salt` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_enabled` bit(1) DEFAULT NULL,
  `is_locked` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UK_sb8bbouer5wak8vyiiy4pf2bx` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (102, '2021-05-11 15:20:05.995018', b'0', '2021-07-14 11:14:19.658896', '/imgs/avatar/default.png', '', 1, '管理员', '5b9a079ebe999bf0edbe2f665e6fc9f2', '13012345678', 'AeC0rlakx6nkIs6xJYqQYQTlvNRISLbdz7K4aKa04T39wxRTL1oOZs5rlTDos9ryXoZCniedn5a4eSZJNxk2mw==', 'admin', b'1', b'0');
INSERT INTO `user` VALUES (402, '2021-05-13 13:56:39.105994', b'0', '2021-07-14 17:06:55.598989', '/imgs/avatar/default.png', '', 1, '黄虹钦', '61d79d1565c6f468fc9942f8adfa9a08', '', 'A9z3nYQsYtyicjqaERD0LRfKEXlcjxIFWQXXT3RZeIbsaGi9lkDEv0nm2hHFpRQV53rXRjnpLX9tX9L9iCL5Qw==', 'hhq', b'1', b'0');
INSERT INTO `user` VALUES (403, '2021-05-13 13:57:13.312625', b'0', '2021-05-13 13:57:13.312657', '/imgs/avatar/default.png', '', 1, '杨耿', 'c25b13b638fc66f2c348d9aff62ea0db', '', 'XWfTtUMO6HXktQbavlg9Lf9Hkirbf2VdYOzzfFurFKZpdOZDGkBaPnuWHKcl3gInAR1qRgrG3BII+zPSx2Mmng==', 'yg', b'1', b'0');
INSERT INTO `user` VALUES (404, '2021-05-13 13:57:59.326378', b'0', '2021-05-13 13:57:59.326398', '/imgs/avatar/default.png', '', 1, ' 吴敏 ', '6871c02cbea20be164ebb38586179ddb', '', 'tlqRs6HekLU2ceuEKYctyBj46AKwqnb0QPbfnflb9ZWnW7upx1VE2spNbXStenvk7nQ1QaGism8al9oIM/UBSg==', 'wm', b'1', b'0');
INSERT INTO `user` VALUES (405, '2021-05-13 13:58:26.108142', b'0', '2021-05-13 13:58:26.108162', '/imgs/avatar/default.png', '', 1, '詹先平', '5f3f027740273c53a7eb7af1416d0701', '', 'HeIAuJbkQxpnw1E0lTrPW4QoL5NkhvwsvKN2j9D//tlnws+2t61ujLFY5796m8Wp7NV+f7dxO86w+yaAUd5WkQ==', 'zxp', b'1', b'0');
INSERT INTO `user` VALUES (406, '2021-05-13 13:58:58.735900', b'0', '2021-07-14 11:13:42.725731', '/imgs/avatar/default.png', '', 0, '刘宏', 'd895fd40c14a098354a0248fe68f8aa5', '', 'HerF7LEu5TSJCM3mKCZdMILdJ12EgBDA89ddutrQfNtYmFP9Fx9fv4Mw67VCc2iDs5updWQzufK8RdYMSSF/fQ==', 'lh', b'1', b'0');
INSERT INTO `user` VALUES (407, '2021-05-13 13:59:36.762631', b'0', '2021-07-14 11:13:42.746650', '/imgs/avatar/default.png', 'haohao@hao.com', 1, '官劲松', '7ce8e5cfcde85dfaedf0f4fce2dcc1e5', '13109876543', 'jHU1qLuP/6hS7XB1f6FZ/ZrM67C5/YNQT9pBss7E1Ftm9cZchqGhZrsGK2onQuJ3Qed/Pbj+c2FyXmCaUlWk6A==', 'gjs', b'1', b'0');
COMMIT;

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `user_id` int(11) NOT NULL,
  `role` varchar(255) DEFAULT NULL,
  KEY `FK55itppkw3i07do3h7qoclqd4k` (`user_id`),
  CONSTRAINT `FK55itppkw3i07do3h7qoclqd4k` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of user_role
-- ----------------------------
BEGIN;
INSERT INTO `user_role` VALUES (102, 'ROLE_ADMIN');
INSERT INTO `user_role` VALUES (406, 'ROLE_TEST');
INSERT INTO `user_role` VALUES (405, 'ROLE_FRONTEND');
INSERT INTO `user_role` VALUES (403, 'ROLE_FRONTEND');
INSERT INTO `user_role` VALUES (404, 'ROLE_BACKEND');
INSERT INTO `user_role` VALUES (407, 'ROLE_BACKEND');
INSERT INTO `user_role` VALUES (402, 'ROLE_BACKEND');
INSERT INTO `user_role` VALUES (402, 'ROLE_ADMIN');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;