From 4d06a7593fba3df556fc3728c142554907c6b157 Mon Sep 17 00:00:00 2001 From: 이민희 <mhlee@maprex.co.kr> Date: 수, 15 12월 2021 10:46:45 +0900 Subject: [PATCH] '전체 이슈 프로젝트 보기' 권한 '이슈 관리' 권한으로 변경 - 이슈관리: 모든 이슈 수정 가능 --- src/main/resources/migration/V1_13__Alter_Table.sql | 21 --------------------- 1 files changed, 0 insertions(+), 21 deletions(-) diff --git a/src/main/resources/migration/V1_13__Alter_Table.sql b/src/main/resources/migration/V1_13__Alter_Table.sql index cbe5106..36a476b 100644 --- a/src/main/resources/migration/V1_13__Alter_Table.sql +++ b/src/main/resources/migration/V1_13__Alter_Table.sql @@ -15,24 +15,3 @@ -- �뾽泥댁쓽 url 而щ읆 INDEX 異붽� ALTER TABLE `company_field` ADD INDEX `urlIndex`(`url`); - -ALTER TABLE `company_field` ADD COLUMN `isp_id` bigint(20) DEFAULT NULL; -ALTER TABLE `company_field` ADD COLUMN `hosting_id` bigint(20) DEFAULT NULL; - -ALTER TABLE `company_field` ADD INDEX `ispIdIndex`(`isp_id`); -ALTER TABLE `company_field` ADD INDEX `hostingIdIndex`(`hosting_id`); - -CREATE TABLE `email_template`( - `id` BIGINT(11) AUTO_INCREMENT, - `title` VARCHAR (255) NOT NULL, - `template` mediumtext NOT NULL, - `register_id` BIGINT(20) NOT NULL, - `register_date` TIMESTAMP NULL, - `modify_id` BIGINT(20) NOT NULL, - `modify_date` TIMESTAMP NULL, - PRIMARY KEY (`id`) USING BTREE -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; - - - - -- Gitblit v1.8.0