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_1__Initial_Setup.sql | 94 +++++++++++++++++++++++----------------------- 1 files changed, 47 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) */; -- Gitblit v1.8.0