From 9e1224315ff031c5cfccda6ccb0d7841729d8612 Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 월, 15 11월 2021 17:21:52 +0900
Subject: [PATCH] Merge branch 'master' of http://192.168.0.25:9001/r/owl-kisa
---
src/main/resources/migration/V1_11__Alter_Table.sql | 76 +++++++++++++++++++++++++++++++++++++
1 files changed, 75 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 bb9d896..dd41b81 100644
--- a/src/main/resources/migration/V1_11__Alter_Table.sql
+++ b/src/main/resources/migration/V1_11__Alter_Table.sql
@@ -52,4 +52,78 @@
`modify_id` BIGINT(20) NOT NULL,
`modify_date` TIMESTAMP NULL,
PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
\ No newline at end of file
+) 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;
+
--
Gitblit v1.8.0