| | |
| | | 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, |
| | |
| | | `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; |