From dc873bdc1e57945d6cb6eadd41ef38cc2a4b35d3 Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 월, 15 11월 2021 17:21:18 +0900
Subject: [PATCH] 담당자 -> 담당부서 변경 * db날리고 실행
---
src/main/resources/migration/V1_1__Initial_Setup.sql | 12 ++++++++----
1 files changed, 8 insertions(+), 4 deletions(-)
diff --git a/src/main/resources/migration/V1_1__Initial_Setup.sql b/src/main/resources/migration/V1_1__Initial_Setup.sql
index 6dc56c9..b9d36b4 100644
--- a/src/main/resources/migration/V1_1__Initial_Setup.sql
+++ b/src/main/resources/migration/V1_1__Initial_Setup.sql
@@ -303,7 +303,8 @@
-- �뀒�씠釉� owl_en_1.5.issue_user 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
- `user_id` bigint(20) NOT NULL,
+ `user_id` bigint(20) NULL,
+ `department_id` bigint(20) NOT NULL,
`issue_id` bigint(20) NOT NULL,
`workspace_id` bigint(20) NOT NULL,
`register_id` bigint(20) NOT NULL,
@@ -314,7 +315,8 @@
KEY `userIdAndIssueIdIndex` (`user_id`,`issue_id`),
KEY `issueIdIndex` (`issue_id`),
KEY `workspaceIdIndex` (`workspace_id`),
- KEY `userIdIndex` (`user_id`)
+ KEY `userIdIndex` (`user_id`),
+ KEY `departmentIdIndex` (`department_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_user:~0 rows (���왂�쟻) �궡蹂대궡湲�
@@ -510,7 +512,8 @@
CREATE TABLE IF NOT EXISTS `project_role_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_role_id` bigint(20) NOT NULL,
- `user_id` bigint(20) NOT NULL,
+ `user_id` bigint(20) NULL,
+ `department_id` bigint(20) NULL,
`register_id` bigint(20) NOT NULL,
`register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`modify_id` bigint(20) NOT NULL,
@@ -518,7 +521,8 @@
PRIMARY KEY (`id`),
KEY `projectRoleIdAndUserIdIndex` (`project_role_id`,`user_id`),
KEY `userIdIndex` (`user_id`),
- KEY `projectRoleIdIndex` (`project_role_id`)
+ KEY `projectRoleIdIndex` (`project_role_id`),
+ KEY `departmentIdIndex` (`department_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.project_role_user:~0 rows (���왂�쟻) �궡蹂대궡湲�
--
Gitblit v1.8.0