createMzidStatement	INSERT INTO mzid(reportedId,name,version) VALUES(?,?,?)	true
createCvListStatement	INSERT INTO cv_list(mzid_ref) VALUES(?)	true
createCvStatement	INSERT INTO cv(reportedId,uri,version,fullName,cvList_ref) VALUES(?,?,?,?,?)	false
createAnalysisSoftwareListStatement	INSERT INTO analysis_software_list(mzid_ref) VALUES(?)	true
createAnalysisSoftwareStatement	INSERT INTO analysis_software(reportedId,version,name,asList_ref) VALUES(?,?,?,?)	true
createSoftwareNameStatement	INSERT INTO software_name(as_ref) VALUES(?)	true
createCvParamForSoftwareNameStatement	INSERT INTO cv_param(accession,name,value,unitAccession,unitName, softwareName_ref) VALUES(?,?,?,?,?,?)	false
createCvParamForModificationStatement	INSERT INTO cv_param(accession,name,value,unitAccession,unitName, modification_ref) VALUES(?,?,?,?,?,?)	false
createCvParamForRoleStatement	INSERT INTO cv_param(accession,name,value,unitAccession,unitName, role_ref) VALUES(?,?,?,?,?,?)	false
createCvParamForPersonStatement	INSERT INTO cv_param(accession,name,value,unitAccession,unitName, person_ref) VALUES(?,?,?,?,?,?)	false
createCvParamForOrganisationStatement	INSERT INTO cv_param(accession,name,value,unitAccession,unitName, organisation_ref) VALUES(?,?,?,?,?,?)	false
createCvParamForSpectrumIdentificationItemStatement	INSERT INTO cv_param(accession,name,value,unitAccession,unitName, spectrumIdentificationItem_ref) VALUES(?,?,?,?,?,?)	false
createCvParamForSpectrumIdentificationResultStatement	INSERT INTO cv_param(accession,name,value,unitAccession,unitName, spectrumIdentificationResult_ref) VALUES(?,?,?,?,?,?)	false
createProviderStatement	INSERT INTO provider(reportedId, mzid_ref) VALUES(?,?)	true
createContactRoleStatement	INSERT INTO contact_role(contact_ref,provider_ref) VALUES(?,?)	true
createRoleStatement	INSERT INTO role(contactRole_ref) VALUES(?)	true
createAuditCollectionStatement	INSERT INTO audit_collection(mzid_ref) VALUES(?)	true
createPersonStatement	INSERT INTO person(reportedId,firstName,lastName,auditCollection_ref) VALUES(?,?,?,?)	true
createAffiliationStatement	INSERT INTO affiliation(organization_ref,person_ref) VALUES(?,?)	false
createOrganisationStatement	INSERT INTO organisation(reportedId,name,auditCollection_ref) VALUES(?,?,?)	true
createSequenceCollectionStatement	INSERT INTO sequence_collection(mzid_ref) VALUES(?)	true
createDbSequenceStatement	INSERT INTO db_sequence(reportedId,accession,searchDatabase_ref,sequenceCollection_ref) VALUES(?,?,?,?)	false
createPeptideStatement	INSERT INTO peptide(reportedId,sequenceCollection_ref) VALUES(?,?)	true
createPeptideSequenceStatement	INSERT INTO peptide_sequence(sequence,peptide_ref) VALUES(?,?)	false
createModificationStatement	INSERT INTO modification(monoisotopic_mass_delta,residues,location, peptide_ref) VALUES(?,?,?,?)	true
createPeptideEvidenceStatement	INSERT INTO peptide_evidence(reportedId,isDecoy,post,pre,end,start,peptide_ref,dbSequence_ref,sequenceCollection_ref) VALUES(?,?,?,?,?,?,?,?,?)	true
createUserParamForPeptideEvidenceStatement	INSERT INTO user_param(name,value,peptideEvidence_ref) VALUES(?,?,?)	false
createUserParamForSpectrumIdentificationItemStatement	INSERT INTO user_param(name,value,spectrumIdentificationItem_ref) VALUES(?,?,?)	false
createDataCollectionStatement	INSERT INTO data_collection(mzid_ref) VALUES (?)	true
createAnalysisDataStatement	INSERT INTO analysis_data(dataCollection_ref) VALUES(?)	true
createSpectrumIdentificationListStatement	INSERT INTO spectrum_identification_list(reportedId, analysisData_ref) VALUES(?,?)	true
createSpectrumIdentificationResultStatement	INSERT INTO spectrum_identification_result(reportedId,spectrumID,spectraData_ref,spectrumIdentificationList_ref) VALUES (?,?,?,?)	true
createSpectrumIdentificationItemStatement	INSERT INTO spectrum_identification_item(reportedId,name,isPassThreshold,rank,peptide_ref,calculatedMassToCharge,experimentalMassToCharge,chargeState,spectrumIdentificationResult_ref) VALUES(?,?,?,?,?,?,?,?)	true
createPeptideEvidenceRefStatement	INSERT INTO peptide_evidence_ref(peptideEvidence_ref,spectrumIdentificationItem_ref) VALUES (?,?)	false
createProteinDetectionListStatement	INSERT INTO protein_detection_list(reportedId,analysisData_ref) VALUES (?,?)	true
createAnalysisProtocolCollection	INSERT INTO analysis_protocol_collection(mzid_id) VALUES (?)	true
        
findMzidVersion	SELECT version FROM mzid WHERE id = ?	false
findAnalysisData	SELECT id FROM analysis_data WHERE mzid_ref = ?	false
findSpectrumIdentificationLists	SELECT id,reportedId FROM spectrum_identification_list WHERE analysisData_ref = ?	false
findSpectrumIdentificationResults	SELECT id,reportedId,spectrumID WHERE spectrumIdentificationList_ref = ?	false
findProteinDetectionLists	SELECT id,reportedId FROM protein_detection_list WHERE analysisData_ref = ?	false
findAnalysisProtocolCollection	SELECT id FROM analysis_protocol_collection WHERE mzid_id = ?	false
findSequenceCollection	SELECT id FROM sequence_collection WHERE mzid_id = ?	false
findPeptideEvidenceByRef	SELECT id,reportedId,isDecoy,post,pre,end,start,peptide_ref,dbSequence_ref FROM peptide_evidence WHERE sequenceCollection_ref in (SELECT id FROM sequence_collection WHERE mzid_id = ?) AND reportedId = ?	false
findPeptideByRef	SELECT id,reportedId FROM peptide WHERE sequenceCollection_ref in (SELECT id FROM sequence_collection WHERE mzid_id = ?) AND reportedId = ?	false
findSpectrumIdentificationResultByRef	SELECT id,reportedId,spectrumID FROM spectrum_identification_result WHERE spectrumIdentificationList_ref in (SELECT id FROM spectrum_identification_list WHERE analysisData_ref in (SELECT id FROM analysis_data WHERE mzid_id = ?)) AND reportedId = ?	false
findSpectrumIdentificationItemByRef	SELECT id,reportedId,name,isPassThreshold,rank,peptide_ref,calculatedMassToCharge,experimentalMassToCharge,chargeState FROM spectrum_identification_item WHERE spectrumIdentificationResult_ref in (SELECT id FROM spectrum_identification_result WHERE spectrumIdentificationList_ref in (SELECT id FROM spectrum_identification_list WHERE analysisData_ref in (SELECT id FROM analysis_data WHERE mzid_id = ?))) AND reportedId = ?	false
        
updateSpectrumIdentificationResultStatement	UPDATE spectrum_identification_result SET retention_time = ? WHERE id = ?	false