drop index if exists pentest_report_findings_report_asset_id_idx;
drop index if exists pentest_report_ports_report_asset_id_idx;

alter table pentest_report_findings
    drop column if exists report_asset_id;

alter table pentest_report_ports
    drop column if exists report_asset_id;

drop table if exists pentest_report_assets;
