src/main/resources/migration/V1_11__Alter_Table.sql | ●●●●● 패치 | 보기 | raw | blame | 히스토리 |
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;