From 61037a004e28c5e508a62f42022d20d6872dc672 Mon Sep 17 00:00:00 2001
From: jhjang <jhjang@maprex.co.kr>
Date: 수, 17 11월 2021 11:50:22 +0900
Subject: [PATCH] - 이슈 상세 페이지에 하위 일감 기능 추가

---
 src/main/resources/migration/V1_11__Alter_Table.sql |  119 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 118 insertions(+), 1 deletions(-)

diff --git a/src/main/resources/migration/V1_11__Alter_Table.sql b/src/main/resources/migration/V1_11__Alter_Table.sql
index b8631f1..caf331d 100644
--- a/src/main/resources/migration/V1_11__Alter_Table.sql
+++ b/src/main/resources/migration/V1_11__Alter_Table.sql
@@ -11,4 +11,121 @@
     `modify_date` TIMESTAMP NULL,
     PRIMARY KEY (`id`) USING BTREE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-/* �씠硫붿씪�� ID 媛믪쑝濡� 諛쏄퀬 �뿰�씫泥섎룄 user�뿉 phone�뿉�꽌 諛쏆쑝硫� �릺怨�*/
\ No newline at end of file
+
+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;

--
Gitblit v1.8.0