/***** Script for database tables creation *****/

/*Projects*/
CREATE TABLE `tblProjects` (
  `Projects_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `Projects_name_S100TEXT` varchar(100) default NULL,
  `Projects_description_S250TEXT` varchar(255) default NULL,
  `Projects_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`Projects_id_LONGINT`)
) TYPE=InnoDB

/*Genes*/
CREATE TABLE `tblGenes` (
  `Genes_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `Genes_name_S100TEXT` varchar(100) default NULL,
  `Genes_project_LONGINT` bigint(20) default NULL,
  `Genes_genomeSeqBuildNb_S50TEXT` varchar(50) default NULL,
  `Genes_chromosome_S50TEXT` varchar(50) default NULL,
  `Genes_posSeqContig_S50TEXT` varchar(50) default NULL,
  `Genes_posRefNt_INTEGER` int(11) default NULL,
  `Genes_commentsPosRefNt_S250TEXT` varchar(255) default NULL,
  `Genes_comments_S250TEXT` varchar(255) default NULL,
  `Genes_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`Genes_id_LONGINT`),
  KEY `IDX_tblGenes_project` (`Genes_project_LONGINT`),
  CONSTRAINT `tblGenes_ibfk_1` FOREIGN KEY (`Genes_project_LONGINT`) REFERENCES `tblProjects` (`Projects_id_LONGINT`)
) TYPE=InnoDB

/*DNA Samples*/
CREATE TABLE `tblDNASamples` (
  `DNASamples_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `DNASamples_gcs_name_S100TEXT` varchar(100) default NULL,
  `DNASamples_ext_name1_S100TEXT` varchar(100) default NULL,
  `DNASamples_ext_name2_S100TEXT` varchar(100) default NULL,
  `DNASamples_date_DATE` date default NULL,
  `DNASamples_comments_S250TEXT` varchar(255) default NULL,
  `DNASamples_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`DNASamples_id_LONGINT`)
) TYPE=InnoDB


/*Samples Projects*/
CREATE TABLE `tblSamplesProjects` (
  `SamplesProjects_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `SamplesProjects_dna_sample_LONGINT` bigint(20) default NULL,
  `SamplesProjects_project_LONGINT` bigint(20) default NULL,
  `SamplesProjects_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`SamplesProjects_id_LONGINT`),
  KEY `IDX_tblSamplesProjects_dna_sample` (`SamplesProjects_dna_sample_LONGINT`),
  KEY `IDX_tblSamplesProjects_project` (`SamplesProjects_project_LONGINT`),
  CONSTRAINT `tblSamplesProjects_ibfk_1` FOREIGN KEY (`SamplesProjects_dna_sample_LONGINT`) REFERENCES `tblDNASamples` (`DNASamples_id_LONGINT`),
  CONSTRAINT `tblSamplesProjects_ibfk_2` FOREIGN KEY (`SamplesProjects_project_LONGINT`) REFERENCES `tblProjects` (`Projects_id_LONGINT`)
) TYPE=InnoDB

/*DNA Plates*/
CREATE TABLE `tblDNAPlates` (
  `DNAPlates_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `DNAPlates_barcode_S20TEXT` varchar(20) default NULL,
  `DNAPlates_type_S100TEXT` varchar(100) default NULL,
  `DNAPlates_volume_S20TEXT` varchar(20) default NULL,
  `DNAPlates_concentration_S20TEXT` varchar(20) default NULL,
  `DNAPlates_date_DATE` date default NULL,
  `DNAPlates_comments_S250TEXT` varchar(255) default NULL,
  `DNAPlates_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`DNAPlates_id_LONGINT`),
  UNIQUE KEY `IDX_tblDNAPlates_barcode` (`DNAPlates_barcode_S20TEXT`)
) TYPE=InnoDB

/*DNA Wells*/
CREATE TABLE `tblDNAWells` (
  `DNAWells_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `DNAWells_dna_sample_LONGINT` bigint(20) default NULL,
  `DNAWells_dna_plate_LONGINT` bigint(20) default NULL,
  `DNAWells_position_S2TEXT` char(3) default NULL,
  `DNAWells_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`DNAWells_id_LONGINT`),
  KEY `IDX_tblDNAWells_dna_sample` (`DNAWells_dna_sample_LONGINT`),
  KEY `IDX_tblDNAWells_dna_plate` (`DNAWells_dna_plate_LONGINT`),
  CONSTRAINT `tblDNAWells_ibfk_1` FOREIGN KEY (`DNAWells_dna_sample_LONGINT`) REFERENCES `tblDNASamples` (`DNASamples_id_LONGINT`),
  CONSTRAINT `tblDNAWells_ibfk_2` FOREIGN KEY (`DNAWells_dna_plate_LONGINT`) REFERENCES `tblDNAPlates` (`DNAPlates_id_LONGINT`)
) TYPE=InnoDB

/*DNA Plates 384*/
CREATE TABLE `tblDNAPlates384` (
  `DNAPlates384_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `DNAPlates384_barcode_S20TEXT` varchar(20) default NULL,
  `DNAPlates384_dna_plate1_LONGINT` bigint(20) default NULL,
  `DNAPlates384_dna_plate2_LONGINT` bigint(20) default NULL,
  `DNAPlates384_dna_plate3_LONGINT` bigint(20) default NULL,
  `DNAPlates384_dna_plate4_LONGINT` bigint(20) default NULL,
  `DNAPlates384_date_DATE` date default NULL,
  `DNAPlates384_comments_S250TEXT` varchar(255) default NULL,
  `DNAPlates384_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`DNAPlates384_id_LONGINT`),
  KEY `IDX_tblDNAPlates384_dna_plate1` (`DNAPlates384_dna_plate1_LONGINT`),
  KEY `IDX_tblDNAPlates384_dna_plate2` (`DNAPlates384_dna_plate2_LONGINT`),
  KEY `IDX_tblDNAPlates384_dna_plate3` (`DNAPlates384_dna_plate3_LONGINT`),
  KEY `IDX_tblDNAPlates384_dna_plate4` (`DNAPlates384_dna_plate4_LONGINT`),
  CONSTRAINT `tblDNAPlates384_ibfk_1` FOREIGN KEY (`DNAPlates384_dna_plate1_LONGINT`) REFERENCES `tblDNAPlates` (`DNAPlates_id_LONGINT`),
  CONSTRAINT `tblDNAPlates384_ibfk_2` FOREIGN KEY (`DNAPlates384_dna_plate2_LONGINT`) REFERENCES `tblDNAPlates` (`DNAPlates_id_LONGINT`),
  CONSTRAINT `tblDNAPlates384_ibfk_3` FOREIGN KEY (`DNAPlates384_dna_plate3_LONGINT`) REFERENCES `tblDNAPlates` (`DNAPlates_id_LONGINT`),
  CONSTRAINT `tblDNAPlates384_ibfk_4` FOREIGN KEY (`DNAPlates384_dna_plate4_LONGINT`) REFERENCES `tblDNAPlates` (`DNAPlates_id_LONGINT`)
) TYPE=InnoDB

/*Staff*/
CREATE TABLE `tblStaff` (
  `Staff_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `Staff_name_S100TEXT` varchar(100) default NULL,
  `Staff_room_INTEGER` int(4) default NULL,
  `Staff_phone_INTEGER` int(4) default NULL,
  `Staff_email_S100TEXT` varchar(100) default NULL,
  `Staff_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`Staff_id_LONGINT`)
) TYPE=InnoDB

/*Suppliers*/
CREATE TABLE `tblSuppliers` (
  `Suppliers_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `Suppliers_name_S100TEXT` varchar(100) default NULL,
  `Suppliers_address_S250TEXT` varchar(255) default NULL,
  `Suppliers_phone_S100TEXT` varchar(100) default NULL,
  `Suppliers_email_S100TEXT` varchar(100) default NULL,
  `Suppliers_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`Suppliers_id_LONGINT`)
) TYPE=InnoDB

/*Reagents*/
CREATE TABLE `tblReagents` (
  `Reagents_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `Reagents_name_S100TEXT` varchar(100) default NULL,
  `Reagents_supplier_LONGINT` bigint(20) default NULL,
  `Reagents_staff_LONGINT` bigint(20) default NULL,
  `Reagents_notebook_INTEGER` int(11) default NULL,
  `Reagents_notebook_page_INTEGER` int(11) default NULL,
  `Reagents_recipe_S250TEXT` varchar(255) default NULL,
  `Reagents_date_delivery_DATE` date default NULL,
  `Reagents_comments_S250TEXT` varchar(255) default NULL,
  `Reagents_type_S100TEXT` varchar(100) default NULL,
  `Reagents_state_S100TEXT` varchar(100) default NULL,
  `Reagents_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`Reagents_id_LONGINT`),
  KEY `IDX_tblReagents_supplier` (`Reagents_supplier_LONGINT`),
  KEY `IDX_tblReagents_staff` (`Reagents_staff_LONGINT`),
  CONSTRAINT `tblReagents_ibfk_1` FOREIGN KEY (`Reagents_supplier_LONGINT`) REFERENCES `tblSuppliers` (`Suppliers_id_LONGINT`),
  CONSTRAINT `tblReagents_ibfk_2` FOREIGN KEY (`Reagents_staff_LONGINT`) REFERENCES `tblStaff` (`Staff_id_LONGINT`)
) TYPE=InnoDB


/*Primers*/
CREATE TABLE `tblPrimers` (
  `Primers_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `Primers_name_S100TEXT` varchar(100) default NULL,
  `Primers_type_S10TEXT` varchar(10) default NULL,
  `Primers_sequence_S250TEXT` varchar(255) default NULL,
  `Primers_concentration_S100TEXT` varchar(100) default NULL,
  `Primers_supplier_LONGINT` bigint(20) default NULL,
  `Primers_date_delivery_DATE` date default NULL,
  `Primers_comments_S250TEXT` varchar(255) default NULL,
  `Primers_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`Primers_id_LONGINT`),
  KEY `IDX_tblPrimers_supplier` (`Primers_supplier_LONGINT`),
  CONSTRAINT `tblPrimers_ibfk_1` FOREIGN KEY (`Primers_supplier_LONGINT`) REFERENCES `tblSuppliers` (`Suppliers_id_LONGINT`)
) TYPE=InnoDB

/*Amplicons*/
CREATE TABLE `tblAmplicons` (
  `Amplicons_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `Amplicons_name_S100TEXT` varchar(100) default NULL,
  `Amplicons_gene_LONGINT` bigint(20) default NULL,
  `Amplicons_type_S100TEXT` varchar(100) default NULL,
  `Amplicons_tr_frame_INTEGER` int(11) default NULL,
  `Amplicons_sequence_S250TEXT` varchar(255) default NULL,
  `Amplicons_exon_position_S20TEXT` varchar(20) default NULL,
  `Amplicons_nb_pol_INTEGER` int(2) default NULL,
  `Amplicons_F_scr_window_S20TEXT` varchar(20) default NULL,
  `Amplicons_R_scr_window_S20TEXT` varchar(20) default NULL,
  `Amplicons_primer1_LONGINT` bigint(20) default NULL,
  `Amplicons_primer2_LONGINT` bigint(20) default NULL,
  `Amplicons_primer3_LONGINT` bigint(20) default NULL,
  `Amplicons_file_scf_BLOB` longblob,
  `Amplicons_file_scf_Fabi_BLOB` longblob,
  `Amplicons_file_scf_Rabi_BLOB` longblob,
  `Amplicons_date_DATE` date default NULL,
  `Amplicons_comments_S250TEXT` varchar(255) default NULL,
  `Amplicons_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`Amplicons_id_LONGINT`),
  KEY `IDX_tblAmplicons_primer1` (`Amplicons_primer1_LONGINT`),
  KEY `IDX_tblAmplicons_primer2` (`Amplicons_primer2_LONGINT`),
  KEY `IDX_tblAmplicons_primer3` (`Amplicons_primer3_LONGINT`),
  KEY `IDX_tblAmplicons_gene` (`Amplicons_gene_LONGINT`),
  CONSTRAINT `tblAmplicons_ibfk_1` FOREIGN KEY (`Amplicons_primer1_LONGINT`) REFERENCES `tblPrimers` (`Primers_id_LONGINT`),
  CONSTRAINT `tblAmplicons_ibfk_2` FOREIGN KEY (`Amplicons_primer2_LONGINT`) REFERENCES `tblPrimers` (`Primers_id_LONGINT`),
  CONSTRAINT `tblAmplicons_ibfk_3` FOREIGN KEY (`Amplicons_primer3_LONGINT`) REFERENCES `tblPrimers` (`Primers_id_LONGINT`),
  CONSTRAINT `tblAmplicons_ibfk_4` FOREIGN KEY (`Amplicons_gene_LONGINT`) REFERENCES `tblGenes` (`Genes_id_LONGINT`)
) TYPE=InnoDB

/*Amplicons Batches*/
CREATE TABLE `tblAmpliconsBatches` (
  `AmpliconsBatches_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `AmpliconsBatches_name_S100TEXT` varchar(100) default NULL,
  `AmpliconsBatches_amp1_LONGINT` bigint(20) default NULL,
  `AmpliconsBatches_amp2_LONGINT` bigint(20) default NULL,
  `AmpliconsBatches_amp3_LONGINT` bigint(20) default NULL,
  `AmpliconsBatches_amp4_LONGINT` bigint(20) default NULL,
  `AmpliconsBatches_date_DATE` date default NULL,
  `AmpliconsBatches_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`AmpliconsBatches_id_LONGINT`),
  KEY `IDX_tblAmpliconsBatches_amp1` (`AmpliconsBatches_amp1_LONGINT`),
  KEY `IDX_tblAmpliconsBatches_amp2` (`AmpliconsBatches_amp2_LONGINT`),
  KEY `IDX_tblAmpliconsBatches_amp3` (`AmpliconsBatches_amp3_LONGINT`),
  KEY `IDX_tblAmpliconsBatches_amp4` (`AmpliconsBatches_amp4_LONGINT`),
  CONSTRAINT `tblAmpliconsBatches_ibfk_1` FOREIGN KEY (`AmpliconsBatches_amp1_LONGINT`) REFERENCES `tblAmplicons` (`Amplicons_id_LONGINT`),
  CONSTRAINT `tblAmpliconsBatches_ibfk_2` FOREIGN KEY (`AmpliconsBatches_amp2_LONGINT`) REFERENCES `tblAmplicons` (`Amplicons_id_LONGINT`),
  CONSTRAINT `tblAmpliconsBatches_ibfk_3` FOREIGN KEY (`AmpliconsBatches_amp3_LONGINT`) REFERENCES `tblAmplicons` (`Amplicons_id_LONGINT`),
  CONSTRAINT `tblAmpliconsBatches_ibfk_4` FOREIGN KEY (`AmpliconsBatches_amp4_LONGINT`) REFERENCES `tblAmplicons` (`Amplicons_id_LONGINT`)
) TYPE=InnoDB

/*Amplicons Compatibilities*/
CREATE TABLE `tblAmpliconsCompatibilities` (
  `AmpliconsCompatibilities_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `AmpliconsCompatibilities_amp_PCR1_LONGINT` bigint(20) default NULL,
  `AmpliconsCompatibilities_amp_PCR2_LONGINT` bigint(20) default NULL,
  `AmpliconsCompatibilities_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`AmpliconsCompatibilities_id_LONGINT`),
  KEY `IDX_tblAmpliconsCompatibilities_amp_PCR1` (`AmpliconsCompatibilities_amp_PCR1_LONGINT`),
  KEY `IDX_tblAmpliconsCompatibilities_amp_PCR2` (`AmpliconsCompatibilities_amp_PCR2_LONGINT`),
  CONSTRAINT `tblAmpliconsCompatibilities_ibfk_1` FOREIGN KEY (`AmpliconsCompatibilities_amp_PCR1_LONGINT`) REFERENCES `tblAmplicons` (`Amplicons_id_LONGINT`),
  CONSTRAINT `tblAmpliconsCompatibilities_ibfk_2` FOREIGN KEY (`AmpliconsCompatibilities_amp_PCR2_LONGINT`) REFERENCES `tblAmplicons` (`Amplicons_id_LONGINT`)
) TYPE=InnoDB

/*Seq Pols*/
CREATE TABLE `tblSeqPols` (
  `SeqPols_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `SeqPols_amplicon_LONGINT` bigint(20) default NULL,
  `SeqPols_rs_S100TEXT` varchar(100) default NULL,
  `SeqPols_ref_seq_S100TEXT` varchar(100) default NULL,
  `SeqPols_type_S20TEXT` varchar(20) default NULL,
  `SeqPols_gene_position_INTEGER` int(11) default NULL,
  `SeqPols_amp_position_INTEGER` int(11) default NULL,
  `SeqPols_func_position_S100TEXT` varchar(100) default NULL,
  `SeqPols_majNT_S100TEXT` varchar(100) default NULL,
  `SeqPols_minNT_S100TEXT` varchar(100) default NULL,
  `SeqPols_majAA_S20TEXT` varchar(20) default NULL,
  `SeqPols_minAA_S20TEXT` varchar(20) default NULL,
  `SeqPols_nb_codons_INTEGER` int(11) default NULL,
  `SeqPols_flanking_seq_TEXT` text,
  `SeqPols_origin_S250TEXT` varchar(255) default NULL,
  `SeqPols_comments_S250TEXT` varchar(255) default NULL,
  `SeqPols_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`SeqPols_id_LONGINT`),
  KEY `IDX_tblSeqPols_amp` (`SeqPols_amplicon_LONGINT`),
  CONSTRAINT `tblSeqPols_ibfk_1` FOREIGN KEY (`SeqPols_amplicon_LONGINT`) REFERENCES `tblAmplicons` (`Amplicons_id_LONGINT`)
) TYPE=InnoDB

/*Plates For PCR*/
CREATE TABLE `tblPlatesForPCR` (
  `PlatesForPCR_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `PlatesForPCR_barcode_S20TEXT` varchar(20) default NULL,
  `PlatesForPCR_type_S100TEXT` varchar(100) default NULL,
  `PlatesForPCR_comments_S250TEXT` varchar(255) default NULL,
  `PlatesForPCR_reagent1_LONGINT` bigint(20) default NULL,
  `PlatesForPCR_reagent2_LONGINT` bigint(20) default NULL,
  `PlatesForPCR_state_S100TEXT` varchar(100) default 'Good',
  `PlatesForPCR_date_prep_oil_DATE` date default NULL,
  `PlatesForPCR_date_prep_mix_DATE` date default NULL,
  `PlatesForPCR_date_use_DATE` date default NULL,
  `PlatesForPCR_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`PlatesForPCR_id_LONGINT`),
  UNIQUE KEY `IDX_tblPlatesForPCR_barcode` (`PlatesForPCR_barcode_S20TEXT`),
  KEY `IDX_tblPlatesForPCR_reagent1` (`PlatesForPCR_reagent1_LONGINT`),
  KEY `IDX_tblPlatesForPCR_reagent2` (`PlatesForPCR_reagent2_LONGINT`),
  CONSTRAINT `tblPlatesForPCR_ibfk_1` FOREIGN KEY (`PlatesForPCR_reagent1_LONGINT`) REFERENCES `tblReagents` (`Reagents_id_LONGINT`),
  CONSTRAINT `tblPlatesForPCR_ibfk_2` FOREIGN KEY (`PlatesForPCR_reagent2_LONGINT`) REFERENCES `tblReagents` (`Reagents_id_LONGINT`)
) TYPE=InnoDB

/*Plates PCR1*/
CREATE TABLE `tblPlatesPCR1` (
  `PlatesPCR1_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `PlatesPCR1_plate_for_PCR_LONGINT` bigint(20) default NULL,
  `PlatesPCR1_dna_plate_LONGINT` bigint(20) default NULL,
  `PlatesPCR1_dna_384_LONGINT` bigint(20) default '1',
  `PlatesPCR1_ampbatch1_LONGINT` bigint(20) default NULL,
  `PlatesPCR1_ampbatch2_LONGINT` bigint(20) default NULL,
  `PlatesPCR1_ampbatch3_LONGINT` bigint(20) default NULL,
  `PlatesPCR1_ampbatch4_LONGINT` bigint(20) default NULL,
  `PlatesPCR1_state_S100TEXT` varchar(100) default NULL,
  `PlatesPCR1_date_DATE` date default NULL,
  `PlatesPCR1_comments_S250TEXT` varchar(255) default NULL,
  `PlatesPCR1_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`PlatesPCR1_id_LONGINT`),
  KEY `IDX_tblPlatesPCR1_plate_for_PCR` (`PlatesPCR1_plate_for_PCR_LONGINT`),
  KEY `IDX_tblPlatesPCR1_dna_plate` (`PlatesPCR1_dna_plate_LONGINT`),
  KEY `IDX_tblPlatesPCR1_ampbatch1` (`PlatesPCR1_ampbatch1_LONGINT`),
  KEY `IDX_tblPlatesPCR1_ampbatch2` (`PlatesPCR1_ampbatch2_LONGINT`),
  KEY `IDX_tblPlatesPCR1_ampbatch3` (`PlatesPCR1_ampbatch3_LONGINT`),
  KEY `IDX_tblPlatesPCR1_ampbatch4` (`PlatesPCR1_ampbatch4_LONGINT`),
  KEY `IDX_tblPlatesPCR1_dna_384` (`PlatesPCR1_dna_384_LONGINT`),
  CONSTRAINT `tblPlatesPCR1_ibfk_1` FOREIGN KEY (`PlatesPCR1_plate_for_PCR_LONGINT`) REFERENCES `tblPlatesForPCR` (`PlatesForPCR_id_LONGINT`),
  CONSTRAINT `tblPlatesPCR1_ibfk_2` FOREIGN KEY (`PlatesPCR1_dna_plate_LONGINT`) REFERENCES `tblDNAPlates` (`DNAPlates_id_LONGINT`),
  CONSTRAINT `tblPlatesPCR1_ibfk_3` FOREIGN KEY (`PlatesPCR1_ampbatch1_LONGINT`) REFERENCES `tblAmpliconsBatches` (`AmpliconsBatches_id_LONGINT`),
  CONSTRAINT `tblPlatesPCR1_ibfk_4` FOREIGN KEY (`PlatesPCR1_ampbatch2_LONGINT`) REFERENCES `tblAmpliconsBatches` (`AmpliconsBatches_id_LONGINT`),
  CONSTRAINT `tblPlatesPCR1_ibfk_5` FOREIGN KEY (`PlatesPCR1_ampbatch3_LONGINT`) REFERENCES `tblAmpliconsBatches` (`AmpliconsBatches_id_LONGINT`),
  CONSTRAINT `tblPlatesPCR1_ibfk_6` FOREIGN KEY (`PlatesPCR1_ampbatch4_LONGINT`) REFERENCES `tblAmpliconsBatches` (`AmpliconsBatches_id_LONGINT`),
  CONSTRAINT `tblPlatesPCR1_ibfk_7` FOREIGN KEY (`PlatesPCR1_dna_384_LONGINT`) REFERENCES `tblDNAPlates384` (`DNAPlates384_id_LONGINT`)
) TYPE=InnoDB

/*Plates PCR2*/
CREATE TABLE `tblPlatesPCR2` (
  `PlatesPCR2_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `PlatesPCR2_plate_for_PCR_LONGINT` bigint(20) default NULL,
  `PlatesPCR2_plate_PCR1_LONGINT` bigint(20) default NULL,
  `PlatesPCR2_amp1_LONGINT` bigint(20) default NULL,
  `PlatesPCR2_amp2_LONGINT` bigint(20) default NULL,
  `PlatesPCR2_amp3_LONGINT` bigint(20) default NULL,
  `PlatesPCR2_amp4_LONGINT` bigint(20) default NULL,
  `PlatesPCR2_state_S100TEXT` varchar(100) default NULL,
  `PlatesPCR2_date_DATE` date default NULL,
  `PlatesPCR2_comments_S250TEXT` varchar(255) default NULL,
  `PlatesPCR2_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`PlatesPCR2_id_LONGINT`),
  KEY `IDX_tblPlatesPCR2_amp1` (`PlatesPCR2_amp1_LONGINT`),
  KEY `IDX_tblPlatesPCR2_amp2` (`PlatesPCR2_amp2_LONGINT`),
  KEY `IDX_tblPlatesPCR2_amp3` (`PlatesPCR2_amp3_LONGINT`),
  KEY `IDX_tblPlatesPCR2_amp4` (`PlatesPCR2_amp4_LONGINT`),
  KEY `IDX_tblPlatesPCR2_plate_for_PCR` (`PlatesPCR2_plate_for_PCR_LONGINT`),
  KEY `IDX_tblPlatesPCR2_plate_PCR1` (`PlatesPCR2_plate_PCR1_LONGINT`),
  CONSTRAINT `tblPlatesPCR2_ibfk_1` FOREIGN KEY (`PlatesPCR2_amp1_LONGINT`) REFERENCES `tblAmplicons` (`Amplicons_id_LONGINT`),
  CONSTRAINT `tblPlatesPCR2_ibfk_2` FOREIGN KEY (`PlatesPCR2_amp2_LONGINT`) REFERENCES `tblAmplicons` (`Amplicons_id_LONGINT`),
  CONSTRAINT `tblPlatesPCR2_ibfk_3` FOREIGN KEY (`PlatesPCR2_amp3_LONGINT`) REFERENCES `tblAmplicons` (`Amplicons_id_LONGINT`),
  CONSTRAINT `tblPlatesPCR2_ibfk_4` FOREIGN KEY (`PlatesPCR2_amp4_LONGINT`) REFERENCES `tblAmplicons` (`Amplicons_id_LONGINT`),
  CONSTRAINT `tblPlatesPCR2_ibfk_5` FOREIGN KEY (`PlatesPCR2_plate_for_PCR_LONGINT`) REFERENCES `tblPlatesForPCR` (`PlatesForPCR_id_LONGINT`),
  CONSTRAINT `tblPlatesPCR2_ibfk_6` FOREIGN KEY (`PlatesPCR2_plate_PCR1_LONGINT`) REFERENCES `tblPlatesPCR1` (`PlatesPCR1_id_LONGINT`)
) TYPE=InnoDB

/*Plates HR*/
CREATE TABLE `tblPlatesHR` (
  `PlatesHR_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `PlatesHR_barcode_S20TEXT` varchar(20) default NULL,
  `PlatesHR_platePCR1_1_LONGINT` bigint(20) default NULL,
  `PlatesHR_platePCR1_2_LONGINT` bigint(20) default NULL,
  `PlatesHR_platePCR1_3_LONGINT` bigint(20) default NULL,
  `PlatesHR_platePCR1_4_LONGINT` bigint(20) default NULL,
  `PlatesHR_platePCR2_1_LONGINT` bigint(20) default NULL,
  `PlatesHR_platePCR2_2_LONGINT` bigint(20) default NULL,
  `PlatesHR_platePCR2_3_LONGINT` bigint(20) default NULL,
  `PlatesHR_platePCR2_4_LONGINT` bigint(20) default NULL,
  `PlatesHR_raw_file_BLOB` longblob,
  `PlatesHR_state_S100TEXT` varchar(100) default NULL,
  `PlatesHR_date_loading_DATE` date default NULL,
  `PlatesHR_comments_S250TEXT` varchar(255) default NULL,
  `PlatesHR_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`PlatesHR_id_LONGINT`),
  KEY `IDX_tblPlatesHR_platePCR1_1` (`PlatesHR_platePCR1_1_LONGINT`),
  KEY `IDX_tblPlatesHR_platePCR1_2` (`PlatesHR_platePCR1_2_LONGINT`),
  KEY `IDX_tblPlatesHR_platePCR1_3` (`PlatesHR_platePCR1_3_LONGINT`),
  KEY `IDX_tblPlatesHR_platePCR1_4` (`PlatesHR_platePCR1_4_LONGINT`),
  KEY `IDX_tblPlatesHR_platePCR2_1` (`PlatesHR_platePCR2_1_LONGINT`),
  KEY `IDX_tblPlatesHR_platePCR2_2` (`PlatesHR_platePCR2_2_LONGINT`),
  KEY `IDX_tblPlatesHR_platePCR2_3` (`PlatesHR_platePCR2_3_LONGINT`),
  KEY `IDX_tblPlatesHR_platePCR2_4` (`PlatesHR_platePCR2_4_LONGINT`),
  CONSTRAINT `tblPlatesHR_ibfk_1` FOREIGN KEY (`PlatesHR_platePCR1_1_LONGINT`) REFERENCES `tblPlatesPCR1` (`PlatesPCR1_id_LONGINT`),
  CONSTRAINT `tblPlatesHR_ibfk_2` FOREIGN KEY (`PlatesHR_platePCR1_2_LONGINT`) REFERENCES `tblPlatesPCR1` (`PlatesPCR1_id_LONGINT`),
  CONSTRAINT `tblPlatesHR_ibfk_3` FOREIGN KEY (`PlatesHR_platePCR1_3_LONGINT`) REFERENCES `tblPlatesPCR1` (`PlatesPCR1_id_LONGINT`),
  CONSTRAINT `tblPlatesHR_ibfk_4` FOREIGN KEY (`PlatesHR_platePCR1_4_LONGINT`) REFERENCES `tblPlatesPCR1` (`PlatesPCR1_id_LONGINT`),
  CONSTRAINT `tblPlatesHR_ibfk_5` FOREIGN KEY (`PlatesHR_platePCR2_1_LONGINT`) REFERENCES `tblPlatesPCR2` (`PlatesPCR2_id_LONGINT`),
  CONSTRAINT `tblPlatesHR_ibfk_6` FOREIGN KEY (`PlatesHR_platePCR2_2_LONGINT`) REFERENCES `tblPlatesPCR2` (`PlatesPCR2_id_LONGINT`),
  CONSTRAINT `tblPlatesHR_ibfk_7` FOREIGN KEY (`PlatesHR_platePCR2_3_LONGINT`) REFERENCES `tblPlatesPCR2` (`PlatesPCR2_id_LONGINT`),
  CONSTRAINT `tblPlatesHR_ibfk_8` FOREIGN KEY (`PlatesHR_platePCR2_4_LONGINT`) REFERENCES `tblPlatesPCR2` (`PlatesPCR2_id_LONGINT`)
) TYPE=InnoDB

/*Genotypes HR*/
CREATE TABLE `tblGenotypesHR` (
  `GenotypesHR_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `GenotypesHR_sample_LONGINT` bigint(20) default NULL,
  `GenotypesHR_plateHR_LONGINT` bigint(20) default NULL,
  `GenotypesHR_position_S2TEXT` char(3) default NULL,
  `GenotypesHR_amplicon_LONGINT` bigint(20) default NULL,
  `GenotypesHR_call_S20TEXT` varchar(50) default NULL,
  `GenotypesHR_Tm1_S20TEXT` varchar(20) default NULL,
  `GenotypesHR_width1_S20TEXT` varchar(20) default NULL,
  `GenotypesHR_Tm2_S20TEXT` varchar(20) default NULL,
  `GenotypesHR_width2_S20TEXT` varchar(20) default NULL,
  `GenotypesHR_Tm3_S20TEXT` varchar(20) default NULL,
  `GenotypesHR_width3_S20TEXT` varchar(20) default NULL,
  `GenotypesHR_Tm4_S20TEXT` varchar(20) default NULL,
  `GenotypesHR_width4_S20TEXT` varchar(20) default NULL,
  `GenotypesHR_Tm5_S20TEXT` varchar(20) default NULL,
  `GenotypesHR_width5_S20TEXT` varchar(20) default NULL,
  `GenotypesHR_Tm6_S20TEXT` varchar(20) default NULL,
  `GenotypesHR_width6_S20TEXT` varchar(20) default NULL,
  `GenotypesHR_comments_S250TEXT` varchar(255) default NULL,
  `GenotypesHR_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`GenotypesHR_id_LONGINT`),
  KEY `IDX_tblGenotypesHR_sample` (`GenotypesHR_sample_LONGINT`),
  KEY `IDX_tblGenotypesHR_plateHR` (`GenotypesHR_plateHR_LONGINT`),
  KEY `IDX_tblGenotypesHR_amplicon` (`GenotypesHR_amplicon_LONGINT`),
  CONSTRAINT `tblGenotypesHR_ibfk_1` FOREIGN KEY (`GenotypesHR_sample_LONGINT`) REFERENCES `tblDNASamples` (`DNASamples_id_LONGINT`),
  CONSTRAINT `tblGenotypesHR_ibfk_2` FOREIGN KEY (`GenotypesHR_plateHR_LONGINT`) REFERENCES `tblPlatesHR` (`PlatesHR_id_LONGINT`),
  CONSTRAINT `tblGenotypesHR_ibfk_3` FOREIGN KEY (`GenotypesHR_amplicon_LONGINT`) REFERENCES `tblAmplicons` (`Amplicons_id_LONGINT`)
) TYPE=InnoDB

/*Plates EXOSAP*/
CREATE TABLE `tblPlatesEXOSAP` (
  `PlatesEXOSAP_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `PlatesEXOSAP_type_S100TEXT` varchar(100) default NULL,
  `PlatesEXOSAP_barcode_S20TEXT` varchar(20) default NULL,
  `PlatesEXOSAP_plate_PCR2_LONGINT` bigint(20) default NULL,
  `PlatesEXOSAP_plate_hr1_LONGINT` bigint(20) default '6',
  `PlatesEXOSAP_plate_hr2_LONGINT` bigint(20) default '6',
  `PlatesEXOSAP_plate_hr3_LONGINT` bigint(20) default '6',
  `PlatesEXOSAP_reagent_LONGINT` bigint(20) default NULL,
  `PlatesEXOSAP_state_S100TEXT` varchar(100) default NULL,
  `PlatesEXOSAP_date_DATE` date default NULL,
  `PlatesEXOSAP_comments_S250TEXT` varchar(255) default NULL,
  `PlatesEXOSAP_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`PlatesEXOSAP_id_LONGINT`),
  KEY `IDX_tblPlatesEXOSAP_plate_PCR2` (`PlatesEXOSAP_plate_PCR2_LONGINT`),
  KEY `IDX_tblPlatesEXOSAP_reagent` (`PlatesEXOSAP_reagent_LONGINT`),
  KEY `IDX_tblPlatesEXOSAP_plate_hr1` (`PlatesEXOSAP_plate_hr1_LONGINT`),
  KEY `IDX_tblPlatesEXOSAP_plate_hr2` (`PlatesEXOSAP_plate_hr2_LONGINT`),
  KEY `IDX_tblPlatesEXOSAP_plate_hr3` (`PlatesEXOSAP_plate_hr3_LONGINT`),
  CONSTRAINT `tblPlatesEXOSAP_ibfk_5` FOREIGN KEY (`PlatesEXOSAP_plate_PCR2_LONGINT`) REFERENCES `tblPlatesPCR2` (`PlatesPCR2_id_LONGINT`),
  CONSTRAINT `tblPlatesEXOSAP_ibfk_6` FOREIGN KEY (`PlatesEXOSAP_reagent_LONGINT`) REFERENCES `tblReagents` (`Reagents_id_LONGINT`),
  CONSTRAINT `tblPlatesEXOSAP_ibfk_7` FOREIGN KEY (`PlatesEXOSAP_plate_hr1_LONGINT`) REFERENCES `tblPlatesHR` (`PlatesHR_id_LONGINT`),
  CONSTRAINT `tblPlatesEXOSAP_ibfk_8` FOREIGN KEY (`PlatesEXOSAP_plate_hr2_LONGINT`) REFERENCES `tblPlatesHR` (`PlatesHR_id_LONGINT`),
  CONSTRAINT `tblPlatesEXOSAP_ibfk_9` FOREIGN KEY (`PlatesEXOSAP_plate_hr3_LONGINT`) REFERENCES `tblPlatesHR` (`PlatesHR_id_LONGINT`)
) TYPE=InnoDB

/*EXOSAP Wells*/
CREATE TABLE `tblEXOSAPWells` (
  `EXOSAPWells_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `EXOSAPWells_plate_EXOSAP_LONGINT` bigint(20) default NULL,
  `EXOSAPWells_position_S2TEXT` char(3) default NULL,
  `EXOSAPWells_sample_LONGINT` bigint(20) default NULL,
  `EXOSAPWells_amplicon_LONGINT` bigint(20) default NULL,
  `EXOSAPWells_plate_hr_LONGINT` bigint(20) default NULL,
  `EXOSAPWells_position_hr_S2TEXT` char(3) default NULL,
  PRIMARY KEY  (`EXOSAPWells_id_LONGINT`),
  KEY `IDX_tblEXOSAPWells_plate_exosap` (`EXOSAPWells_plate_EXOSAP_LONGINT`),
  KEY `IDX_tblEXOSAPWells_sample` (`EXOSAPWells_sample_LONGINT`),
  KEY `IDX_tblEXOSAPWells_amplicon` (`EXOSAPWells_amplicon_LONGINT`),
  KEY `IDX_tblEXOSAPWells_plate_hr` (`EXOSAPWells_plate_hr_LONGINT`),
  CONSTRAINT `tblEXOSAPWells_ibfk_1` FOREIGN KEY (`EXOSAPWells_plate_EXOSAP_LONGINT`) REFERENCES `tblPlatesEXOSAP` (`PlatesEXOSAP_id_LONGINT`),
  CONSTRAINT `tblEXOSAPWells_ibfk_2` FOREIGN KEY (`EXOSAPWells_sample_LONGINT`) REFERENCES `tblDNASamples` (`DNASamples_id_LONGINT`),
  CONSTRAINT `tblEXOSAPWells_ibfk_3` FOREIGN KEY (`EXOSAPWells_amplicon_LONGINT`) REFERENCES `tblAmplicons` (`Amplicons_id_LONGINT`),
  CONSTRAINT `tblEXOSAPWells_ibfk_4` FOREIGN KEY (`EXOSAPWells_plate_hr_LONGINT`) REFERENCES `tblPlatesHR` (`PlatesHR_id_LONGINT`)
) TYPE=InnoDB

/*Plates For Seq*/
CREATE TABLE `tblPlatesForSeq` (
  `PlatesForSeq_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `PlatesForSeq_barcode_S20TEXT` varchar(20) default NULL,
  `PlatesForSeq_direction_S1TEXT` char(2) default NULL,
  `PlatesForSeq_reagent1_LONGINT` bigint(20) default NULL,
  `PlatesForSeq_reagent2a_LONGINT` bigint(20) default NULL,
  `PlatesForSeq_reagent2t_LONGINT` bigint(20) default NULL,
  `PlatesForSeq_reagent2c_LONGINT` bigint(20) default NULL,
  `PlatesForSeq_reagent2g_LONGINT` bigint(20) default NULL,
  `PlatesForSeq_state_S100TEXT` varchar(100) default NULL,
  `PlatesForSeq_date_prep_oil_DATE` date default NULL,
  `PlatesForSeq_date_prep_mix_DATE` date default NULL,
  `PlatesForSeq_date_use_DATE` date default NULL,
  `PlatesForSeq_comments_S250TEXT` varchar(255) default NULL,
  `PlatesForSeq_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`PlatesForSeq_id_LONGINT`),
  KEY `IDX_tblPlatesForSeq_reagent1` (`PlatesForSeq_reagent1_LONGINT`),
  KEY `IDX_tblPlatesForSeq_reagent2a` (`PlatesForSeq_reagent2a_LONGINT`),
  KEY `IDX_tblPlatesForSeq_reagent2t` (`PlatesForSeq_reagent2t_LONGINT`),
  KEY `IDX_tblPlatesForSeq_reagent2c` (`PlatesForSeq_reagent2c_LONGINT`),
  KEY `IDX_tblPlatesForSeq_reagent2g` (`PlatesForSeq_reagent2g_LONGINT`),
  CONSTRAINT `tblPlatesForSeq_ibfk_1` FOREIGN KEY (`PlatesForSeq_reagent1_LONGINT`) REFERENCES `tblReagents` (`Reagents_id_LONGINT`),
  CONSTRAINT `tblPlatesForSeq_ibfk_2` FOREIGN KEY (`PlatesForSeq_reagent2a_LONGINT`) REFERENCES `tblReagents` (`Reagents_id_LONGINT`),
  CONSTRAINT `tblPlatesForSeq_ibfk_3` FOREIGN KEY (`PlatesForSeq_reagent2t_LONGINT`) REFERENCES `tblReagents` (`Reagents_id_LONGINT`),
  CONSTRAINT `tblPlatesForSeq_ibfk_4` FOREIGN KEY (`PlatesForSeq_reagent2c_LONGINT`) REFERENCES `tblReagents` (`Reagents_id_LONGINT`),
  CONSTRAINT `tblPlatesForSeq_ibfk_5` FOREIGN KEY (`PlatesForSeq_reagent2g_LONGINT`) REFERENCES `tblReagents` (`Reagents_id_LONGINT`)
) TYPE=InnoDB

/*Plates Seq*/
CREATE TABLE `tblPlatesSeq` (
  `PlatesSeq_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `PlatesSeq_plate_for_seq_LONGINT` bigint(20) default NULL,
  `PlatesSeq_plate_exosap_LONGINT` bigint(20) default NULL,
  `PlatesSeq_type_S100TEXT` varchar(100) default NULL,
  `PlatesSeq_state_S100TEXT` varchar(100) default NULL,
  `PlatesSeq_date_DATE` date default NULL,
  `PlatesSeq_comments_S250TEXT` varchar(255) default NULL,
  `PlatesSeq_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`PlatesSeq_id_LONGINT`),
  KEY `IDX_tblPlatesSeq_plate_for_seq` (`PlatesSeq_plate_for_seq_LONGINT`),
  KEY `IDX_tblPlatesSeq_plate_exosap` (`PlatesSeq_plate_exosap_LONGINT`),
  CONSTRAINT `tblPlatesSeq_ibfk_1` FOREIGN KEY (`PlatesSeq_plate_for_seq_LONGINT`) REFERENCES `tblPlatesForSeq` (`PlatesForSeq_id_LONGINT`),
  CONSTRAINT `tblPlatesSeq_ibfk_2` FOREIGN KEY (`PlatesSeq_plate_exosap_LONGINT`) REFERENCES `tblPlatesEXOSAP` (`PlatesEXOSAP_id_LONGINT`)
) TYPE=InnoDB

/*Plates Con*/
CREATE TABLE `tblPlatesCon` (
  `PlatesCon_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `PlatesCon_barcode_S20TEXT` varchar(20) default NULL,
  `PlatesCon_reagent1_LONGINT` bigint(20) default NULL,
  `PlatesCon_reagent2_LONGINT` bigint(20) default NULL,
  `PlatesCon_plate_seq_LONGINT` bigint(20) default NULL,
  `PlatesCon_type_S100TEXT` varchar(100) default NULL,
  `PlatesCon_state_S100TEXT` varchar(100) default NULL,
  `PlatesCon_date_precipitation_DATE` date default NULL,
  `PlatesCon_date_loading_DATE` date default NULL,
  `PlatesCon_comments_S250TEXT` varchar(255) default NULL,
  `PlatesCon_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`PlatesCon_id_LONGINT`),
  KEY `IDX_tblPlatesCon_reagent1` (`PlatesCon_reagent1_LONGINT`),
  KEY `IDX_tblPlatesCon_reagent2` (`PlatesCon_reagent2_LONGINT`),
  KEY `IDX_tblPlatesCon_plate_seq` (`PlatesCon_plate_seq_LONGINT`),
  CONSTRAINT `tblPlatesCon_ibfk_1` FOREIGN KEY (`PlatesCon_reagent1_LONGINT`) REFERENCES `tblReagents` (`Reagents_id_LONGINT`),
  CONSTRAINT `tblPlatesCon_ibfk_2` FOREIGN KEY (`PlatesCon_reagent2_LONGINT`) REFERENCES `tblReagents` (`Reagents_id_LONGINT`),
  CONSTRAINT `tblPlatesCon_ibfk_3` FOREIGN KEY (`PlatesCon_plate_seq_LONGINT`) REFERENCES `tblPlatesSeq` (`PlatesSeq_id_LONGINT`)
) TYPE=InnoDB

/*Files*/
CREATE TABLE `tblFiles` (
  `Files_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `Files_name_S100TEXT` varchar(100) default NULL,
  `Files_file_BLOB` longblob,
  `Files_type_S100TEXT` varchar(100) default NULL,
  `Files_plate_con_LONGINT` bigint(20) default NULL,
  `Files_date_DATE` date default NULL,
  `Files_quality1_S100TEXT` varchar(100) default NULL,
  `Files_quality2_S100TEXT` varchar(100) default NULL,
  `Files_state_S100TEXT` varchar(100) default NULL,
  `Files_comments_S250TEXT` varchar(255) default NULL,
  `Files_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`Files_id_LONGINT`),
  KEY `IDX_tblFiles_plate_con` (`Files_plate_con_LONGINT`),
  KEY `Files_name_S100TEXT` (`Files_name_S100TEXT`),
  CONSTRAINT `tblFiles_ibfk_1` FOREIGN KEY (`Files_plate_con_LONGINT`) REFERENCES `tblPlatesCon` (`PlatesCon_id_LONGINT`)
) TYPE=InnoDB

/*Samples Files*/
CREATE TABLE `tblSamplesFiles` (
  `SamplesFiles_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `SamplesFiles_sample_LONGINT` bigint(20) default NULL,
  `SamplesFiles_sample_position_S2TEXT` char(3) default NULL,
  `SamplesFiles_fileF_LONGINT` bigint(20) default NULL,
  `SamplesFiles_fileR_LONGINT` bigint(20) default NULL,
  PRIMARY KEY  (`SamplesFiles_id_LONGINT`),
  KEY `IDX_tblSamplesFiles_sample` (`SamplesFiles_sample_LONGINT`),
  KEY `IDX_tblSamplesFiles_fileF` (`SamplesFiles_fileF_LONGINT`),
  KEY `IDX_tblSamplesFiles_fileR` (`SamplesFiles_fileR_LONGINT`),
  CONSTRAINT `tblSamplesFiles_ibfk_1` FOREIGN KEY (`SamplesFiles_sample_LONGINT`) REFERENCES `tblDNASamples` (`DNASamples_id_LONGINT`),
  CONSTRAINT `tblSamplesFiles_ibfk_2` FOREIGN KEY (`SamplesFiles_fileF_LONGINT`) REFERENCES `tblFiles` (`Files_id_LONGINT`),
  CONSTRAINT `tblSamplesFiles_ibfk_3` FOREIGN KEY (`SamplesFiles_fileR_LONGINT`) REFERENCES `tblFiles` (`Files_id_LONGINT`)
) TYPE=InnoDB

/*ScreeningSets*/
CREATE TABLE `tblScreeningSets` (
  `ScreeningSets_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `ScreeningSets_name_S100TEXT` varchar(100) default NULL,
  `ScreeningSets_amplicon_LONGINT` bigint(20) default NULL,
  `ScreeningSets_type_S20TEXT` varchar(20) default NULL,
  `ScreeningSets_F_window_S20TEXT` varchar(20) default NULL,
  `ScreeningSets_R_window_S20TEXT` varchar(20) default NULL,
  `ScreeningSets_file_trg_BLOB` longblob,
  `ScreeningSets_file_result_BLOB` longblob,
  `ScreeningSets_date_DATE` date default NULL,
  `ScreeningSets_comments_S250TEXT` varchar(255) default NULL,
  `ScreeningSets_update_S250TEXT` varchar(255) default NULL,
  PRIMARY KEY  (`ScreeningSets_id_LONGINT`),
  KEY `ScreeningSets_name_S100TEXT` (`ScreeningSets_name_S100TEXT`),
  KEY `ScreeningSets_amplicon_LONGINT` (`ScreeningSets_amplicon_LONGINT`)
) TYPE=InnoDB

/*ScreeningSets Samples Files*/
CREATE TABLE `tblScreeningSetsSamplesFiles` (
  `ScreeningSetsSamplesFiles_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `ScreeningSetsSamplesFiles_screening_set_LONGINT` bigint(20) default NULL,
  `ScreeningSetsSamplesFiles_seq_files_LONGINT` bigint(20) default NULL,
  `ScreeningSetsSamplesFiles_seq_files_status_S10TEXT` varchar(20) default NULL,
  `ScreeningSetsSamplesFiles_dat_fileF_BLOB` longblob,
  `ScreeningSetsSamplesFiles_dat_fileR_BLOB` longblob,
  PRIMARY KEY  (`ScreeningSetsSamplesFiles_id_LONGINT`),
  KEY `IDX_tblScreeningSetsSamplesFiles_screening_set` (`ScreeningSetsSamplesFiles_screening_set_LONGINT`),
  KEY `IDX_tblScreeningSetsSamplesFiles_seq_files` (`ScreeningSetsSamplesFiles_seq_files_LONGINT`),
  CONSTRAINT `tblScreeningSetsSamplesFiles_ibfk_1` FOREIGN KEY (`ScreeningSetsSamplesFiles_screening_set_LONGINT`) REFERENCES `tblScreeningSets` (`ScreeningSets_id_LONGINT`),
  CONSTRAINT `tblScreeningSetsSamplesFiles_ibfk_2` FOREIGN KEY (`ScreeningSetsSamplesFiles_seq_files_LONGINT`) REFERENCES `tblSamplesFiles` (`SamplesFiles_id_LONGINT`)
) TYPE=InnoDB

/*ScreeningSets Polymorphisms*/
CREATE TABLE `tblScreeningSetsPolymorphisms` (
  `ScreeningSetsPolymorphisms_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `ScreeningSetsPolymorphisms_screening_set_LONGINT` bigint(20) default NULL,
  `ScreeningSetsPolymorphisms_polymorphism_S20TEXT` varchar(20) default NULL,
  PRIMARY KEY  (`ScreeningSetsPolymorphisms_id_LONGINT`),
  KEY `IDX_tblScreeningSetsPolymorphisms_screening_set` (`ScreeningSetsPolymorphisms_screening_set_LONGINT`),
  CONSTRAINT `tblScreeningSetsPolymorphisms_ibfk_1` FOREIGN KEY (`ScreeningSetsPolymorphisms_screening_set_LONGINT`) REFERENCES `tblScreeningSets` (`ScreeningSets_id_LONGINT`)
) TYPE=InnoDB

/*ScreeningSets Samples Polymorphisms Results*/
CREATE TABLE `tblScreeningSetsSamplesPolymorpResults` (
  `ScreeningSetsSamplesPolymorpResults_id_LONGINT` bigint(20) NOT NULL auto_increment,
  `ScreeningSetsSamplesPolymorpResults_scr_set_sample_files_LONGINT` bigint(20) default NULL,
  `ScreeningSetsSamplesPolymorpResults_scr_set_polymorphism_LONGINT` bigint(20) default NULL,
  `ScreeningSetsSamplesPolymorpResults_result_S20TEXT` varchar(20) default NULL,
  PRIMARY KEY  (`ScreeningSetsSamplesPolymorpResults_id_LONGINT`),
  KEY `IDX_tblScreeningSetsSamplesPolymorpResults_scr_set_sample_files` (`ScreeningSetsSamplesPolymorpResults_scr_set_sample_files_LONGINT`),
  KEY `IDX_tblScreeningSetsSamplesPolymorpResults_scr_set_polymorp` (`ScreeningSetsSamplesPolymorpResults_scr_set_polymorphism_LONGINT`),
  CONSTRAINT `tblScreeningSetsSamplesPolymorpResults_ibfk_1` FOREIGN KEY (`ScreeningSetsSamplesPolymorpResults_scr_set_sample_files_LONGINT`) REFERENCES `tblScreeningSetsSamplesFiles` (`ScreeningSetsSamplesFiles_id_LONGINT`),
  CONSTRAINT `tblScreeningSetsSamplesPolymorpResults_ibfk_2` FOREIGN KEY (`ScreeningSetsSamplesPolymorpResults_scr_set_polymorphism_LONGINT`) REFERENCES `tblScreeningSetsPolymorphisms` (`ScreeningSetsPolymorphisms_id_LONGINT`)
) TYPE=InnoDB