OWL ITS + 탐지시스템(인터넷 진흥원)
이민희
2021-11-25 72cbca5a2e1263ad691bc7b3c0080691640309ab
src/main/resources/migration/V1_11__Alter_Table.sql
@@ -205,4 +205,9 @@
                                      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,호스팅 ID 컬럼 추가
ALTER TABLE `issue_type` ADD COLUMN  `company_id` BIGINT(20) NULL;
ALTER TABLE `issue_type` ADD COLUMN  `isp_id` BIGINT(20) NULL;
ALTER TABLE `issue_type` ADD COLUMN  `hosting_id` BIGINT(20) NULL;