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_10__Alter_Table.sql | 5 ++--- 1 files changed, 2 insertions(+), 3 deletions(-) diff --git a/src/main/resources/migration/V1_10__Alter_Table.sql b/src/main/resources/migration/V1_10__Alter_Table.sql index 146e53a..9cca17d 100644 --- a/src/main/resources/migration/V1_10__Alter_Table.sql +++ b/src/main/resources/migration/V1_10__Alter_Table.sql @@ -1,11 +1,10 @@ ALTER TABLE `user` DROP COLUMN `permission`; ALTER TABLE `user` ADD COLUMN `level_id` BIGINT(11) NULL; -ALTER TABLE `user` ADD COLUMN `department_id` BIGINT(11) NULL; -CREATE TABLE `department_management`( +CREATE TABLE `department`( `id` BIGINT(11) AUTO_INCREMENT, `department_name` VARCHAR(50) NOT NULL, - `department_description` VARCHAR(255) NOT NULL, + `department_description` VARCHAR(255) NULL, `register_id` BIGINT(20) NOT NULL, `register_date` TIMESTAMP NULL, `modify_id` BIGINT(20) NOT NULL, -- Gitblit v1.8.0