OWL ITS + 탐지시스템(인터넷 진흥원)
이민희
2021-11-26 392f3bae3fba9de4a366e81c201bfa7d7055ff3b
src/main/resources/migration/V1_11__Alter_Table.sql
@@ -205,4 +205,7 @@
                                      INDEX `workflowIdIndex` (`workflow_id`) USING BTREE,
                                      INDEX `issueStatusIdIndex` (`issue_status_id`) USING BTREE,
                                      INDEX `departmentIdIndex` (`department_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- issue_type 테이블 업체,ISP,호스팅 컬럼 추가
ALTER TABLE `issue_type` ADD COLUMN  `use_company` BIGINT(11) NOT NULL DEFAULT '0';