From 6e9f504acc73687b623a1f7598eb3833cbc088aa Mon Sep 17 00:00:00 2001
From: 이민희 <mhlee@maprex.co.kr>
Date: 수, 08 12월 2021 18:04:50 +0900
Subject: [PATCH] ** DB 초기화 필요 업체 - url 인덱스 추가 및 url 중복으로 추가 못하도록 수정

---
 src/main/resources/migration/V1_12__Alter_Table.sql |   11 +++++++++--
 1 files changed, 9 insertions(+), 2 deletions(-)

diff --git a/src/main/resources/migration/V1_12__Alter_Table.sql b/src/main/resources/migration/V1_12__Alter_Table.sql
index 8076925..36a476b 100644
--- a/src/main/resources/migration/V1_12__Alter_Table.sql
+++ b/src/main/resources/migration/V1_12__Alter_Table.sql
@@ -1,10 +1,17 @@
 -- �븘�닔 �뜲�씠�꽣 �뿬遺�
 ALTER TABLE `custom_field` ADD COLUMN  `required_data` VARCHAR(1) NOT NULL DEFAULT 'N';
 
--- �룄硫붿씤 �빆紐� 異붽�
+-- url �빆紐� 異붽�
 ALTER TABLE `company_field` ADD COLUMN  `url` VARCHAR(255) NULL;
 ALTER TABLE `isp_field` ADD COLUMN  `url` VARCHAR(255) NULL;
 ALTER TABLE `hosting_field` ADD COLUMN  `url` VARCHAR(255) NULL;
 
+ALTER TABLE `issue_company` ADD COLUMN  `url` VARCHAR(255) NULL;
+ALTER TABLE `issue_isp` ADD COLUMN  `url` VARCHAR(255) NULL;
+ALTER TABLE `issue_hosting` ADD COLUMN  `url` VARCHAR(255) NULL;
+
 -- �옄�룞 �셿猷� �긽�깭 異붽�
-ALTER TABLE `issue_type` ADD COLUMN  `complete_issue_status_id` BIGINT(20) NULL;
\ No newline at end of file
+ALTER TABLE `issue_type` ADD COLUMN  `complete_issue_status_id` BIGINT(20) NULL;
+
+-- �뾽泥댁쓽 url 而щ읆 INDEX 異붽�
+ALTER TABLE `company_field` ADD INDEX `urlIndex`(`url`);

--
Gitblit v1.8.0