====== Troubleshooting - How to delete a wrong ticket ======

Author: Yanjun Wang

===== Request =====
//Part of PM of Poles project//

<code>Delete all the old PM of Poles tickets on QA. </code>

----

===== Solution =====

From database:

<code>

1. delete all the form entries from related form tables based on change_id
2. delete all the Ticket Change entries for forms from ticket_change table based on the ticket_id
3. delete all the attachments entries from uploadable_file table and ticket_uploadable_file based on ticket_id
4. delete all the Ticket Status entries from ticket_status based on the ticket_id
5. delete other related entries, like emails
6. delete the ticket from ticket table

</code>