/* 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: 22/09/2021 17:33:10 */ 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, `branch` 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-09-22 16:24:38.380583', 'content', 'develop', '管理员', '成功', '2021-09-22 16:24:38.350127', 'e366b6f1', '2021-09-22 16:20:40.000000', 'test', 'dotnetCore', '614ae846c2ba1453fd6ce252', '内容服务', 8002, 'docker.alpha.iquizoo.com/iq3x/content:e366b6f1', NULL); 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', NULL); 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, NULL); INSERT INTO `app_building` VALUES (7905, '2021-06-28 16:12:02.075125', b'0', '2021-09-19 20:26:33.698663', 'user', 'develop', '管理员', '失败', '2021-09-19 20:26:33.689619', '7f7bb7ef', '2021-09-18 16:02:17.000000', 'test', 'dotnetCore', '61472c79377f6f6f3e2e7509', '用户服务', 8001, NULL, NULL); INSERT INTO `app_building` VALUES (7906, '2021-06-28 16:12:02.088139', b'0', '2021-09-22 10:59:19.318465', 'data', 'develop', '管理员', '成功', '2021-09-22 10:59:19.254793', '4e08552b', '2021-09-22 10:53:46.000000', 'test', 'dotnetCore', '614a9c073858586ba1d41615', '数据服务', 8006, 'docker.alpha.iquizoo.com/iq3x/data:4e08552b', NULL); INSERT INTO `app_building` VALUES (7907, '2021-06-28 16:12:02.101431', b'0', '2021-07-28 17:44:22.248331', 'dnkt-mgr', 'develop', '管理员', '成功', '2021-07-28 17:44:22.240183', '72e2406f', '2021-07-28 15:16:32.000000', 'test', 'npm', '610126f6f43236069220e3b0', '大脑课堂后台', 8083, 'docker.alpha.iquizoo.com/iq3x/dnkt-mgr:72e2406f', NULL); INSERT INTO `app_building` VALUES (7908, '2021-06-28 16:12:02.114041', b'0', '2021-06-28 16:12:02.114088', 'admin-sys', 'develop', NULL, NULL, NULL, NULL, NULL, 'test', 'npm', NULL, '智慧云', 8086, NULL, NULL); INSERT INTO `app_building` VALUES (7909, '2021-06-28 16:12:02.127808', b'0', '2021-06-28 16:12:02.127854', 'dagent', 'master', NULL, NULL, NULL, NULL, NULL, 'dev', 'maven', NULL, '机器节点', 0, NULL, NULL); INSERT INTO `app_building` VALUES (7910, '2021-06-28 16:12:02.139767', b'0', '2021-06-28 16:12:02.139812', 'cterminal', 'develop', NULL, NULL, NULL, NULL, NULL, 'test', 'npm', NULL, '脑智未来', 8088, NULL, 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, NULL); INSERT INTO `app_building` VALUES (7912, '2021-06-28 16:12:02.165815', b'0', '2021-09-19 20:25:20.438128', 'dnkt-jigou', 'develop', '管理员', '失败', '2021-09-19 20:25:20.387247', '736ace93', '2020-09-02 11:34:13.000000', 'test', 'npm', '61472c30377f6f6f3e2e7504', '大脑课堂机构版', 8082, NULL, NULL); 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, NULL); INSERT INTO `app_building` VALUES (7914, '2021-06-28 16:12:02.189282', b'0', '2021-09-17 15:34:11.730054', 'auth', 'develop', '管理员', '成功', '2021-09-17 15:34:11.725668', 'f755915c', '2021-09-17 15:33:13.000000', 'test', 'dotnetCore', '614444f3457fe962fb35f1a1', '认证服务', 5000, 'docker.alpha.iquizoo.com/iq3x/auth:f755915c', NULL); 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, 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, NULL); INSERT INTO `app_building` VALUES (7917, '2021-06-28 16:12:02.228742', b'0', '2021-06-28 16:12:02.228794', 'external', 'develop', NULL, NULL, NULL, NULL, NULL, 'test', 'dotnetCore', NULL, '外部内容服务', 8008, NULL, NULL); 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, NULL); INSERT INTO `app_building` VALUES (7919, '2021-06-28 16:12:02.253646', b'0', '2021-08-11 15:55:19.017092', 'calculate-score', 'develop', '管理员', '成功', '2021-08-11 15:55:19.008385', '02a0c474', '2021-08-11 15:54:27.000000', 'test', 'dotnetCore', '61138267c2fc852cd7a58e15', '算分服务', 8003, 'docker.alpha.iquizoo.com/iq3x/calculate-score:02a0c474', NULL); INSERT INTO `app_building` VALUES (7920, '2021-06-28 16:12:02.265516', b'0', '2021-09-22 16:39:58.477340', 'calculate-score-prod', 'master', '管理员', '成功', '2021-09-22 16:39:58.471475', '2aa38f5d', '2021-09-22 16:01:40.000000', 'prod', 'dotnetCore', '614aebdec2ba1453fd6ce25d', '算分服务', 8003, 'docker.iquizoo.com/iq3x/calculate-score-prod:2aa38f5d', NULL); 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', NULL); 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', NULL); 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, 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', NULL); 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', NULL); 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, 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, 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, NULL); INSERT INTO `app_building` VALUES (7929, '2021-06-28 16:12:02.375625', b'0', '2021-09-18 14:21:33.281641', 'content-prod', 'master', '管理员', '成功', '2021-09-18 14:21:33.245813', '5f1c1250', '2021-09-18 13:51:40.000000', 'prod', 'dotnetCore', '6145856deec23b320d011ec3', '内容服务', 8002, 'docker.iquizoo.com/iq3x/content-prod:5f1c1250', NULL); INSERT INTO `app_building` VALUES (7930, '2021-06-28 16:12:02.387972', b'0', '2021-09-22 16:53:49.018934', 'dnkt-prod', 'master', '管理员', '成功', '2021-09-22 16:53:49.013905', 'f5405a11', '2021-09-22 16:53:02.000000', 'prod', 'npm', '614aef1dc2ba1453fd6ce26a', '大脑课堂', 8081, 'docker.iquizoo.com/iq3x/dnkt-prod:f5405a11', NULL); 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, NULL); INSERT INTO `app_building` VALUES (7932, '2021-06-28 16:12:02.414038', b'0', '2021-09-18 09:31:58.279496', 'user-prod', 'master', '管理员', '成功', '2021-09-18 09:31:58.217633', '6d130342', '2021-09-18 09:08:11.000000', 'prod', 'dotnetCore', '6145418ee7404c18a283bae8', '用户服务', 8001, 'docker.iquizoo.com/iq3x/user-prod:6d130342', NULL); INSERT INTO `app_building` VALUES (7933, '2021-06-28 16:12:02.425406', b'0', '2021-09-22 16:40:04.361394', 'data-prod', 'master', '管理员', '成功', '2021-09-22 16:40:04.357408', '4732dd5a', '2021-09-22 16:01:59.000000', 'prod', 'dotnetCore', '614aebe4c2ba1453fd6ce260', '数据服务', 8006, 'docker.iquizoo.com/iq3x/data-prod:4732dd5a', NULL); INSERT INTO `app_building` VALUES (7934, '2021-06-28 16:12:02.437285', b'0', '2021-08-03 13:32:40.798141', 'dnkt-mgr-prod', 'master', '管理员', '成功', '2021-08-03 13:32:40.789018', '40613e25', '2021-08-02 17:42:12.000000', 'prod', 'npm', '6108d4f8b24fbd456733394a', '大脑课堂后台', 8083, 'docker.iquizoo.com/iq3x/dnkt-mgr-prod:40613e25', NULL); INSERT INTO `app_building` VALUES (7935, '2021-06-28 16:12:02.449213', b'0', '2021-09-18 15:26:19.601858', 'cterminal-prod', 'master', '管理员', '成功', '2021-09-18 15:26:19.567191', '1550636e', '2021-09-18 15:25:11.000000', 'prod', 'npm', '6145949b23bb9c0675e661c3', '脑智未来', 8088, 'docker.iquizoo.com/iq3x/cterminal-prod:1550636e', NULL); INSERT INTO `app_building` VALUES (7936, '2021-06-28 16:12:02.461558', b'0', '2021-08-03 20:25:40.176897', 'admin-sys-prod', 'master', '管理员', '成功', '2021-08-03 20:25:40.141531', 'b6a2a15d', '2021-08-03 20:25:06.000000', 'prod', 'npm', '610935c4ed04896d980c536e', '智慧云', 8086, 'docker.iquizoo.com/iq3x/admin-sys-prod:b6a2a15d', NULL); 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, 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', NULL); INSERT INTO `app_building` VALUES (7939, '2021-06-28 16:12:02.497838', b'0', '2021-09-22 16:03:17.424216', 'data-uat', 'master', '管理员', '成功', '2021-09-22 16:03:17.417380', '4732dd5a', '2021-09-22 16:01:59.000000', 'uat', 'dotnetCore', '614ae345c2ba1453fd6ce247', '数据服务', 8006, 'docker.alpha.iquizoo.com/iq3x/data-uat:4732dd5a', NULL); INSERT INTO `app_building` VALUES (7940, '2021-06-28 16:12:02.509389', b'0', '2021-08-11 17:49:03.733514', 'base', 'develop', '管理员', '成功', '2021-08-11 17:49:03.722003', '9c742d0c', '2021-08-11 17:47:59.000000', 'test', 'dotnetCore', '61139d0fc2fc852cd7a58e23', '基础服务', 8009, 'docker.alpha.iquizoo.com/iq3x/base:9c742d0c', NULL); 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', NULL); 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', NULL); INSERT INTO `app_building` VALUES (7943, '2021-06-28 16:12:02.544213', b'0', '2021-09-22 15:25:42.601032', 'user-uat', 'master', '管理员', '成功', '2021-09-22 15:25:42.491261', '6f7a0239', '2021-09-22 15:24:26.000000', 'uat', 'dotnetCore', '614ada76c2ba1453fd6ce233', '用户服务', 8001, 'docker.alpha.iquizoo.com/iq3x/user-uat:6f7a0239', NULL); 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', NULL); 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, NULL); INSERT INTO `app_building` VALUES (7946, '2021-06-28 16:12:02.580255', b'0', '2021-09-22 16:03:16.354060', 'calscore-uat', 'master', '管理员', '成功', '2021-09-22 16:03:16.348448', '2aa38f5d', '2021-09-22 16:01:40.000000', 'uat', 'dotnetCore', '614ae344c2ba1453fd6ce244', '算分服务', 8003, 'docker.alpha.iquizoo.com/iq3x/calscore-uat:2aa38f5d', NULL); 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, 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', NULL); INSERT INTO `app_building` VALUES (7949, '2021-06-28 16:12:02.611337', b'0', '2021-09-18 13:55:53.847379', 'content-uat', 'master', '管理员', '成功', '2021-09-18 13:55:53.788443', '5f1c1250', '2021-09-18 13:51:40.000000', 'uat', 'dotnetCore', '61457f690f476814168d98bb', '内容服务', 8002, 'docker.alpha.iquizoo.com/iq3x/content-uat:5f1c1250', NULL); 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', NULL); INSERT INTO `app_building` VALUES (7951, '2021-06-28 16:12:02.633269', b'0', '2021-06-28 16:12:02.633290', 'dmaster', 'master', NULL, NULL, NULL, NULL, NULL, 'dev', 'maven', NULL, '机器节点', 0, NULL, NULL); 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', NULL); INSERT INTO `app_building` VALUES (10752, '2021-09-17 11:01:28.054453', b'0', '2021-09-22 16:25:14.436281', 'dnkt-uat', 'master', '管理员', '成功', '2021-09-22 16:25:14.428117', 'd5e2d805', '2021-09-22 16:24:25.000000', 'uat', 'npm', '614ae86ac2ba1453fd6ce256', '大脑课堂', 8081, 'docker.alpha.iquizoo.com/iq3x/dnkt-uat:d5e2d805', NULL); INSERT INTO `app_building` VALUES (10753, '2021-09-17 11:02:04.444076', b'0', '2021-09-17 11:03:56.291747', 'dnkt-mgr-uat', 'master', '管理员', '成功', '2021-09-17 11:03:56.286556', '40613e25', '2021-08-02 17:42:12.000000', 'uat', 'npm', '6144059c76b4bb2c31f828c0', '大脑课堂后台', 8083, 'docker.alpha.iquizoo.com/iq3x/dnkt-mgr-uat:40613e25', NULL); INSERT INTO `app_building` VALUES (10852, '2021-09-18 09:40:03.040071', b'0', '2021-09-20 14:59:57.041757', 'content-dev', 'develop', '管理员', '失败', '2021-09-20 14:59:57.028504', '66982cab', '2021-09-17 17:42:40.000000', 'dev', 'dotnetCore', '6148316dca178d15d2ed1e4b', '内容服务', 8002, NULL, NULL); INSERT INTO `app_building` VALUES (10853, '2021-09-18 09:40:26.395809', b'0', '2021-09-20 14:59:40.879151', 'dnkt-dev', 'develop', '管理员', '失败', '2021-09-20 14:59:40.642393', '14a2b5b7', '2021-08-19 14:48:44.000000', 'dev', 'npm', '6148315cca178d15d2ed1e48', '大脑课堂', 8081, NULL, NULL); INSERT INTO `app_building` VALUES (10952, '2021-09-18 10:47:14.798128', b'0', '2021-09-18 11:31:09.191381', 'cterminal-uat', 'master', '管理员', '成功', '2021-09-18 11:31:09.155130', 'e01066e2', '2021-09-18 11:24:07.000000', 'uat', 'npm', '61455d7dc08cb453ce14b1f2', '脑智未来', 8088, 'docker.alpha.iquizoo.com/iq3x/cterminal-uat:e01066e2', NULL); 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, `proj_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, 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, 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, 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, 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, NULL); INSERT INTO `app_config` VALUES (58, '2021-02-20 09:37:42.000000', b'0', '2021-06-28 13:33:38.642948', '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, NULL); INSERT INTO `app_config` VALUES (60, '2021-02-20 09:37:47.000000', b'0', '2021-06-28 11:42:41.871006', 'admin-sys', 'git@codeup.aliyun.com:5f1f8daf6207a1a8b17f6742/FrontEnd/IQuizoo.AdminSys.git', 'npm', 'develop', 'FROM debian10/nginx\n\nRUN sed -i \'s/8080/8086/\' /etc/nginx/conf.d/http.conf\nCOPY ./dist /opt/webroot/\n', '/', 'IQuizoo.AdminSys', 'test', '/', 8086, 40, 117, 4, NULL, NULL, '智慧云', NULL, NULL, NULL); INSERT INTO `app_config` VALUES (106, '2021-02-23 13:05:32.000000', b'0', '2021-02-23 13:05:32.000000', 'dagent', 'http://git.reghao.cn/reghao/autodop.git', 'maven', 'master', NULL, '/', 'dagent', 'dev', NULL, NULL, NULL, NULL, NULL, 108, 'autodop-dagent.jar', '机器节点', NULL, NULL, NULL); INSERT INTO `app_config` VALUES (152, '2021-05-08 14:50:19.715000', b'0', '2021-06-28 11:43:23.386996', 'cterminal', '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, 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, 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, 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, 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, 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, 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, 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, NULL); INSERT INTO `app_config` VALUES (167, '2021-02-27 01:08:39.000000', b'0', '2021-06-28 11:43:30.801420', 'system-config', '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, NULL); INSERT INTO `app_config` VALUES (169, '2021-02-27 01:09:10.000000', b'0', '2021-06-28 11:43:20.238807', 'calculate-score', '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, NULL); INSERT INTO `app_config` VALUES (171, '2021-02-27 03:51:17.000000', b'0', '2021-02-27 03:51:17.000000', 'calculate-score-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, NULL); INSERT INTO `app_config` VALUES (176, '2021-02-27 04:04:20.000000', b'0', '2021-02-27 04:04:20.000000', 'system-config-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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, NULL); INSERT INTO `app_config` VALUES (202, '2021-05-12 13:42:50.673000', b'0', '2021-05-12 13:42:50.673000', 'cterminal-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, NULL); INSERT INTO `app_config` VALUES (203, '2021-02-27 04:06:58.000000', b'0', '2021-08-03 17:58:46.505677', 'admin-sys-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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, 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, NULL); INSERT INTO `app_config` VALUES (7552, '2021-06-28 10:18:57.960884', b'0', '2021-06-28 10:18:57.960923', 'dmaster', 'http://git.reghao.cn/reghao/autodop.git', 'maven', 'master', NULL, '/', 'dagent', 'dev', NULL, NULL, NULL, NULL, NULL, 108, 'autodop-dagent.jar', '机器节点', 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, 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, 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, NULL); INSERT INTO `app_config` VALUES (10802, '2021-09-18 09:40:03.007481', b'0', '2021-09-18 09:47:40.948843', '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, 117, 36, NULL, '', '内容服务', NULL, NULL, NULL); INSERT INTO `app_config` VALUES (10803, '2021-09-18 09:40:26.382859', b'0', '2021-09-18 09:48:47.411898', 'dnkt-dev', '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', 'dev', '/', 8081, 40, 117, 4, NULL, NULL, '大脑课堂', NULL, NULL, NULL); INSERT INTO `app_config` VALUES (10902, '2021-09-18 10:47:14.765393', b'0', '2021-09-18 10:47:14.765430', 'cterminal-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, 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 (10802, '5d1a727991f34d3a9c1220a1899e6ebd', 'docker', '', '{\r\n \"Env\":[\r\n \"ASPNETCORE_ENVIRONMENT=Staging\",\r\n \"ASPNETCORE_URLS=http://192.168.0.172:8002;https://192.168.0.172: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.197', NULL); INSERT INTO `app_config_deploy_configs` VALUES (10803, '5d1a727991f34d3a9c1220a1899e6ebd', 'docker', '', '{\r\n \"Env\":[\r\n \"ASPNETCORE_ENVIRONMENT=Staging\",\r\n \"ASPNETCORE_URLS=http://192.168.0.172:8002;https://192.168.0.172: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.197', 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 (60, 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); 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-07-28 17:44:22.275368', 'dnkt-mgr', '610126f6f43236069220e3b0', 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-09-22 16:03:17.447242', 'data-uat', '614ae345c2ba1453fd6ce247', 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; INSERT INTO `app_running` VALUES (8002, '2021-06-28 16:12:02.694708', b'0', '2021-06-28 16:12:02.694724', 'dnkt-mgr', '大脑课堂后台', 'npm', 'test', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111', NULL, NULL, NULL, NULL, NULL, NULL, '/', 8083); INSERT INTO `app_running` VALUES (8003, '2021-06-28 16:12:02.701999', b'0', '2021-06-28 16:12:02.702017', 'cterminal', '脑智未来', 'npm', 'test', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111', NULL, NULL, NULL, NULL, NULL, NULL, 'http://cterminal.alpha.iquizoo.com', 8088); INSERT INTO `app_running` VALUES (8004, '2021-06-28 16:12:02.718746', b'0', '2021-06-28 16:12:02.718766', 'data-uat', '数据服务', 'dotnetCore', 'uat', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.111', NULL, NULL, NULL, NULL, NULL, NULL, '/health', 8006); 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` varchar(255) DEFAULT NULL, `env` varchar(255) DEFAULT NULL, `last_check` datetime(6) DEFAULT 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 (10602, '2021-09-16 11:19:57.522309', b'0', '2021-09-18 10:25:17.919964', '2021-09-13 09:16:25', 'test', '2021-09-18 10:25:17.906369', '5d1a727991f34d3a9c1220a1899e6ebd', '192.168.0.197', 'amd64', 'Linux', '5.4.143-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 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-05-13 10:34:32.400507', 'layui-icon layui-icon-face-smile', 302, 3, '构建部署', 'page', '/app/build', b'1'); INSERT INTO `menu` VALUES (304, '2021-05-13 10:36:35.162567', b'0', '2021-05-13 10:36:35.162602', 'layui-icon layui-icon-set', 302, 2, '应用配置', 'dir', '#', b'1'); INSERT INTO `menu` VALUES (305, '2021-05-13 10:38:19.945521', b'0', '2021-05-13 10:38:19.945556', 'layui-icon layui-icon-set', 304, 2, '应用编排', 'page', 'app/config/app', b'1'); INSERT INTO `menu` VALUES (306, '2021-05-13 10:38:46.911342', b'0', '2021-05-13 10:38:46.911361', 'layui-icon layui-icon-set', 304, 3, '项目编排', 'page', 'app/config/proj', 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-05-20 13:48:04.812641', 'layui-icon layui-icon-face-smile', 302, 5, '构建历史', 'page', '/app/log/build', b'1'); INSERT INTO `menu` VALUES (809, '2021-05-20 13:53:46.834540', b'0', '2021-05-20 13:53:46.834575', 'layui-icon layui-icon-face-smile', 302, 4, '应用状态', '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 monitor_job -- ---------------------------- DROP TABLE IF EXISTS `monitor_job`; CREATE TABLE `monitor_job` ( `id` int(11) NOT NULL, `create_time` datetime(6) DEFAULT NULL, `is_delete` bit(1) DEFAULT NULL, `update_time` datetime(6) DEFAULT NULL, `cron_exp` varchar(255) DEFAULT NULL, `enable` bit(1) DEFAULT NULL, `job_class_name` varchar(255) DEFAULT NULL, `job_id` varchar(255) NOT NULL, `job_type` varchar(255) DEFAULT NULL, `max_notify_count` int(11) DEFAULT NULL, `notify_count` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UK_iwipkv5n37xlb37c1e8e9ag1b` (`job_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- ---------------------------- -- Records of monitor_job -- ---------------------------- BEGIN; INSERT INTO `monitor_job` VALUES (9252, '2021-07-06 16:57:09.542178', b'0', '2021-07-09 10:49:36.461571', '0/10 * * * * ?', b'0', 'MachineStatCheckJob', '5d1a727991f34d3a9c1220a1899e6ebd-MachineStatCheckJob', 'machine', 3, 3); 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', '192.168.0.111: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 proj_config -- ---------------------------- DROP TABLE IF EXISTS `proj_config`; CREATE TABLE `proj_config` ( `id` bigint(20) NOT NULL, `create_time` datetime(6) DEFAULT NULL, `is_delete` bit(1) DEFAULT NULL, `update_time` datetime(6) DEFAULT NULL, `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code_dirname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `proj_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `proj_repo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `compiler_config_id` bigint(20) DEFAULT NULL, `packer_config_id` bigint(20) DEFAULT NULL, `repo_auth_config_id` int(11) DEFAULT NULL, `proj_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, `repo_branch` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dirname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UK_pnprxmjagrsvqhjh990n7knxo` (`proj_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- ---------------------------- -- Records of proj_config -- ---------------------------- BEGIN; INSERT INTO `proj_config` VALUES (108, '2021-02-23 13:14:17.000000', b'0', '2021-02-23 13:14:17.000000', '运维自动化系统', 'autodop', 'autodop', 'http://git.reghao.cn/reghao/autodop.git', 100, 102, 99, '运维自动化系统', 'maven', 'test', 'develop', NULL); 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', 'xjV^Ilw2', NULL, 'git', 'azyadmin'); 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, 304); INSERT INTO `role_menu` VALUES (202, 304); INSERT INTO `role_menu` VALUES (52, 305); INSERT INTO `role_menu` VALUES (202, 305); INSERT INTO `role_menu` VALUES (52, 306); INSERT INTO `role_menu` VALUES (202, 306); 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 (11101); 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;