| | |
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; |
| | | |
| | | -- 이슈 테이블 타입 설정(1: 메인, 2: 연관, 3: 하위) |
| | | ALTER TABLE `issue_table_config` ADD COLUMN `issue_id` BIGINT(20) NOT NULL; |
| | | ALTER TABLE `issue_table_config` ADD COLUMN `issue_type_id` BIGINT(20) NOT NULL; |
| | | ALTER TABLE `issue_table_config` ADD COLUMN `issue_table_type` INT(11) NOT NULL; |
| | | ALTER TABLE `issue_table_config` ADD INDEX `issueTableTypeIndex`(`issue_table_type`); |
| | | |
| | |
| | | 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_partner` BIGINT(11) NOT NULL DEFAULT '0'; |