From 2a4399780b2e146331fbdf0c931fc67dee5e844f Mon Sep 17 00:00:00 2001 From: wyu <kknd09321@nate.com> Date: 일, 12 12월 2021 10:41:42 +0900 Subject: [PATCH] 이메일 템플릿 수정[DB 초기화 필요] --- src/main/resources/migration/V1_13__Alter_Table.sql | 21 +++++++++++++++++++++ 1 files changed, 21 insertions(+), 0 deletions(-) diff --git a/src/main/resources/migration/V1_13__Alter_Table.sql b/src/main/resources/migration/V1_13__Alter_Table.sql index 36a476b..cbe5106 100644 --- a/src/main/resources/migration/V1_13__Alter_Table.sql +++ b/src/main/resources/migration/V1_13__Alter_Table.sql @@ -15,3 +15,24 @@ -- �뾽泥댁쓽 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