ALTER TABLE `custom_field_api_overlap` ADD COLUMN `project_id` bigint(20) DEFAULT NULL;
|
ALTER TABLE `custom_field_api_overlap` ADD INDEX `projectIdIndex`(`project_id`);
|
|
ALTER TABLE `issue_type` DROP COLUMN `complete_issue_status_id`;
|
|
-- 이슈 자동 종료 설정 테이블
|
CREATE TABLE IF NOT EXISTS `issue_type_api_end_status` (
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
`user_id` bigint(20) DEFAULT NULL,
|
`project_id` bigint(20) DEFAULT NULL,
|
`issue_type_id` bigint(20) DEFAULT NULL,
|
`issue_status_id` bigint(20) DEFAULT NULL,
|
`register_id` bigint(20) NOT NULL COMMENT 'register_id',
|
`register_date` timestamp NULL DEFAULT NULL COMMENT 'register_date',
|
`modify_id` bigint(20) NOT NULL COMMENT 'modify_id',
|
`modify_date` timestamp NULL DEFAULT NULL COMMENT 'modify_date',
|
PRIMARY KEY (`id`),
|
KEY `userIdIndex` (`user_id`),
|
KEY `projectIdIndex` (`project_id`),
|
KEY `issueTypeIdIndex` (`issue_type_id`),
|
KEY `issueStatusIdIndex` (`issue_status_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
