V1015_3_v32资源视图树结构表结构.sql
12.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
/*
Navicat Premium Data Transfer
Source Server : hg-69-zj
Source Server Type : MySQL
Source Server Version : 80022
Source Host : 192.168.0.69:3306
Source Schema : cloud_backend_monitor
Target Server Type : MySQL
Target Server Version : 80022
File Encoding : 65001
Date: 15/10/2021 02:07:06
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for b_res_list_tree_v32
-- ----------------------------
DROP TABLE IF EXISTS `b_res_list_tree_v32`;
CREATE TABLE `b_res_list_tree_v32` (
`id` int(0) NOT NULL AUTO_INCREMENT COMMENT '资源类型id',
`parentId` int(0) NULL DEFAULT NULL COMMENT '父资源类型',
`resType` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源类型CODE',
`nodeName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点名称',
`nodeDesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点描述',
`nodeType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点分类',
`sort` int(0) NULL DEFAULT NULL COMMENT '排序',
`options` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置信息',
`detailProps` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '详情页属性、参数( JSON)',
`detailPage` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '详情页 对应字典：DETAIL_PAGE',
`ext1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段',
`ext2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段',
`ext3` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段',
`ext4` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段',
`ext5` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '扩展字段',
`querySub` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否查询子节点 0是1否，默认0，相同的资源类型值相同，否则按照否处理',
`excludeResType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '查询排除类型(TODO) ',
`veiwName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '查询视图名称，默认值：v_resource',
`createTime` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `resType`(`id`, `resType`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 50023 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '资源类型信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of b_res_list_tree_v32
-- ----------------------------
INSERT INTO `b_res_list_tree_v32` VALUES (11100, 0, 'HOST_MINICOMPUTER', '整机', '计算存储', '', 11100, '', '', '', '', '', '', '', '', '', '', 'v_resource_minipc', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (11102, 0, 'HOST_MINICOMPUTER_PARTITION', '分区', '计算存储', '', 11102, '', '', '', '', '', '', '', '', '', '', 'v_resource_minipc_part', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (11200, 0, 'HOST_X86SERVER', 'PC服务器', '计算存储', '', 11200, '', '', '', '', '', '', '', '', '', '', 'v_resource_pc', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (11300, 0, 'HOST_ONECOMPUTER', '一体机', '计算存储', '', 11300, '', '', '', '', '', '', '', '', '', '', 'v_resource_pc', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (12100, 0, 'VIRTUALIZATION_VMWARE', 'VMWARE', '计算存储', '', 12100, '', NULL, '', '', '', '', '', '', '', '', 'v_resource_vmware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (12110, 12100, 'VIRTUALIZATION_VMWARE_CLUSTER', 'vm资源池', '计算存储', '', 12110, '', '', '', '', '', '', '', '', '', '', 'v_resource_vmware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (12120, 12100, 'VIRTUALIZATION_VMWARE_PHYSICSHOST', 'vm宿主机', '计算存储', '', 12120, '', '', '', '', '', '', '', '', '', '', 'v_resource_vmware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (12130, 12100, 'VIRTUALIZATION_VMWARE_VHOST', 'vm虚拟机', '计算存储', '', 12130, '', '', '', '', '', '', '', '', '', '', 'v_resource_vmware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (12900, 12100, 'VIRTUALIZATION_VHOST', '虚拟机', '计算存储', '', 12900, '', '', '', '', '', '', '', '', '', '', 'v_resource_vmware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (13000, 0, 'HUAWEI_CLOUD_PLAT', '华为云', '计算存储', '', 13000, '', '', '', '', '', '', '', '', '', '', 'v_resource_cloud_hw', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (13100, 13000, 'HUAWEI_CLOUD_COLONY', '资源池', '计算存储', '', 13100, '', '', '', '', '', '', '', '', '', '', 'v_resource_cloud_hw', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (13101, 13000, 'HUAWEI_CLOUD_STORAGE', '存储', '计算存储', '', 13101, '', '', '', '', '', '', '', '', '', '', 'v_resource_cloud_hw', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (13102, 13000, 'HUAWEI_CLOUD_SWITCHBOARD', '交换机', '计算存储', '', 13102, '', '', '', '', '', '', '', '', '', '', 'v_resource_cloud_hw', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (13103, 13000, 'HUAWEI_CLOUD_FIREWALL', '防火墙', '计算存储', '', 13103, '', '', '', '', '', '', '', '', '', '', 'v_resource_cloud_hw', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (13110, 13000, 'HUAWEI_CLOUD_CLUSTER', '集群', '计算存储', '', 13110, '', '', '', '', '', '', '', '', '', '', 'v_resource_cloud_hw', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (13111, 13000, 'HUAWEI_CLOUD_CLUSTER_OST', '物理机', '计算存储', '', 13111, '', '', '', '', '', '', '', '', '', '', 'v_resource_cloud_hw', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (13112, 13000, 'HUAWEI_CLOUD_VIRTUALHOST', '虚拟机', '计算存储', '', 13112, '', '', '', '', '', '', '', '', '', '', 'v_resource_cloud_hw', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (14000, 0, 'ALI_CLOUD_PLAT', '阿里云', '计算存储', '', 14000, '', '', '', '', '', '', '', '', '', '', 'v_resource_cloud_ali', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (14100, 14000, 'ALI_CLOUD_ECS', 'ECS-云服务器', '计算存储', '', 14100, '', '', '', '', '', '', '', '', '', '', 'v_resource_cloud_ali', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (14200, 14000, 'ALI_CLOUD_RDS', 'RDS-云数据库', '计算存储', '', 14200, '', '', '', '', '', '', '', '', '', '', 'v_resource_cloud_ali', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (14300, 14000, 'ALI_CLOUD_SLB', 'SLB-负载均衡', '计算存储', '', 14300, '', '', '', '', '', '', '', '', '', '', 'v_resource_cloud_ali', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (14400, 14000, 'ALI_CLOUD_OSS', 'OSS-对象存储', '计算存储', '', 14400, '', '', '', '', '', '', '', '', '', '', 'v_resource_cloud_ali', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (15000, 0, 'STORAGE', '存储设备', '计算存储', '', 15000, '', '', '', '', '', '', '', '', '', '', 'v_resource_storage', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (15100, 15000, 'STORAGE_SHARE', '共享存储', '计算存储', '', 15100, '', '', '', '', '', '', '', '', '', '', 'v_resource_storage', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (15101, 15100, 'STORAGE_SHARE_LUN', 'LUN', '计算存储', '', 15100, '', '', '', '', '', '', '', '', '', '', 'v_resource_storage_lun', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (15300, 15000, 'STORAGE_TAPELIBRARY', '物理带库', '计算存储', '', 15300, '', '', '', '', '', '', '', '', '', '', 'v_resource_storage', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (15400, 15000, 'STORAGE_VTAPELIBRARY', '虚拟带库', '计算存储', '', 15400, '', '', '', '', '', '', '', '', '', '', 'v_resource_storage', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (16000, 0, 'DATABASE', '数据库', '系统软件', '', 20001, '', '', '', '', '', '', '', '', '', '', 'v_resource_database', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (16100, 16000, 'DATABASE_ORACLE', 'oracle', '系统软件', '', 16100, '', '', '', '', '', '', '', '', '', '', 'v_resource_database', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (16101, 16000, 'DATABASE_RAC', 'oracle集群', '系统软件', '', 16101, '', '', '', '', '', '', '', '', '', '', 'v_resource_database', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (16200, 16000, 'DATABASE_OGG', 'ogg', '系统软件', '', 16200, '', '', '', '', '', '', '', '', '', '', 'v_resource_database', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (16300, 16000, 'DATABASE_MYSQL', 'mysql', '系统软件', '', 16300, '', '', '', '', '', '', '', '', '', '', 'v_resource_database', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (16400, 16000, 'DATABASE_REDIS', 'redis', '系统软件', '', 16400, '', '', '', '', '', '', '', '', '', '', 'v_resource_database', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (16500, 16000, 'DATABASE_ELASTICSEARCH', 'elasticsearch', '系统软件', '', 16500, '', '', '', '', '', '', '', '', '', '', 'v_resource_database', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (16600, 16000, 'DATABASE_MONGODB', 'mongodb', '系统软件', '', 16600, '', '', '', '', '', '', '', '', '', '', 'v_resource_database', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (17000, 0, 'MIDDLEWARE', '中间件', '系统软件', '', 20002, '', '', '', '', '', '', '', '', '', '', 'v_resource_middleware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (17100, 17000, 'MIDDLEWARE_WEBLOGIC', 'weblogic', '系统软件', '', 17100, '', '', '', '', '', '', '', '', '', '', 'v_resource_middleware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (17200, 17000, 'MIDDLEWARE_KAFKA', 'kafka', '系统软件', '', 17200, '', '', '', '', '', '', '', '', '', '', 'v_resource_middleware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (17300, 17000, 'MIDDLEWARE_NGINX', 'nginx', '系统软件', '', 17300, '', '', '', '', '', '', '', '', '', '', 'v_resource_middleware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (17400, 17000, 'MIDDLEWARE_ZOOKEEPER', 'zookeeper', '系统软件', '', 17400, '', '', '', '', '', '', '', '', '', '', 'v_resource_middleware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (17500, 17000, 'MIDDLEWARE_TOMCAT', 'tomcat', '系统软件', '', 17500, '', '', '', '', '', '', '', '', '', '', 'v_resource_middleware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (17600, 17000, 'MIDDLEWARE_MQ', 'MQ', '系统软件', '', 17600, '', '', '', '', '', '', '', '', '', '', 'v_resource_middleware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (18000, 0, 'NETHARDWARE', '计算机网络设备', '网络系统', '', 18000, '', '', '', '', '', '', '', '', '', '', 'v_resource_nethardware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (18100, 18000, 'NETHARDWARE_ROUTER', '路由器', '网络系统', '', 18100, '', '', '', '', '', '', '', '', '', '', 'v_resource_nethardware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (18200, 18000, 'NETHARDWARE_SWITCHBOARD', '交换机', '网络系统', '', 18200, '', '', '', '', '', '', '', '', '', '', 'v_resource_nethardware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (18300, 18000, 'NETHARDWARE_LOADBALANCING', '负载均衡', '网络系统', '', 18300, '', '', '', '', '', '', '', '', '', '', 'v_resource_nethardware', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (19000, 0, 'NETSAFE', '安全设备', '安全设备', '', 19000, '', '', '', '', '', '', '', '', '', '', 'v_resource_netsafe', '2021-10-14 11:28:32');
INSERT INTO `b_res_list_tree_v32` VALUES (19100, 19000, 'NETSAFE_FIREWALL', '防火墙', '安全设备', '', 19100, '', '', '', '', '', '', '', '', '', '', 'v_resource_netsafe', '2021-10-14 11:28:32');
SET FOREIGN_KEY_CHECKS = 1;