From 56c40ebd05a576e6f7c40ac10c78ac0463cf4074 Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 수, 19 1월 2022 11:41:13 +0900
Subject: [PATCH] 이슈 업체메일보내기 클릭 시 업체/isp/hosting 이메일 다 안가져오는 문제 해결("업체 선택" 항목은 제거 처리)
---
src/main/resources/migration/V1_3__insert_new_data.sql | 18 +++++++++++++++++-
1 files changed, 17 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 7e83ca9..86094c9 100644
--- a/src/main/resources/migration/V1_3__insert_new_data.sql
+++ b/src/main/resources/migration/V1_3__insert_new_data.sql
@@ -152,4 +152,20 @@
ALTER TABLE `company_field` ADD COLUMN `parent_sector_id` bigint(11) NULL;
ALTER TABLE `company_field` ADD COLUMN `child_sector_id` bigint(11) NULL;
ALTER TABLE `company_field` ADD COLUMN `region_id` bigint(11) NULL;
-ALTER TABLE `company_field` ADD COLUMN `status_id` bigint(11) NULL;
\ No newline at end of file
+ALTER TABLE `company_field` ADD COLUMN `status_id` bigint(11) NULL;
+ALTER TABLE `company_field` ADD COLUMN `status_name` varchar(50) NULL;
+
+ALTER TABLE `company_field` MODIFY `tel` varchar(255);
+ALTER TABLE `isp_field` MODIFY `tel` varchar(255);
+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