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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
| -- --------------------------------------------------------
| -- 호스트: 127.0.0.1
| -- 서버 버전: 10.5.8-MariaDB - mariadb.org binary distribution
| -- 서버 OS: Win64
| -- HeidiSQL 버전: 11.0.0.5919
| -- --------------------------------------------------------
|
| /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
| /*!40101 SET NAMES utf8 */;
| /*!50503 SET NAMES utf8mb4 */;
| /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
| /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
| -- 테이블 데이터 prod_db.custom_field:~7 rows (대략적) 내보내기
| DELETE FROM `custom_field`;
| /*!40000 ALTER TABLE `custom_field` DISABLE KEYS */;
| INSERT INTO `custom_field` (`id`, `workspace_id`, `name`, `custom_field_type`, `default_value`, `register_id`, `modify_id`, `register_date`, `modify_date`, `use_flag`, `required_data`) VALUES
| (1, 1, '탐지일시', 'DATETIME', '', 1, 1, '2021-12-03 15:45:42', '2021-12-03 15:45:42', 'Y', 'N'),
| (2, 1, '경유지', 'SITE', '', 1, 1, '2021-12-03 15:45:48', '2021-12-03 20:49:11', 'Y', 'N'),
| (3, 1, '국가', 'SINGLE_SELECT', '', 1, 1, '2021-12-03 15:47:05', '2021-12-03 15:47:05', 'Y', 'N'),
| (4, 1, '도메인', 'SITE', '', 1, 1, '2021-12-03 20:49:40', '2021-12-03 20:49:40', 'Y', 'N'),
| (5, 1, '유포지', 'IP_ADDRESS', '', 1, 1, '2021-12-06 09:03:18', '2021-12-06 09:16:50', 'Y', 'N'),
| (6, 1, '탐지패턴', 'INPUT', '', 1, 1, '2021-12-06 10:10:12', '2021-12-06 10:10:12', 'Y', 'N'),
| (7, 1, 'IP정보', 'IP_ADDRESS', '', 1, 1, '2021-12-14 13:19:22', '2021-12-14 13:19:22', 'Y', 'N');
| /*!40000 ALTER TABLE `custom_field` ENABLE KEYS */;
|
| -- 테이블 데이터 prod_db.issue_status:~22 rows (대략적) 내보내기
| DELETE FROM `issue_status`;
| /*!40000 ALTER TABLE `issue_status` DISABLE KEYS */;
| INSERT INTO `issue_status` (`id`, `workspace_id`, `issue_status_type`, `name`, `default_yn`, `color`, `position`, `register_id`, `register_date`, `modify_id`, `modify_date`) VALUES
| (1, 1, 'READY', '생성', 'Y', '#665fff', 1, 1, '2021-12-03 15:43:32', 1, '2021-12-03 15:43:32'),
| (2, 1, 'OPEN', '진행', 'Y', '#98c220', 2, 1, '2021-12-03 15:43:32', 1, '2021-12-03 15:43:32'),
| (3, 1, 'OPEN', '재진행', 'Y', '#c940ea', 3, 1, '2021-12-03 15:43:32', 1, '2021-12-03 15:43:32'),
| (4, 1, 'OPEN', '확인', 'Y', '#febd35', 4, 1, '2021-12-03 15:43:32', 1, '2021-12-03 15:43:32'),
| (5, 1, 'CLOSE', '종료', 'Y', '#888888', 5, 1, '2021-12-03 15:43:32', 1, '2021-12-03 15:43:32'),
| (6, 1, 'CLOSE', '승인 불가', 'Y', '#888888', 6, 1, '2021-12-03 15:43:32', 1, '2021-12-06 11:38:20'),
| (7, 1, 'CLOSE', '승인', 'Y', '#888888', 7, 1, '2021-12-03 15:43:32', 1, '2021-12-06 11:38:25'),
| (8, 1, 'READY', '탐지', 'N', '#febd35', 0, 1, '2021-12-03 20:22:13', 1, '2021-12-03 20:22:13'),
| (9, 1, 'OPEN', '1차 조치 완료', 'N', '#febd35', 0, 1, '2021-12-03 20:43:05', 1, '2021-12-03 20:43:05'),
| (10, 1, 'OPEN', '2차 조치 완료', 'N', '#febd35', 0, 1, '2021-12-03 20:43:15', 1, '2021-12-03 20:43:15'),
| (11, 1, 'OPEN', '3차 조치 완료', 'N', '#febd35', 0, 1, '2021-12-03 20:43:20', 1, '2021-12-03 20:43:20'),
| (12, 1, 'OPEN', '공문 발송 완료', 'N', '#febd35', 0, 1, '2021-12-03 20:43:34', 1, '2021-12-03 20:43:34'),
| (13, 1, 'CLOSE', '조치 완료', 'N', '#888888', 0, 1, '2021-12-03 20:43:46', 1, '2021-12-06 11:38:06'),
| (14, 1, 'CLOSE', '완전비협조', 'N', '#888888', 0, 1, '2021-12-03 20:44:00', 1, '2021-12-06 11:36:53'),
| (15, 1, 'OPEN', '차단검토요청', 'N', '#febd35', 0, 1, '2021-12-06 09:32:03', 1, '2021-12-06 09:32:03'),
| (16, 1, 'OPEN', '차단확인요청', 'N', '#febd35', 0, 1, '2021-12-06 09:32:09', 1, '2021-12-06 09:32:09'),
| (17, 1, 'CLOSE', '차단완료', 'N', '#888888', 0, 1, '2021-12-06 09:32:27', 1, '2021-12-06 11:38:12'),
| (18, 1, 'OPEN', '조치요청', 'N', '#febd35', 0, 1, '2021-12-06 09:32:32', 1, '2021-12-06 09:32:32'),
| (19, 1, 'OPEN', '조치확인요청', 'N', '#febd35', 0, 1, '2021-12-06 09:32:39', 1, '2021-12-06 09:32:39'),
| (21, 1, 'OPEN', '분석 요청', 'N', '#febd35', 0, 1, '2021-12-06 09:51:11', 1, '2021-12-06 09:51:11'),
| (22, 1, 'CLOSE', '접속 불가', 'N', '#888888', 0, 1, '2021-12-06 09:54:38', 1, '2021-12-06 11:37:04');
| /*!40000 ALTER TABLE `issue_status` ENABLE KEYS */;
|
| -- 테이블 데이터 prod_db.workflow:~4 rows (대략적) 내보내기
| DELETE FROM `workflow`;
| /*!40000 ALTER TABLE `workflow` DISABLE KEYS */;
| INSERT INTO `workflow` (`id`, `workspace_id`, `name`, `description`, `project_type`, `register_date`, `register_id`, `modify_date`, `modify_id`) VALUES
| (4, 1, '경유지 대응 워크플로우', NULL, NULL, '2021-12-03 20:48:19', 1, '2021-12-03 20:48:19', 1),
| (5, 1, '유포지 대응 워크플로우', NULL, NULL, '2021-12-06 09:41:02', 1, '2021-12-06 09:41:02', 1),
| (6, 1, '분석결과대응 워크플로우', NULL, NULL, '2021-12-06 09:47:20', 1, '2021-12-06 09:47:20', 1),
| (7, 1, '악성도메인 워크플로우', NULL, NULL, '2021-12-06 09:58:20', 1, '2021-12-06 09:58:20', 1);
| /*!40000 ALTER TABLE `workflow` ENABLE KEYS */;
|
| -- 테이블 데이터 prod_db.workflow_status:~35 rows (대략적) 내보내기
| DELETE FROM `workflow_status`;
| /*!40000 ALTER TABLE `workflow_status` DISABLE KEYS */;
| INSERT INTO `workflow_status` (`id`, `project_id`, `name`, `first_yn`, `last_yn`, `progress`, `color`, `position`, `register_id`, `register_date`, `modify_id`, `modify_date`) VALUES
| (1, 1, '오픈', 'Y', 'N', 0, '#047bf8', 0, 1, '2021-12-03 15:49:46', 1, '2021-12-03 15:49:46'),
| (2, 1, '할당', 'N', 'N', 20, '#e65252', 1, 1, '2021-12-03 15:49:46', 1, '2021-12-03 15:49:46'),
| (3, 1, '해결', 'N', 'N', 50, '#5bc0de', 2, 1, '2021-12-03 15:49:46', 1, '2021-12-03 15:49:46'),
| (4, 1, '확인', 'N', 'N', 70, '#5eb314', 3, 1, '2021-12-03 15:49:46', 1, '2021-12-03 15:49:46'),
| (5, 1, '종료', 'N', 'Y', 100, '#b17247', 4, 1, '2021-12-03 15:49:46', 1, '2021-12-03 15:49:46'),
| (6, 2, '오픈', 'Y', 'N', 0, '#047bf8', 0, 1, '2021-12-03 15:52:05', 1, '2021-12-03 15:52:05'),
| (7, 2, '할당', 'N', 'N', 20, '#e65252', 1, 1, '2021-12-03 15:52:05', 1, '2021-12-03 15:52:05'),
| (8, 2, '해결', 'N', 'N', 50, '#5bc0de', 2, 1, '2021-12-03 15:52:05', 1, '2021-12-03 15:52:05'),
| (9, 2, '확인', 'N', 'N', 70, '#5eb314', 3, 1, '2021-12-03 15:52:05', 1, '2021-12-03 15:52:05'),
| (10, 2, '종료', 'N', 'Y', 100, '#b17247', 4, 1, '2021-12-03 15:52:05', 1, '2021-12-03 15:52:05'),
| (11, 3, '오픈', 'Y', 'N', 0, '#047bf8', 0, 9, '2021-12-14 19:17:39', 9, '2021-12-14 19:17:39'),
| (12, 3, '할당', 'N', 'N', 20, '#e65252', 1, 9, '2021-12-14 19:17:39', 9, '2021-12-14 19:17:39'),
| (13, 3, '해결', 'N', 'N', 50, '#5bc0de', 2, 9, '2021-12-14 19:17:39', 9, '2021-12-14 19:17:39'),
| (14, 3, '확인', 'N', 'N', 70, '#5eb314', 3, 9, '2021-12-14 19:17:39', 9, '2021-12-14 19:17:39'),
| (15, 3, '종료', 'N', 'Y', 100, '#b17247', 4, 9, '2021-12-14 19:17:39', 9, '2021-12-14 19:17:39'),
| (16, 4, '오픈', 'Y', 'N', 0, '#047bf8', 0, 9, '2021-12-14 19:19:54', 9, '2021-12-14 19:19:54'),
| (17, 4, '할당', 'N', 'N', 20, '#e65252', 1, 9, '2021-12-14 19:19:54', 9, '2021-12-14 19:19:54'),
| (18, 4, '해결', 'N', 'N', 50, '#5bc0de', 2, 9, '2021-12-14 19:19:54', 9, '2021-12-14 19:19:54'),
| (19, 4, '확인', 'N', 'N', 70, '#5eb314', 3, 9, '2021-12-14 19:19:54', 9, '2021-12-14 19:19:54'),
| (20, 4, '종료', 'N', 'Y', 100, '#b17247', 4, 9, '2021-12-14 19:19:54', 9, '2021-12-14 19:19:54'),
| (21, 5, '오픈', 'Y', 'N', 0, '#047bf8', 0, 9, '2021-12-14 19:25:10', 9, '2021-12-14 19:25:10'),
| (22, 5, '할당', 'N', 'N', 20, '#e65252', 1, 9, '2021-12-14 19:25:10', 9, '2021-12-14 19:25:10'),
| (23, 5, '해결', 'N', 'N', 50, '#5bc0de', 2, 9, '2021-12-14 19:25:10', 9, '2021-12-14 19:25:10'),
| (24, 5, '확인', 'N', 'N', 70, '#5eb314', 3, 9, '2021-12-14 19:25:10', 9, '2021-12-14 19:25:10'),
| (25, 5, '종료', 'N', 'Y', 100, '#b17247', 4, 9, '2021-12-14 19:25:10', 9, '2021-12-14 19:25:10'),
| (26, 6, '오픈', 'Y', 'N', 0, '#047bf8', 0, 9, '2021-12-14 19:25:18', 9, '2021-12-14 19:25:18'),
| (27, 6, '할당', 'N', 'N', 20, '#e65252', 1, 9, '2021-12-14 19:25:18', 9, '2021-12-14 19:25:18'),
| (28, 6, '해결', 'N', 'N', 50, '#5bc0de', 2, 9, '2021-12-14 19:25:18', 9, '2021-12-14 19:25:18'),
| (29, 6, '확인', 'N', 'N', 70, '#5eb314', 3, 9, '2021-12-14 19:25:18', 9, '2021-12-14 19:25:18'),
| (30, 6, '종료', 'N', 'Y', 100, '#b17247', 4, 9, '2021-12-14 19:25:18', 9, '2021-12-14 19:25:18'),
| (31, 7, '오픈', 'Y', 'N', 0, '#047bf8', 0, 9, '2021-12-14 19:25:37', 9, '2021-12-14 19:25:37'),
| (32, 7, '할당', 'N', 'N', 20, '#e65252', 1, 9, '2021-12-14 19:25:37', 9, '2021-12-14 19:25:37'),
| (33, 7, '해결', 'N', 'N', 50, '#5bc0de', 2, 9, '2021-12-14 19:25:37', 9, '2021-12-14 19:25:37'),
| (34, 7, '확인', 'N', 'N', 70, '#5eb314', 3, 9, '2021-12-14 19:25:37', 9, '2021-12-14 19:25:37'),
| (35, 7, '종료', 'N', 'Y', 100, '#b17247', 4, 9, '2021-12-14 19:25:37', 9, '2021-12-14 19:25:37');
| /*!40000 ALTER TABLE `workflow_status` ENABLE KEYS */;
|
| -- 테이블 데이터 prod_db.workflow_transition:~30 rows (대략적) 내보내기
| DELETE FROM `workflow_transition`;
| /*!40000 ALTER TABLE `workflow_transition` DISABLE KEYS */;
| INSERT INTO `workflow_transition` (`id`, `workflow_id`, `source_issue_status_id`, `target_issue_status_id`, `source_x`, `source_y`, `target_x`, `target_y`, `correct_x`, `correct_y`, `direct`, `register_date`, `register_id`, `modify_date`, `modify_id`) VALUES
| (58, 6, 1, 15, 132, 71, 300, 74, 148, 69, 'N', '2021-12-06 09:52:14', 1, '2021-12-06 09:52:14', 1),
| (59, 6, 15, 16, 300, 74, 468, 73, 332, 72, 'N', '2021-12-06 09:52:14', 1, '2021-12-06 09:52:14', 1),
| (60, 6, 15, 18, 300, 74, 396, 188, 390, 88, 'N', '2021-12-06 09:52:14', 1, '2021-12-06 09:52:14', 1),
| (61, 6, 16, 17, 468, 73, 645, 75, 468, 73, 'N', '2021-12-06 09:52:14', 1, '2021-12-06 09:52:14', 1),
| (62, 6, 18, 19, 396, 188, 556, 213, 476, 129, 'N', '2021-12-06 09:52:14', 1, '2021-12-06 09:52:14', 1),
| (63, 6, 19, 18, 556, 213, 396, 188, 513, 232, 'N', '2021-12-06 09:52:14', 1, '2021-12-06 09:52:14', 1),
| (64, 6, 19, 13, 556, 213, 671, 215, 556, 213, 'N', '2021-12-06 09:52:14', 1, '2021-12-06 09:52:14', 1),
| (75, 7, 1, 21, 109, 36, 285, 38, 109, 36, 'N', '2021-12-10 14:32:25', 6, '2021-12-10 14:32:25', 6),
| (76, 7, 15, 16, 377, 159, 565, 172, 377, 159, 'N', '2021-12-10 14:32:25', 6, '2021-12-10 14:32:25', 6),
| (77, 7, 16, 17, 565, 172, 735, 179, 565, 172, 'N', '2021-12-10 14:32:25', 6, '2021-12-10 14:32:25', 6),
| (78, 7, 21, 22, 285, 38, 486, 37, 285, 38, 'N', '2021-12-10 14:32:25', 6, '2021-12-10 14:32:25', 6),
| (79, 7, 21, 15, 285, 38, 377, 159, 347, 43, 'N', '2021-12-10 14:32:25', 6, '2021-12-10 14:32:25', 6),
| (80, 5, 1, 15, 38, 41, 162, 33, 117, 35, 'N', '2021-12-10 14:43:10', 6, '2021-12-10 14:43:10', 6),
| (81, 5, 15, 16, 162, 33, 438, 30, 297, 30, 'N', '2021-12-10 14:43:10', 6, '2021-12-10 14:43:10', 6),
| (82, 5, 15, 18, 162, 33, 274, 154, 286, 43, 'N', '2021-12-10 14:43:10', 6, '2021-12-10 14:43:10', 6),
| (83, 5, 16, 17, 438, 30, 598, 30, 434, 30, 'N', '2021-12-10 14:43:10', 6, '2021-12-10 14:43:10', 6),
| (84, 5, 18, 19, 274, 154, 433, 195, 363, 218, 'N', '2021-12-10 14:43:10', 6, '2021-12-10 14:43:10', 6),
| (85, 5, 19, 18, 433, 195, 274, 154, 397, 82, 'N', '2021-12-10 14:43:10', 6, '2021-12-10 14:43:10', 6),
| (86, 5, 19, 13, 433, 195, 605, 181, 432, 195, 'N', '2021-12-10 14:43:10', 6, '2021-12-10 14:43:10', 6),
| (87, 4, 11, 12, 434, 227, 599, 211, 434, 227, 'N', '2021-12-13 17:01:35', 6, '2021-12-13 17:01:35', 6),
| (88, 4, 11, 13, 434, 227, 441, 30, 434, 227, 'N', '2021-12-13 17:01:35', 6, '2021-12-13 17:01:35', 6),
| (89, 4, 12, 14, 599, 211, 810, 153, 594, 218, 'N', '2021-12-13 17:01:35', 6, '2021-12-13 17:01:35', 6),
| (90, 4, 12, 13, 599, 211, 441, 30, 599, 211, 'N', '2021-12-13 17:01:35', 6, '2021-12-13 17:01:35', 6),
| (91, 4, 14, 13, 810, 153, 441, 30, 810, 153, 'N', '2021-12-13 17:01:35', 6, '2021-12-13 17:01:35', 6),
| (92, 4, 8, 9, 44, 69, 132, 167, 76, 93, 'N', '2021-12-13 17:01:36', 6, '2021-12-13 17:01:36', 6),
| (93, 4, 8, 13, 44, 69, 441, 30, 56, 69, 'N', '2021-12-13 17:01:36', 6, '2021-12-13 17:01:36', 6),
| (94, 4, 9, 10, 132, 167, 276, 236, 140, 171, 'N', '2021-12-13 17:01:36', 6, '2021-12-13 17:01:36', 6),
| (95, 4, 9, 13, 132, 167, 441, 30, 140, 171, 'N', '2021-12-13 17:01:36', 6, '2021-12-13 17:01:36', 6),
| (96, 4, 10, 11, 276, 236, 434, 227, 282, 223, 'N', '2021-12-13 17:01:36', 6, '2021-12-13 17:01:36', 6),
| (97, 4, 10, 13, 276, 236, 441, 30, 282, 223, 'N', '2021-12-13 17:01:36', 6, '2021-12-13 17:01:36', 6);
| /*!40000 ALTER TABLE `workflow_transition` ENABLE KEYS */;
|
| /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
| /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
| /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
