From 2c273d1072424a9363314fb258265cbf487f0297 Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 목, 16 12월 2021 17:48:46 +0900
Subject: [PATCH] - Excel Import 기능 담당부서도 들어가게 하기(기간 미지정 시에도 가능하도록 수정) - 이슈 통합검색 키워드에 업체,ISP,호스팅 정보도 포함 - 프로젝트에서 설정한 이슈유형만 보여주기

---
 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