From 235dc86c096fcf06b0ff5d4ac31f754f44fc320e Mon Sep 17 00:00:00 2001 From: wyu <kknd09321@nate.com> Date: 월, 08 11월 2021 18:00:41 +0900 Subject: [PATCH] 업체 관리 백엔드 수정 --- src/main/resources/migration/V1_10__Alter_Table.sql | 3 ++- 1 files changed, 2 insertions(+), 1 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..c65a167 100644 --- a/src/main/resources/migration/V1_10__Alter_Table.sql +++ b/src/main/resources/migration/V1_10__Alter_Table.sql @@ -2,7 +2,7 @@ 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_manage`( `id` BIGINT(11) AUTO_INCREMENT, `department_name` VARCHAR(50) NOT NULL, `department_description` VARCHAR(255) NOT NULL, @@ -10,6 +10,7 @@ `register_date` TIMESTAMP NULL, `modify_id` BIGINT(20) NOT NULL, `modify_date` TIMESTAMP NULL, + `default_department` VARCHAR (50) NULL DEFAULT '遺��꽌 �뾾�쓬', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- Gitblit v1.8.0