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 | 10 +++++++--- 1 files changed, 7 insertions(+), 3 deletions(-) diff --git a/src/main/resources/migration/V1_12__Alter_Table.sql b/src/main/resources/migration/V1_12__Alter_Table.sql index f5f99b7..36a476b 100644 --- a/src/main/resources/migration/V1_12__Alter_Table.sql +++ b/src/main/resources/migration/V1_12__Alter_Table.sql @@ -1,13 +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_type` ADD COLUMN `complete_issue_status_id` BIGINT(20) 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; + +-- �뾽泥댁쓽 url 而щ읆 INDEX 異붽� +ALTER TABLE `company_field` ADD INDEX `urlIndex`(`url`); -- Gitblit v1.8.0