How to restore a deleted task in Redmine?

Question

MySQL

How can I restore a deleted task in Redmine? If this cannot be done through the system itself, then maybe you can somehow restore it directly through the MySQL database?

Answer 1

No way. Why ?
You can restore details from logs, the same e-mail notifications, and so on.

Answer 2

If there is a backup, then it's easy!
The issue is described by the following fields:
SELECT * FROM issues WHERE id = <issue_id>;
SELECT * FROM journals WHERE journalized_id = <issue_id>;
SELECT * FROM journal_details WHERE journal_id IN (SELECT id FROM journals WHERE journalized_id = <task_id>);
SELECT * FROM attachments WHERE container_id = <task_id>;
SELECT * FROM custom_values ​​WHERE customized_id = <task_id>;
SELECT * FROM watchers WHERE watchable_id = <task_id>;
SELECT * FROM issue_relations WHERE issue_from_id = <issue_id> OR issue_to_id = <issue_id>;
/*select * from time_entries where issue_id = <issue_id>;*/
And files
SELECT disk_filename FROM attachments WHERE container_id = <task_id>;