How to completely uninstall and remove all Insight data

If you want to uninstall Insight and remove all data from the database, you need to do the following steps:

1. Uninstall Insight
2. Delete directory JIRA_HOME/data/attachments/insight
3. Delete all Insight tables starting with prefix "AO_8542F1" and the associated sequences. Because of constraints, you will need to delete them in a  specific order.
4. Lookup the upgrade index in Jira database and reset it by following this instructions. This is important in order to reset Jira.
5. Run these SQL queries, depending on the database type:

   UPDATE propertystring SET propertyvalue = '0' WHERE id = (SELECT id FROM propertyentry WHERE property_key = 'com.riadalabs.jira.plugins.insight:build');
   DELETE FROM propertystring where ID = (SELECT ID FROM propertyentry WHERE property_key = ‘insight_installed_version’)
   DELETE FROM propertystring where ID = (SELECT id FROM propertyentry WHERE property_key = 'insight_new_icon_set')
   DELETE FROM propertystring where ID = (SELECT id FROM propertyentry WHERE property_key = 'insight_themeable_icon_set_import_1')