| | |
|---|
| | | 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_management`( |
|---|
| | | 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, |
|---|
