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 |   11 +++++++++++
 1 files changed, 11 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 7b53c33..cbe5106 100644
--- a/src/main/resources/migration/V1_13__Alter_Table.sql
+++ b/src/main/resources/migration/V1_13__Alter_Table.sql
@@ -22,6 +22,17 @@
 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