text: SET FOREIGN_KEY_CHECKS=0;
  INSERT INTO `adm_sequence` (`id_adm_sequence`, `seq_name`, `current_val`, `increment_val`, `length_limitation`, `left_zero_padding`) VALUES
  	(25, 'system_design', 14, 1, 8, 'N'),
  	(26, 'subsys_design', 15, 1, 8, 'N'),
  	(27, 'unit_design', 21, 1, 8, 'N'),
  	(28, 'IDC_design', 3, 1, 8, 'N'),
  	(29, 'zone_design', 7, 1, 8, 'N'),
  	(30, 'DCN_desgin', 8, 1, 8, 'N'),
  	(31, 'resource_set_design', 11, 1, 8, 'N'),
  	(32, 'service_design', 7, 1, 8, 'N'),
  	(33, 'invoke_design', 9, 1, 8, 'N'),
  	(34, 'subsys', 11, 1, 8, 'N'),
  	(35, 'IDC', 21, 1, 8, 'N'),
  	(36, 'zone', 7, 1, 8, 'N'),
  	(37, 'DCN', 13, 1, 8, 'N'),
  	(38, 'resource_set', 13, 1, 8, 'N'),
  	(39, 'zone_link_design', 8, 1, 8, 'N'),
  	(40, 'zone_link', 9, 1, 8, 'N'),
  	(41, 'unit', 10, 1, 8, 'N'),
  	(42, 'package', 15, 1, 8, 'N'),
  	(43, 'network_segment', 13, 1, 8, 'N'),
  	(44, 'ip_addr', 82, 1, 8, 'N'),
  	(45, 'running_instance', 15, 1, 8, 'N'),
  	(46, 'host', 3503, 1, 8, 'N'),
  	(47, 'service', 1, 1, 8, 'N'),
  	(48, 'invoke', 1, 1, 8, 'N'),
  	(49, 'invoke_sequence_design', 1, 1, 8, 'N'),
  	(50, 'block_storage', 5, 1, 8, 'N');
  
  INSERT INTO `DCN` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `dcn_design`, `name`, `zone`) VALUES
  	('0019_0000000001', NULL, '0019_0000000001', 'admin', '2019-07-24 12:26:42', 'admin', '2019-07-24 07:12:44', 'PRD-GZ1-SF-RDCN', 37, NULL, 'RDCN', 'RDCN', NULL, NULL, '0025_0000000001', 'RDCN1', '0017_0000000001'),
  	('0019_0000000005', NULL, '0019_0000000005', 'admin', '2019-07-24 12:26:43', 'admin', '2019-07-24 07:30:50', 'PRD-GZ1-DMZ-DMZ', 37, NULL, 'DMZ', 'DMZ', NULL, NULL, '0025_0000000002', 'DMZ', '0017_0000000004'),
  	('0019_0000000006', NULL, '0019_0000000006', 'admin', '2019-07-24 12:26:43', 'admin', '2019-07-24 07:31:05', 'PRD-GZ1-ECN-ECN', 37, NULL, 'ECN', 'ECN', NULL, NULL, '0025_0000000003', 'ECN', '0017_0000000002'),
  	('0019_0000000007', NULL, '0019_0000000007', 'admin', '2019-07-24 12:26:44', 'admin', '2019-07-24 07:31:19', 'PRD-GZ1-MGMT-MGMT', 37, NULL, 'MGMT', 'MGMT', NULL, NULL, '0025_0000000004', 'MGMT', '0017_0000000003'),
  	('0019_0000000008', NULL, '0019_0000000008', 'admin', '2019-07-24 12:26:44', 'admin', '2019-07-24 07:31:51', 'PRD-GZ1-SF-ADM', 37, NULL, 'ADM', 'ADM', NULL, NULL, '0025_0000000005', 'ADM', '0017_0000000001'),
  	('0019_0000000011', NULL, '0019_0000000011', 'admin', '2019-07-24 13:04:15', 'admin', '2019-07-24 13:01:58', 'PRD-GZ1-INTERNET-H5', 37, '', 'H5', 'H5客户端', NULL, NULL, '0025_0000000006', 'H5', '0017_0000000006'),
  	('0019_0000000012', NULL, '0019_0000000012', 'admin', '2019-07-24 13:03:23', 'admin', '2019-07-24 13:03:22', 'PRD-GZ1-INTRANET-WEB', 37, '', 'WEB', '桌面WEB', NULL, NULL, '0025_0000000008', 'WEB', '0017_0000000007'),
  	('0019_0000000013', NULL, '0019_0000000013', 'admin', '2019-07-24 13:03:47', 'admin', '2019-07-24 13:03:47', 'PRD-GZ1-PARTNERNET-API', 37, '', 'API', '合作伙伴API', NULL, NULL, '0025_0000000007', 'API', '0017_0000000005');
  
  INSERT INTO `DCN_desgin` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `business_group`, `type`, `zone_design`) VALUES
  	('0025_0000000001', NULL, '0025_0000000001', 'admin', '2019-07-23 13:53:18', 'admin', '2019-07-23 13:53:18', 'PRD-SF-RDCN', 34, NULL, 'RDCN', '存款DCN', NULL, NULL, 105, 135, '0023_0000000001'),
  	('0025_0000000002', NULL, '0025_0000000002', 'admin', '2019-07-24 07:27:28', 'admin', '2019-07-24 07:27:28', 'PRD-DMZ-DMZ', 34, NULL, 'DMZ', '客户接入', NULL, NULL, 105, 129, '0023_0000000002'),
  	('0025_0000000003', NULL, '0025_0000000003', 'admin', '2019-07-24 07:27:56', 'admin', '2019-07-24 07:27:56', 'PRD-ECN-ECN', 34, NULL, 'ECN', '伙伴接入', NULL, NULL, 105, 130, '0023_0000000004'),
  	('0025_0000000004', NULL, '0025_0000000004', 'admin', '2019-07-24 07:28:53', 'admin', '2019-07-24 07:28:53', 'PRD-MGMT-MGMT', 34, NULL, 'MGMT', '工具管理', NULL, NULL, 105, 131, '0023_0000000003'),
  	('0025_0000000005', NULL, '0025_0000000005', 'admin', '2019-07-24 07:29:43', 'admin', '2019-07-24 07:29:43', 'PRD-SF-ADM', 34, NULL, 'ADM', '核心业务', NULL, NULL, 105, 132, '0023_0000000001'),
  	('0025_0000000006', NULL, '0025_0000000006', 'admin', '2019-07-24 10:40:45', 'admin', '2019-07-24 10:40:45', 'PRD-INTERNET-H5', 34, '', 'H5', 'H5客户端', NULL, NULL, 105, 126, '0023_0000000005'),
  	('0025_0000000007', NULL, '0025_0000000007', 'admin', '2019-07-24 11:53:24', 'admin', '2019-07-24 10:42:10', 'PRD-PARTNERNET-API', 34, '', 'API', 'API客户端', NULL, NULL, 105, 127, '0023_0000000007'),
  	('0025_0000000008', NULL, '0025_0000000008', 'admin', '2019-07-24 11:50:22', 'admin', '2019-07-24 11:50:21', 'PRD-INTRANET-WEB', 34, '', 'WEB', '桌面WEB', NULL, NULL, 105, 126, '0023_0000000006');
  
  INSERT INTO `host` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `asset_code`, `charge_type`, `disk`, `instance_num`, `internet_nat_ip`, `intranet_ip`, `name`, `os`, `resource_set`, `type`) VALUES
  	('0012_0000000002', NULL, '0012_0000000002', 'admin', '2019-07-25 13:07:00', 'admin', '2019-07-25 12:39:07', 'HOST-07_10.0.16.2', 40, '2019-07-25 21:07:00', 'HOST-07', 'HOST-07', NULL, 'rxeYnnIy2Bv', 'ins-rudnbj7m', 115, 167, 3, '', '0014_0000000002', 'HOST-07', 164, '0020_0000000003', 163),
  	('0012_0000000003', NULL, '0012_0000000003', 'admin', '2019-07-25 13:47:00', 'admin', '2019-07-25 13:44:53', 'HOST08_10.0.21.2', 40, '2019-07-25 21:47:00', 'HOST-08', 'HOST-08', NULL, 'rxf8rvAJ2Bi', 'ins-eh5hzypa', 115, 167, 3, '', '0014_0000000021', 'HOST08', 164, '0020_0000000013', 163);
  
  INSERT INTO `IDC` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `address`, `city`, `env_type`, `idc_design`, `name`, `parameter`, `network_segment`) VALUES
  	('0016_0000000001', NULL, '0016_0000000001', 'admin', '2019-07-24 14:19:54', 'admin', '2019-07-24 06:57:33', 'PRD-GZ1', 38, NULL, 'GZ1', '生产广州云机房1', NULL, NULL, '', '广州', 109, '0022_0000000001', '生产广州云机房1', 'Region=ap-guangzhou;AvailableZone=ap-guangzhou-3;SecretID=SecretID;SecretKey=SecretKey', '0021_0000000001'),
  	('0016_0000000002', NULL, '0016_0000000002', 'admin', '2019-07-24 12:11:01', 'admin', '2019-07-24 06:57:58', 'PRD-GZ2', 38, NULL, 'GZ2', '生产广州云机房2', NULL, NULL, '', '广州', NULL, '0022_0000000001', '生产广州云机房2', 'Region=ap-guangzhou;AvailableZone=ap-guangzhou-3;SecretID=SecretID;SecretKey=SecretKey', NULL),
  	('0016_0000000003', NULL, '0016_0000000003', 'admin', '2019-07-24 12:11:01', 'admin', '2019-07-24 06:58:50', 'STG-SH1', 38, NULL, 'SH1', '测试上海云机房1', NULL, NULL, '', '上海', NULL, '0022_0000000002', '测试上海云机房1', 'Region=ap-shanghai;AvailableZone=ap-shanghai-2;SecretID=SecretID;SecretKey=SecretKey', NULL),
  	('0016_0000000004', NULL, '0016_0000000001', 'admin', '2019-07-24 07:32:57', 'admin', '2019-07-24 06:57:33', 'PRD-0016_0000000001', 37, '2019-07-24 15:32:57', '0016_0000000001', '生产广州云机房1', NULL, NULL, '', '广州', NULL, '0022_0000000001', '生产广州云机房1', 'Region=ap-guangzhou;AvailableZone=ap-guangzhou-3;SecretID=SecretID;SecretKey=SecretKey', NULL),
  	('0016_0000000005', NULL, '0016_0000000002', 'admin', '2019-07-24 07:32:58', 'admin', '2019-07-24 06:57:58', 'PRD-0016_0000000002', 37, '2019-07-24 15:32:58', '0016_0000000002', '生产广州云机房2', NULL, NULL, '', '广州', NULL, '0022_0000000001', '生产广州云机房2', 'Region=ap-guangzhou;AvailableZone=ap-guangzhou-3;SecretID=SecretID;SecretKey=SecretKey', NULL),
  	('0016_0000000006', NULL, '0016_0000000003', 'admin', '2019-07-24 07:32:59', 'admin', '2019-07-24 06:58:50', 'STG-0016_0000000003', 37, '2019-07-24 15:32:59', '0016_0000000003', '测试上海云机房1', NULL, NULL, '', '上海', NULL, '0022_0000000002', '测试上海云机房1', 'Region=ap-shanghai;AvailableZone=ap-shanghai-2;SecretID=SecretID;SecretKey=SecretKey', NULL);
  
  INSERT INTO `IDC_design` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `env_type`, `name`) VALUES
  	('0022_0000000001', NULL, '0022_0000000001', 'admin', '2019-07-24 07:33:06', 'admin', '2019-07-23 13:52:15', 'PRD', 34, '2019-07-24 15:33:06', 'PRD', '生产机房设计', NULL, NULL, 109, '生产机房设计'),
  	('0022_0000000002', NULL, '0022_0000000002', 'admin', '2019-07-24 07:33:06', 'admin', '2019-07-24 06:47:12', 'STG', 34, '2019-07-24 15:33:06', 'STG', '测试机房设计', NULL, NULL, 110, '测试机房设计');
  
  INSERT INTO `invoke` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `invoke_design`, `service`, `unit`) VALUES
  	('0010_0000000001', NULL, '0010_0000000001', 'admin', '2019-07-24 13:17:21', 'admin', '2019-07-24 13:17:21', 'DEMO-WEB_PRD-APP_sync_invoke_DEMO-WEB_PRD-APP-SER1', 37, '', 'sync_invoke', '页面调用', NULL, NULL, '0005_0000000004', '0009_0000000001', '0008_0000000005');
  
  INSERT INTO `invoke_design` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `service_design`, `type`, `unit_design`) VALUES
  	('0005_0000000001', NULL, '0005_0000000001', 'admin', '2019-07-24 08:35:30', 'admin', '2019-07-24 03:51:27', 'EDA-CORE-APP_同步调用_EDA-CORE-DB-RW', 34, '2019-07-24 16:35:30', 'sync_invoke', '访问数据库', NULL, NULL, '0004_0000000002', 152, '0003_0000000002'),
  	('0005_0000000002', NULL, '0005_0000000002', 'admin', '2019-07-24 08:35:30', 'admin', '2019-07-24 03:51:49', 'EDP-CONSOLE-APP_同步调用_EDP-CONSOLE-DB-RW', 34, '2019-07-24 16:35:30', 'sync_invoke', '访问数据库', NULL, NULL, '0004_0000000003', 152, '0003_0000000004'),
  	('0005_0000000003', NULL, '0005_0000000003', 'admin', '2019-07-24 12:59:17', 'admin', '2019-07-24 12:59:16', 'EDP-CORE-APP_同步调用_ECIF-CORE-APP-QUERY', 34, '', 'sync_invoke', '获取客户信息', NULL, NULL, '0004_0000000005', 152, '0003_0000000002'),
  	('0005_0000000004', NULL, '0005_0000000004', 'admin', '2019-07-24 13:18:02', 'admin', '2019-07-24 13:16:13', 'DEMO-WEB-APP_同步调用_DEMO-WEB-APP-SER1', 34, '2019-07-24 21:18:02', 'sync_invoke', '页面调用', NULL, NULL, '0004_0000000006', 152, '0003_0000000011'),
  	('0005_0000000005', NULL, '0005_0000000005', 'admin', '2019-07-24 13:46:52', 'admin', '2019-07-24 13:46:52', 'EDP-CLIENT-WEB_同步调用_EDP-PROXY-PROXY-WEB', 34, '', 'sync_invoke', '访问WEB', NULL, NULL, '0004_0000000007', 152, '0003_0000000013'),
  	('0005_0000000006', NULL, '0005_0000000006', 'admin', '2019-07-24 16:11:00', 'admin', '2019-07-24 16:11:00', 'EDP-CORE-APP_同步调用_EDP-CONSOLE-APP-SER1', 34, '', 'sync_invoke', '无', NULL, NULL, '0004_0000000004', 152, '0003_0000000002'),
  	('0005_0000000007', NULL, '0005_0000000007', 'admin', '2019-07-24 16:11:45', 'admin', '2019-07-24 16:11:45', 'EDP-PROXY-PROXY_同步调用_EDP-CONSOLE-APP-SER1', 34, '', 'sync_invoke', '无', NULL, NULL, '0004_0000000004', 152, '0003_0000000012'),
  	('0005_0000000008', NULL, '0005_0000000008', 'admin', '2019-07-25 11:18:35', 'admin', '2019-07-25 11:18:35', 'EDP-ADMCORE-APP_同步调用_EDP-CORE-APP-SER1', 34, '', 'sync_invoke', '访问CORE', NULL, '', '0004_0000000001', 152, '0003_0000000019'),
  	('0005_0000000009', NULL, '0005_0000000009', 'admin', '2019-07-25 11:19:07', 'admin', '2019-07-25 11:19:06', 'EDP-ADMBATCH-APP_同步调用_EDP-CORE-APP-SER1', 34, '', 'sync_invoke', '访问CORE', NULL, '', '0004_0000000001', 152, '0003_0000000018');
  
  INSERT INTO `invoke_sequence_design` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `name`, `service_design`) VALUES
  	('0006_0000000001', NULL, '0006_0000000001', 'admin', '2019-07-29 03:38:01', 'admin', '2019-07-24 15:13:03', 'EDP-CONSOLE-APP-SER1-MANAGE', 34, '', 'MANAGE', '管理', 223, 'rxA3j9uJ2BD', '管理', '0004_0000000004');
  
  INSERT INTO `ip_addr` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `network_segment`, `type`, `used_record`) VALUES
  	('0014_0000000001', NULL, '0014_0000000001', 'admin', '2019-07-24 11:41:45', 'admin', '2019-07-24 11:40:31', '10.0.16.1/24', 37, '', '10.0.16.1', 'DMZ proxy 网关', NULL, NULL, '0021_0000000006', 172, '0014_0000000001_0014_0000000001_0014_0000000001_10.0.16.0/24_VPC子网网段'),
  	('0014_0000000002', NULL, '0014_0000000002', 'admin', '2019-07-24 11:47:11', 'admin', '2019-07-24 11:47:10', '10.0.16.2/24', 37, '', '10.0.16.2', 'DMZ proxy 可用IP', NULL, NULL, '0021_0000000006', 172, '0014_0000000002_0014_0000000002_0014_0000000002_0014_0000000002'),
  	('0014_0000000003', NULL, '0014_0000000003', 'admin', '2019-07-24 11:47:43', 'admin', '2019-07-24 11:47:43', '10.0.16.3/24', 37, '', '10.0.16.3', 'DMZ proxy 可用IP', NULL, NULL, '0021_0000000006', 172, '0014_0000000003_0014_0000000003_0014_0000000003_0014_0000000003'),
  	('0014_0000000004', NULL, '0014_0000000004', 'admin', '2019-07-24 11:48:08', 'admin', '2019-07-24 11:48:08', '10.0.16.4/24', 37, '', '10.0.16.4', 'DMZ proxy 可用IP', NULL, NULL, '0021_0000000006', 172, '0014_0000000004_0014_0000000004_0014_0000000004_0014_0000000004'),
  	('0014_0000000005', NULL, '0014_0000000005', 'admin', '2019-07-24 11:48:34', 'admin', '2019-07-24 11:48:34', '10.0.16.5/24', 37, '', '10.0.16.5', 'DMZ proxy 可用IP', NULL, NULL, '0021_0000000006', 172, '0014_0000000005_0014_0000000005_0014_0000000005_0014_0000000005'),
  	('0014_0000000006', NULL, '0014_0000000006', 'admin', '2019-07-24 11:49:03', 'admin', '2019-07-24 11:49:03', '10.0.16.6/24', 37, '', '10.0.16.6', 'DMZ proxy 可用IP', NULL, NULL, '0021_0000000006', 172, '0014_0000000006_0014_0000000006_0014_0000000006_0014_0000000006'),
  	('0014_0000000007', NULL, '0014_0000000007', 'admin', '2019-07-24 11:49:25', 'admin', '2019-07-24 11:49:24', '10.0.16.7/24', 37, '', '10.0.16.7', 'DMZ proxy 可用IP', NULL, NULL, '0021_0000000006', 172, '0014_0000000007_0014_0000000007_0014_0000000007_0014_0000000007'),
  	('0014_0000000008', NULL, '0014_0000000008', 'admin', '2019-07-24 11:49:42', 'admin', '2019-07-24 11:49:42', '10.0.16.8/24', 37, '', '10.0.16.8', 'DMZ proxy 可用IP', NULL, NULL, '0021_0000000006', 172, '0014_0000000008_0014_0000000008_0014_0000000008_0014_0000000008'),
  	('0014_0000000009', NULL, '0014_0000000009', 'admin', '2019-07-24 11:49:59', 'admin', '2019-07-24 11:49:58', '10.0.16.9/24', 37, '', '10.0.16.9', 'DMZ proxy 可用IP', NULL, NULL, '0021_0000000006', 172, '0014_0000000009_0014_0000000009_0014_0000000009_0014_0000000009'),
  	('0014_0000000010', NULL, '0014_0000000010', 'admin', '2019-07-24 12:18:57', 'admin', '2019-07-24 11:51:14', '10.0.20.1/24', 37, '', '10.0.20.1', 'MGMT APP网关', NULL, NULL, '0021_0000000007', 172, '0014_0000000010_0014_0000000010_0014_0000000010_10.0.20.0/24_VPC子网网段'),
  	('0014_0000000011', NULL, '0014_0000000011', 'admin', '2019-07-24 12:18:57', 'admin', '2019-07-24 11:52:15', '10.0.20.2/24', 37, '', '10.0.20.2', 'MGMT APP 可用IP', NULL, NULL, '0021_0000000007', 172, '0014_0000000011_0014_0000000011_0014_0000000011_0014_0000000011'),
  	('0014_0000000012', NULL, '0014_0000000012', 'admin', '2019-07-24 12:18:57', 'admin', '2019-07-24 11:52:36', '10.0.20.3/24', 37, '', '10.0.20.3', 'MGMT APP 可用IP', NULL, NULL, '0021_0000000007', 172, '0014_0000000012_0014_0000000012_0014_0000000012_0014_0000000012'),
  	('0014_0000000014', NULL, '0014_0000000014', 'admin', '2019-07-24 12:18:57', 'admin', '2019-07-24 11:53:18', '10.0.20.4/24', 37, '', '10.0.20.4', 'MGMT APP 可用IP', NULL, NULL, '0021_0000000007', 172, '0014_0000000014_0014_0000000014_0014_0000000014_0014_0000000014'),
  	('0014_0000000015', NULL, '0014_0000000015', 'admin', '2019-07-24 12:18:57', 'admin', '2019-07-24 11:53:44', '10.0.20.5/24', 37, '', '10.0.20.5', 'MGMT APP 可用IP', NULL, NULL, '0021_0000000007', 172, '0014_0000000015_0014_0000000015_0014_0000000015_0014_0000000015'),
  	('0014_0000000016', NULL, '0014_0000000016', 'admin', '2019-07-24 12:18:58', 'admin', '2019-07-24 11:54:19', '10.0.20.6/24', 37, '', '10.0.20.6', 'MGMT APP 可用IP', NULL, NULL, '0021_0000000007', 172, '0014_0000000016_0014_0000000016_0014_0000000016_0014_0000000016'),
  	('0014_0000000017', NULL, '0014_0000000017', 'admin', '2019-07-24 12:18:58', 'admin', '2019-07-24 11:54:52', '10.0.20.7/24', 37, '', '10.0.20.7', 'MGMT APP 可用IP', NULL, NULL, '0021_0000000007', 172, '0014_0000000017_0014_0000000017_0014_0000000017_0014_0000000017'),
  	('0014_0000000018', NULL, '0014_0000000018', 'admin', '2019-07-24 12:18:58', 'admin', '2019-07-24 11:55:13', '10.0.20.8/24', 37, '', '10.0.20.8', 'MGMT APP 可用IP', NULL, NULL, '0021_0000000007', 172, '0014_0000000018_0014_0000000018_0014_0000000018_0014_0000000018'),
  	('0014_0000000019', NULL, '0014_0000000019', 'admin', '2019-07-24 12:18:58', 'admin', '2019-07-24 11:55:29', '10.0.20.9/24', 37, '', '10.0.20.9', 'MGMT APP 可用IP', NULL, NULL, '0021_0000000007', 172, '0014_0000000019_0014_0000000019_0014_0000000019_0014_0000000019'),
  	('0014_0000000020', NULL, '0014_0000000020', 'admin', '2019-07-24 12:19:24', 'admin', '2019-07-24 11:56:15', '10.0.21.1/24', 37, '', '10.0.21.1', 'MGMT DB 网关', NULL, NULL, '0021_0000000008', 172, '0014_0000000020_0014_0000000020_0014_0000000020_10.0.21.0/24_VPC子网网段'),
  	('0014_0000000021', NULL, '0014_0000000021', 'admin', '2019-07-24 12:19:24', 'admin', '2019-07-24 11:56:44', '10.0.21.2/24', 37, '', '10.0.21.2', 'MGMT DB 可用IP', NULL, NULL, '0021_0000000008', 172, '0014_0000000021_0014_0000000021_0014_0000000021_0014_0000000021'),
  	('0014_0000000022', NULL, '0014_0000000022', 'admin', '2019-07-24 12:19:24', 'admin', '2019-07-24 11:57:15', '10.0.21.3/24', 37, '', '10.0.21.3', 'MGMT DB 可用IP', NULL, NULL, '0021_0000000008', 172, '0014_0000000022_0014_0000000022_0014_0000000022_0014_0000000022'),
  	('0014_0000000023', NULL, '0014_0000000023', 'admin', '2019-07-24 12:19:24', 'admin', '2019-07-24 11:57:36', '10.0.21.4/24', 37, '', '10.0.21.4', 'MGMT DB 可用IP', NULL, NULL, '0021_0000000008', 172, '0014_0000000023_0014_0000000023_0014_0000000023_0014_0000000023'),
  	('0014_0000000024', NULL, '0014_0000000024', 'admin', '2019-07-24 12:19:24', 'admin', '2019-07-24 11:57:55', '10.0.21.5/24', 37, '', '10.0.21.5', 'MGMT DB 可用IP', NULL, NULL, '0021_0000000008', 172, '0014_0000000024_0014_0000000024_0014_0000000024_0014_0000000024'),
  	('0014_0000000025', NULL, '0014_0000000025', 'admin', '2019-07-24 12:19:24', 'admin', '2019-07-24 11:58:14', '10.0.21.6/24', 37, '', '10.0.21.6', 'MGMT DB 可用IP', NULL, NULL, '0021_0000000008', 172, '0014_0000000025_0014_0000000025_0014_0000000025_0014_0000000025'),
  	('0014_0000000026', NULL, '0014_0000000026', 'admin', '2019-07-24 12:19:24', 'admin', '2019-07-24 11:58:39', '10.0.21.7/24', 37, '', '10.0.21.7', 'MGMT DB 可用IP', NULL, NULL, '0021_0000000008', 172, '0014_0000000026_0014_0000000026_0014_0000000026_0014_0000000026'),
  	('0014_0000000027', NULL, '0014_0000000027', 'admin', '2019-07-24 12:19:24', 'admin', '2019-07-24 11:58:53', '10.0.21.8/24', 37, '', '10.0.21.8', 'MGMT DB 可用IP', NULL, NULL, '0021_0000000008', 172, '0014_0000000027_0014_0000000027_0014_0000000027_0014_0000000027'),
  	('0014_0000000028', NULL, '0014_0000000028', 'admin', '2019-07-24 12:19:25', 'admin', '2019-07-24 11:59:25', '10.0.21.9/24', 37, '', '10.0.21.9', 'MGMT DB 可用IP', NULL, NULL, '0021_0000000008', 172, '0014_0000000028_0014_0000000028_0014_0000000028_0014_0000000028'),
  	('0014_0000000029', NULL, '0014_0000000029', 'admin', '2019-07-24 12:19:26', 'admin', '2019-07-24 12:00:29', '10.0.24.1/24', 37, '', '10.0.24.1', 'ECN PROXY 网关', NULL, NULL, '0021_0000000009', 172, '0014_0000000029_0014_0000000029_0014_0000000029_10.0.24.0/24_VPC子网网段'),
  	('0014_0000000030', NULL, '0014_0000000030', 'admin', '2019-07-24 12:19:26', 'admin', '2019-07-24 12:01:01', '10.0.24.2/24', 37, '', '10.0.24.2', 'ECN PROXY 可用IP', NULL, NULL, '0021_0000000009', 172, '0014_0000000030_0014_0000000030_0014_0000000030_0014_0000000030'),
  	('0014_0000000031', NULL, '0014_0000000031', 'admin', '2019-07-24 12:19:26', 'admin', '2019-07-24 12:01:24', '10.0.24.3/24', 37, '', '10.0.24.3', 'ECN PROXY 可用IP', NULL, NULL, '0021_0000000009', 172, '0014_0000000031_0014_0000000031_0014_0000000031_0014_0000000031'),
  	('0014_0000000032', NULL, '0014_0000000032', 'admin', '2019-07-24 12:19:26', 'admin', '2019-07-24 12:01:38', '10.0.24.4/24', 37, '', '10.0.24.4', 'ECN PROXY 可用IP', NULL, NULL, '0021_0000000009', 172, '0014_0000000032_0014_0000000032_0014_0000000032_0014_0000000032'),
  	('0014_0000000033', NULL, '0014_0000000033', 'admin', '2019-07-24 12:19:26', 'admin', '2019-07-24 12:01:55', '10.0.24.5/24', 37, '', '10.0.24.5', 'ECN PROXY 可用IP', NULL, NULL, '0021_0000000009', 172, '0014_0000000033_0014_0000000033_0014_0000000033_0014_0000000033'),
  	('0014_0000000034', NULL, '0014_0000000034', 'admin', '2019-07-24 12:19:26', 'admin', '2019-07-24 12:02:14', '10.0.24.6/24', 37, '', '10.0.24.6', 'ECN PROXY 可用IP', NULL, NULL, '0021_0000000009', 172, '0014_0000000034_0014_0000000034_0014_0000000034_0014_0000000034'),
  	('0014_0000000035', NULL, '0014_0000000035', 'admin', '2019-07-24 12:19:26', 'admin', '2019-07-24 12:02:31', '10.0.24.7/24', 37, '', '10.0.24.7', 'ECN PROXY 可用IP', NULL, NULL, '0021_0000000009', 172, '0014_0000000035_0014_0000000035_0014_0000000035_0014_0000000035'),
  	('0014_0000000036', NULL, '0014_0000000036', 'admin', '2019-07-24 12:19:26', 'admin', '2019-07-24 12:02:54', '10.0.24.8/24', 37, '', '10.0.24.8', 'ECN PROXY 可用IP', NULL, NULL, '0021_0000000009', 172, '0014_0000000036_0014_0000000036_0014_0000000036_0014_0000000036'),
  	('0014_0000000037', NULL, '0014_0000000037', 'admin', '2019-07-24 12:19:26', 'admin', '2019-07-24 12:03:12', '10.0.24.9/24', 37, '', '10.0.24.9', 'ECN PROXY 可用IP', NULL, NULL, '0021_0000000009', 172, '0014_0000000037_0014_0000000037_0014_0000000037_0014_0000000037'),
  	('0014_0000000038', NULL, '0014_0000000038', 'admin', '2019-07-24 12:19:46', 'admin', '2019-07-24 12:04:00', '10.0.0.1/24', 37, '', '10.0.0.1', 'SF ADM APP 网关', NULL, NULL, '0021_0000000010', 172, '0014_0000000038_0014_0000000038_0014_0000000038_10.0.0.0/24_VPC子网网段'),
  	('0014_0000000039', NULL, '0014_0000000039', 'admin', '2019-07-24 12:19:46', 'admin', '2019-07-24 12:04:23', '10.0.0.2/24', 37, '', '10.0.0.2', 'SF ADM APP 可用IP', NULL, NULL, '0021_0000000010', 172, '0014_0000000039_0014_0000000039_0014_0000000039_0014_0000000039'),
  	('0014_0000000040', NULL, '0014_0000000040', 'admin', '2019-07-24 12:19:46', 'admin', '2019-07-24 12:04:40', '10.0.0.3/24', 37, '', '10.0.0.3', 'SF ADM APP 可用IP', NULL, NULL, '0021_0000000010', 172, '0014_0000000040_0014_0000000040_0014_0000000040_0014_0000000040'),
  	('0014_0000000041', NULL, '0014_0000000041', 'admin', '2019-07-24 12:19:46', 'admin', '2019-07-24 12:04:58', '10.0.0.4/24', 37, '', '10.0.0.4', 'SF ADM APP 可用IP', NULL, NULL, '0021_0000000010', 172, '0014_0000000041_0014_0000000041_0014_0000000041_0014_0000000041'),
  	('0014_0000000042', NULL, '0014_0000000042', 'admin', '2019-07-24 12:19:46', 'admin', '2019-07-24 12:05:18', '10.0.0.5/24', 37, '', '10.0.0.5', 'SF ADM APP 可用IP', NULL, NULL, '0021_0000000010', 172, '0014_0000000042_0014_0000000042_0014_0000000042_0014_0000000042'),
  	('0014_0000000043', NULL, '0014_0000000043', 'admin', '2019-07-24 12:19:46', 'admin', '2019-07-24 12:05:38', '10.0.0.6/24', 37, '', '10.0.0.6', 'SF ADM APP 可用IP', NULL, NULL, '0021_0000000010', 172, '0014_0000000043_0014_0000000043_0014_0000000043_0014_0000000043'),
  	('0014_0000000044', NULL, '0014_0000000044', 'admin', '2019-07-24 12:19:46', 'admin', '2019-07-24 12:05:54', '10.0.0.7/24', 37, '', '10.0.0.7', 'SF ADM APP 可用IP', NULL, NULL, '0021_0000000010', 172, '0014_0000000044_0014_0000000044_0014_0000000044_0014_0000000044'),
  	('0014_0000000045', NULL, '0014_0000000045', 'admin', '2019-07-24 12:19:46', 'admin', '2019-07-24 12:06:09', '10.0.0.8/24', 37, '', '10.0.0.8', 'SF ADM APP 可用IP', NULL, NULL, '0021_0000000010', 172, '0014_0000000045_0014_0000000045_0014_0000000045_0014_0000000045'),
  	('0014_0000000046', NULL, '0014_0000000046', 'admin', '2019-07-24 12:19:46', 'admin', '2019-07-24 12:06:25', '10.0.0.9/24', 37, '', '10.0.0.9', 'SF ADM APP 可用IP', NULL, NULL, '0021_0000000010', 172, '0014_0000000046_0014_0000000046_0014_0000000046_0014_0000000046'),
  	('0014_0000000047', NULL, '0014_0000000047', 'admin', '2019-07-24 12:20:27', 'admin', '2019-07-24 12:07:06', '10.0.1.1/24', 37, '', '10.0.1.1', 'SF ADM DB 网关', NULL, NULL, '0021_0000000011', 172, '0014_0000000047_0014_0000000047_0014_0000000047_10.0.1.0/24_VPC子网网段'),
  	('0014_0000000048', NULL, '0014_0000000048', 'admin', '2019-07-24 12:20:27', 'admin', '2019-07-24 12:07:31', '10.0.1.2/24', 37, '', '10.0.1.2', 'SF ADM DB 可用IP', NULL, NULL, '0021_0000000011', 172, '0014_0000000048_0014_0000000048_0014_0000000048_0014_0000000048'),
  	('0014_0000000049', NULL, '0014_0000000049', 'admin', '2019-07-24 12:20:27', 'admin', '2019-07-24 12:07:49', '10.0.1.3/24', 37, '', '10.0.1.3', 'SF ADM DB 可用IP', NULL, NULL, '0021_0000000011', 172, '0014_0000000049_0014_0000000049_0014_0000000049_0014_0000000049'),
  	('0014_0000000050', NULL, '0014_0000000050', 'admin', '2019-07-24 12:20:27', 'admin', '2019-07-24 12:08:06', '10.0.1.4/24', 37, '', '10.0.1.4', 'SF ADM DB 可用IP', NULL, NULL, '0021_0000000011', 172, '0014_0000000050_0014_0000000050_0014_0000000050_0014_0000000050'),
  	('0014_0000000051', NULL, '0014_0000000051', 'admin', '2019-07-24 12:20:27', 'admin', '2019-07-24 12:08:34', '10.0.1.5/24', 37, '', '10.0.1.5', 'SF ADM DB 可用IP', NULL, NULL, '0021_0000000011', 172, '0014_0000000051_0014_0000000051_0014_0000000051_0014_0000000051'),
  	('0014_0000000052', NULL, '0014_0000000052', 'admin', '2019-07-24 12:20:27', 'admin', '2019-07-24 12:08:51', '10.0.1.6/24', 37, '', '10.0.1.6', 'SF ADM DB 可用IP', NULL, NULL, '0021_0000000011', 172, '0014_0000000052_0014_0000000052_0014_0000000052_0014_0000000052'),
  	('0014_0000000053', NULL, '0014_0000000053', 'admin', '2019-07-24 12:20:27', 'admin', '2019-07-24 12:09:11', '10.0.1.7/24', 37, '', '10.0.1.7', 'SF ADM DB 可用IP', NULL, NULL, '0021_0000000011', 172, '0014_0000000053_0014_0000000053_0014_0000000053_0014_0000000053'),
  	('0014_0000000054', NULL, '0014_0000000054', 'admin', '2019-07-24 12:20:28', 'admin', '2019-07-24 12:09:27', '10.0.1.8/24', 37, '', '10.0.1.8', 'SF ADM DB 可用IP', NULL, NULL, '0021_0000000011', 172, '0014_0000000054_0014_0000000054_0014_0000000054_0014_0000000054'),
  	('0014_0000000055', NULL, '0014_0000000055', 'admin', '2019-07-24 12:20:28', 'admin', '2019-07-24 12:09:45', '10.0.1.9/24', 37, '', '10.0.1.9', 'SF ADM DB 可用IP', NULL, NULL, '0021_0000000011', 172, '0014_0000000055_0014_0000000055_0014_0000000055_0014_0000000055'),
  	('0014_0000000056', NULL, '0014_0000000056', 'admin', '2019-07-24 12:20:29', 'admin', '2019-07-24 12:10:29', '10.0.2.1/24', 37, '', '10.0.2.1', 'SF RDCN1 APP 网关', NULL, NULL, '0021_0000000012', 172, '0014_0000000056_0014_0000000056_0014_0000000056_10.0.2.0/24_VPC子网网段'),
  	('0014_0000000057', NULL, '0014_0000000057', 'admin', '2019-07-24 12:20:29', 'admin', '2019-07-24 12:10:55', '10.0.2.2/24', 37, '', '10.0.2.2', 'SF RDCN1 APP 可用IP', NULL, NULL, '0021_0000000012', 172, '0014_0000000057_0014_0000000057_0014_0000000057_0014_0000000057'),
  	('0014_0000000058', NULL, '0014_0000000058', 'admin', '2019-07-24 12:20:29', 'admin', '2019-07-24 12:11:11', '10.0.2.3/24', 37, '', '10.0.2.3', 'SF RDCN1 APP 可用IP', NULL, NULL, '0021_0000000012', 172, '0014_0000000058_0014_0000000058_0014_0000000058_0014_0000000058'),
  	('0014_0000000059', NULL, '0014_0000000059', 'admin', '2019-07-24 12:20:29', 'admin', '2019-07-24 12:11:26', '10.0.2.4/24', 37, '', '10.0.2.4', 'SF RDCN1 APP 可用IP', NULL, NULL, '0021_0000000012', 172, '0014_0000000059_0014_0000000059_0014_0000000059_0014_0000000059'),
  	('0014_0000000060', NULL, '0014_0000000060', 'admin', '2019-07-24 12:20:29', 'admin', '2019-07-24 12:11:47', '10.0.2.5/24', 37, '', '10.0.2.5', 'SF RDCN1 APP 可用IP', NULL, NULL, '0021_0000000012', 172, '0014_0000000060_0014_0000000060_0014_0000000060_0014_0000000060'),
  	('0014_0000000061', NULL, '0014_0000000061', 'admin', '2019-07-24 12:20:29', 'admin', '2019-07-24 12:12:03', '10.0.2.6/24', 37, '', '10.0.2.6', 'SF RDCN1 APP 可用IP', NULL, NULL, '0021_0000000012', 172, '0014_0000000061_0014_0000000061_0014_0000000061_0014_0000000061'),
  	('0014_0000000062', NULL, '0014_0000000062', 'admin', '2019-07-24 12:20:29', 'admin', '2019-07-24 12:12:20', '10.0.2.7/24', 37, '', '10.0.2.7', 'SF RDCN1 APP 可用IP', NULL, NULL, '0021_0000000012', 172, '0014_0000000062_0014_0000000062_0014_0000000062_0014_0000000062'),
  	('0014_0000000063', NULL, '0014_0000000063', 'admin', '2019-07-24 12:20:29', 'admin', '2019-07-24 12:12:35', '10.0.2.8/24', 37, '', '10.0.2.8', 'SF RDCN1 APP 可用IP', NULL, NULL, '0021_0000000012', 172, '0014_0000000063_0014_0000000063_0014_0000000063_0014_0000000063'),
  	('0014_0000000064', NULL, '0014_0000000064', 'admin', '2019-07-24 16:14:05', 'admin', '2019-07-24 12:12:50', '10.0.2.9/24', 37, '', '10.0.2.9', 'SF RDCN1 APP 可用IP', NULL, NULL, '0021_0000000012', 172, 'DEMO-WEB_PRD-APP-SER1_HOST_05_10.0.2.9,HOST_06_10.0.2.9_0014_0000000064_0014_0000000064'),
  	('0014_0000000065', NULL, '0014_0000000065', 'admin', '2019-07-24 12:20:30', 'admin', '2019-07-24 12:13:34', '10.0.3.1/24', 37, '', '10.0.3.1', 'SF RDCN1 DB 网关', NULL, NULL, '0021_0000000013', 172, '0014_0000000065_0014_0000000065_0014_0000000065_10.0.3.0/24_VPC子网网段'),
  	('0014_0000000066', NULL, '0014_0000000066', 'admin', '2019-07-24 12:20:31', 'admin', '2019-07-24 12:14:01', '10.0.3.2/24', 37, '', '10.0.3.2', 'SF RDCN1 DB 可用IP', NULL, NULL, '0021_0000000013', 172, '0014_0000000066_0014_0000000066_0014_0000000066_0014_0000000066'),
  	('0014_0000000067', NULL, '0014_0000000067', 'admin', '2019-07-24 12:20:31', 'admin', '2019-07-24 12:14:18', '10.0.3.3/24', 37, '', '10.0.3.3', 'SF RDCN1 DB 可用IP', NULL, NULL, '0021_0000000013', 172, '0014_0000000067_0014_0000000067_0014_0000000067_0014_0000000067'),
  	('0014_0000000068', NULL, '0014_0000000068', 'admin', '2019-07-24 12:20:31', 'admin', '2019-07-24 12:14:32', '10.0.3.4/24', 37, '', '10.0.3.4', 'SF RDCN1 DB 可用IP', NULL, NULL, '0021_0000000013', 172, '0014_0000000068_0014_0000000068_0014_0000000068_0014_0000000068'),
  	('0014_0000000069', NULL, '0014_0000000069', 'admin', '2019-07-24 12:20:31', 'admin', '2019-07-24 12:14:46', '10.0.3.5/24', 37, '', '10.0.3.5', 'SF RDCN1 DB 可用IP', NULL, NULL, '0021_0000000013', 172, '0014_0000000069_0014_0000000069_0014_0000000069_0014_0000000069'),
  	('0014_0000000070', NULL, '0014_0000000070', 'admin', '2019-07-24 12:20:31', 'admin', '2019-07-24 12:15:02', '10.0.3.6/24', 37, '', '10.0.3.6', 'SF RDCN1 DB 可用IP', NULL, NULL, '0021_0000000013', 172, '0014_0000000070_0014_0000000070_0014_0000000070_0014_0000000070'),
  	('0014_0000000071', NULL, '0014_0000000071', 'admin', '2019-07-24 12:20:31', 'admin', '2019-07-24 12:15:17', '10.0.3.7/24', 37, '', '10.0.3.7', 'SF RDCN1 DB 可用IP', NULL, NULL, '0021_0000000013', 172, '0014_0000000071_0014_0000000071_0014_0000000071_0014_0000000071'),
  	('0014_0000000072', NULL, '0014_0000000072', 'admin', '2019-07-24 12:20:31', 'admin', '2019-07-24 12:15:32', '10.0.3.8/24', 37, '', '10.0.3.8', 'SF RDCN1 DB 可用IP', NULL, NULL, '0021_0000000013', 172, '0014_0000000072_0014_0000000072_0014_0000000072_0014_0000000072'),
  	('0014_0000000073', NULL, '0014_0000000073', 'admin', '2019-07-24 12:20:31', 'admin', '2019-07-24 12:15:47', '10.0.3.9/24', 37, '', '10.0.3.9', 'SF RDCN1 DB 可用IP', NULL, NULL, '0021_0000000013', 172, '0014_0000000073_0014_0000000073_0014_0000000073_0014_0000000073'),
  	('0014_0000000075', NULL, '0014_0000000075', 'admin', '2019-07-25 14:03:43', 'admin', '2019-07-25 14:03:42', '10.0.10.200/16', 37, '', '10.0.10.200', 'SF可用IP', NULL, '', '0021_0000000001', 172, '0014_0000000075_0014_0000000075_0014_0000000075_0014_0000000075'),
  	('0014_0000000076', NULL, '0014_0000000076', 'admin', '2019-07-25 14:04:13', 'admin', '2019-07-25 14:04:12', '10.0.10.239/16', 37, '', '10.0.10.239', 'SF可用IP', NULL, '', '0021_0000000001', 172, '0014_0000000076_0014_0000000076_0014_0000000076_0014_0000000076');
  
  INSERT INTO `network_segment` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `asset_code`, `f_network_segment`, `gateway_ip`, `mask`, `name`, `type`) VALUES
  	('0021_0000000001', NULL, '0021_0000000001', 'admin', '2019-07-24 11:25:55', 'admin', '2019-07-24 11:25:55', '10.0.0.0/16_机房网段', 37, '', '10.0.0.0/16', '广州1机房', NULL, NULL, '', '', '', 16, '广州机房B类网段', 179),
  	('0021_0000000002', NULL, '0021_0000000002', 'admin', '2019-07-24 11:27:41', 'admin', '2019-07-24 11:27:41', '10.0.0.0/20_VPC网段', 37, '', '10.0.0.0/20', '广州机房1 SF网段', NULL, NULL, '', '0021_0000000001', '', 20, '广州机房1 SF子网', 180),
  	('0021_0000000003', NULL, '0021_0000000003', 'admin', '2019-07-24 11:30:07', 'admin', '2019-07-24 11:30:07', '10.0.16.0/22_VPC网段', 37, '', '10.0.16.0/22', '广州机房1 DMZ网段', NULL, NULL, '', '0021_0000000001', '', 22, '广州机房1 DMZ网段', 180),
  	('0021_0000000004', NULL, '0021_0000000004', 'admin', '2019-07-24 11:31:15', 'admin', '2019-07-24 11:31:14', '10.0.20.0/22_VPC网段', 37, '', '10.0.20.0/22', '广州机房1 MGMT网段', NULL, NULL, '', '0021_0000000001', '', 22, '广州机房1 MGMT 网段', 180),
  	('0021_0000000005', NULL, '0021_0000000005', 'admin', '2019-07-24 11:31:56', 'admin', '2019-07-24 11:31:56', '10.0.24.0/22_VPC网段', 37, '', '10.0.24.0/22', '广州机房1 ECN网段', NULL, NULL, '', '0021_0000000001', '', 22, '广州机房1 ECN网段', 180),
  	('0021_0000000006', NULL, '0021_0000000006', 'admin', '2019-07-24 11:41:45', 'admin', '2019-07-24 11:33:17', '10.0.16.0/24_VPC子网网段', 37, '', '10.0.16.0/24', 'DMZ FROXY 资源集网段', NULL, NULL, '', '0021_0000000003', '0014_0000000001', 24, 'DMZ FROXY 资源集网段', 181),
  	('0021_0000000007', NULL, '0021_0000000007', 'admin', '2019-07-24 12:18:58', 'admin', '2019-07-24 11:34:10', '10.0.20.0/24_VPC子网网段', 37, '', '10.0.20.0/24', 'MGMT APP资源集网段', NULL, NULL, '', '0021_0000000004', '0014_0000000010', 24, 'MGMT APP资源集网段', 181),
  	('0021_0000000008', NULL, '0021_0000000008', 'admin', '2019-07-24 12:19:25', 'admin', '2019-07-24 11:34:56', '10.0.21.0/24_VPC子网网段', 37, '', '10.0.21.0/24', 'MGMT DB资源集网段	', NULL, NULL, '', '0021_0000000004', '0014_0000000020', 24, 'MGMT DB资源集网段', 181),
  	('0021_0000000009', NULL, '0021_0000000009', 'admin', '2019-07-24 12:19:27', 'admin', '2019-07-24 11:35:43', '10.0.24.0/24_VPC子网网段', 37, '', '10.0.24.0/24', 'ECN PROXY资源集网段', NULL, NULL, '', '0021_0000000005', '0014_0000000029', 24, 'ECN PROXY资源集网段', 181),
  	('0021_0000000010', NULL, '0021_0000000010', 'admin', '2019-07-24 12:19:47', 'admin', '2019-07-24 11:36:35', '10.0.0.0/24_VPC子网网段', 37, '', '10.0.0.0/24', 'SF ADM APP资源集网段', NULL, NULL, '', '0021_0000000002', '0014_0000000038', 24, 'SF ADM APP资源集网段', 181),
  	('0021_0000000011', NULL, '0021_0000000011', 'admin', '2019-07-24 12:20:28', 'admin', '2019-07-24 11:37:15', '10.0.1.0/24_VPC子网网段', 37, '', '10.0.1.0/24', 'SF ADM DB资源集网段', NULL, NULL, '', '0021_0000000002', '0014_0000000047', 24, 'SF ADM DB资源集网段', 181),
  	('0021_0000000012', NULL, '0021_0000000012', 'admin', '2019-07-24 12:20:30', 'admin', '2019-07-24 11:38:06', '10.0.2.0/24_VPC子网网段', 37, '', '10.0.2.0/24', 'SF RDCN1 APP资源集网段', NULL, NULL, '', '0021_0000000002', '0014_0000000056', 24, 'SF RDCN1 APP资源集网段', 181),
  	('0021_0000000013', NULL, '0021_0000000013', 'admin', '2019-07-24 12:20:31', 'admin', '2019-07-24 11:38:40', '10.0.3.0/24_VPC子网网段', 37, '', '10.0.3.0/24', 'SF RDCN1 DB资源集网段', NULL, NULL, '', '0021_0000000002', '0014_0000000065', 24, 'SF RDCN1 DB资源集网段', 181);
  
  INSERT INTO `package` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `deploy_file`, `deploy_path`, `deploy_user`, `diff_conf_file`, `md5_value`, `name`, `url`, `start_file`, `stop_file`, `unit_design`, `upload_time`, `upload_user`) VALUES
  	('0011_0000000010', NULL, '0011_0000000010', 'admin', '2019-08-02 06:45:11', 'admin', '2019-07-24 16:23:45', 'edp-core-app_v1.0.zip', 37, NULL, 'edp-core-app_v1.0.zip', 'edp-core-app_v1.0.zip', NULL, NULL, 'http://10.0.10.12:9000/scripts/wecube-demo.sh', '/home/app/edp-core-app_v1.0.zip', 233, '/edp-core-app_v1.0/conf/app.conf', '647c06750f42710c9b379bc3036841e9', 'edp-core-app_v1.0.zip', 'http://10.0.10.12:9000/wecube-artifact/647c06750f42710c9b379bc3036841e9_edp-core-app_v1.0.zip', '/edp-core-app_v1.0/start.sh', '/edp-core-app_v1.0/stop.sh', '0003_0000000002', '2019-07-25 00:23:45', 'admin'),
  	('0011_0000000015', NULL, '0011_0000000015', 'admin', '2019-09-09 07:52:20', 'admin', '2019-08-09 07:09:14', 'edp-core-app_v2.0.zip', 37, NULL, 'edp-core-app_v2.0.zip', 'edp-core-app_v2.0.zip', NULL, NULL, '', NULL, NULL, '/edp-core-app_v2.0/conf/app.conf', 'f562614ce56ca51e201d89c91adac2db', 'edp-core-app_v2.0.zip', 'http://10.0.10.12:9000/wecube-artifact/f562614ce56ca51e201d89c91adac2db_edp-core-app_v2.0.zip', '/edp-core-app_v2.0/start.sh', '/edp-core-app_v2.0/stop.sh', '0003_0000000002', '2019-08-09 15:09:14', 'admin');
  
  INSERT INTO `resource_set` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `asset_code`, `dcn`, `env`, `name`, `network_segment`, `resource_set_design`) VALUES
  	('0020_0000000001', '0020_0000000009', '0020_0000000001', 'admin', '2019-07-25 10:26:52', 'admin', '2019-07-24 07:35:30', 'PRD-GZ1-SF-RDCN-APPSET', 38, '2019-07-25 18:26:52', 'APP', 'APP', NULL, NULL, 'subnet-k46rteik', '0019_0000000001', 111, 'APP', '0021_0000000012', '0026_0000000001'),
  	('0020_0000000002', '0020_0000000008', '0020_0000000002', 'admin', '2019-07-25 10:08:03', 'admin', '2019-07-24 07:35:57', 'PRD-GZ1-SF-RDCN-DBSET', 39, '2019-07-25 18:08:03', 'DB', 'DB', NULL, '', 'subnet-blcu9vue', '0019_0000000001', 111, 'DB', '0021_0000000013', '0026_0000000002'),
  	('0020_0000000003', '0020_0000000012', '0020_0000000003', 'admin', '2019-07-25 13:06:45', 'admin', '2019-07-24 13:09:29', 'PRD-GZ1-DMZ-DMZ-PROXY', 38, '2019-07-25 21:06:45', 'PROXY', 'PROXY', NULL, NULL, 'subnet-ppvt3bw2', '0019_0000000005', 111, 'PROXY', '0021_0000000006', '0026_0000000005'),
  	('0020_0000000004', NULL, '0020_0000000004', 'admin', '2019-07-25 10:04:31', 'admin', '2019-07-24 13:10:59', 'PRD-GZ1-ECN-ECN-PROXY', 37, '2019-07-25 18:04:31', 'PROXY', 'PROXY', NULL, NULL, '', '0019_0000000006', 111, 'PROXY', '0021_0000000009', '0026_0000000006'),
  	('0020_0000000005', NULL, '0020_0000000005', 'admin', '2019-07-25 10:04:32', 'admin', '2019-07-24 13:11:35', 'PRD-GZ1-MGMT-MGMT-APPSET', 37, '2019-07-25 18:04:32', 'APPSET', 'APP', NULL, NULL, '', '0019_0000000007', 111, 'APP', '0021_0000000007', '0026_0000000007'),
  	('0020_0000000006', NULL, '0020_0000000006', 'admin', '2019-07-25 10:04:33', 'admin', '2019-07-24 13:12:03', 'PRD-GZ1-MGMT-MGMT-DBSET', 37, '2019-07-25 18:04:33', 'DBSET', 'DB', NULL, NULL, '', '0019_0000000007', 111, 'DB', '0021_0000000008', '0026_0000000008'),
  	('0020_0000000007', '0020_0000000010', '0020_0000000007', 'admin', '2019-07-25 10:26:52', 'admin', '2019-07-24 13:12:46', 'PRD-GZ1-SF-ADM-APPSET', 38, '2019-07-25 18:26:52', 'APPSET', 'APP', NULL, NULL, 'subnet-5gmttriu', '0019_0000000008', 111, 'APP', '0021_0000000010', '0026_0000000003'),
  	('0020_0000000008', '0020_0000000011', '0020_0000000002', 'admin', '2019-07-25 10:26:52', 'admin', '2019-07-24 07:35:57', 'PRD-GZ1-SF-RDCN-DBSET', 38, '2019-07-25 18:26:52', 'DB', 'DB', NULL, NULL, 'subnet-q20lxnqy', '0019_0000000001', 111, 'DB', '0021_0000000013', '0026_0000000002'),
  	('0020_0000000009', NULL, '0020_0000000001', 'admin', '2019-07-25 10:26:50', 'admin', '2019-07-24 07:35:30', 'PRD-GZ1-SF-RDCN-APPSET', 37, '2019-07-25 17:21:29', 'APP', 'APP', 225, 'rxek7WAq2Bi', 'subnet-k46rteik', '0019_0000000001', 111, 'APP', '0021_0000000012', '0026_0000000001'),
  	('0020_0000000010', NULL, '0020_0000000007', 'admin', '2019-07-25 10:26:50', 'admin', '2019-07-24 13:12:46', 'PRD-GZ1-SF-ADM-APPSET', 37, '2019-07-25 17:21:29', 'APPSET', 'APP', NULL, 'rxek7WAq2Bi', 'subnet-5gmttriu', '0019_0000000008', 111, 'APP', '0021_0000000010', '0026_0000000003'),
  	('0020_0000000011', NULL, '0020_0000000002', 'admin', '2019-07-25 10:26:50', 'admin', '2019-07-24 07:35:57', 'PRD-GZ1-SF-RDCN-DBSET', 37, '2019-07-25 17:21:29', 'DB', 'DB', NULL, 'rxek7WAq2Bi', 'subnet-blcu9vue', '0019_0000000001', 111, 'DB', '0021_0000000013', '0026_0000000002'),
  	('0020_0000000012', NULL, '0020_0000000003', 'admin', '2019-07-25 13:06:42', 'admin', '2019-07-24 13:09:29', 'PRD-GZ1-DMZ-DMZ-PROXY', 37, '2019-07-25 18:04:30', 'PROXY', 'PROXY', NULL, 'rxeYnnIy2Bv', '', '0019_0000000005', 111, 'PROXY', '0021_0000000006', '0026_0000000005'),
  	('0020_0000000013', NULL, '0020_0000000013', 'admin', '2019-07-25 13:46:44', 'admin', '2019-07-25 13:42:23', 'PRD-GZ1-PARTNERNET-API-USER', 37, '2019-07-25 21:46:44', 'USER', 'APP', NULL, 'rxf8rvAJ2Bi', 'subnet-16o81som', '0019_0000000013', 111, 'APP', '0021_0000000008', '0026_0000000011');
  
  INSERT INTO `resource_set_design` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `dcn_design`, `type`) VALUES
  	('0026_0000000001', NULL, '0026_0000000001', 'admin', '2019-07-23 13:53:55', 'admin', '2019-07-23 13:53:54', 'PRD-SF-RDCN-APPSET', 34, NULL, 'APPSET', '应用资源集设计', NULL, NULL, '0025_0000000001', 136),
  	('0026_0000000002', NULL, '0026_0000000002', 'admin', '2019-07-23 14:28:29', 'admin', '2019-07-23 14:28:29', 'PRD-SF-RDCN-DBSET', 34, NULL, 'DBSET', '数据库资源集设计', NULL, NULL, '0025_0000000001', 137),
  	('0026_0000000003', NULL, '0026_0000000003', 'admin', '2019-07-24 10:37:16', 'admin', '2019-07-24 10:37:16', 'PRD-SF-ADM-APPSET', 34, '', 'APPSET', '应用资源集设计', NULL, NULL, '0025_0000000005', 136),
  	('0026_0000000004', NULL, '0026_0000000004', 'admin', '2019-07-24 10:37:32', 'admin', '2019-07-24 10:37:32', 'PRD-SF-ADM-DBSET', 34, '', 'DBSET', '数据库资源集设计', NULL, NULL, '0025_0000000005', 137),
  	('0026_0000000005', NULL, '0026_0000000005', 'admin', '2019-07-24 10:38:13', 'admin', '2019-07-24 10:38:13', 'PRD-DMZ-DMZ-PROXY', 34, '', 'PROXY', '代理资源集设计', NULL, NULL, '0025_0000000002', 136),
  	('0026_0000000006', NULL, '0026_0000000006', 'admin', '2019-07-24 10:38:32', 'admin', '2019-07-24 10:38:32', 'PRD-ECN-ECN-PROXY', 34, '', 'PROXY', '代理资源集设计', NULL, NULL, '0025_0000000003', 136),
  	('0026_0000000007', NULL, '0026_0000000007', 'admin', '2019-07-24 10:39:00', 'admin', '2019-07-24 10:39:00', 'PRD-MGMT-MGMT-APPSET', 34, '', 'APPSET', '应用资源集设计', NULL, NULL, '0025_0000000004', 136),
  	('0026_0000000008', NULL, '0026_0000000008', 'admin', '2019-07-24 10:39:19', 'admin', '2019-07-24 10:39:19', 'PRD-MGMT-MGMT-DBSET', 34, '', 'DBSET', '数据库资源集设计', NULL, NULL, '0025_0000000004', 137),
  	('0026_0000000009', NULL, '0026_0000000009', 'admin', '2019-07-24 11:53:52', 'admin', '2019-07-24 11:53:52', 'PRD-INTERNET-H5-USER', 34, '', 'USER', '客户资源集', NULL, NULL, '0025_0000000006', 221),
  	('0026_0000000010', NULL, '0026_0000000010', 'admin', '2019-07-24 11:54:10', 'admin', '2019-07-24 11:54:10', 'PRD-INTRANET-WEB-USER', 34, '', 'USER', '客户资源集', NULL, NULL, '0025_0000000008', 221),
  	('0026_0000000011', NULL, '0026_0000000011', 'admin', '2019-07-24 11:54:33', 'admin', '2019-07-24 11:54:32', 'PRD-PARTNERNET-API-USER', 34, '', 'USER', '客户资源集', NULL, NULL, '0025_0000000007', 221);
  
  INSERT INTO `running_instance` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `asset_code`, `charge_type`, `host`, `instance_disk`, `instance_mem`, `instance_num`, `port`, `type`, `unit`) VALUES
  	('0015_0000000001', NULL, '0015_0000000001', 'admin', '2019-07-24 12:37:37', 'admin', '2019-07-24 12:08:43', 'ECIF-CORE_PRD-APP_APP_01', 40, '', 'APP_01', 'APP_01', NULL, NULL, '', 115, '0012_0000000003', 100, 2, 3, '', 174, '0008_0000000001'),
  	('0015_0000000002', NULL, '0015_0000000002', 'admin', '2019-07-24 12:37:55', 'admin', '2019-07-24 12:09:13', 'ECIF-INDEX_PRD-APP_APP_01', 40, '', 'APP_01', 'APP_01', NULL, NULL, '', 115, '0012_0000000002', 100, 2, 3, '', 174, '0008_0000000002'),
  	('0015_0000000003', NULL, '0015_0000000003', 'admin', '2019-07-24 12:39:37', 'admin', '2019-07-24 12:09:39', 'EDP-CORE_PRD-APP_APP_01', 40, '', 'APP_01', 'APP_01', NULL, NULL, '', 115, '0012_0000000003', 100, 2, 3, '', 174, '0008_0000000003'),
  	('0015_0000000004', NULL, '0015_0000000004', 'admin', '2019-08-09 07:30:12', 'admin', '2019-07-24 12:10:04', 'EDP-CONSOLE_PRD-APP_APP_01', 40, '', 'APP_01', 'APP_01', NULL, 'ryDjxIWF2Bj', '', 115, '0012_0000000003', 100, 2, 3, '', 174, '0008_0000000004'),
  	('0015_0000000005', NULL, '0015_0000000005', 'admin', '2019-07-25 15:36:18', 'admin', '2019-07-24 13:11:20', 'DEMO-WEB_PRD-APP_APP_01', 40, '2019-07-25 22:17:20', 'APP_01', 'APP_01', NULL, 'rxfA2pJJ2Bv', '', 115, '0012_0000000003', 100, 2, 3, '', 174, '0008_0000000005');
  
  INSERT INTO `service` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `dns_domain`, `dns_name`, `ha_type`, `service_design`, `service_ip`, `service_port`, `unit`) VALUES
  	('0009_0000000001', NULL, '0009_0000000001', 'admin', '2019-07-24 13:13:42', 'admin', '2019-07-24 13:13:42', 'DEMO-WEB_PRD-APP-SER1', 37, '', 'SER1', '服务1', NULL, NULL, 155, 'demo.wecube.com', 140, '0004_0000000006', '0014_0000000064', '', '0008_0000000005');
  
  INSERT INTO `service_design` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `ha_type`, `name`, `type`, `unit_design`) VALUES
  	('0004_0000000001', NULL, '0004_0000000001', 'admin', '2019-07-24 08:35:30', 'admin', '2019-07-23 14:02:15', 'EDP-CORE-APP-SER1', 34, '2019-07-24 16:35:30', 'SER1', '服务设计', NULL, NULL, 140, '服务1', 149, '0003_0000000002'),
  	('0004_0000000002', NULL, '0004_0000000002', 'admin', '2019-07-24 08:35:30', 'admin', '2019-07-24 03:43:44', 'EDP-CORE-DB-RW', 34, '2019-07-24 16:35:30', 'RW', '数据库服务读写', NULL, NULL, 142, '读写服务', 149, '0003_0000000003'),
  	('0004_0000000003', NULL, '0004_0000000003', 'admin', '2019-07-24 08:35:30', 'admin', '2019-07-24 03:45:42', 'EDP-CONSOLE-DB-RW', 34, '2019-07-24 16:35:30', 'RW', '数据库读写服务', NULL, NULL, 142, '读写服务', 149, '0003_0000000005'),
  	('0004_0000000004', NULL, '0004_0000000004', 'admin', '2019-07-24 08:35:30', 'admin', '2019-07-24 03:46:41', 'EDP-CONSOLE-APP-SER1', 34, '2019-07-24 16:35:30', 'SER1', '服务设计1', NULL, NULL, 140, '服务1', 150, '0003_0000000004'),
  	('0004_0000000005', NULL, '0004_0000000005', 'admin', '2019-07-24 12:58:41', 'admin', '2019-07-24 12:58:41', 'ECIF-CORE-APP-QUERY', 34, '', 'QUERY', '客户信息查询', NULL, NULL, 140, '信息查询', 150, '0003_0000000006'),
  	('0004_0000000006', NULL, '0004_0000000006', 'admin', '2019-07-24 13:18:02', 'admin', '2019-07-24 13:12:35', 'DEMO-WEB-APP-SER1', 34, '2019-07-24 21:18:02', 'SER1', '服务设计1', NULL, NULL, 140, '服务设计1', 150, '0003_0000000011'),
  	('0004_0000000007', NULL, '0004_0000000007', 'admin', '2019-07-24 13:44:06', 'admin', '2019-07-24 13:44:06', 'EDP-PROXY-PROXY-WEB', 34, '', 'WEB', 'WBE代理服务', NULL, NULL, 140, '代理服务', 150, '0003_0000000012');
  
  INSERT INTO `subsys` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `env`, `manager`, `subsys_design`) VALUES
  	('0007_0000000001', NULL, '0007_0000000001', 'admin', '2019-07-24 08:30:17', 'admin', '2019-07-24 06:40:03', 'ECIF-CORE_PRD', 37, '2019-07-24 16:30:17', 'CORE', 'ECIF-CORE PRD', NULL, NULL, 111, 'nertonsong', '0002_0000000010'),
  	('0007_0000000002', NULL, '0007_0000000002', 'admin', '2019-07-24 08:30:18', 'admin', '2019-07-24 06:40:25', 'ECIF-INDEX_PRD', 37, '2019-07-24 16:30:18', 'INDEX', 'ECIF-INDEX PRD', NULL, NULL, 111, 'nertonsong', '0002_0000000011'),
  	('0007_0000000003', NULL, '0007_0000000003', 'admin', '2019-07-24 08:30:18', 'admin', '2019-07-24 06:40:59', 'EDP-CORE_PRD', 37, '2019-07-24 16:30:18', 'CORE', 'EDP-CORE PRD', NULL, NULL, 111, 'irvingzhao', '0002_0000000001'),
  	('0007_0000000004', NULL, '0007_0000000004', 'admin', '2019-07-24 08:30:19', 'admin', '2019-07-24 06:41:18', 'EDP-CONSOLE_PRD', 37, '2019-07-24 16:30:19', 'CONSOLE', 'EDP-CONSOLE PRD', NULL, NULL, 111, 'irvingzhao', '0002_0000000003'),
  	('0007_0000000005', NULL, '0007_0000000005', 'admin', '2019-07-24 08:30:20', 'admin', '2019-07-24 06:41:34', 'EDP-BATCH_PRD', 37, '2019-07-24 16:30:20', 'BATCH', 'EDP-BATCH PRD', NULL, NULL, 111, 'irvingzhao', '0002_0000000004'),
  	('0007_0000000006', NULL, '0007_0000000006', 'admin', '2019-07-24 08:30:20', 'admin', '2019-07-24 06:41:50', 'EDP-GL_PRD', 37, '2019-07-24 16:30:20', 'GL', 'EDP-GL PRD', NULL, NULL, 111, 'irvingzhao', '0002_0000000005'),
  	('0007_0000000007', NULL, '0007_0000000007', 'admin', '2019-07-24 08:30:21', 'admin', '2019-07-24 06:42:07', 'EDP-ADMBATCH_PRD', 37, '2019-07-24 16:30:21', 'ADMBATCH', 'EDP-ADMBATCH PRD', NULL, NULL, 111, 'irvingzhao', '0002_0000000006'),
  	('0007_0000000008', NULL, '0007_0000000008', 'admin', '2019-07-24 08:30:23', 'admin', '2019-07-24 06:42:28', 'EDP-ADMCORE_PRD', 37, '2019-07-24 16:30:23', 'ADMCORE', 'EDP-ADMCORE PRD', NULL, NULL, 111, 'irvingzhao', '0002_0000000007'),
  	('0007_0000000009', NULL, '0007_0000000009', 'admin', '2019-07-24 08:30:24', 'admin', '2019-07-24 06:42:42', 'EDP-WEB_PRD', 37, '2019-07-24 16:30:24', 'WEB', 'EDP-WEB PRD', NULL, NULL, 111, 'irvingzhao', '0002_0000000009'),
  	('0007_0000000010', NULL, '0007_0000000010', 'admin', '2019-07-24 13:05:47', 'admin', '2019-07-24 13:05:47', 'DEMO-WEB_PRD', 37, '', 'WEB', 'DEMO-WEB PRD', NULL, NULL, 111, 'nertonsong', '0002_0000000012');
  
  INSERT INTO `subsys_design` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `business_group`, `dcn_design_type`, `name`, `system_design`) VALUES
  	('0002_0000000001', NULL, '0002_0000000001', 'admin', '2019-07-24 08:28:22', 'admin', '2019-07-23 13:29:24', 'EDP-CORE', 34, '2019-07-24 16:28:22', 'CORE', '联机子系统', NULL, NULL, 105, 135, '联机子系统', '0001_0000000001'),
  	('0002_0000000003', NULL, '0002_0000000003', 'admin', '2019-07-24 08:28:23', 'admin', '2019-07-24 03:29:39', 'EDP-CONSOLE', 34, '2019-07-24 16:28:23', 'CONSOLE', '管理台子系统', NULL, NULL, 105, 132, '管理台子系统', '0001_0000000001'),
  	('0002_0000000004', NULL, '0002_0000000004', 'admin', '2019-07-24 08:28:23', 'admin', '2019-07-24 03:32:47', 'EDP-BATCH', 34, '2019-07-24 16:28:23', 'BATCH', '批量子系统', NULL, NULL, 105, 135, '批量子系统', '0001_0000000001'),
  	('0002_0000000005', NULL, '0002_0000000005', 'admin', '2019-07-24 08:28:24', 'admin', '2019-07-24 03:34:31', 'EDP-GL', 34, '2019-07-24 16:28:24', 'GL', '小总账子系统', NULL, NULL, 105, 135, '小总账子系统', '0001_0000000001'),
  	('0002_0000000006', NULL, '0002_0000000006', 'admin', '2019-07-24 08:28:25', 'admin', '2019-07-24 03:37:56', 'EDP-ADMBATCH', 34, '2019-07-24 16:28:25', 'ADMBATCH', 'ADM批量子系统', NULL, NULL, 105, 132, 'ADM批量批量子系统', '0001_0000000001'),
  	('0002_0000000007', NULL, '0002_0000000007', 'admin', '2019-07-24 08:28:26', 'admin', '2019-07-24 03:39:07', 'EDP-ADMCORE', 34, '2019-07-24 16:28:26', 'ADMCORE', 'ADM联机子系统', NULL, NULL, 105, 132, 'ADM联机子系统', '0001_0000000001'),
  	('0002_0000000009', NULL, '0002_0000000009', 'admin', '2019-07-24 08:28:27', 'admin', '2019-07-24 03:53:46', 'EDP-WEB', 34, '2019-07-24 16:28:27', 'WEB', '管理台WEB子系统', NULL, NULL, 105, 126, '管理台WEB子系统', '0001_0000000001'),
  	('0002_0000000010', NULL, '0002_0000000010', 'admin', '2019-07-24 08:28:27', 'admin', '2019-07-24 06:28:18', 'ECIF-CORE', 34, '2019-07-24 16:28:27', 'CORE', '客户信息核心系统', NULL, NULL, 105, 135, '客户信息核心系统', '0001_0000000003'),
  	('0002_0000000011', NULL, '0002_0000000011', 'admin', '2019-07-24 08:28:28', 'admin', '2019-07-24 06:29:14', 'ECIF-INDEX', 34, '2019-07-24 16:28:28', 'INDEX', '客户信息索引', NULL, NULL, 105, 135, '客户信息索引', '0001_0000000003'),
  	('0002_0000000012', NULL, '0002_0000000012', 'admin', '2019-07-24 13:18:02', 'admin', '2019-07-24 13:05:01', 'DEMO-WEB', 34, '2019-07-24 21:18:02', 'WEB', '演示页面子系统', NULL, NULL, 105, 135, '演示系统', '0001_0000000004'),
  	('0002_0000000014', NULL, '0002_0000000014', 'admin', '2019-08-01 08:45:08', 'admin', '2019-07-24 13:42:03', 'EDP-PROXY', 34, '2019-08-01 16:45:08', 'PROXY', '代理子系统', NULL, NULL, 105, 129, '代理子系统', '0001_0000000001'),
  	('0002_0000000015', NULL, '0002_0000000015', 'admin', '2019-07-24 13:44:48', 'admin', '2019-07-24 13:44:48', 'EDP-CLIENT', 34, '', 'CLIENT', '管理台WEB客户端', NULL, NULL, 105, 126, 'WEB客户端', '0001_0000000001');
  
  INSERT INTO `system_design` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `business_group`, `name`) VALUES
  	('0001_0000000001', NULL, '0001_0000000001', 'admin', '2019-08-28 06:41:47', 'admin', '2019-07-23 13:22:11', 'EDP', 34, '2019-07-24 17:28:15', 'EDP', '存款微核心系统', NULL, NULL, 105, '存款微核心系统'),
  	('0001_0000000002', NULL, '0001_0000000002', 'admin', '2019-07-25 07:34:35', 'admin', '2019-07-24 03:23:47', 'PEBS', 34, '2019-07-24 17:28:16', 'PEBS', '个人网银系统', NULL, NULL, 105, '个人网银系统'),
  	('0001_0000000003', NULL, '0001_0000000003', 'admin', '2019-07-25 07:34:25', 'admin', '2019-07-24 06:25:10', 'ECIF', 34, '2019-07-24 17:28:17', 'ECIF', '客户信息管理系统', NULL, NULL, 105, '客户信息管理系统'),
  	('0001_0000000004', NULL, '0001_0000000004', 'admin', '2019-08-20 07:07:18', 'admin', '2019-07-24 13:03:56', 'DEMO', 34, '2019-07-24 21:18:02', 'DEMO', '演示系统', NULL, NULL, 105, '演示系统');
  
  INSERT INTO `unit` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `instance_num`, `package`, `subsys`, `unit_design`) VALUES
  	('0008_0000000001', NULL, '0008_0000000001', 'admin', '2019-07-24 08:30:35', 'admin', '2019-07-24 08:14:07', 'ECIF-CORE_PRD-APP', 37, '2019-07-24 16:30:35', 'APP', '', NULL, NULL, 1, '', '0007_0000000001', '0003_0000000006'),
  	('0008_0000000002', NULL, '0008_0000000002', 'admin', '2019-07-24 08:30:36', 'admin', '2019-07-24 08:15:04', 'ECIF-INDEX_PRD-APP', 37, '2019-07-24 16:30:36', 'APP', '', NULL, NULL, 1, '', '0007_0000000002', '0003_0000000008'),
  	('0008_0000000003', NULL, '0008_0000000003', 'admin', '2019-07-24 09:56:34', 'admin', '2019-07-24 08:15:31', 'EDP-CORE_PRD-APP', 37, '2019-07-24 16:30:37', 'APP', '', NULL, NULL, 1, '', '0007_0000000003', '0003_0000000002'),
  	('0008_0000000004', '0008_0000000008', '0008_0000000004', 'admin', '2019-08-09 07:34:16', 'admin', '2019-07-24 08:15:50', 'EDP-CONSOLE_PRD-APP', 38, NULL, 'APP', '', 235, NULL, 1, '', '0007_0000000004', '0003_0000000004'),
  	('0008_0000000005', NULL, '0008_0000000005', 'admin', '2019-08-12 02:23:37', 'admin', '2019-07-24 13:08:38', 'DEMO-WEB_PRD-APP', 37, '2019-08-12 10:21:34', 'APP', '', 235, 'rxfA2pJJ2Bv', 1, '0011_0000000010', '0007_0000000010', '0003_0000000011'),
  	('0008_0000000007', NULL, '0008_0000000007', 'admin', '2019-07-31 06:19:05', 'admin', '2019-07-31 06:19:05', 'ECIF-CORE_PRD-DB', 37, '', 'DB', 'aa', 231, '', 1, '0011_0000000010', '0007_0000000001', '0003_0000000007'),
  	('0008_0000000008', NULL, '0008_0000000004', 'admin', '2019-07-24 08:30:37', 'admin', '2019-07-24 08:15:50', 'EDP-CONSOLE_PRD-APP', 37, '2019-07-24 16:30:37', 'APP', '', NULL, NULL, 1, '', '0007_0000000004', '0003_0000000004');
  
  INSERT INTO `unit$resource_set` (`id`, `from_guid`, `to_guid`, `seq_no`) VALUES
  	(1, '0008_0000000001', '0020_0000000001', 1),
  	(2, '0008_0000000002', '0020_0000000001', 1),
  	(3, '0008_0000000003', '0020_0000000001', 1),
  	(7, '0008_0000000007', '0020_0000000001', 1),
  	(8, '0008_0000000008', '0020_0000000001', 0),
  	(9, '0008_0000000004', '0020_0000000001', 1),
  	(15, '0008_0000000005', '0020_0000000001', 0);
  
  INSERT INTO `unit_design` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `across_idc`, `name`, `resource_set_design`, `resource_set_design_type`, `subsys_design`, `type`) VALUES
  	('0003_0000000002', NULL, '0003_0000000002', 'admin', '2019-07-24 09:56:36', 'admin', '2019-07-23 14:00:57', 'EDP-CORE-APP', 35, '2019-07-24 17:56:36', 'APP', '应用模块', NULL, NULL, 147, '应用模块', '0026_0000000001', 136, '0002_0000000001', 106),
  	('0003_0000000003', NULL, '0003_0000000003', 'admin', '2019-07-24 08:28:59', 'admin', '2019-07-23 14:28:03', 'EDP-CORE-DB', 34, '2019-07-24 16:28:59', 'DB', '数据库模块', NULL, NULL, 147, '数据库模块', '0026_0000000001', 137, '0002_0000000001', 107),
  	('0003_0000000004', NULL, '0003_0000000004', 'admin', '2019-07-24 08:29:00', 'admin', '2019-07-24 03:40:34', 'EDP-CONSOLE-APP', 34, '2019-07-24 16:29:00', 'APP', '应用模块', NULL, NULL, 147, '应用模块', NULL, 136, '0002_0000000003', 106),
  	('0003_0000000005', NULL, '0003_0000000005', 'admin', '2019-07-24 08:29:00', 'admin', '2019-07-24 03:41:37', 'EDP-CONSOLE-DB', 34, '2019-07-24 16:29:00', 'DB', '数据库模块', NULL, NULL, 147, '数据库模块', NULL, 137, '0002_0000000003', 107),
  	('0003_0000000006', NULL, '0003_0000000006', 'admin', '2019-07-24 08:29:05', 'admin', '2019-07-24 08:01:24', 'ECIF-CORE-APP', 34, '2019-07-24 16:29:05', 'APP', '应用模块', NULL, NULL, 147, '应用模块', NULL, 136, '0002_0000000010', 106),
  	('0003_0000000007', NULL, '0003_0000000007', 'admin', '2019-07-24 08:30:00', 'admin', '2019-07-24 08:01:56', 'ECIF-CORE-DB', 34, '2019-07-24 16:30:00', 'DB', '数据库模块', NULL, NULL, 147, '数据库模块', NULL, 137, '0002_0000000010', 107),
  	('0003_0000000008', NULL, '0003_0000000008', 'admin', '2019-07-24 08:29:04', 'admin', '2019-07-24 08:02:39', 'ECIF-INDEX-APP', 34, '2019-07-24 16:29:04', 'APP', '应用模块', NULL, NULL, 147, '应用模块', NULL, 136, '0002_0000000011', 106),
  	('0003_0000000009', NULL, '0003_0000000009', 'admin', '2019-07-24 08:29:03', 'admin', '2019-07-24 08:02:58', 'ECIF-INDEX-DB', 34, '2019-07-24 16:29:03', 'DB', '数据库模块', NULL, NULL, 147, '数据库模块', NULL, 137, '0002_0000000011', 108),
  	('0003_0000000010', NULL, '0003_0000000002', 'admin', '2019-07-24 08:28:58', 'admin', '2019-07-23 14:00:57', 'EDP-CORE-APP', 34, '2019-07-24 16:28:58', 'APP', '应用模块', NULL, NULL, 147, '应用模块', '0026_0000000001', 136, '0002_0000000001', 106),
  	('0003_0000000011', NULL, '0003_0000000011', 'admin', '2019-07-24 13:18:02', 'admin', '2019-07-24 13:07:54', 'DEMO-WEB-APP', 34, '2019-07-24 21:18:02', 'APP', '应用模块', NULL, NULL, 147, '应用模块', NULL, 136, '0002_0000000012', 106),
  	('0003_0000000012', NULL, '0003_0000000012', 'admin', '2019-07-24 13:43:10', 'admin', '2019-07-24 13:43:10', 'EDP-PROXY-PROXY', 34, '', 'PROXY', '代理模块', NULL, NULL, 147, '代理模块', NULL, 136, '0002_0000000014', 106),
  	('0003_0000000013', NULL, '0003_0000000013', 'admin', '2019-07-24 13:45:52', 'admin', '2019-07-24 13:45:52', 'EDP-CLIENT-WEB', 34, '', 'WEB', 'WEB客户端', NULL, NULL, 147, '客户端', NULL, 221, '0002_0000000015', 106),
  	('0003_0000000015', NULL, '0003_0000000015', 'admin', '2019-07-25 11:14:45', 'admin', '2019-07-25 11:14:45', 'EDP-BATCH-APP', 34, '', 'APP', '应用模块', NULL, '', 147, '应用模块', NULL, 136, '0002_0000000004', 106),
  	('0003_0000000016', NULL, '0003_0000000016', 'admin', '2019-07-25 11:15:22', 'admin', '2019-07-25 11:15:22', 'EDP-GL-APP', 34, '', 'APP', '应用模块', NULL, '', 147, '应用模块', NULL, 136, '0002_0000000005', 106),
  	('0003_0000000018', NULL, '0003_0000000018', 'admin', '2019-07-25 11:17:36', 'admin', '2019-07-25 11:17:36', 'EDP-ADMBATCH-APP', 34, '', 'APP', '应用模块', NULL, '', 147, '应用模块', NULL, 136, '0002_0000000006', 106),
  	('0003_0000000019', NULL, '0003_0000000019', 'admin', '2019-07-25 11:18:05', 'admin', '2019-07-25 11:18:05', 'EDP-ADMCORE-APP', 34, '', 'APP', '应用模块', NULL, '', 147, '应用模块', NULL, 136, '0002_0000000007', 106),
  	('0003_0000000021', NULL, '0003_0000000021', 'admin', '2019-08-06 08:18:06', 'admin', '2019-08-06 08:18:05', 'EDP-CORE-test', 34, '', 'test', 'test', NULL, '', 146, 'test', NULL, 136, '0002_0000000001', 107);
  
  INSERT INTO `zone` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `asset_code`, `idc`, `name`, `network_segment`, `type`, `vpc`, `zone_design`, `zone_layer`) VALUES
  	('0017_0000000001', NULL, '0017_0000000001', 'admin', '2019-07-25 11:58:31', 'admin', '2019-07-24 07:05:16', 'PRD-GZ1-SF', 37, '2019-07-25 17:02:19', 'SF', 'SF', 229, 'rxek7WAq2Bi', 'vpc-1mopfr45', '0016_0000000001', 'SF', '0021_0000000002', 122, '', '0023_0000000001', 125),
  	('0017_0000000002', NULL, '0017_0000000002', 'admin', '2019-07-25 07:38:53', 'admin', '2019-07-24 07:06:17', 'PRD-GZ1-ECN', 37, '2019-07-25 15:38:53', 'ECN', 'ECN', 229, '', 'vpc-83gnp7dv', '0016_0000000001', 'ECN', '0021_0000000005', 120, '', '0023_0000000004', 124),
  	('0017_0000000003', NULL, '0017_0000000003', 'admin', '2019-07-25 12:29:44', 'admin', '2019-07-24 07:09:37', 'PRD-GZ1-MGMT', 37, NULL, 'MGMT', 'MGMT', 224, NULL, '', '0016_0000000001', 'MGMT', '0021_0000000004', 121, '', '0023_0000000003', 124),
  	('0017_0000000004', NULL, '0017_0000000004', 'admin', '2019-07-25 13:06:44', 'admin', '2019-07-24 07:10:14', 'PRD-GZ1-DMZ', 37, '2019-07-25 21:06:44', 'DMZ', 'DMZ', 224, 'rxeYnnIy2Bv', 'vpc-iq7kl2ld', '0016_0000000001', 'DMZ', '0021_0000000003', 119, '', '0023_0000000002', 124),
  	('0017_0000000005', NULL, '0017_0000000005', 'admin', '2019-07-25 13:46:43', 'admin', '2019-07-24 07:11:37', 'PRD-GZ1-PARTNERNET', 37, '2019-07-25 21:46:43', 'PARTNERNET', 'PARTNER', 224, 'rxf8rvAJ2Bi', 'vpc-hewlni6b', '0016_0000000001', 'PARTNER', '0021_0000000008', 117, '', '0023_0000000007', 123),
  	('0017_0000000006', NULL, '0017_0000000006', 'admin', '2019-08-08 09:28:39', 'admin', '2019-07-24 07:52:19', 'PRD-GZ1-INTERNET', 37, NULL, 'INTERNET', 'INTERNET', 224, NULL, '', '0016_0000000001', 'INTERNET', '', 116, '', '0023_0000000005', 123),
  	('0017_0000000007', NULL, '0017_0000000007', 'admin', '2019-07-24 12:11:52', 'admin', '2019-07-24 07:52:47', 'PRD-GZ1-INTRANET', 37, NULL, 'INTRANET', 'INTRANET', NULL, NULL, '', '0016_0000000001', 'INTRANET', '', 118, '', '0023_0000000006', 123);
  
  
  INSERT INTO `zone_design` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `idc_design`, `type`, `zone_layer`) VALUES
  	('0023_0000000001', NULL, '0023_0000000001', 'admin', '2019-07-23 13:52:47', 'admin', '2019-07-23 13:52:47', 'PRD-SF', 34, NULL, 'SF', 'SF区', NULL, NULL, '0022_0000000001', 122, 125),
  	('0023_0000000002', NULL, '0023_0000000002', 'admin', '2019-07-24 04:05:43', 'admin', '2019-07-24 04:05:42', 'PRD-DMZ', 34, NULL, 'DMZ', 'DMZ区', NULL, NULL, '0022_0000000001', 119, 124),
  	('0023_0000000003', NULL, '0023_0000000003', 'admin', '2019-07-24 04:06:11', 'admin', '2019-07-24 04:06:11', 'PRD-MGMT', 34, NULL, 'MGMT', 'MGMT', NULL, NULL, '0022_0000000001', 121, 124),
  	('0023_0000000004', NULL, '0023_0000000004', 'admin', '2019-07-24 04:06:43', 'admin', '2019-07-24 04:06:43', 'PRD-ECN', 34, NULL, 'ECN', 'ECN区', NULL, NULL, '0022_0000000001', 120, 124),
  	('0023_0000000005', NULL, '0023_0000000005', 'admin', '2019-07-24 04:07:08', 'admin', '2019-07-24 04:07:08', 'PRD-INTERNET', 34, NULL, 'INTERNET', '互联网', NULL, NULL, '0022_0000000001', 116, 123),
  	('0023_0000000006', NULL, '0023_0000000006', 'admin', '2019-07-24 04:07:32', 'admin', '2019-07-24 04:07:32', 'PRD-INTRANET', 34, NULL, 'INTRANET', '内部网', NULL, NULL, '0022_0000000001', 118, 123),
  	('0023_0000000007', NULL, '0023_0000000007', 'admin', '2019-07-24 04:08:10', 'admin', '2019-07-24 04:08:10', 'PRD-PARTNERNET', 34, NULL, 'PARTNERNET', '伙伴网', NULL, NULL, '0022_0000000001', 117, 123);
  
  INSERT INTO `zone_link` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `asset_code`, `name`, `zone1`, `zone2`, `zone_link_design`) VALUES
  	('0018_0000000002', NULL, '0018_0000000002', 'admin', '2019-07-24 12:28:49', 'admin', '2019-07-24 07:46:49', 'PRD-GZ1-MGMT_link_PRD-GZ1-SF', 37, NULL, 'MGMT-SF', '', NULL, NULL, '', 'MGMT-SF', '0017_0000000003', '0017_0000000001', '0024_0000000001'),
  	('0018_0000000003', NULL, '0018_0000000003', 'admin', '2019-07-24 12:28:50', 'admin', '2019-07-24 07:47:16', 'PRD-GZ1-MGMT_link_PRD-GZ1-ECN', 37, NULL, 'MGMT-ECN', '', NULL, NULL, '', 'MGMT-ECN', '0017_0000000003', '0017_0000000002', '0024_0000000005'),
  	('0018_0000000004', NULL, '0018_0000000004', 'admin', '2019-07-24 13:00:52', 'admin', '2019-07-24 07:47:34', 'PRD-GZ1-DMZ_link_PRD-GZ1-MGMT', 37, NULL, 'DMZ-MGMT', '', NULL, NULL, '', 'MGMT-DMZ', '0017_0000000004', '0017_0000000003', '0024_0000000004'),
  	('0018_0000000005', NULL, '0018_0000000005', 'admin', '2019-07-24 12:28:51', 'admin', '2019-07-24 07:47:54', 'PRD-GZ1-ECN_link_PRD-GZ1-SF', 37, NULL, 'ECN-SF', '', NULL, NULL, '', 'ECN-SF', '0017_0000000002', '0017_0000000001', '0024_0000000003'),
  	('0018_0000000006', NULL, '0018_0000000006', 'admin', '2019-07-24 12:28:52', 'admin', '2019-07-24 07:48:15', 'PRD-GZ1-DMZ_link_PRD-GZ1-SF', 37, NULL, 'DMZ-SF', '', NULL, NULL, '', 'DMZ-SF', '0017_0000000004', '0017_0000000001', '0024_0000000002'),
  	('0018_0000000007', NULL, '0018_0000000007', 'admin', '2019-07-24 12:28:52', 'admin', '2019-07-24 07:49:16', 'PRD-GZ1-PARTNERNET_link_PRD-GZ1-ECN', 37, NULL, 'PARTNERNET-ECN', '', NULL, NULL, '', 'PARTNERNET-ECN', '0017_0000000005', '0017_0000000002', '0024_0000000006'),
  	('0018_0000000008', NULL, '0018_0000000008', 'admin', '2019-07-24 12:28:53', 'admin', '2019-07-24 07:54:04', 'PRD-GZ1-INTERNET_link_PRD-GZ1-DMZ', 37, NULL, 'INTERNET-DMZ', '', NULL, NULL, '', 'INTERNET-DMZ', '0017_0000000006', '0017_0000000004', '0024_0000000007'),
  	('0018_0000000009', NULL, '0018_0000000009', 'admin', '2019-07-24 12:28:54', 'admin', '2019-07-24 07:54:33', 'PRD-GZ1-INTRANET_link_PRD-GZ1-MGMT', 37, NULL, 'INTRANET-MGMT', '', NULL, NULL, '', 'INTRANET-MGMT', '0017_0000000007', '0017_0000000003', '0024_0000000008');
  
  INSERT INTO `zone_link_design` (`guid`, `p_guid`, `r_guid`, `updated_by`, `updated_date`, `created_by`, `created_date`, `key_name`, `state`, `fixed_date`, `code`, `description`, `orchestration`, `biz_key`, `zone_design1`, `zone_design2`) VALUES
  	('0024_0000000001', NULL, '0024_0000000001', 'admin', '2019-07-24 07:38:36', 'admin', '2019-07-24 07:38:35', 'PRD-MGMT_link_PRD-SF', 34, NULL, 'MGMT-SF', 'MGMT-SF', NULL, NULL, '0023_0000000003', '0023_0000000001'),
  	('0024_0000000002', NULL, '0024_0000000002', 'admin', '2019-07-24 07:38:52', 'admin', '2019-07-24 07:38:52', 'PRD-DMZ_link_PRD-SF', 34, NULL, 'DMZ-SF', 'DMZ-SF', NULL, NULL, '0023_0000000002', '0023_0000000001'),
  	('0024_0000000003', NULL, '0024_0000000003', 'admin', '2019-07-24 07:39:13', 'admin', '2019-07-24 07:39:13', 'PRD-ECN_link_PRD-SF', 34, NULL, 'ECN-SF', 'ECN-SF', NULL, NULL, '0023_0000000004', '0023_0000000001'),
  	('0024_0000000004', NULL, '0024_0000000004', 'admin', '2019-07-24 10:24:53', 'admin', '2019-07-24 07:39:45', 'PRD-DMZ_link_PRD-MGMT', 34, NULL, 'MGMT-DMZ', 'MGMT-DMZ', NULL, NULL, '0023_0000000002', '0023_0000000003'),
  	('0024_0000000005', NULL, '0024_0000000005', 'admin', '2019-07-24 07:40:00', 'admin', '2019-07-24 07:40:00', 'PRD-MGMT_link_PRD-ECN', 34, NULL, 'MGMT-ECN', 'MGMT-ECN', NULL, NULL, '0023_0000000003', '0023_0000000004'),
  	('0024_0000000006', NULL, '0024_0000000006', 'admin', '2019-07-24 07:42:33', 'admin', '2019-07-24 07:42:33', 'PRD-PARTNERNET_link_PRD-ECN', 34, NULL, 'PARTNERNET-ECN', 'PARTNERNET-ECN', NULL, NULL, '0023_0000000007', '0023_0000000004'),
  	('0024_0000000007', NULL, '0024_0000000007', 'admin', '2019-07-24 07:43:05', 'admin', '2019-07-24 07:43:04', 'PRD-INTERNET_link_PRD-DMZ', 34, NULL, 'INTERNET-DMZ', 'INTERNET-DMZ', NULL, NULL, '0023_0000000005', '0023_0000000002'),
  	('0024_0000000008', NULL, '0024_0000000008', 'admin', '2019-07-24 07:43:40', 'admin', '2019-07-24 07:43:39', 'PRD-INTRANET_link_PRD-MGMT', 34, NULL, 'INTRANET-MGMT', 'INTRANET-MGMT', NULL, NULL, '0023_0000000006', '0023_0000000003');
  
  INSERT INTO `adm_integrate_template` (`id_adm_integrate_template`, `ci_type_id`, `name`, `des`) VALUES
  	(2, 1, '查询系统设计下的子系统', '查询系统设计下的子系统'),
  	(3, 2, '查询子系统下的单元', '查询子系统下的单元'),
  	(4, 12, '查询主机及运行实例', '查询主机及运行实例'),
  	(5, 19, '查询数据中心节点下的主机', '查询数据中心节点下的主机');
  
  INSERT INTO `adm_integrate_template_alias` (`id_alias`, `id_adm_ci_type`, `id_adm_integrate_template`, `alias`) VALUES
  	(11, 1, 2, '系统设计'),
  	(12, 2, 2, '2-1-子系统设计-系统设计'),
  	(13, 7, 2, '3-1-子系统-子系统设计'),
  	(14, 2, 3, '子系统设计'),
  	(15, 3, 3, '2-1-单元设计-子系统设计'),
  	(16, 8, 3, '3-1-单元-单元设计'),
  	(17, 12, 4, '主机'),
  	(18, 14, 4, '2-2-内网IP-使用'),
  	(19, 15, 4, '2-1-运行实例-主机'),
  	(20, 19, 5, '数据中心节点'),
  	(21, 20, 5, '2-1-资源集-DCN'),
  	(22, 12, 5, '3-1-主机-资源集');
  
  INSERT INTO `adm_integrate_template_alias_attr` (`id_attr`, `id_alias`, `id_ci_type_attr`, `is_condition`, `is_displayed`, `mapping_name`, `filter`, `key_name`, `seq_no`, `cn_alias`, `sys_attr`) VALUES
  	(13, 11, 8, '1', '1', '编码', NULL, 'systemDesign$code', 1, NULL, NULL),
  	(14, 11, 15, '1', '1', '名称', NULL, 'systemDesign$name', 1, NULL, NULL),
  	(15, 11, 16, '1', '1', '业务群组', NULL, 'systemDesign$businessGroup', 1, NULL, NULL),
  	(16, 12, 24, '1', '1', '编码', NULL, 'systemDesign-subsysDesign$code', 1, NULL, NULL),
  	(17, 12, 32, '1', '1', '名称', NULL, 'systemDesign-subsysDesign$name', 1, NULL, NULL),
  	(18, 13, 114, '1', '1', '编码', NULL, 'systemDesign-subsysDesign-subsys$code', 1, NULL, NULL),
  	(19, 13, 122, '1', '1', '环境', NULL, 'systemDesign-subsysDesign-subsys$env', 1, NULL, NULL),
  	(20, 14, 24, '1', '1', '编码', NULL, 'subsysDesign$code', 1, NULL, NULL),
  	(21, 14, 32, '1', '1', '名称', NULL, 'subsysDesign$name', 1, NULL, NULL),
  	(22, 14, 33, '1', '1', '业务群组', NULL, 'subsysDesign$businessGroup', 1, NULL, NULL),
  	(23, 15, 42, '1', '1', '编码', NULL, 'subsysDesign-unitDesign$code', 1, NULL, NULL),
  	(24, 15, 52, '1', '1', '名称', NULL, 'subsysDesign-unitDesign$name', 1, NULL, NULL),
  	(25, 16, 126, '1', '1', '状态', NULL, 'subsysDesign-unitDesign-unit$state', 1, NULL, NULL),
  	(26, 16, 131, '1', '1', '编码', NULL, 'subsysDesign-unitDesign-unit$code', 1, NULL, NULL),
  	(27, 17, 215, '1', '1', '编码', NULL, 'host$code', 1, NULL, NULL),
  	(28, 17, 223, '1', '1', '名称', NULL, 'host$name', 1, NULL, NULL),
  	(29, 17, 224, '1', '1', '类型', NULL, 'host$type', 1, NULL, NULL),
  	(30, 17, 226, '1', '1', '内网IP', NULL, 'host$intranetIp', 1, NULL, NULL),
  	(31, 17, 231, '1', '1', '资产编码', NULL, 'host$assetCode', 1, NULL, NULL),
  	(32, 18, 261, '1', '1', '编码', NULL, 'host-ipAddr$code', 1, NULL, NULL),
  	(33, 18, 270, '1', '1', 'IP网段', NULL, 'host-ipAddr$networkSegment', 1, NULL, NULL),
  	(34, 19, 278, '1', '1', '编码', NULL, 'host-runningInstance$code', 1, NULL, NULL),
  	(35, 19, 287, '1', '1', '端口', NULL, 'host-runningInstance$port', 1, NULL, NULL),
  	(36, 19, 290, '1', '1', '实例磁盘(GB)', NULL, 'host-runningInstance$instanceDisk', 1, NULL, NULL),
  	(37, 20, 362, '1', '1', '编码', NULL, 'dcn$code', 1, NULL, NULL),
  	(38, 20, 371, '1', '1', '名称', NULL, 'dcn$name', 1, NULL, NULL),
  	(39, 21, 379, '1', '1', '编码', NULL, 'dcn-resourceSet$code', 1, NULL, NULL),
  	(40, 21, 388, '1', '1', '名称', NULL, 'dcn-resourceSet$name', 1, NULL, NULL),
  	(41, 21, 389, '1', '1', '环境', NULL, 'dcn-resourceSet$env', 1, NULL, NULL),
  	(42, 22, 215, '1', '1', '编码', NULL, 'dcn-resourceSet-host$code', 1, NULL, NULL),
  	(43, 22, 223, '1', '1', '名称', NULL, 'dcn-resourceSet-host$name', 1, NULL, NULL),
  	(44, 22, 226, '1', '1', '内网IP', NULL, 'dcn-resourceSet-host$intranetIp', 1, NULL, NULL),
  	(45, 22, 231, '1', '1', '资产编码', NULL, 'dcn-resourceSet-host$assetCode', 1, NULL, NULL);
  
  INSERT INTO `adm_integrate_template_relation` (`id_relation`, `child_alias_id`, `child_ref_attr_id`, `parent_alias_id`, `is_refered_from_parent`) VALUES
  	(7, 12, 31, 11, 0),
  	(8, 13, 121, 12, 0),
  	(9, 15, 49, 14, 0),
  	(10, 16, 139, 15, 0),
  	(11, 18, 226, 17, 1),
  	(12, 19, 286, 17, 0),
  	(13, 21, 386, 20, 0),
  	(14, 22, 222, 21, 0);
  
  SET FOREIGN_KEY_CHECKS=1;