-- --------------------------------------------------------
-- 호스트:                          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 */;
