From 482e3fa84615f83c455d56e68bab6bb5fd61866b Mon Sep 17 00:00:00 2001 From: jhjang <jhjang@maprex.co.kr> Date: 월, 27 12월 2021 11:25:11 +0900 Subject: [PATCH] - db 마이그레이션 autoincrement 관련 오류 수정 - db 마이그레이션 진흥원용 초기 데이터 파일 추가 --- src/main/resources/migration/V1_2__insert_default_data.sql | 143 +++++++++++++++++++++++++++++++++++ src/main/resources/migration/V1_1__Initial_Setup.sql | 94 +++++++++++----------- 2 files changed, 190 insertions(+), 47 deletions(-) diff --git a/src/main/resources/migration/V1_1__Initial_Setup.sql b/src/main/resources/migration/V1_1__Initial_Setup.sql index 06f5def..a21fd2a 100644 --- a/src/main/resources/migration/V1_1__Initial_Setup.sql +++ b/src/main/resources/migration/V1_1__Initial_Setup.sql @@ -23,7 +23,7 @@ `modify_date` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `userIdIndex` (`user_id`) USING BTREE - ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.attached_file 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `attached_file` ( @@ -44,7 +44,7 @@ PRIMARY KEY (`id`), KEY `issueIdIndex` (`issue_id`), KEY `workspaceIdIndex` (`workspace_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.company_field 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `company_field` ( @@ -65,7 +65,7 @@ KEY `urlIndex` (`url`), KEY `ispIdIndex` (`isp_id`), KEY `hostingIdIndex` (`hosting_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.custom_field 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `custom_field` ( @@ -82,7 +82,7 @@ `required_data` varchar(1) NOT NULL DEFAULT 'N', PRIMARY KEY (`id`), KEY `workspaceIdIndex` (`workspace_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.custom_field_api_default 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `custom_field_api_default` ( @@ -115,7 +115,7 @@ KEY `userIdIndex` (`user_id`) USING BTREE, KEY `issueTypeIdIndex` (`issue_type_id`) USING BTREE, KEY `projectIdIndex` (`project_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.custom_field_value 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `custom_field_value` ( @@ -140,7 +140,7 @@ `modify_id` bigint(20) NOT NULL, `modify_date` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE - ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.email_template 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `email_template` ( @@ -210,7 +210,7 @@ `modify_date` timestamp NULL DEFAULT NULL, `url` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE - ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.isp_field 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `isp_field` ( @@ -227,7 +227,7 @@ `modify_date` timestamp NULL DEFAULT NULL, `url` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE - ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue` ( @@ -254,7 +254,7 @@ KEY `projectIdIndex` (`project_id`), KEY `reverseIndex` (`reverse_index`), KEY `issueTypeIdIndex` (`issue_type_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_api_default 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_api_default` ( @@ -278,7 +278,7 @@ PRIMARY KEY (`id`) USING BTREE, KEY `userIdIndex` (`user_id`) USING BTREE, KEY `issueTypeIdIndex` (`issue_type_id`) USING BTREE - ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_comment 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_comment` ( @@ -312,7 +312,7 @@ `url` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `companyIdIndex` (`company_id`) USING BTREE - ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_custom_field_value 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_custom_field_value` ( @@ -329,7 +329,7 @@ KEY `customFieldIdIndex` (`custom_field_id`), KEY `issueTypeCustomFieldIdIndex` (`issue_type_custom_field_id`), KEY `issueIdIndex` (`issue_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_department 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_department` ( @@ -346,7 +346,7 @@ KEY `issueIdIndex` (`issue_id`), KEY `workspaceIdIndex` (`workspace_id`), KEY `departmentIdIndex` (`department_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_history 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_history` ( @@ -362,7 +362,7 @@ PRIMARY KEY (`id`), KEY `issueIdIndex` (`issue_id`), KEY `projectIdIndex` (`project_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_hosting 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_hosting` ( @@ -382,7 +382,7 @@ `url` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `hostingIdIndex` (`hosting_id`) USING BTREE - ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_isp 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_isp` ( @@ -402,7 +402,7 @@ `url` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, KEY `ispIdIndex` (`isp_id`) USING BTREE - ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_number_generator 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_number_generator` ( @@ -415,7 +415,7 @@ `modify_date` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `projectIdIndex` (`project_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_relation 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_relation` ( @@ -464,7 +464,7 @@ PRIMARY KEY (`id`), KEY `issueIdIndex` (`issue_id`), KEY `workspaceIdIndex` (`workspace_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_search 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_search` ( @@ -478,7 +478,7 @@ `modify_date` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `workspaceIdAndUserIdIndex` (`workspace_id`,`user_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_status 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_status` ( @@ -495,7 +495,7 @@ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date', PRIMARY KEY (`id`), KEY `workspaceIdIndex` (`workspace_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_table_config 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_table_config` ( @@ -513,7 +513,7 @@ KEY `workspaceIdAndUserIdIndex` (`workspace_id`,`user_id`), KEY `workspaceIdIndex` (`workspace_id`), KEY `issueTableTypeIndex` (`issue_table_type`) - ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_type 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_type` ( @@ -532,7 +532,7 @@ PRIMARY KEY (`id`), KEY `workspaceIdIndex` (`workspace_id`), KEY `workflowIdIndex` (`workflow_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_type_api_end_status 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_type_api_end_status` ( @@ -550,7 +550,7 @@ KEY `projectIdIndex` (`project_id`), KEY `issueTypeIdIndex` (`issue_type_id`), KEY `issueStatusIdIndex` (`issue_status_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_type_custom_field 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_type_custom_field` ( @@ -569,7 +569,7 @@ KEY `issueTypeIdIndex` (`issue_type_id`), KEY `customFieldIdIndex` (`custom_field_id`), KEY `projectIdAndIssueTypeIdIndex` (`project_id`,`issue_type_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.issue_user 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `issue_user` ( @@ -604,7 +604,7 @@ KEY `issueIdIndex` (`issue_id`), KEY `workspaceIdIndex` (`workspace_id`), KEY `projectIdIndex` (`project_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.notice 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `notice` ( @@ -663,7 +663,7 @@ `modify_id` bigint(20) NOT NULL, `modify_date` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) - ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.permission:~12 rows (���왂�쟻) �궡蹂대궡湲� /*!40000 ALTER TABLE `permission` DISABLE KEYS */; @@ -695,7 +695,7 @@ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id', `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date', PRIMARY KEY (`id`) - ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.project 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `project` ( @@ -715,7 +715,7 @@ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date', PRIMARY KEY (`id`), KEY `workspaceIdIndex` (`workspace_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='project'; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='project'; -- �뀒�씠釉� dev_db.project_closure 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `project_closure` ( @@ -729,7 +729,7 @@ PRIMARY KEY (`id`) USING BTREE, KEY `projectIdIndex` (`project_id`) USING BTREE, KEY `parentProjectIdIndex` (`parent_project_id`) USING BTREE - ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.project_role 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `project_role` ( @@ -743,7 +743,7 @@ `modify_date` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `projectIdIndex` (`project_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.project_role_department 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `project_role_department` ( @@ -758,7 +758,7 @@ KEY `projectRoleIdAndDepartmentIdIndex` (`project_role_id`,`department_id`), KEY `departmentIdIndex` (`department_id`), KEY `projectRoleIdIndex` (`project_role_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.project_role_permission 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `project_role_permission` ( @@ -771,7 +771,7 @@ `modify_date` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `projectRoleIdIndex` (`project_role_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.project_role_user 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `project_role_user` ( @@ -786,7 +786,7 @@ KEY `projectRoleIdAndUserIdIndex` (`project_role_id`,`user_id`), KEY `userIdIndex` (`user_id`), KEY `projectRoleIdIndex` (`project_role_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.qna 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `qna` ( @@ -854,7 +854,7 @@ `register_id` bigint(20) NOT NULL, `modify_id` bigint(20) NOT NULL, PRIMARY KEY (`id`) - ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.system_email 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `system_email` ( @@ -868,7 +868,7 @@ `register_date` timestamp NULL DEFAULT NULL, `modify_date` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) - ) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.system_role 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `system_role` ( @@ -880,7 +880,7 @@ `modify_id` bigint(20) NOT NULL, `modify_date` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) - ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.system_role:~2 rows (���왂�쟻) �궡蹂대궡湲� /*!40000 ALTER TABLE `system_role` DISABLE KEYS */; @@ -901,7 +901,7 @@ `modify_id` bigint(20) NOT NULL, `modify_date` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) - ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.system_role_permission:~18 rows (���왂�쟻) �궡蹂대궡湲� /*!40000 ALTER TABLE `system_role_permission` DISABLE KEYS */; @@ -940,7 +940,7 @@ PRIMARY KEY (`id`), KEY `userIdIndex` (`user_id`), KEY `systemRoleidIndex` (`system_role_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.user 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `user` ( @@ -968,7 +968,7 @@ `insert_type` varchar(1) NOT NULL DEFAULT 'N', PRIMARY KEY (`id`), KEY `levelIdIndex` (`level_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.user_department 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `user_department` ( @@ -980,7 +980,7 @@ `modify_id` bigint(20) NOT NULL, `modify_date` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE - ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.user_invite 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `user_invite` ( @@ -1022,7 +1022,7 @@ `default_yn` varchar(1) NOT NULL DEFAULT 'N', `basic_user` varchar(1) NOT NULL DEFAULT 'N', PRIMARY KEY (`id`) USING BTREE - ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.user_like_issue 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `user_like_issue` ( @@ -1067,7 +1067,7 @@ PRIMARY KEY (`id`), KEY `userIdIndex` (`user_id`), KEY `workspaceIdIndex` (`workspace_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.workflow 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `workflow` ( @@ -1082,7 +1082,7 @@ `modify_id` bigint(20) NOT NULL, PRIMARY KEY (`id`), KEY `workspaceIdIndex` (`workspace_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.workflow_department 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `workflow_department` ( @@ -1098,7 +1098,7 @@ KEY `workflowIdIndex` (`workflow_id`) USING BTREE, KEY `issueStatusIdIndex` (`issue_status_id`) USING BTREE, KEY `departmentIdIndex` (`department_id`) USING BTREE - ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.workflow_status 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `workflow_status` ( @@ -1115,7 +1115,7 @@ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id', `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date', PRIMARY KEY (`id`) USING BTREE - ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.workflow_transition 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `workflow_transition` ( @@ -1138,7 +1138,7 @@ KEY `workflowIdIndex` (`workflow_id`), KEY `sourceIssueStatusIdIndex` (`source_issue_status_id`), KEY `targetIssueStatusIdIndex` (`target_issue_status_id`) - ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- �뀒�씠釉� dev_db.workspace 援ъ“ �궡蹂대궡湲� CREATE TABLE IF NOT EXISTS `workspace` ( @@ -1155,7 +1155,7 @@ `modify_date` timestamp NULL DEFAULT NULL, `modify_id` bigint(20) NOT NULL, PRIMARY KEY (`id`) - ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4; + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!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) */; diff --git a/src/main/resources/migration/V1_2__insert_default_data.sql b/src/main/resources/migration/V1_2__insert_default_data.sql new file mode 100644 index 0000000..d82a7e2 --- /dev/null +++ b/src/main/resources/migration/V1_2__insert_default_data.sql @@ -0,0 +1,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 */; -- Gitblit v1.8.0