From da08346c769258b6102cb4fe5348dc164ea2f3f7 Mon Sep 17 00:00:00 2001 From: jhjang <jhjang@maprex.co.kr> Date: 일, 12 12월 2021 17:40:31 +0900 Subject: [PATCH] - 연관 이슈 추가 안되는 오류 수정 - 연관 이슈 추가 후 목록 안뜨는 문제 수정 - 이슈 목록 트리 구조 보기 기능 추가 --- src/main/resources/migration/V1_13__Alter_Table.sql | 21 --------------------- 1 files changed, 0 insertions(+), 21 deletions(-) diff --git a/src/main/resources/migration/V1_13__Alter_Table.sql b/src/main/resources/migration/V1_13__Alter_Table.sql index cbe5106..36a476b 100644 --- a/src/main/resources/migration/V1_13__Alter_Table.sql +++ b/src/main/resources/migration/V1_13__Alter_Table.sql @@ -15,24 +15,3 @@ -- �뾽泥댁쓽 url 而щ읆 INDEX 異붽� ALTER TABLE `company_field` ADD INDEX `urlIndex`(`url`); - -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; - - - - -- Gitblit v1.8.0