delete from saml_validated_assertion;
SELECT setval('saml_validated_assertion_id_seq', 1);
delete from atna_validated_message;
SELECT setval('atna_validated_message_id_seq', 1);
delete from object_indexer_cda_validated_file;
delete from cda_validated_file;
SELECT setval('cda_validated_file_id_seq', 1);
delete from dicom_validated_object;
SELECT setval('dicom_validated_object_id_seq', 1);
delete from validated_dicomweb;
SELECT setval('validated_dicomweb_id_seq', 1);
delete from validated_dsub;
SELECT setval('validated_dsub_id_seq', 1);
delete from hl7_validated_message;
SELECT setval('hl7_validated_message_id_seq', 1);
delete from hl7v3_validated_message;
SELECT setval('hl7v3_validated_message_id_seq', 1);
delete from validated_hpd;
SELECT setval('validated_hpd_id_seq', 1);
delete from validated_pdf;
SELECT setval('validated_pdf_id_seq', 1);
delete from validated_svs;
SELECT setval('validated_svs_id_seq', 1);
delete from tls_validated_certificate;
SELECT setval('tls_validated_certificate_id_seq', 1);
delete from validated_xds;
SELECT setval('validated_xds_id_seq', 1);
delete from validated_xdw;
SELECT setval('validated_xdw_id_seq', 1);
delete from validated_xml;
SELECT setval('validated_xml_id_seq', 1);
delete from validated_fhir;
SELECT setval('validated_fhir_id_seq', 1);

-- Remove MCA entries

delete from validation_types;
delete from analyzed_object;
SELECT setval('analyzed_object_id_seq', 1);

update analyzed_object_part set parent_id = null;
delete from analyzed_object_part_namespaces;
delete from analyzed_object_part;
SELECT setval('analyzed_object_part_id_seq', 1);
