| | |
|---|
| | | 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_name` VARCHAR(50) 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; |
|---|
| | | |
|---|
