OWL ITS + 탐지시스템(인터넷 진흥원)
이민희
2021-11-15 dc873bdc1e57945d6cb6eadd41ef38cc2a4b35d3
src/main/resources/migration/V1_10__Alter_Table.sql
@@ -1,10 +1,9 @@
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) NULL,
    `department_name` VARCHAR(50) NOT NULL,
    `department_description` VARCHAR(255) NULL,
    `register_id` BIGINT(20) NOT NULL,
    `register_date` TIMESTAMP NULL,