createMzidStatement	INSERT INTO mzid(reportedId,name,version) VALUES(?,?,?)	true
createCvListStatement	INSERT INTO cv_list(mzid_ref) VALUES(?)	true
createCvStatement	INSERT DELAYED 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 DELAYED INTO cv_param(accession,name,value,unitAccession,unitName, softwareName_ref) VALUES(?,?,?,?,?,?)	false
createCvParamForModificationStatement	INSERT DELAYED INTO cv_param(accession,name,value,unitAccession,unitName, modification_ref) VALUES(?,?,?,?,?,?)	false
createCvParamForRoleStatement	INSERT DELAYED INTO cv_param(accession,name,value,unitAccession,unitName, role_ref) VALUES(?,?,?,?,?,?)	false
createCvParamForPersonStatement	INSERT DELAYED INTO cv_param(accession,name,value,unitAccession,unitName, person_ref) VALUES(?,?,?,?,?,?)	false
createCvParamForOrganisationStatement	INSERT DELAYED INTO cv_param(accession,name,value,unitAccession,unitName, organisation_ref) VALUES(?,?,?,?,?,?)	false
createCvParamForSpectrumIdentificationItemStatement	INSERT DELAYED INTO cv_param(accession,name,value,unitAccession,unitName, spectrumIdentificationItem_ref) VALUES(?,?,?,?,?,?)	false
createCvParamForSpectrumIdentificationResultStatement	INSERT DELAYED 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 DELAYED 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 DELAYED INTO db_sequence(reportedId,accession,searchDatabase_ref,sequenceCollection_ref) VALUES(?,?,?,?)	false
createPeptideStatement	INSERT INTO peptide(reportedId,sequenceCollection_ref) VALUES(?,?)	true
createPeptideSequenceStatement	INSERT DELAYED 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 DELAYED INTO user_param(name,value,peptideEvidence_ref) VALUES(?,?,?)	false
createUserParamForSpectrumIdentificationItemStatement	INSERT DELAYED 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,isPassThreshold,rank,peptide_ref,calculatedMassToCharge,experimentalMassToCharge,chargeState,spectrumIdentificationResult_ref) VALUES(?,?,?,?,?,?,?,?)	true
createPeptideEvidenceRefStatement	INSERT DELAYED INTO peptide_evidence_ref(peptideEvidence_ref,spectrumIdentificationItem_ref) VALUES (?,?)	false
        
findMzidVersion	SELECT version FROM mzid WHERE id = ?	false
        
updateSpectrumIdentificationResultStatement	UPDATE spectrum_identification_result SET retention_time = ? WHERE id = ?	false