From aee80b74b454e07786753765c94ec73d0485f0bc Mon Sep 17 00:00:00 2001 From: 이민희 <mhlee@maprex.co.kr> Date: 월, 20 12월 2021 18:32:31 +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