From 5b34a6602df667035c80260912f38e90e6482944 Mon Sep 17 00:00:00 2001
From: 박지현 <jhpark@maprex.co.kr>
Date: 수, 23 2월 2022 17:44:48 +0900
Subject: [PATCH] Merge branch 'master' of http://maprex.iptime.org:9001/r/owl-kisa

---
 src/main/resources/migration/V1_3__insert_new_data.sql |   13 ++++++++++++-
 1 files changed, 12 insertions(+), 1 deletions(-)

diff --git a/src/main/resources/migration/V1_3__insert_new_data.sql b/src/main/resources/migration/V1_3__insert_new_data.sql
index f624445..86094c9 100644
--- a/src/main/resources/migration/V1_3__insert_new_data.sql
+++ b/src/main/resources/migration/V1_3__insert_new_data.sql
@@ -157,4 +157,15 @@
 
 ALTER TABLE `company_field` MODIFY `tel` varchar(255);
 ALTER TABLE `isp_field` MODIFY `tel` varchar(255);
-ALTER TABLE `hosting_field` MODIFY `tel` varchar(255);
\ No newline at end of file
+ALTER TABLE `hosting_field` MODIFY `tel` varchar(255);
+
+ALTER TABLE `issue_company` ADD COLUMN `company_type_id` bigint(11) NULL;
+ALTER TABLE `issue_company` ADD COLUMN `parent_sector_id` bigint(11) NULL;
+ALTER TABLE `issue_company` ADD COLUMN `child_sector_id` bigint(11) NULL;
+ALTER TABLE `issue_company` ADD COLUMN `region_id` bigint(11) NULL;
+ALTER TABLE `issue_company` ADD COLUMN `status_id` bigint(11) NULL;
+ALTER TABLE `issue_company` ADD COLUMN `status_name` varchar(50) NULL;
+
+ALTER TABLE `issue_company` MODIFY `tel` varchar(255);
+ALTER TABLE `issue_isp` MODIFY `tel` varchar(255);
+ALTER TABLE `issue_hosting` MODIFY `tel` varchar(255);
\ No newline at end of file

--
Gitblit v1.8.0