From 8e6c2879222d906759291370f86756681c5f51c4 Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 월, 15 11월 2021 13:05:16 +0900
Subject: [PATCH] 이슈관리 - 담당부서 추가
---
src/main/resources/migration/V1_1__Initial_Setup.sql | 6 ++++--
1 files changed, 4 insertions(+), 2 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..91a8e2d 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 (���왂�쟻) �궡蹂대궡湲�
--
Gitblit v1.8.0