From 8c444812f7b9f0ad92e6e5a76f159778232eac65 Mon Sep 17 00:00:00 2001
From: jhjang <jhjang@maprex.co.kr>
Date: 토, 11 12월 2021 17:38:45 +0900
Subject: [PATCH] - api로 이슈 추가시 해당 워크플로우의 Ready 상태로 추가하도록 수정

---
 src/main/resources/migration/V1_13__Alter_Table.sql |   10 ++++++++++
 1 files changed, 10 insertions(+), 0 deletions(-)

diff --git a/src/main/resources/migration/V1_13__Alter_Table.sql b/src/main/resources/migration/V1_13__Alter_Table.sql
index 36a476b..7b53c33 100644
--- a/src/main/resources/migration/V1_13__Alter_Table.sql
+++ b/src/main/resources/migration/V1_13__Alter_Table.sql
@@ -15,3 +15,13 @@
 
 -- �뾽泥댁쓽 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`);
+
+
+
+

--
Gitblit v1.8.0