Merge branch 'master' of http://192.168.0.25:9001/r/owl-kisa
| | |
| | | `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; |
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
| | |
| | | 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 |