From b2b9e785e10c8fd59c3fcee8c8fda2aeb86be8c3 Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 월, 27 12월 2021 13:34:22 +0900
Subject: [PATCH] Merge branch 'master' of http://192.168.0.25:9001/r/owl-kisa
---
src/main/java/kr/wisestone/owl/service/impl/IssueServiceImpl.java | 106 ++--
src/main/java/kr/wisestone/owl/data/CheckIssueData.java | 45 --
src/main/resources/mybatis/query-template/companyField-template.xml | 3
src/main/java/kr/wisestone/owl/web/controller/ApiController.java | 44 -
src/main/java/kr/wisestone/owl/service/impl/WorkflowTransitionServiceImpl.java | 7
src/main/java/kr/wisestone/owl/constant/MsgConstants.java | 3
src/main/webapp/assets/styles/main.css | 2
src/main/resources/migration/V1_1__Initial_Setup.sql | 849 +++++++++++++++++++++++++-------------
/dev/null | 71 ---
src/main/resources/migration/V1_2__insert_default_data.sql | 143 ++++++
src/main/java/kr/wisestone/owl/domain/CustomFieldApiOverlap.java | 2
src/main/java/kr/wisestone/owl/util/CommonUtil.java | 28 +
src/main/java/kr/wisestone/owl/web/form/IssueApiForm.java | 9
src/main/java/kr/wisestone/owl/service/WorkflowTransitionService.java | 2
14 files changed, 837 insertions(+), 477 deletions(-)
diff --git a/src/main/java/kr/wisestone/owl/constant/MsgConstants.java b/src/main/java/kr/wisestone/owl/constant/MsgConstants.java
index 5a278a0..e581672 100644
--- a/src/main/java/kr/wisestone/owl/constant/MsgConstants.java
+++ b/src/main/java/kr/wisestone/owl/constant/MsgConstants.java
@@ -251,4 +251,7 @@
public static final String API_ISSUE_NOT_EXIST = "API_ISSUE_NOT_EXIST"; // �닔�젙�븷 �씠�뒋瑜� 李얠쓣�닔 �뾾�뒿�땲�떎.
public static final String API_COMPLETE_ISSUE_STATUS_NOT_EXIST = "API_COMPLETE_ISSUE_STATUS_NOT_EXIST"; // �옄�룞 醫낅즺 泥섎━�븷 �긽�깭媛� �꽕�젙�릺吏� �븡�븯�뒿�땲�떎.
public static final String API_ISSUE_STATUS_NOT_EXIST = "API_ISSUE_STATUS_NOT_EXIST"; // �씠�뒋 �긽�깭瑜� 李얠쓣�닔 �뾾�뒿�땲�떎
+ public static final String API_ISSUE_STATUS_IS_NULL = "API_ISSUE_STATUS_IS_NULL"; // �씠�뒋 �긽�깭 媛믪씠 �뾾�뒿�땲�떎.
+ public static final String API_CUSTOM_FIELD_NOT_EXIST = "API_CUSTOM_FIELD_NOT_EXIST"; // �궗�슜�옄 �젙�쓽 �븘�뱶瑜� 議댁옱�븯吏� �븡�뒿�땲�떎.
+ public static final String API_ISSUE_STATUS_NOT_IN_WORKFLOW = "API_ISSUE_STATUS_NOT_IN_WORKFLOW"; // �씠�뒋 �긽�깭媛� �썙�겕�뵆濡쒖슦�뿉 �룷�븿�릺�뼱 �엳吏� �븡�뒿�땲�떎
}
diff --git a/src/main/java/kr/wisestone/owl/data/CheckIssueData.java b/src/main/java/kr/wisestone/owl/data/CheckIssueData.java
index d4d60b5..17357ae 100644
--- a/src/main/java/kr/wisestone/owl/data/CheckIssueData.java
+++ b/src/main/java/kr/wisestone/owl/data/CheckIssueData.java
@@ -1,12 +1,8 @@
package kr.wisestone.owl.data;
-import kr.wisestone.owl.config.CommonConfiguration;
import kr.wisestone.owl.domain.*;
-import kr.wisestone.owl.service.*;
import kr.wisestone.owl.util.ConvertUtil;
import kr.wisestone.owl.web.form.IssueForm;
-import org.springframework.beans.factory.annotation.Autowired;
-
// issue �쑀�슚�꽦 泥댄겕�슜 �겢�옒�뒪
public class CheckIssueData {
@@ -18,48 +14,7 @@
Priority priority;
Severity severity;
- @Autowired
- private IssueService issueService;
-
- @Autowired
- private WorkspaceService workspaceService;
-
- @Autowired
- private ProjectService projectService;
-
- @Autowired
- private IssueStatusService issueStatusService;
-
- @Autowired
- private IssueTypeService issueTypeService;
-
- @Autowired
- private PriorityService priorityService;
-
- @Autowired
- private SeverityService severityService;
-
public CheckIssueData() {}
-
- public boolean CheckData(User user, IssueForm issueForm) {
- // �궗�슜�븯怨� �엳�뒗 �뾽臾� 怨듦컙�씠 �솢�꽦 �긽�깭�씤吏� �솗�씤�븳�떎. �궗�슜 怨듦컙�뿉�꽌 濡쒓렇�씤�븳 �궗�슜�옄媛� 鍮꾪솢�꽦�씤吏� �솗�씤�븳�떎.
- this.workspaceService.checkUseWorkspace(user, user.getLastWorkspaceId());
-
- Issue issue = this.issueService.getIssue(issueForm.getId());
- IssueStatus oldIssueStatus = issue.getIssueStatus();
- // �봽濡쒖젥�듃 �쑀�슚�꽦 泥댄겕
- Project project = this.projectService.getProject(issueForm.getProjectId());
- // �씠�뒋 �긽�깭 �쑀�슚�꽦 泥댄겕
- IssueStatus issueStatus = this.issueStatusService.getIssueStatus(issueForm.getIssueStatusId());
- // �씠�뒋 �쑀�삎 �쑀�슚�꽦 泥댄겕
- IssueType issueType = this.issueTypeService.getIssueType(issueForm.getIssueTypeId());
- // �슦�꽑�닚�쐞 �쑀�슚�꽦 泥댄겕
- Priority priority = this.priorityService.getPriority(issueForm.getPriorityId());
- // 以묒슂�룄 �쑀�슚�꽦 泥댄겕
- Severity severity = this.severityService.getSeverity(issueForm.getSeverityId());
-
- return true;
- }
public Issue getIssue() {
return issue;
diff --git a/src/main/java/kr/wisestone/owl/domain/CustomFieldApiOverlap.java b/src/main/java/kr/wisestone/owl/domain/CustomFieldApiOverlap.java
index 3d52d10..8f80889 100644
--- a/src/main/java/kr/wisestone/owl/domain/CustomFieldApiOverlap.java
+++ b/src/main/java/kr/wisestone/owl/domain/CustomFieldApiOverlap.java
@@ -24,7 +24,7 @@
@JoinColumn(name = "issue_type_id")
private IssueType issueType;
- @ManyToOne(fetch = FetchType.LAZY)
+ @ManyToOne(fetch = FetchType.EAGER)
@JoinColumn(name = "custom_field_id")
private CustomField customField;
diff --git a/src/main/java/kr/wisestone/owl/service/WorkflowTransitionService.java b/src/main/java/kr/wisestone/owl/service/WorkflowTransitionService.java
index 7be65a3..42c60f1 100644
--- a/src/main/java/kr/wisestone/owl/service/WorkflowTransitionService.java
+++ b/src/main/java/kr/wisestone/owl/service/WorkflowTransitionService.java
@@ -16,6 +16,8 @@
List<WorkflowTransition> findByWorkflowId(Long workflowId);
+ boolean contains(Long issueStatusId, Long workflowId);
+
List<WorkflowTransitionVo> findBySourceIssueStatusIdAndWorkflowId(Long sourceIssueStatusId, Long workflowId);
void modify(Workflow workflow, List<IssueStatusVo> issueStatusVos);
diff --git a/src/main/java/kr/wisestone/owl/service/impl/IssueServiceImpl.java b/src/main/java/kr/wisestone/owl/service/impl/IssueServiceImpl.java
index 5c2d587..8151068 100644
--- a/src/main/java/kr/wisestone/owl/service/impl/IssueServiceImpl.java
+++ b/src/main/java/kr/wisestone/owl/service/impl/IssueServiceImpl.java
@@ -187,6 +187,9 @@
private UserDepartmentService userDepartmentService;
@Autowired
+ private WorkflowTransitionService workflowTransitionService;
+
+ @Autowired
private UserDepartmentRepository userDepartmentRepository;
@Autowired
@@ -194,6 +197,9 @@
@Autowired
private WorkflowDepartmentRepository workflowDepartmentRepository;
+
+ @Autowired
+ WorkflowService workflowService;
@Override
protected JpaRepository<Issue, Long> getRepository() {
@@ -234,7 +240,6 @@
}
Workflow workflow = issueType.getWorkflow();
-
if (issueApiForm.getApiType().equals(IssueApiForm.ApiType.add)) {
// �씠�뒋 �긽�깭媛� 吏��젙�릺�뼱 �엳吏� �븡�쓣 寃쎌슦 �썙�겕�뵆濡쒖슦 ��湲� �긽�깭 媛믪쑝濡� 吏��젙
List<Long> departmentIds = this.workflowDepartmentService.findFirstDepartmentIds(workflow);
@@ -243,8 +248,15 @@
issueForm.addDepartmentId(departmentId);
}
}
- } else if (issueApiForm.getIssueStatusId() == null){
- throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.API_ISSUE_STATUS_NOT_EXIST));
+ } else {
+ if (issueApiForm.getIssueStatusId() == null){
+ throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.API_ISSUE_STATUS_IS_NULL));
+ }
+ // �썙�겕�뵆濡쒖슦�뿉�꽌 �궗�슜 以묒씤 �씠�뒋 �긽�깭�씤吏� 泥댄겕
+ else if (!this.workflowTransitionService.contains(issueApiForm.getIssueStatusId(), workflow.getId())) {
+ throw new OwlRuntimeException(
+ this.messageAccessor.getMessage(MsgConstants.API_ISSUE_STATUS_NOT_IN_WORKFLOW));
+ }
}
// �봽濡쒖젥�듃 �엯�젰
@@ -280,6 +292,20 @@
if (customFieldApiOverlaps != null && customFieldApiOverlaps.size() > 0) {
for (int i = 0; i < customFieldApiOverlaps.size(); i++) {
CustomFieldApiOverlap customFieldApiOverlap = customFieldApiOverlaps.get(i);
+ CustomField customField = customFieldApiOverlap.getCustomField();
+ if (customField.getCustomFieldType() == CustomFieldType.SITE) {
+ for (Map<String, Object> map : issueApiForm.getCustomFieldValues()) {
+ if (customField.getId().equals(MapUtil.getLong(map, "customFieldId"))) {
+ String fullUrl = MapUtil.getString(map, "useValue");
+ String url = CommonUtil.getUrl(fullUrl);
+ if (!url.equals("")) {
+ issueApiForm.setUrl(fullUrl);
+ break;
+ }
+ }
+ }
+
+ }
issueApiForm.addUseIssueCustomFieldId(customFieldApiOverlap.getCustomField().getId());
}
@@ -301,7 +327,7 @@
// �궗�슜�옄 �젙�쓽 �븘�뱶 �꽕�젙
issueForm.setIssueCustomFields(issueApiForm.getCustomFieldValues());
// 媛숈� �룄硫붿씤 �뾽泥� 李얘린
- this.findCompanyField(issueForm);
+ this.findCompanyField(issueForm, issueApiForm.getUrl());
// api �엯�젰媛� �쟻�슜
ConvertUtil.copyProperties(issueApiForm, issueForm);
@@ -313,45 +339,36 @@
}
}
- private void findCompanyField(IssueForm issueForm) {
+ private void findCompanyField(IssueForm issueForm, String url) {
if(issueForm.getIssueCustomFields() != null && issueForm.getIssueCustomFields().size() > 0) {
CompanyFieldCondition condition = new CompanyFieldCondition();
+ condition.setUrl(url);
List<Map<String, Object>> companyFields = this.companyFieldService.find(condition);
List<Map<String, Object>> issueCompanyFields = Lists.newArrayList();
List<Map<String, Object>> issueIspFields = Lists.newArrayList();
List<Map<String, Object>> issueHostingFields = Lists.newArrayList();
- for (Map<String, Object> issueCustomField : issueForm.getIssueCustomFields()) {
- int customFieldId = (Integer) issueCustomField.get("customFieldId");
- Long customId = (long) customFieldId;
- CustomField customField = this.customFieldService.getCustomField(customId);
- if(customField != null && customField.getCustomFieldType().toString().equals("SITE") && customField.getName().equals("�룄硫붿씤")) {
- String useValue = issueCustomField.get("useValue").toString();
- if(companyFields != null && companyFields.size() > 0) {
- for (Map<String, Object> companyField : companyFields) {
- CompanyFieldVo companyFieldVo = ConvertUtil.convertMapToClass(companyField, CompanyFieldVo.class);
- if(useValue.equals(companyFieldVo.getUrl())) {
- companyField.put("companyId", companyField.get("id"));
- issueCompanyFields.add(companyField);
- if(companyFieldVo.getIspId() != null) {
- Map<String, Object> ispField = this.ispFieldService.find(companyFieldVo.getIspId());
- if (ispField != null) {
- ispField.put("ispId", ispField.get("id"));
- issueIspFields.add(ispField);
- }
- }
- if(companyFieldVo.getHostingId() != null) {
- Map<String, Object> hostingField = this.hostingFieldService.find(companyFieldVo.getHostingId());
- if (hostingField != null) {
- hostingField.put("hostingId", hostingField.get("id"));
- issueHostingFields.add(hostingField);
- }
- }
- }
- }
- }
- }
+ if (companyFields != null && companyFields.size() > 0) {
+ Map<String, Object> companyFieldMap = companyFields.get(0);
+ companyFieldMap.put("companyId", companyFieldMap.get("id"));
+
+ issueCompanyFields.add(companyFieldMap);
issueForm.setIssueCompanyFields(issueCompanyFields);
+
+ IspField ispField = this.ispFieldService.getIsp(MapUtil.getLong(companyFieldMap, "ispId"));
+ if (ispField != null) {
+ Map<String, Object> ispFieldMap = ConvertUtil.convertObjectToMap(ispField);
+ ispFieldMap.put("ispId", ispField.getId());
+ issueIspFields.add(ispFieldMap);
+ }
+
+ HostingField hostingField = this.hostingFieldService.getHosting(MapUtil.getLong(companyFieldMap, "hostingId"));
+ if (hostingField != null) {
+ Map<String, Object> hostingFieldMap = ConvertUtil.convertObjectToMap(hostingField);
+ hostingFieldMap.put("hostingId", hostingField.getId());
+ issueHostingFields.add(hostingFieldMap);
+ }
+
issueForm.setIssueIspFields(issueIspFields);
issueForm.setIssueHostingFields(issueHostingFields);
}
@@ -928,7 +945,7 @@
// if (!this.userWorkspaceService.checkWorkspaceManager(user)
// && !MngPermission.checkMngPermission(userLevel.getPermission(), MngPermission.USER_PERMISSION_MNG_ISSUE)) { //理쒓퀬愿�由ъ옄 & �봽濡쒖젥�듃,�씠�뒋 愿�由ъ옄 �씪 寃쎌슦 紐⑤뱺 �씠�뒋 蹂닿린
// this.SetMyDepartmentId(issueCondition);
- //this.SetAllDepartmentId(issueCondition);
+ //this.SetAllDepartmentId(issueCondition);
// } /*else{
// results = this.issueMapper.findByDepartment(issueCondition);
// totalCount = this.issueMapper.countByDepartment(issueCondition);
@@ -1812,15 +1829,14 @@
Issue parentIssue = modifyIssue.getParentIssue();
IssueType issueType = modifyIssue.getIssueType();
- Set<IssueTypeApiEndStatus> issueTypeApiEndStatuses = issueType.getIssueTypeApiEndStatuses();
- IssueTypeApiEndStatus issueStatus = null;
- if (issueTypeApiEndStatuses != null && issueTypeApiEndStatuses.size() > 0) {
- issueStatus = issueTypeApiEndStatuses.iterator().next();
- } else {
- throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.API_COMPLETE_ISSUE_STATUS_NOT_EXIST));
- }
-
if (parentIssue != null) {
+ Set<IssueTypeApiEndStatus> issueTypeApiEndStatuses = issueType.getIssueTypeApiEndStatuses();
+ IssueTypeApiEndStatus issueStatus = null;
+ if (issueTypeApiEndStatuses != null && issueTypeApiEndStatuses.size() > 0) {
+ issueStatus = issueTypeApiEndStatuses.iterator().next();
+ } else {
+ throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.API_COMPLETE_ISSUE_STATUS_NOT_EXIST));
+ }
IssueCondition issueCondition = new IssueCondition(issueVo.getId(), parentIssue.getId());
List<Map<String, Object>> results = this.issueMapper.findNotCompleteByParentIssueId(issueCondition);
@@ -3448,7 +3464,7 @@
}
}
- // �궗�슜�옄 �젙�쓽 �븘�뱶 �젙蹂대�� IssueForm �뿉 ���옣�븳�떎.-
+ // �궗�슜�옄 �젙�쓽 �븘�뱶 �젙蹂대�� IssueForm �뿉 ���옣�븳�떎.
private void setIssueFormCustomFieldValue(Cell cell, Map<String, CustomField> customFieldMaps, IssueForm issueForm, String customFieldName, int rowIndex) {
if (cell != null) {
String cellValue = CommonUtil.convertExcelStringToCell(cell);
diff --git a/src/main/java/kr/wisestone/owl/service/impl/WorkflowTransitionServiceImpl.java b/src/main/java/kr/wisestone/owl/service/impl/WorkflowTransitionServiceImpl.java
index c2271c6..5fc42b4 100644
--- a/src/main/java/kr/wisestone/owl/service/impl/WorkflowTransitionServiceImpl.java
+++ b/src/main/java/kr/wisestone/owl/service/impl/WorkflowTransitionServiceImpl.java
@@ -131,6 +131,13 @@
return this.workflowTransitionRepository.findByWorkflowId(workflowId);
}
+ // �썙�겕�뵆濡쒖슦�뿉 �궗�슜�릺�뒗 �씠�뒋 �긽�깭�씤吏� �솗�씤�븳�떎
+ @Override
+ public boolean contains(Long issueStatusId, Long workflowId) {
+ List<WorkflowTransitionVo> workflowTransitionVos = this.findBySourceIssueStatusIdAndWorkflowId(issueStatusId, workflowId);
+ return workflowTransitionVos != null && workflowTransitionVos.size() > 0;
+ }
+
// �씠�뒋 �긽�깭�� �뿰寃곕맂 �쟾�씠�꽑 �젙蹂대�� 議고쉶�븳�떎.
@Override
@Transactional(readOnly = true)
diff --git a/src/main/java/kr/wisestone/owl/util/CommonUtil.java b/src/main/java/kr/wisestone/owl/util/CommonUtil.java
index afcb056..079f3a4 100644
--- a/src/main/java/kr/wisestone/owl/util/CommonUtil.java
+++ b/src/main/java/kr/wisestone/owl/util/CommonUtil.java
@@ -42,6 +42,8 @@
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.*;
+import java.util.regex.Matcher;
+import java.util.regex.Pattern;
public class CommonUtil {
private static final Logger LOGGER = LoggerFactory.getLogger(CommonUtil.class);
@@ -1005,4 +1007,30 @@
}
}
+ // 硫붿씤 url留� 異붿텧
+ public static String extractUrl(String content){
+ try {
+ String REGEX = "(http(s)?:\\/\\/)([a-z0-9\\w]+\\.*)+[a-z0-9]{2,4}";
+ Pattern p = Pattern.compile(REGEX, Pattern.CASE_INSENSITIVE);
+ Matcher m = p.matcher(content);
+ if (m.find()) {
+ return m.group();
+ }
+ return "";
+ } catch (Exception e) {
+ return "";
+ }
+ }
+
+ // 硫붿씤 url 異붿텧�쓣 �쐞�빐 http: �솗�씤
+ public static String getUrl(String fullUrl) {
+ if (fullUrl != null) {
+ if (fullUrl.indexOf("http") == -1) {
+ fullUrl = "http://" + fullUrl;
+ }
+
+ return extractUrl(fullUrl);
+ }
+ return "";
+ }
}
diff --git a/src/main/java/kr/wisestone/owl/web/controller/ApiController.java b/src/main/java/kr/wisestone/owl/web/controller/ApiController.java
index fb3a53a..5c13abc 100644
--- a/src/main/java/kr/wisestone/owl/web/controller/ApiController.java
+++ b/src/main/java/kr/wisestone/owl/web/controller/ApiController.java
@@ -3,16 +3,12 @@
import kr.wisestone.owl.constant.Constants;
import kr.wisestone.owl.constant.MsgConstants;
import kr.wisestone.owl.domain.Issue;
-import kr.wisestone.owl.domain.User;
import kr.wisestone.owl.exception.OwlRuntimeException;
import kr.wisestone.owl.service.IssueService;
import kr.wisestone.owl.util.ConvertUtil;
import kr.wisestone.owl.web.form.IssueApiForm;
import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.data.domain.Pageable;
-import org.springframework.http.MediaType;
import org.springframework.stereotype.Controller;
-import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
@@ -28,19 +24,6 @@
@Autowired
private IssueService issueService;
- // �씠�뒋 異붽�(json 諛⑹떇�쑝濡� �뙆�씪�쟾�넚)
-// @RequestMapping(value = "api/issue", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
-// public
-// @ResponseBody
-// Map<String, Object> addIssue(@RequestBody Map<String, Map<String, Object>> params) {
-// Map<String, Object> resJsonData = new HashMap<>();
-//
-// IssueApiForm issueForm = IssueApiForm.make(params.get(Constants.REQ_KEY_CONTENT));
-// Issue issue = this.issueService.addApiIssue(issueForm);
-// // 踰꾩쟾 �깮�꽦
-// this.issueService.addIssueVersion(issue.getId());
-// return this.setSuccessMessage(resJsonData);
-// }
@RequestMapping(value = "api/issue", method = RequestMethod.POST)
public
@ResponseBody
@@ -53,6 +36,11 @@
if (issueForm == null) {
throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.API_PARAMETER_ERROR));
}
+ // �궗�슜�옄 �젙�쓽 �븘�뱶媛� �뾾�쓣 寃쎌슦 寃��깋�쓣 �븷 �닔 �뾾湲� �븣臾몄뿉 �삁�쇅泥섎━
+ else if (issueForm.getCustomFieldValues() == null || issueForm.getCustomFieldValues().size() == 0) {
+ throw new OwlRuntimeException(this.messageAccessor.getMessage(MsgConstants.API_CUSTOM_FIELD_NOT_EXIST));
+ }
+
if (issueForm.getApiType() == IssueApiForm.ApiType.add) {
List<Issue> issues = this.issueService.addApiIssue(issueForm);
// 踰꾩쟾 �깮�꽦
@@ -60,6 +48,8 @@
this.issueService.addIssueVersion(issue.getId(), issue.getRegisterId());
}
} else {
+
+
this.issueService.modifyIssue(issueForm, request.getFiles("file"));
}
@@ -67,15 +57,15 @@
}
// �씠�뒋 議고쉶
- @RequestMapping(value = "/api/issueList", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
- public
- @ResponseBody
- Map<String, Object> find(@RequestBody Map<String, Map<String, Object>> params) {
- Map<String, Object> resJsonData = new HashMap<>();
- Pageable pageable = this.pageUtil.convertPageable(this.getPageVo(params));
-
- // todo
- return this.setSuccessMessage(resJsonData);
- }
+// @RequestMapping(value = "/api/issueList", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
+// public
+// @ResponseBody
+// Map<String, Object> find(@RequestBody Map<String, Map<String, Object>> params) {
+// Map<String, Object> resJsonData = new HashMap<>();
+// Pageable pageable = this.pageUtil.convertPageable(this.getPageVo(params));
+//
+// // todo
+// return this.setSuccessMessage(resJsonData);
+// }
}
diff --git a/src/main/java/kr/wisestone/owl/web/form/IssueApiForm.java b/src/main/java/kr/wisestone/owl/web/form/IssueApiForm.java
index 698375e..42c5467 100644
--- a/src/main/java/kr/wisestone/owl/web/form/IssueApiForm.java
+++ b/src/main/java/kr/wisestone/owl/web/form/IssueApiForm.java
@@ -31,6 +31,7 @@
private List<Map<String, Object>> CustomFieldValues = Lists.newArrayList();
private List<MultipartFile> multipartFiles = Lists.newArrayList();
private List<Long> useIssueCustomFieldIds = Lists.newArrayList(); // �궗�쐞�씪媛먯슜 �궗�슜�옄�븘�뱶媛�
+ private String url; // �깘吏� �떆�뒪�뀥�뿉�꽌留� �쟻�슜
public IssueApiForm() {
}
@@ -228,4 +229,12 @@
this.useIssueCustomFieldIds.add(customFieldId);
}
}
+
+ public String getUrl() {
+ return url;
+ }
+
+ public void setUrl(String url) {
+ this.url = url;
+ }
}
diff --git a/src/main/resources/migration/V1_10__Alter_Table.sql b/src/main/resources/migration/V1_10__Alter_Table.sql
deleted file mode 100644
index 9cca17d..0000000
--- a/src/main/resources/migration/V1_10__Alter_Table.sql
+++ /dev/null
@@ -1,26 +0,0 @@
-ALTER TABLE `user` DROP COLUMN `permission`;
-ALTER TABLE `user` ADD COLUMN `level_id` BIGINT(11) NULL;
-
-CREATE TABLE `department`(
- `id` BIGINT(11) AUTO_INCREMENT,
- `department_name` VARCHAR(50) NOT NULL,
- `department_description` VARCHAR(255) NULL,
- `register_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `modify_date` TIMESTAMP NULL,
- PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE `user_level`(
- `id` BIGINT(11) AUTO_INCREMENT,
- `level_name` VARCHAR(50) NOT NULL,
- `permission` INT NULL,
- `register_id` BIGINT(20) NOT NULL COMMENT 'register_id',
- `register_date` TIMESTAMP NULL COMMENT 'register_date',
- `modify_id` BIGINT(20) NOT NULL COMMENT 'modify_id',
- `modify_date` TIMESTAMP NULL COMMENT 'modify_date',
- `default_yn` VARCHAR (1) NOT NULL DEFAULT 'N',
- `basic_user` VARCHAR (1) NOT NULL DEFAULT 'N',
- PRIMARY KEY (`id`) USING btree
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
\ No newline at end of file
diff --git a/src/main/resources/migration/V1_11__Alter_Table.sql b/src/main/resources/migration/V1_11__Alter_Table.sql
deleted file mode 100644
index 9fa9b72..0000000
--- a/src/main/resources/migration/V1_11__Alter_Table.sql
+++ /dev/null
@@ -1,214 +0,0 @@
-CREATE TABLE `company_field`(
- `id` BIGINT(11) AUTO_INCREMENT,
- `name` VARCHAR(50) NOT NULL,
- `manager` VARCHAR(50) NULL,
- `tel` VARCHAR (50) NULL,
- `email` VARCHAR (255) NULL,
- `memo` VARCHAR(255) NULL,
- `register_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `modify_date` TIMESTAMP NULL,
- PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE `isp_field`(
- `id` BIGINT(11) AUTO_INCREMENT,
- `code` varchar (50) NOT NULL,
- `name` VARCHAR(50) NOT NULL,
- `manager` VARCHAR(50) NULL,
- `tel` VARCHAR (50) NULL,
- `email` VARCHAR (255) NULL,
- `memo` VARCHAR(255) NULL,
- `register_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `modify_date` TIMESTAMP NULL,
- PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-
-CREATE TABLE `hosting_field`(
- `id` BIGINT(11) AUTO_INCREMENT,
- `code` VARCHAR(50) NOT NULL,
- `name` VARCHAR(50) NOT NULL,
- `manager` VARCHAR(50) NULL,
- `tel` VARCHAR (50) NULL,
- `email` VARCHAR (255) NULL,
- `memo` VARCHAR(255) NULL,
- `register_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `modify_date` TIMESTAMP NULL,
- PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE `user_department`(
- `id` BIGINT(11) AUTO_INCREMENT,
- `department_id` BIGINT(11),
- `user_id` BIGINT(11),
- `register_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `modify_date` TIMESTAMP NULL,
- PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-
--- api 愿��젴
-ALTER TABLE `user` ADD COLUMN `insert_type` VARCHAR(1) NOT NULL DEFAULT 'N';
-
-CREATE TABLE `api_token`(
- `id` BIGINT(11) AUTO_INCREMENT,
- `user_id` BIGINT(50) NOT NULL,
- `app_name` VARCHAR(50) NOT NULL,
- `token` VARCHAR(1024) NOT NULL,
- `register_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `modify_date` TIMESTAMP NULL,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `userIdIndex` (`user_id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE `issue_api_default`(
- `id` BIGINT(11) AUTO_INCREMENT,
- `user_id` BIGINT(11) NOT NULL,
- `issue_type_id` bigint(11) NOT NULL,
- `issue_status_id` bigint(20) DEFAULT NULL,
- `project_id` bigint(20) DEFAULT NULL,
- `priority_id` bigint(20) DEFAULT NULL,
- `severity_id` bigint(20) DEFAULT NULL,
- `title` varchar(300) DEFAULT NULL,
- `description` mediumtext COMMENT 'description',
- `reverse_index` bigint(20) DEFAULT NULL,
- `issue_number` bigint(20) DEFAULT NULL,
- `start_date` varchar(20) DEFAULT NULL,
- `complete_date` varchar(20) DEFAULT NULL,
- `register_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `modify_date` TIMESTAMP NULL,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `userIdIndex` (`user_id`) USING BTREE,
- INDEX `issueTypeIdIndex` (`issue_type_id`) USING BTREE
-
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE `custom_field_api_default`(
- `id` BIGINT(11) AUTO_INCREMENT,
- `user_id` BIGINT(11) NOT NULL,
- `issue_type_id` BIGINT(11) NOT NULL,
- `custom_field_id` BIGINT(11) NOT NULL,
- `custom_field_value` varchar(300) NOT NULL,
- `register_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `modify_date` TIMESTAMP NULL,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `userIdIndex` (`user_id`) USING BTREE,
- INDEX `issueTypeIdIndex` (`issue_type_id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE `custom_field_api_overlap`(
- `id` BIGINT(11) AUTO_INCREMENT,
- `user_id` BIGINT(11) NOT NULL,
- `issue_type_id` BIGINT(11) NOT NULL,
- `custom_field_id` BIGINT(11) NOT NULL,
- `register_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `modify_date` TIMESTAMP NULL,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `userIdIndex` (`user_id`) USING BTREE,
- INDEX `issueTypeIdIndex` (`issue_type_id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
--- �씠�뒋 ���엯 �봽濡쒖젥�듃
-ALTER TABLE `issue_type` ADD COLUMN `project_id` BIGINT(11) NULL;
-
--- �긽�쐞 �씠�뒋
-ALTER TABLE `issue` ADD COLUMN `parent_issue_id` BIGINT(11) NULL;
-
-CREATE TABLE `issue_company` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `issue_id` bigint(20) NOT NULL,
- `company_id` bigint(20) DEFAULT NULL,
- `name` VARCHAR(50) NULL,
- `manager` VARCHAR(50) NULL,
- `tel` VARCHAR (50) NULL,
- `email` VARCHAR (255) NULL,
- `memo` VARCHAR(255) NULL,
- `register_id` bigint(20) NOT NULL COMMENT 'register_id',
- `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
- `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
- `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `companyIdIndex` (`company_id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE `issue_hosting` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `issue_id` bigint(20) NOT NULL,
- `hosting_id` bigint(20) DEFAULT NULL,
- `name` VARCHAR(50) NULL,
- `code` VARCHAR(50) NULL,
- `manager` VARCHAR(50) NULL,
- `tel` VARCHAR (50) NULL,
- `email` VARCHAR (255) NULL,
- `memo` VARCHAR(255) NULL,
- `register_id` bigint(20) NOT NULL COMMENT 'register_id',
- `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
- `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
- `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `hostingIdIndex` (`hosting_id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE `issue_isp` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `issue_id` bigint(20) NOT NULL,
- `isp_id` bigint(20) DEFAULT NULL,
- `name` VARCHAR(50) NULL,
- `code` VARCHAR(50) NULL,
- `manager` VARCHAR(50) NULL,
- `tel` VARCHAR (50) NULL,
- `email` VARCHAR (255) NULL,
- `memo` VARCHAR(255) NULL,
- `register_id` bigint(20) NOT NULL COMMENT 'register_id',
- `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
- `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
- `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `ispIdIndex` (`isp_id`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
--- �씠�뒋 �뀒�씠釉� ���엯 �꽕�젙(1: 硫붿씤, 2: �뿰愿�, 3: �븯�쐞)
-ALTER TABLE `issue_table_config` ADD COLUMN `issue_type_id` BIGINT(20) NOT NULL;
-ALTER TABLE `issue_table_config` ADD COLUMN `issue_table_type` INT(11) NOT NULL;
-ALTER TABLE `issue_table_config` ADD INDEX `issueTableTypeIndex`(`issue_table_type`);
-
--- issue_risk �뀒�씠釉� 遺��꽌蹂�寃� 移댁슫�듃 而щ읆 異붽�
-ALTER TABLE `issue_risk` ADD COLUMN `change_department_count` BIGINT(20) NOT NULL DEFAULT '0';
-
--- �썙�겕 �뵆濡쒖슦 �긽�깭 �떞�떦遺��꽌 吏��젙
-CREATE TABLE `workflow_department`(
- `id` BIGINT(11) AUTO_INCREMENT,
- `workflow_id` BIGINT(11),
- `issue_status_id` BIGINT(11),
- `department_id` BIGINT(11),
- `register_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `modify_date` TIMESTAMP NULL,
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `workflowIdIndex` (`workflow_id`) USING BTREE,
- INDEX `issueStatusIdIndex` (`issue_status_id`) USING BTREE,
- INDEX `departmentIdIndex` (`department_id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
--- issue_type �뀒�씠釉� �뾽泥�,ISP,�샇�뒪�똿 而щ읆 異붽�
-ALTER TABLE `issue_type` ADD COLUMN `use_partner` BIGINT(11) NOT NULL DEFAULT '0';
-
--- api �씠�뒋 �뿬遺�
-ALTER TABLE `issue` ADD COLUMN `is_api` VARCHAR(1) NOT NULL DEFAULT 'N';
diff --git a/src/main/resources/migration/V1_12__Alter_Table.sql b/src/main/resources/migration/V1_12__Alter_Table.sql
deleted file mode 100644
index 9944ff1..0000000
--- a/src/main/resources/migration/V1_12__Alter_Table.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `user` ADD INDEX `levelIdIndex`(`level_id`);
\ No newline at end of file
diff --git a/src/main/resources/migration/V1_13__Alter_Table.sql b/src/main/resources/migration/V1_13__Alter_Table.sql
deleted file mode 100644
index 36a476b..0000000
--- a/src/main/resources/migration/V1_13__Alter_Table.sql
+++ /dev/null
@@ -1,17 +0,0 @@
--- �븘�닔 �뜲�씠�꽣 �뿬遺�
-ALTER TABLE `custom_field` ADD COLUMN `required_data` VARCHAR(1) NOT NULL DEFAULT 'N';
-
--- url �빆紐� 異붽�
-ALTER TABLE `company_field` ADD COLUMN `url` VARCHAR(255) NULL;
-ALTER TABLE `isp_field` ADD COLUMN `url` VARCHAR(255) NULL;
-ALTER TABLE `hosting_field` ADD COLUMN `url` VARCHAR(255) NULL;
-
-ALTER TABLE `issue_company` ADD COLUMN `url` VARCHAR(255) NULL;
-ALTER TABLE `issue_isp` ADD COLUMN `url` VARCHAR(255) NULL;
-ALTER TABLE `issue_hosting` ADD COLUMN `url` VARCHAR(255) NULL;
-
--- �옄�룞 �셿猷� �긽�깭 異붽�
-ALTER TABLE `issue_type` ADD COLUMN `complete_issue_status_id` BIGINT(20) NULL;
-
--- �뾽泥댁쓽 url 而щ읆 INDEX 異붽�
-ALTER TABLE `company_field` ADD INDEX `urlIndex`(`url`);
diff --git a/src/main/resources/migration/V1_14__Alter_Table.sql b/src/main/resources/migration/V1_14__Alter_Table.sql
deleted file mode 100644
index 60751c8..0000000
--- a/src/main/resources/migration/V1_14__Alter_Table.sql
+++ /dev/null
@@ -1,16 +0,0 @@
-ALTER TABLE `company_field` ADD COLUMN `isp_id` bigint(20) DEFAULT NULL;
-ALTER TABLE `company_field` ADD COLUMN `hosting_id` bigint(20) DEFAULT NULL;
-
-ALTER TABLE `company_field` ADD INDEX `ispIdIndex`(`isp_id`);
-ALTER TABLE `company_field` ADD INDEX `hostingIdIndex`(`hosting_id`);
-
-CREATE TABLE `email_template`(
- `id` BIGINT(11) AUTO_INCREMENT,
- `title` VARCHAR (255) NOT NULL,
- `template` mediumtext NOT NULL,
- `register_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `modify_date` TIMESTAMP NULL,
- PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
diff --git a/src/main/resources/migration/V1_15__Alter_Table.sql b/src/main/resources/migration/V1_15__Alter_Table.sql
deleted file mode 100644
index 2313994..0000000
--- a/src/main/resources/migration/V1_15__Alter_Table.sql
+++ /dev/null
@@ -1,22 +0,0 @@
-ALTER TABLE `custom_field_api_overlap` ADD COLUMN `project_id` bigint(20) DEFAULT NULL;
-ALTER TABLE `custom_field_api_overlap` ADD INDEX `projectIdIndex`(`project_id`);
-
-ALTER TABLE `issue_type` DROP COLUMN `complete_issue_status_id`;
-
--- �씠�뒋 �옄�룞 醫낅즺 �꽕�젙 �뀒�씠釉�
-CREATE TABLE IF NOT EXISTS `issue_type_api_end_status` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `user_id` bigint(20) DEFAULT NULL,
- `project_id` bigint(20) DEFAULT NULL,
- `issue_type_id` bigint(20) DEFAULT NULL,
- `issue_status_id` bigint(20) DEFAULT NULL,
- `register_id` bigint(20) NOT NULL COMMENT 'register_id',
- `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
- `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
- `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
- PRIMARY KEY (`id`),
- KEY `userIdIndex` (`user_id`),
- KEY `projectIdIndex` (`project_id`),
- KEY `issueTypeIdIndex` (`issue_type_id`),
- KEY `issueStatusIdIndex` (`issue_status_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
diff --git a/src/main/resources/migration/V1_1__Initial_Setup.sql b/src/main/resources/migration/V1_1__Initial_Setup.sql
index 6474c42..a21fd2a 100644
--- a/src/main/resources/migration/V1_1__Initial_Setup.sql
+++ b/src/main/resources/migration/V1_1__Initial_Setup.sql
@@ -1,8 +1,8 @@
-- --------------------------------------------------------
--- �샇�뒪�듃: 192.168.0.64
--- �꽌踰� 踰꾩쟾: 10.1.13-MariaDB - Source distribution
--- �꽌踰� OS: Linux
--- HeidiSQL 踰꾩쟾: 10.1.0.5464
+-- �샇�뒪�듃: 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 */;
@@ -11,8 +11,21 @@
/*!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' */;
+-- �뀒�씠釉� dev_db.api_token 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `api_token` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `user_id` bigint(50) NOT NULL,
+ `app_name` varchar(50) NOT NULL,
+ `token` varchar(1024) NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `userIdIndex` (`user_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.attached_file 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.attached_file 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `attached_file` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`issue_id` bigint(20) DEFAULT NULL,
@@ -27,16 +40,34 @@
`modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
`modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
`aws_key` varchar(255) DEFAULT NULL,
+ `attached_type` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `issueIdIndex` (`issue_id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.attached_file:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `attached_file` DISABLE KEYS */;
-/*!40000 ALTER TABLE `attached_file` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.company_field 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `company_field` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(50) NOT NULL,
+ `manager` varchar(50) DEFAULT NULL,
+ `tel` varchar(50) DEFAULT NULL,
+ `email` varchar(255) DEFAULT NULL,
+ `memo` varchar(255) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ `url` varchar(255) DEFAULT NULL,
+ `isp_id` bigint(20) DEFAULT NULL,
+ `hosting_id` bigint(20) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `urlIndex` (`url`),
+ KEY `ispIdIndex` (`isp_id`),
+ KEY `hostingIdIndex` (`hosting_id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.custom_field 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.custom_field 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `custom_field` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
@@ -45,34 +76,160 @@
`default_value` varchar(100) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ `use_flag` varchar(1) NOT NULL DEFAULT 'Y',
+ `required_data` varchar(1) NOT NULL DEFAULT 'N',
PRIMARY KEY (`id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.custom_field:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `custom_field` DISABLE KEYS */;
-/*!40000 ALTER TABLE `custom_field` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.custom_field_api_default 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `custom_field_api_default` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `user_id` bigint(11) NOT NULL,
+ `issue_type_id` bigint(11) NOT NULL,
+ `custom_field_id` bigint(11) NOT NULL,
+ `custom_field_value` varchar(300) NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `userIdIndex` (`user_id`) USING BTREE,
+ KEY `issueTypeIdIndex` (`issue_type_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.custom_field_value 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.custom_field_api_overlap 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `custom_field_api_overlap` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `user_id` bigint(11) NOT NULL,
+ `issue_type_id` bigint(11) NOT NULL,
+ `custom_field_id` bigint(11) NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ `project_id` bigint(20) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `userIdIndex` (`user_id`) USING BTREE,
+ KEY `issueTypeIdIndex` (`issue_type_id`) USING BTREE,
+ KEY `projectIdIndex` (`project_id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.custom_field_value 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `custom_field_value` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`custom_field_id` bigint(20) NOT NULL,
`value` varchar(100) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `customFieldIdIndex` (`custom_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.custom_field_value:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `custom_field_value` DISABLE KEYS */;
-/*!40000 ALTER TABLE `custom_field_value` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.department 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `department` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `department_name` varchar(50) NOT NULL,
+ `department_description` varchar(255) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.email_template 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `email_template` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `title` varchar(255) NOT NULL,
+ `template` mediumtext NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.event 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `event` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `title` varchar(200) NOT NULL,
+ `description` mediumtext NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `start_date` varchar(10) DEFAULT NULL COMMENT 'start_date',
+ `end_date` varchar(10) DEFAULT NULL COMMENT 'end_date',
+ `status` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.faq 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `faq` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `title` varchar(200) NOT NULL,
+ `description` mediumtext NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `status` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.guide 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `guide` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `title` varchar(200) NOT NULL,
+ `description` mediumtext NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `status` int(11) NOT NULL,
+ PRIMARY KEY (`id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.hosting_field 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `hosting_field` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `code` varchar(50) NOT NULL,
+ `name` varchar(50) NOT NULL,
+ `manager` varchar(50) DEFAULT NULL,
+ `tel` varchar(50) DEFAULT NULL,
+ `email` varchar(255) DEFAULT NULL,
+ `memo` varchar(255) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ `url` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.isp_field 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `isp_field` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `code` varchar(50) NOT NULL,
+ `name` varchar(50) NOT NULL,
+ `manager` varchar(50) DEFAULT NULL,
+ `tel` varchar(50) DEFAULT NULL,
+ `email` varchar(255) DEFAULT NULL,
+ `memo` varchar(255) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ `url` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.issue 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`issue_status_id` bigint(20) DEFAULT NULL,
@@ -81,7 +238,7 @@
`priority_id` bigint(20) DEFAULT NULL,
`severity_id` bigint(20) DEFAULT NULL,
`title` varchar(300) DEFAULT NULL,
- `description` mediumtext COMMENT 'description',
+ `description` mediumtext DEFAULT NULL COMMENT 'description',
`reverse_index` bigint(20) DEFAULT NULL,
`issue_number` bigint(20) DEFAULT NULL,
`start_date` varchar(20) DEFAULT NULL,
@@ -90,17 +247,40 @@
`register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
`modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
`modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ `workflow_status_id` bigint(20) DEFAULT NULL,
+ `parent_issue_id` bigint(11) DEFAULT NULL,
+ `is_api` varchar(1) NOT NULL DEFAULT 'N',
PRIMARY KEY (`id`),
KEY `projectIdIndex` (`project_id`),
KEY `reverseIndex` (`reverse_index`),
KEY `issueTypeIdIndex` (`issue_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.issue_api_default 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_api_default` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `user_id` bigint(11) NOT NULL,
+ `issue_type_id` bigint(11) NOT NULL,
+ `issue_status_id` bigint(20) DEFAULT NULL,
+ `project_id` bigint(20) DEFAULT NULL,
+ `priority_id` bigint(20) DEFAULT NULL,
+ `severity_id` bigint(20) DEFAULT NULL,
+ `title` varchar(300) DEFAULT NULL,
+ `description` mediumtext DEFAULT NULL COMMENT 'description',
+ `reverse_index` bigint(20) DEFAULT NULL,
+ `issue_number` bigint(20) DEFAULT NULL,
+ `start_date` varchar(20) DEFAULT NULL,
+ `complete_date` varchar(20) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `userIdIndex` (`user_id`) USING BTREE,
+ KEY `issueTypeIdIndex` (`issue_type_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_comment 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_comment 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_comment` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`issue_id` bigint(20) NOT NULL COMMENT 'issue_id',
@@ -115,11 +295,26 @@
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='issue_comment';
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_comment:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_comment` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_comment` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.issue_company 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_company` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
+ `issue_id` bigint(20) NOT NULL,
+ `company_id` bigint(20) DEFAULT NULL,
+ `name` varchar(50) DEFAULT NULL,
+ `manager` varchar(50) DEFAULT NULL,
+ `tel` varchar(50) DEFAULT NULL,
+ `email` varchar(255) DEFAULT NULL,
+ `memo` varchar(255) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ `url` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `companyIdIndex` (`company_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_custom_field_value 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_custom_field_value 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_custom_field_value` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`issue_id` bigint(20) NOT NULL,
@@ -128,25 +323,38 @@
`use_value` mediumtext NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `customFieldIdIndex` (`custom_field_id`),
KEY `issueTypeCustomFieldIdIndex` (`issue_type_custom_field_id`),
KEY `issueIdIndex` (`issue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_custom_field_value:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_custom_field_value` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_custom_field_value` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.issue_department 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_department` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `department_id` bigint(20) NOT NULL,
+ `issue_id` bigint(20) NOT NULL,
+ `workspace_id` bigint(20) NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`id`),
+ KEY `departmentIdAndIssueIdIndex` (`department_id`,`issue_id`),
+ KEY `issueIdIndex` (`issue_id`),
+ KEY `workspaceIdIndex` (`workspace_id`),
+ KEY `departmentIdIndex` (`department_id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_history 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_history 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_history` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`issue_id` bigint(20) DEFAULT NULL,
`project_id` bigint(20) DEFAULT NULL,
`issue_history_type` varchar(10) NOT NULL,
- `description` mediumtext,
+ `description` mediumtext DEFAULT NULL,
`register_id` bigint(20) DEFAULT NULL,
`register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) DEFAULT NULL,
@@ -156,67 +364,123 @@
KEY `projectIdIndex` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_history:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_history` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_history` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.issue_hosting 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_hosting` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
+ `issue_id` bigint(20) NOT NULL,
+ `hosting_id` bigint(20) DEFAULT NULL,
+ `name` varchar(50) DEFAULT NULL,
+ `code` varchar(50) DEFAULT NULL,
+ `manager` varchar(50) DEFAULT NULL,
+ `tel` varchar(50) DEFAULT NULL,
+ `email` varchar(255) DEFAULT NULL,
+ `memo` varchar(255) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ `url` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `hostingIdIndex` (`hosting_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_number_generator 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_isp 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_isp` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
+ `issue_id` bigint(20) NOT NULL,
+ `isp_id` bigint(20) DEFAULT NULL,
+ `name` varchar(50) DEFAULT NULL,
+ `code` varchar(50) DEFAULT NULL,
+ `manager` varchar(50) DEFAULT NULL,
+ `tel` varchar(50) DEFAULT NULL,
+ `email` varchar(255) DEFAULT NULL,
+ `memo` varchar(255) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ `url` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `ispIdIndex` (`isp_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.issue_number_generator 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_number_generator` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_id` bigint(20) NOT NULL,
`number` bigint(20) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `projectIdIndex` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_number_generator:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_number_generator` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_number_generator` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.issue_relation 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_relation` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `issue_id` bigint(20) NOT NULL,
+ `relation_issue_id` bigint(20) NOT NULL DEFAULT -1,
+ `relation_issue_type` int(20) NOT NULL,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `issueId` (`issue_id`) USING BTREE,
+ KEY `relationIssueId` (`relation_issue_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_risk 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_reservation 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_reservation` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `issue_id` bigint(20) DEFAULT NULL,
+ `workspace_id` bigint(20) DEFAULT NULL,
+ `reservation` varchar(10) DEFAULT NULL,
+ `issue_reservation_type` varchar(10) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ PRIMARY KEY (`id`),
+ KEY `workspaceIdIndex` (`workspace_id`),
+ KEY `issueIdIndex` (`issue_id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.issue_risk 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_risk` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`issue_id` bigint(20) NOT NULL,
`workspace_id` bigint(20) NOT NULL,
- `change_assignee_count` bigint(20) NOT NULL DEFAULT '0',
- `change_issue_status_count` bigint(20) NOT NULL DEFAULT '0',
+ `change_assignee_count` bigint(20) NOT NULL DEFAULT 0,
+ `change_issue_status_count` bigint(20) NOT NULL DEFAULT 0,
`issue_status_ids` text NOT NULL,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ `change_department_count` bigint(20) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `issueIdIndex` (`issue_id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_risk:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_risk` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_risk` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.issue_search 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_search 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_search` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
- `conditions` mediumtext,
+ `conditions` mediumtext DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `workspaceIdAndUserIdIndex` (`workspace_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_search:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_search` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_search` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.issue_status 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_status 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_status` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) DEFAULT NULL,
@@ -233,30 +497,25 @@
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_status:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_status` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_status` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.issue_table_config 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_table_config 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_table_config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
`issue_table_configs` mediumtext CHARACTER SET utf8 NOT NULL,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
+ `issue_type_id` bigint(20) NOT NULL,
+ `issue_table_type` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `workspaceIdAndUserIdIndex` (`workspace_id`,`user_id`),
- KEY `workspaceIdIndex` (`workspace_id`)
+ KEY `workspaceIdIndex` (`workspace_id`),
+ KEY `issueTableTypeIndex` (`issue_table_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_table_config:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_table_config` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_table_config` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.issue_type 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_type 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_type` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
@@ -264,31 +523,47 @@
`name` varchar(15) NOT NULL,
`description` mediumtext NOT NULL,
`color` varchar(255) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
+ `project_id` bigint(11) DEFAULT NULL,
+ `use_partner` bigint(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`),
KEY `workspaceIdIndex` (`workspace_id`),
KEY `workflowIdIndex` (`workflow_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_type:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_type` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_type` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.issue_type_api_end_status 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_type_api_end_status` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `user_id` bigint(20) DEFAULT NULL,
+ `project_id` bigint(20) DEFAULT NULL,
+ `issue_type_id` bigint(20) DEFAULT NULL,
+ `issue_status_id` bigint(20) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ PRIMARY KEY (`id`),
+ KEY `userIdIndex` (`user_id`),
+ KEY `projectIdIndex` (`project_id`),
+ KEY `issueTypeIdIndex` (`issue_type_id`),
+ KEY `issueStatusIdIndex` (`issue_status_id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_type_custom_field 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_type_custom_field 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_type_custom_field` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_id` bigint(20) NOT NULL,
`issue_type_id` bigint(20) NOT NULL,
`custom_field_id` bigint(20) NOT NULL,
`field_option` varchar(10) NOT NULL,
- `position` bigint(20) NOT NULL DEFAULT '0',
+ `position` bigint(20) NOT NULL DEFAULT 0,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `projectIdIndex` (`project_id`),
KEY `issueTypeIdIndex` (`issue_type_id`),
@@ -296,20 +571,16 @@
KEY `projectIdAndIssueTypeIdIndex` (`project_id`,`issue_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_type_custom_field:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_type_custom_field` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_type_custom_field` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.issue_user 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.issue_user 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `issue_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
- `user_id` bigint(20) NULL,
+ `user_id` bigint(20) DEFAULT NULL,
`issue_id` bigint(20) NOT NULL,
`workspace_id` bigint(20) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `userIdAndIssueIdIndex` (`user_id`,`issue_id`),
KEY `issueIdIndex` (`issue_id`),
@@ -317,35 +588,14 @@
KEY `userIdIndex` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.issue_department 援ъ“ �궡蹂대궡湲�
-CREATE TABLE IF NOT EXISTS `issue_department` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `department_id` bigint(20) NOT NULL,
- `issue_id` bigint(20) NOT NULL,
- `workspace_id` bigint(20) NOT NULL,
- `register_id` bigint(20) NOT NULL,
- `modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`),
- KEY `departmentIdAndIssueIdIndex` (`department_id`,`issue_id`),
- KEY `issueIdIndex` (`issue_id`),
- KEY `workspaceIdIndex` (`workspace_id`),
- KEY `departmentIdIndex` (`department_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_user:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_user` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_user` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.issue_version_control 援ъ“ �궡蹂대궡湲�
-CREATE TABLE IF NOT EXISTS `issue_version_control` (
+-- �뀒�씠釉� dev_db.issue_version 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `issue_version` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) DEFAULT NULL,
`project_id` bigint(20) DEFAULT NULL,
`issue_id` bigint(20) DEFAULT NULL,
`version` bigint(20) DEFAULT NULL,
- `content` mediumtext,
+ `content` mediumtext DEFAULT NULL,
`register_id` bigint(20) DEFAULT NULL,
`register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) DEFAULT NULL,
@@ -356,25 +606,19 @@
KEY `projectIdIndex` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.issue_version_control:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `issue_version_control` DISABLE KEYS */;
-/*!40000 ALTER TABLE `issue_version_control` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.login_history 援ъ“ �궡蹂대궡湲�
-CREATE TABLE IF NOT EXISTS `login_history` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `user_id` bigint(20) NOT NULL COMMENT 'user_id',
- `login_date` timestamp NULL DEFAULT NULL COMMENT 'login_date',
- `logout_date` timestamp NULL DEFAULT NULL COMMENT 'logout_date',
- `login_ip` varchar(20) NOT NULL COMMENT 'login_ip',
+-- �뀒�씠釉� dev_db.notice 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `notice` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `title` varchar(200) NOT NULL,
+ `description` mediumtext NOT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
+ `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='login_history';
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.login_history:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `login_history` DISABLE KEYS */;
-/*!40000 ALTER TABLE `login_history` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.payment 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.payment 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `payment` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) DEFAULT NULL,
@@ -389,11 +633,7 @@
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.payment:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `payment` DISABLE KEYS */;
-/*!40000 ALTER TABLE `payment` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.payment_history 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.payment_history 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `payment_history` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
@@ -404,19 +644,15 @@
`merchant_uid` varchar(255) NOT NULL,
`payment_result` varchar(10) NOT NULL,
`payment_response` mediumtext NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.payment_history:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `payment_history` DISABLE KEYS */;
-/*!40000 ALTER TABLE `payment_history` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.permission 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.permission 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `permission` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
@@ -427,7 +663,7 @@
`modify_id` bigint(20) NOT NULL,
`modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.permission:~12 rows (���왂�쟻) �궡蹂대궡湲�
/*!40000 ALTER TABLE `permission` DISABLE KEYS */;
@@ -443,7 +679,8 @@
(9, '�씠�뒋 �긽�깭 �넻�빀 沅뚰븳', 'ISSUE_STATUS_TOTAL', '01', 1, '2018-05-03 15:06:31', 1, '2018-05-03 15:06:32'),
(10, '�썙�겕�뵆濡쒖슦 �넻�빀 沅뚰븳', 'WORKFLOW_TOTAL', '01', 1, '2018-05-03 15:07:09', 1, '2018-05-03 15:07:10'),
(11, '�씠�뒋 �쑀�삎 �넻�빀 沅뚰븳', 'ISSUE_TYPE_TOTAL', '01', 1, '2018-05-03 15:07:35', 1, '2018-05-03 15:07:36'),
-(12, '�궗�슜�옄 �젙�쓽 �븘�뱶 �넻�빀 沅뚰븳', 'CUSTOM_FIELD_TOTAL', '01', 1, '2018-05-03 15:07:55', 1, '2018-05-03 15:07:56');
+(12, '�궗�슜�옄 �젙�쓽 �븘�뱶 �넻�빀 沅뚰븳', 'CUSTOM_FIELD_TOTAL', '01', 1, '2018-05-03 15:07:55', 1, '2018-05-03 15:07:56'),
+(13, '怨듭��궗�빆 議고쉶 沅뚰븳', 'NOTICE_READ', '01', 1, '2018-05-03 15:07:55', 1, '2018-05-03 15:07:56');
/*!40000 ALTER TABLE `permission` ENABLE KEYS */;
-- �뀒�씠釉� owl_en_1.5.priority 援ъ“ �궡蹂대궡湲�
@@ -460,18 +697,14 @@
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.priority:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `priority` DISABLE KEYS */;
-/*!40000 ALTER TABLE `priority` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.project 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.project 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `project` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `workspace_id` bigint(20) NOT NULL DEFAULT '0',
+ `workspace_id` bigint(20) NOT NULL DEFAULT 0,
`name` varchar(50) NOT NULL COMMENT 'name',
`project_key` varchar(10) NOT NULL,
`project_type` varchar(50) NOT NULL,
- `description` mediumtext COMMENT 'description',
+ `description` mediumtext DEFAULT NULL COMMENT 'description',
`status` varchar(2) NOT NULL DEFAULT '01' COMMENT '01:�솢�꽦, 02:鍮꾪솢�꽦',
`start_date` varchar(10) DEFAULT NULL COMMENT 'start_date',
`end_date` varchar(10) DEFAULT NULL COMMENT 'end_date',
@@ -484,95 +717,103 @@
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='project';
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.project:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `project` DISABLE KEYS */;
-/*!40000 ALTER TABLE `project` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.project_closure 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `project_closure` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `project_id` bigint(20) NOT NULL,
+ `parent_project_id` bigint(20) NOT NULL DEFAULT -1,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `projectIdIndex` (`project_id`) USING BTREE,
+ KEY `parentProjectIdIndex` (`parent_project_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.project_role 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.project_role 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `project_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_id` bigint(20) NOT NULL,
`name` varchar(50) NOT NULL,
`role_type` varchar(2) NOT NULL,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `projectIdIndex` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.project_role:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `project_role` DISABLE KEYS */;
-/*!40000 ALTER TABLE `project_role` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.project_role_department 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `project_role_department` (
+ `id` bigint(20) NOT NULL AUTO_INCREMENT,
+ `project_role_id` bigint(20) NOT NULL,
+ `department_id` bigint(20) NOT 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,
+ `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ PRIMARY KEY (`id`),
+ KEY `projectRoleIdAndDepartmentIdIndex` (`project_role_id`,`department_id`),
+ KEY `departmentIdIndex` (`department_id`),
+ KEY `projectRoleIdIndex` (`project_role_id`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.project_role_permission 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.project_role_permission 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `project_role_permission` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`project_role_id` bigint(20) NOT NULL,
`permission_id` bigint(20) NOT NULL,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `projectRoleIdIndex` (`project_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.project_role_permission:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `project_role_permission` DISABLE KEYS */;
-/*!40000 ALTER TABLE `project_role_permission` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.project_role_user 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.project_role_user 援ъ“ �궡蹂대궡湲�
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,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `projectRoleIdAndUserIdIndex` (`project_role_id`,`user_id`),
KEY `userIdIndex` (`user_id`),
KEY `projectRoleIdIndex` (`project_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.project_role_department 援ъ“ �궡蹂대궡湲�
-CREATE TABLE IF NOT EXISTS `project_role_department` (
+-- �뀒�씠釉� dev_db.qna 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `qna` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
- `project_role_id` bigint(20) NOT NULL,
- `department_id` bigint(20) NOT NULL,
+ `title` varchar(200) NOT NULL,
+ `description` mediumtext NOT 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,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`),
- KEY `projectRoleIdAndDepartmentIdIndex` (`project_role_id`,`department_id`),
- KEY `departmentIdIndex` (`department_id`),
- KEY `projectRoleIdIndex` (`project_role_id`)
+ PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.project_role_department 援ъ“ �궡蹂대궡湲�
-CREATE TABLE IF NOT EXISTS `project_role_department` (
+-- �뀒�씠釉� dev_db.qna_answer 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `qna_answer` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
- `project_role_id` bigint(20) NOT NULL,
- `department_id` bigint(20) NULL,
+ `ask_id` bigint(20) NOT NULL,
+ `title` varchar(200) NOT NULL,
+ `description` mediumtext NOT 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,
+ `register_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`),
- KEY `projectRoleIdAndDepartmentIdIndex` (`project_role_id`,`department_id`),
- KEY `departmentIdIndex` (`department_id`),
- KEY `projectRoleIdIndex` (`project_role_id`)
+ PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.project_role_user:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `project_role_user` DISABLE KEYS */;
-/*!40000 ALTER TABLE `project_role_user` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.reservation_disable_user 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.reservation_disable_user 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `reservation_disable_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`payment_id` bigint(20) DEFAULT NULL,
@@ -585,29 +826,37 @@
KEY `paymentIdIndex` (`payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.reservation_disable_user:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `reservation_disable_user` DISABLE KEYS */;
-/*!40000 ALTER TABLE `reservation_disable_user` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.schema_version 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `schema_version` (
+ `installed_rank` int(11) NOT NULL,
+ `version` varchar(50) DEFAULT NULL,
+ `description` varchar(200) NOT NULL,
+ `type` varchar(20) NOT NULL,
+ `script` varchar(1000) NOT NULL,
+ `checksum` int(11) DEFAULT NULL,
+ `installed_by` varchar(100) NOT NULL,
+ `installed_on` timestamp NOT NULL DEFAULT current_timestamp(),
+ `execution_time` int(11) NOT NULL,
+ `success` tinyint(1) NOT NULL,
+ PRIMARY KEY (`installed_rank`),
+ KEY `schema_version_s_idx` (`success`)
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--- �뀒�씠釉� owl_en_1.5.severity 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.severity 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `severity` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
`name` varchar(50) NOT NULL,
`position` bigint(20) NOT NULL,
`color` varchar(255) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.severity:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `severity` DISABLE KEYS */;
-/*!40000 ALTER TABLE `severity` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.system_email 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.system_email 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `system_email` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`send_address` varchar(50) NOT NULL,
@@ -616,16 +865,12 @@
`send_yn` varchar(2) NOT NULL DEFAULT 'N',
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.system_email:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `system_email` DISABLE KEYS */;
-/*!40000 ALTER TABLE `system_email` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.system_role 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.system_role 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `system_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
@@ -635,13 +880,15 @@
`modify_id` bigint(20) NOT NULL,
`modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.system_role:~2 rows (���왂�쟻) �궡蹂대궡湲�
/*!40000 ALTER TABLE `system_role` DISABLE KEYS */;
INSERT INTO `system_role` (`id`, `name`, `role_type`, `register_id`, `register_date`, `modify_id`, `modify_date`) VALUES
(1, '�씪諛� �궗�슜�옄 �뿭�븷', '01', 1, '2017-12-29 21:37:15', 1, '2017-12-29 21:37:16'),
-(2, '�썙�겕�뒪�럹�씠�뒪 愿�由ъ옄 �뿭�븷', '02', 1, '2017-12-29 21:37:27', 1, '2017-12-29 21:37:28');
+(2, '�썙�겕�뒪�럹�씠�뒪 愿�由ъ옄 �뿭�븷', '02', 1, '2017-12-29 21:37:27', 1, '2017-12-29 21:37:28'),
+(3, '�봽濡쒖젥�듃 �궗�슜�옄 �뿭�븷', '03', 1, '2017-12-29 21:37:15', 1, '2017-12-29 21:37:15'),
+(4, '�봽濡쒖젥�듃 愿�由ъ옄 �뿭�븷', '04', 1, '2017-12-29 21:37:15', 1, '2017-12-29 21:37:15');
/*!40000 ALTER TABLE `system_role` ENABLE KEYS */;
-- �뀒�씠釉� owl_en_1.5.system_role_permission 援ъ“ �궡蹂대궡湲�
@@ -654,7 +901,7 @@
`modify_id` bigint(20) NOT NULL,
`modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=19 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 */;
@@ -676,7 +923,9 @@
(15, 2, 9, 1, '2018-05-08 15:52:13', 1, '2018-05-08 15:52:14'),
(16, 2, 10, 1, '2018-05-08 15:52:20', 1, '2018-05-08 15:52:21'),
(17, 2, 11, 1, '2018-05-08 15:52:28', 1, '2018-05-08 15:52:28'),
-(18, 2, 12, 1, '2018-05-08 15:52:35', 1, '2018-05-08 15:52:36');
+(18, 2, 12, 1, '2018-05-08 15:52:35', 1, '2018-05-08 15:52:36'),
+(19, 1, 13, 1, '2019-06-12 12:06:35', 1, '2019-06-12 12:06:37'),
+(20, 2, 13, 1, '2019-06-12 12:06:47', 1, '2019-06-12 12:06:49');
/*!40000 ALTER TABLE `system_role_permission` ENABLE KEYS */;
-- �뀒�씠釉� owl_en_1.5.system_role_user 援ъ“ �궡蹂대궡湲�
@@ -693,11 +942,7 @@
KEY `systemRoleidIndex` (`system_role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.system_role_user:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `system_role_user` DISABLE KEYS */;
-/*!40000 ALTER TABLE `system_role_user` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.user 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.user 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
@@ -715,14 +960,29 @@
`register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
`modify_date` timestamp NULL DEFAULT NULL,
- PRIMARY KEY (`id`)
+ `licensekey` varchar(255) DEFAULT NULL,
+ `last_project_id` bigint(20) DEFAULT 0,
+ `last_issue_type_id` bigint(20) DEFAULT 0,
+ `last_login_date` timestamp NULL DEFAULT NULL,
+ `level_id` bigint(11) DEFAULT NULL,
+ `insert_type` varchar(1) NOT NULL DEFAULT 'N',
+ PRIMARY KEY (`id`),
+ KEY `levelIdIndex` (`level_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.user:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `user` DISABLE KEYS */;
-/*!40000 ALTER TABLE `user` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.user_department 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `user_department` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `department_id` bigint(11) DEFAULT NULL,
+ `user_id` bigint(11) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.user_invite 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.user_invite 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `user_invite` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
@@ -730,35 +990,41 @@
`status` varchar(10) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.user_invite:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `user_invite` DISABLE KEYS */;
-/*!40000 ALTER TABLE `user_invite` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.user_invite_project 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.user_invite_project 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `user_invite_project` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_invite_id` bigint(20) NOT NULL,
`project_id` bigint(20) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `userInviteIdIndex` (`user_invite_id`),
KEY `projectIdIndex` (`project_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.user_invite_project:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `user_invite_project` DISABLE KEYS */;
-/*!40000 ALTER TABLE `user_invite_project` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.user_level 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `user_level` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `level_name` varchar(50) NOT NULL,
+ `permission` int(11) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
+ `modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
+ `default_yn` varchar(1) NOT NULL DEFAULT 'N',
+ `basic_user` varchar(1) NOT NULL DEFAULT 'N',
+ PRIMARY KEY (`id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.user_like_issue 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.user_like_issue 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `user_like_issue` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
@@ -766,35 +1032,27 @@
`workspace_id` bigint(20) NOT NULL,
`register_id` bigint(20) NOT NULL,
`modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `userIdIndex` (`user_id`),
KEY `issueIdIndex` (`issue_id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.user_like_issue:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `user_like_issue` DISABLE KEYS */;
-/*!40000 ALTER TABLE `user_like_issue` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.user_with_draw 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.user_with_draw 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `user_with_draw` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`account` varchar(200) NOT NULL,
`register_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `accountIndex` (`account`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.user_with_draw:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `user_with_draw` DISABLE KEYS */;
-/*!40000 ALTER TABLE `user_with_draw` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.user_workspace 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.user_workspace 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `user_workspace` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) DEFAULT NULL,
@@ -802,39 +1060,64 @@
`manager_yn` varchar(2) NOT NULL DEFAULT 'N',
`use_yn` varchar(2) NOT NULL DEFAULT 'N',
`disable_position` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `userIdIndex` (`user_id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.user_workspace:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `user_workspace` DISABLE KEYS */;
-/*!40000 ALTER TABLE `user_workspace` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.workflow 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.workflow 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `workflow` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workspace_id` bigint(20) NOT NULL,
`name` varchar(50) NOT NULL,
- `description` mediumtext,
+ `description` mediumtext DEFAULT NULL,
`project_type` varchar(50) DEFAULT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `workspaceIdIndex` (`workspace_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.workflow:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `workflow` DISABLE KEYS */;
-/*!40000 ALTER TABLE `workflow` ENABLE KEYS */;
+-- �뀒�씠釉� dev_db.workflow_department 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `workflow_department` (
+ `id` bigint(11) NOT NULL AUTO_INCREMENT,
+ `workflow_id` bigint(11) DEFAULT NULL,
+ `issue_status_id` bigint(11) DEFAULT NULL,
+ `department_id` bigint(11) DEFAULT NULL,
+ `register_id` bigint(20) NOT NULL,
+ `register_date` timestamp NULL DEFAULT NULL,
+ `modify_id` bigint(20) NOT NULL,
+ `modify_date` timestamp NULL DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ KEY `workflowIdIndex` (`workflow_id`) USING BTREE,
+ KEY `issueStatusIdIndex` (`issue_status_id`) USING BTREE,
+ KEY `departmentIdIndex` (`department_id`) USING BTREE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� owl_en_1.5.workflow_transition 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.workflow_status 援ъ“ �궡蹂대궡湲�
+CREATE TABLE IF NOT EXISTS `workflow_status` (
+ `id` int(11) NOT NULL AUTO_INCREMENT,
+ `project_id` bigint(20) DEFAULT NULL,
+ `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
+ `first_yn` varchar(1) CHARACTER SET utf8 NOT NULL DEFAULT 'N',
+ `last_yn` varchar(1) CHARACTER SET utf8 NOT NULL DEFAULT 'N',
+ `progress` bigint(20) unsigned NOT NULL DEFAULT 0 COMMENT '吏꾪뻾瑜�',
+ `color` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '0',
+ `position` bigint(20) NOT NULL DEFAULT 0,
+ `register_id` bigint(20) NOT NULL COMMENT 'register_id',
+ `register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
+ `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 DEFAULT CHARSET=utf8mb4;
+
+-- �뀒�씠釉� dev_db.workflow_transition 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `workflow_transition` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`workflow_id` bigint(20) NOT NULL,
@@ -847,9 +1130,9 @@
`correct_x` bigint(20) DEFAULT NULL,
`correct_y` bigint(20) DEFAULT NULL,
`direct` varchar(2) NOT NULL DEFAULT 'N',
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `register_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `workflowIdIndex` (`workflow_id`),
@@ -857,31 +1140,23 @@
KEY `targetIssueStatusIdIndex` (`target_issue_status_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.workflow_transition:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `workflow_transition` DISABLE KEYS */;
-/*!40000 ALTER TABLE `workflow_transition` ENABLE KEYS */;
-
--- �뀒�씠釉� owl_en_1.5.workspace 援ъ“ �궡蹂대궡湲�
+-- �뀒�씠釉� dev_db.workspace 援ъ“ �궡蹂대궡湲�
CREATE TABLE IF NOT EXISTS `workspace` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`max_user` bigint(20) NOT NULL,
- `start_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `expire_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `start_date` timestamp NULL DEFAULT NULL,
+ `expire_date` timestamp NULL DEFAULT NULL,
`storage_size` bigint(20) NOT NULL,
`use_traffic` bigint(20) DEFAULT NULL,
`service_type` varchar(10) DEFAULT NULL,
- `register_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `register_date` timestamp NULL DEFAULT NULL,
`register_id` bigint(20) NOT NULL,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `modify_date` timestamp NULL DEFAULT NULL,
`modify_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
--- �뀒�씠釉� �뜲�씠�꽣 owl_en_1.5.workspace:~0 rows (���왂�쟻) �궡蹂대궡湲�
-/*!40000 ALTER TABLE `workspace` DISABLE KEYS */;
-/*!40000 ALTER TABLE `workspace` 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 */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
\ No newline at end of file
diff --git a/src/main/resources/migration/V1_2__Alter_Table.sql b/src/main/resources/migration/V1_2__Alter_Table.sql
deleted file mode 100644
index 3d762ee..0000000
--- a/src/main/resources/migration/V1_2__Alter_Table.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE issue_version_control RENAME issue_version;
\ No newline at end of file
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 */;
diff --git a/src/main/resources/migration/V1_3__Alter_Table.sql b/src/main/resources/migration/V1_3__Alter_Table.sql
deleted file mode 100644
index 0b525bc..0000000
--- a/src/main/resources/migration/V1_3__Alter_Table.sql
+++ /dev/null
@@ -1,2 +0,0 @@
-alter table attached_file add attached_type varchar (20) not null;
-update attached_file set attached_type = 'ISSUE_ATTACHED';
\ No newline at end of file
diff --git a/src/main/resources/migration/V1_4__Alter_Table.sql b/src/main/resources/migration/V1_4__Alter_Table.sql
deleted file mode 100644
index 06e871e..0000000
--- a/src/main/resources/migration/V1_4__Alter_Table.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-CREATE TABLE IF NOT EXISTS `issue_reservation` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `issue_id` bigint(20) DEFAULT NULL,
- `workspace_id` bigint(20) DEFAULT NULL,
- `reservation` varchar(10) DEFAULT NULL,
- `issue_reservation_type` varchar(10) DEFAULT 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,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`),
- KEY `workspaceIdIndex` (`workspace_id`),
- KEY `issueIdIndex` (`issue_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
\ No newline at end of file
diff --git a/src/main/resources/migration/V1_5__Alter_Table.sql b/src/main/resources/migration/V1_5__Alter_Table.sql
deleted file mode 100644
index 01f6374..0000000
--- a/src/main/resources/migration/V1_5__Alter_Table.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-CREATE TABLE IF NOT EXISTS `notice` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT,
- `title` varchar(200) NOT NULL,
- `description` mediumtext NOT NULL,
- `register_id` bigint(20) NOT NULL,
- `modify_id` bigint(20) NOT NULL,
- `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
diff --git a/src/main/resources/migration/V1_6__Alter_Table.sql b/src/main/resources/migration/V1_6__Alter_Table.sql
deleted file mode 100644
index 0702934..0000000
--- a/src/main/resources/migration/V1_6__Alter_Table.sql
+++ /dev/null
@@ -1,59 +0,0 @@
-ALTER TABLE custom_field modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE custom_field modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE custom_field_value modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE custom_field_value modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_custom_field_value modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_custom_field_value modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_number_generator modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_number_generator modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_reservation modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_reservation modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_risk modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_risk modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_search modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_search modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_table_config modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_table_config modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_type modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_type modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_type_custom_field modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_type_custom_field modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_user modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE issue_user modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE payment_history modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE payment_history modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE project_role modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE project_role modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE project_role_permission modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE project_role_permission modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE project_role_user modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE project_role_user modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE severity modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE severity modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE system_email modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE system_email modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE user_invite modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE user_invite modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE user_invite_project modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE user_invite_project modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE user_like_issue modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE user_like_issue modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE user_with_draw modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE user_with_draw modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE user_workspace modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE user_workspace modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE workflow modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE workflow modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE workflow_transition modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE workflow_transition modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE workspace modify register_date timestamp NULL DEFAULT NULL;
-ALTER TABLE workspace modify modify_date timestamp NULL DEFAULT NULL;
-ALTER TABLE workspace modify start_date timestamp NULL DEFAULT NULL;
-ALTER TABLE workspace modify expire_date timestamp NULL DEFAULT NULL;
-
-INSERT INTO `permission` (`name`, `action`, `role_type`, `register_id`, `register_date`, `modify_id`, `modify_date`) VALUES
- ('怨듭��궗�빆 議고쉶 沅뚰븳', 'NOTICE_READ', '01', 1, '2019-06-12 12:05:23', 1, '2019-06-12 12:05:24');
-
-INSERT INTO `system_role_permission` (`system_role_id`, `permission_id`, `register_id`, `register_date`, `modify_id`, `modify_date`) VALUES
- (1, 13, 1, '2019-06-12 12:06:35', 1, '2019-06-12 12:06:37'),
- (2, 13, 1, '2019-06-12 12:06:47', 1, '2019-06-12 12:06:49');
diff --git a/src/main/resources/migration/V1_7__Alter_Table.sql b/src/main/resources/migration/V1_7__Alter_Table.sql
deleted file mode 100644
index 58aa81f..0000000
--- a/src/main/resources/migration/V1_7__Alter_Table.sql
+++ /dev/null
@@ -1 +0,0 @@
-DROP TABLE login_history;
diff --git a/src/main/resources/migration/V1_8__Alter_Table.sql b/src/main/resources/migration/V1_8__Alter_Table.sql
deleted file mode 100644
index 6af0d38..0000000
--- a/src/main/resources/migration/V1_8__Alter_Table.sql
+++ /dev/null
@@ -1,63 +0,0 @@
-ALTER TABLE `user` ADD COLUMN `permission` int NULL DEFAULT NULL;
-ALTER TABLE `user` ADD COLUMN `licensekey` varchar(255) NULL DEFAULT NULL;
-
-CREATE TABLE IF NOT EXISTS `faq` (
- `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
- `title` VARCHAR(200) NOT NULL,
- `description` MEDIUMTEXT NOT NULL,
- `register_id` BIGINT(20) NOT NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
- `modify_date` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
- `status` INT(11) NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE IF NOT EXISTS `qna` (
- `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
- `title` VARCHAR(200) NOT NULL,
- `description` MEDIUMTEXT NOT NULL,
- `register_id` BIGINT(20) NOT NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
- `modify_date` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE IF NOT EXISTS `qna_answer` (
- `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
- `ask_id` BIGINT(20) NOT NULL,
- `title` VARCHAR(200) NOT NULL,
- `description` MEDIUMTEXT NOT NULL,
- `register_id` BIGINT(20) NOT NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
- `modify_date` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE IF NOT EXISTS `event` (
- `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
- `title` VARCHAR(200) NOT NULL,
- `description` MEDIUMTEXT NOT NULL,
- `register_id` BIGINT(20) NOT NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
- `modify_date` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
- `start_date` varchar(10) DEFAULT NULL COMMENT 'start_date',
- `end_date` varchar(10) DEFAULT NULL COMMENT 'end_date',
- `status` INT(11) NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-CREATE TABLE IF NOT EXISTS `guide` (
- `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
- `title` VARCHAR(200) NOT NULL,
- `description` MEDIUMTEXT NOT NULL,
- `register_id` BIGINT(20) NOT NULL,
- `modify_id` BIGINT(20) NOT NULL,
- `register_date` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
- `modify_date` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
- `status` INT(11) NOT NULL,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
\ No newline at end of file
diff --git a/src/main/resources/migration/V1_9__Alter_Table.sql b/src/main/resources/migration/V1_9__Alter_Table.sql
deleted file mode 100644
index d11ac0e..0000000
--- a/src/main/resources/migration/V1_9__Alter_Table.sql
+++ /dev/null
@@ -1,71 +0,0 @@
-INSERT INTO `system_role` (`id`, `name`, `role_type`, `register_id`, `register_date`, `modify_id`, `modify_date`) VALUES
-(3, '�봽濡쒖젥�듃 �궗�슜�옄 �뿭�븷', '03', 1, '2017-12-29 21:37:15', 1, '2017-12-29 21:37:15'),
-(4, '�봽濡쒖젥�듃 愿�由ъ옄 �뿭�븷', '04', 1, '2017-12-29 21:37:15', 1, '2017-12-29 21:37:15');
-
-DELETE FROM `system_role_permission` WHERE id = '5';
-DELETE FROM `system_role_permission` WHERE id = '6';
-DELETE FROM `system_role_permission` WHERE id = '7';
-DELETE FROM `system_role_permission` WHERE id = '8';
-
-CREATE TABLE `workflow_status` (
- `id` INT(11) NOT NULL AUTO_INCREMENT,
- `project_id` BIGINT(20) NULL,
- `name` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
- `first_yn` VARCHAR(1) NOT NULL DEFAULT 'N' COLLATE 'utf8_general_ci',
- `last_yn` VARCHAR(1) NOT NULL DEFAULT 'N' COLLATE 'utf8_general_ci',
- `progress` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '吏꾪뻾瑜�',
- `color` VARCHAR(255) NOT NULL DEFAULT '0' COLLATE 'utf8_general_ci',
- `position` BIGINT(20) NOT NULL DEFAULT '0',
- `register_id` BIGINT(20) NOT NULL COMMENT 'register_id',
- `register_date` TIMESTAMP NULL COMMENT 'register_date',
- `modify_id` BIGINT(20) NOT NULL COMMENT 'modify_id',
- `modify_date` TIMESTAMP NULL COMMENT 'modify_date',
- PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-ALTER TABLE `user` ADD COLUMN `last_project_id` bigint(20) NULL DEFAULT '0';
-ALTER TABLE `user` ADD COLUMN `last_issue_type_id` bigint(20) NULL DEFAULT '0';
-ALTER TABLE `user` ADD COLUMN `last_login_date` TIMESTAMP NULL;
-ALTER TABLE `issue` ADD COLUMN `workflow_status_id` bigint(20) NULL DEFAULT NULL;
-
-/* �봽濡쒖젥�듃 �겢濡쒖� �뀒�씠釉� */
-CREATE TABLE `project_closure` (
- `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
- `project_id` BIGINT(20) NOT NULL,
- `parent_project_id` BIGINT(20) NOT NULL DEFAULT -1,
- `register_id` BIGINT(20) NOT NULL COMMENT 'register_id',
- `register_date` TIMESTAMP NULL COMMENT 'register_date',
- `modify_id` BIGINT(20) NOT NULL COMMENT 'modify_id',
- `modify_date` TIMESTAMP NULL COMMENT 'modify_date',
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `projectIdIndex` (`project_id`) USING BTREE,
- INDEX `parentProjectIdIndex` (`parent_project_id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-/* �뿰愿� �씠�뒋 �뀒�씠釉� */
-CREATE TABLE `issue_relation` (
- `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
- `issue_id` BIGINT(20) NOT NULL,
- `relation_issue_id` BIGINT(20) NOT NULL DEFAULT -1,
- `relation_issue_type` INT(20) NOT NULL,
- `register_id` BIGINT(20) NOT NULL COMMENT 'register_id',
- `register_date` TIMESTAMP NULL COMMENT 'register_date',
- `modify_id` BIGINT(20) NOT NULL COMMENT 'modify_id',
- `modify_date` TIMESTAMP NULL COMMENT 'modify_date',
- PRIMARY KEY (`id`) USING BTREE,
- INDEX `issueId` (`issue_id`) USING BTREE,
- INDEX `relationIssueId` (`relation_issue_id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-/* �쑀�� 濡쒓렇�씤 �씠�젰 �뀒�씠釉� (�엳�뒪�넗由� 遺덊븘�슂) */
--- CREATE TABLE `user_history` (
--- `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
--- `history_type` VARCHAR (20) NOT NULL,
--- `register_id` BIGINT(20) NOT NULL COMMENT 'register_id',
--- `register_date` TIMESTAMP NULL COMMENT 'register_date',
--- `modify_id` BIGINT(20) NOT NULL COMMENT 'modify_id',
--- `modify_date` TIMESTAMP NULL COMMENT 'modify_date',
--- PRIMARY KEY (`id`) USING BTREE
--- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-ALTER TABLE `custom_field` ADD COLUMN `use_flag` varchar(1) NOT NULL DEFAULT 'Y';
\ No newline at end of file
diff --git a/src/main/resources/mybatis/query-template/companyField-template.xml b/src/main/resources/mybatis/query-template/companyField-template.xml
index 0ee3d09..2393acf 100644
--- a/src/main/resources/mybatis/query-template/companyField-template.xml
+++ b/src/main/resources/mybatis/query-template/companyField-template.xml
@@ -23,6 +23,9 @@
<if test="id != '' and id != null">
AND cf.id like CONCAT('%',#{id},'%')
</if>
+ <if test="url != '' and id != url">
+ AND cf.url like CONCAT('%',#{url},'%')
+ </if>
ORDER BY cf.id DESC
<if test="pageSize != '' and pageSize != null">
limit #{pageSize} offset #{page};
diff --git a/src/main/webapp/assets/styles/main.css b/src/main/webapp/assets/styles/main.css
index ac4b5ff..b16f97f 100644
--- a/src/main/webapp/assets/styles/main.css
+++ b/src/main/webapp/assets/styles/main.css
@@ -5225,7 +5225,7 @@
}*/
.modal-open {
- overflow: auto
+ overflow: hidden;
}
.modal {
--
Gitblit v1.8.0