CREATE TABLE IF NOT EXISTS `issue_reservation` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `issue_id` bigint(20) DEFAULT NULL, `workspace_id` bigint(20) DEFAULT NULL, `reservation` varchar(10) DEFAULT NULL, `issue_reservation_type` varchar(10) DEFAULT NULL, `register_id` bigint(20) NOT NULL, `register_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `modify_id` bigint(20) NOT NULL, `modify_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `workspaceIdIndex` (`workspace_id`), KEY `issueIdIndex` (`issue_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;