From 9c237ff6f08cb7a4121cac6c642660ced1045030 Mon Sep 17 00:00:00 2001 From: 이민희 <mhlee@maprex.co.kr> Date: 화, 21 12월 2021 11:16:02 +0900 Subject: [PATCH] - 트리구조 데이터 없을때 데이터 없음 표시 - 이슈 추가 시 담당부서가 워크플로우 '생성' 상태의 담당부서가 선택되는 기능 --- src/main/resources/migration/V1_10__Alter_Table.sql | 6 ++---- 1 files changed, 2 insertions(+), 4 deletions(-) diff --git a/src/main/resources/migration/V1_10__Alter_Table.sql b/src/main/resources/migration/V1_10__Alter_Table.sql index c65a167..9cca17d 100644 --- a/src/main/resources/migration/V1_10__Alter_Table.sql +++ b/src/main/resources/migration/V1_10__Alter_Table.sql @@ -1,16 +1,14 @@ 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_manage`( +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, `modify_date` TIMESTAMP NULL, - `default_department` VARCHAR (50) NULL DEFAULT '遺��꽌 �뾾�쓬', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- Gitblit v1.8.0