From a4efd2c5d8f2c31d3bfb6860c58af5cb62606c9a Mon Sep 17 00:00:00 2001 From: wyu <kknd09321@nate.com> Date: 금, 05 11월 2021 10:51:38 +0900 Subject: [PATCH] 부서관리 테이블 변경 및 언어팩 수정 --- src/main/resources/migration/V1_10__Alter_Table.sql | 7 ++----- 1 files changed, 2 insertions(+), 5 deletions(-) diff --git a/src/main/resources/migration/V1_10__Alter_Table.sql b/src/main/resources/migration/V1_10__Alter_Table.sql index 95e9573..734f6c7 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, @@ -24,7 +24,4 @@ `default_yn` VARCHAR (1) NOT NULL DEFAULT 'N', `basic_user` VARCHAR (1) NOT NULL DEFAULT 'N', PRIMARY KEY (`id`) USING btree -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; - -ALTER TABLE `user_workspace` ADD COLUMN `level_name` VARCHAR(50) NOT NULL; -ALTER TABLE `user_workspace` ADD COLUMN `department_name` VARCHAR(50) NOT NULL; \ No newline at end of file +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; \ No newline at end of file -- Gitblit v1.8.0