From 70442b7c9a832ad57bca61d9767ad1451b144cc3 Mon Sep 17 00:00:00 2001
From: wyu <kknd09321@nate.com>
Date: 목, 04 11월 2021 18:28:32 +0900
Subject: [PATCH] 사용자관리 테이블 추가
---
src/main/resources/mybatis/query-template/userWorkspace-template.xml | 2 ++
src/main/resources/migration/V1_10__Alter_Table.sql | 2 ++
2 files changed, 4 insertions(+), 0 deletions(-)
diff --git a/src/main/resources/migration/V1_10__Alter_Table.sql b/src/main/resources/migration/V1_10__Alter_Table.sql
index 94a4154..95e9573 100644
--- a/src/main/resources/migration/V1_10__Alter_Table.sql
+++ b/src/main/resources/migration/V1_10__Alter_Table.sql
@@ -26,3 +26,5 @@
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
diff --git a/src/main/resources/mybatis/query-template/userWorkspace-template.xml b/src/main/resources/mybatis/query-template/userWorkspace-template.xml
index 0b89246..cde0860 100644
--- a/src/main/resources/mybatis/query-template/userWorkspace-template.xml
+++ b/src/main/resources/mybatis/query-template/userWorkspace-template.xml
@@ -9,6 +9,8 @@
u.id as userId,
u.name as userName,
u.account as account,
+ u.levelName as levelName,
+ u.departmentName as departmentName,
/*u.permission as permission,*/
CASE WHEN uw.use_yn = 'Y' THEN 'true' ELSE 'false' END as useYn
FROM
--
Gitblit v1.8.0