~jhpark/owl-kisa.git - maprexDevGit

~jhpark / owl-kisa

OWL ITS + 탐지시스템(인터넷 진흥원)

요약
커밋
트리
문서
포크
비교

백앤드 수정

wyu

2021-11-09 6f111a79db77890bc448cd46ea080d94039864cf

 src/main/resources/migration/V1_10__Alter_Table.sql

@@ -1,8 +1,7 @@
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_description` VARCHAR(255) NULL,

			@@ -1,8 +1,7 @@
			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_description` VARCHAR(255) NULL,