From dc9b09a4ee390db471ba8b7dedc375a9c7e72ad3 Mon Sep 17 00:00:00 2001 From: 이민희 <mhlee@maprex.co.kr> Date: 월, 13 12월 2021 15:56:49 +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