From 2c273d1072424a9363314fb258265cbf487f0297 Mon Sep 17 00:00:00 2001 From: 이민희 <mhlee@maprex.co.kr> Date: 목, 16 12월 2021 17:48:46 +0900 Subject: [PATCH] - Excel Import 기능 담당부서도 들어가게 하기(기간 미지정 시에도 가능하도록 수정) - 이슈 통합검색 키워드에 업체,ISP,호스팅 정보도 포함 - 프로젝트에서 설정한 이슈유형만 보여주기 --- src/main/resources/migration/V1_12__Alter_Table.sql | 18 +----------------- 1 files changed, 1 insertions(+), 17 deletions(-) diff --git a/src/main/resources/migration/V1_12__Alter_Table.sql b/src/main/resources/migration/V1_12__Alter_Table.sql index 36a476b..9944ff1 100644 --- a/src/main/resources/migration/V1_12__Alter_Table.sql +++ b/src/main/resources/migration/V1_12__Alter_Table.sql @@ -1,17 +1 @@ --- �븘�닔 �뜲�씠�꽣 �뿬遺� -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; - --- �뾽泥댁쓽 url 而щ읆 INDEX 異붽� -ALTER TABLE `company_field` ADD INDEX `urlIndex`(`url`); +ALTER TABLE `user` ADD INDEX `levelIdIndex`(`level_id`); \ No newline at end of file -- Gitblit v1.8.0