# DBTools DBMYSQL - MySQL Database Dump
#

# Dumping Table Structure for div_aa_annotation

#
CREATE TABLE `div_aa_annotation` (
  `div_aa_annotation_id` bigint(20) NOT NULL auto_increment,
  `div_annotation_type_id` bigint(20) default '0',
  `div_allele_assay_id` bigint(20) default '0',
  `annotation_value` varchar(50) default NULL,
  PRIMARY KEY  (`div_aa_annotation_id`),
  KEY `div_aa_annotationdiv_annotation_type_id` (`div_annotation_type_id`),
  KEY `genotypeExpAnnotationID` (`div_aa_annotation_id`),
  KEY `genotypeExpID` (`div_allele_assay_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_allele

#
CREATE TABLE `div_allele` (
  `div_allele_id` bigint(20) NOT NULL auto_increment,
  `div_obs_unit_sample_id` bigint(20) default '0',
  `div_allele_assay_id` bigint(20) default '0',
  `allele_num` bigint(20) default '0',
  `quality` text,
  `value` text,
  `proportion` bigint(20) default '0',
  `total_n` bigint(20) default '0',
  PRIMARY KEY  (`div_allele_id`),
  KEY `allele_num` (`allele_num`),
  KEY `div_allele_assay_id` (`div_allele_assay_id`),
  KEY `div_stock_sample_id` (`div_obs_unit_sample_id`),
  KEY `genotypeID` (`div_allele_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_allele_assay

#
CREATE TABLE `div_allele_assay` (
  `div_allele_assay_id` bigint(20) NOT NULL auto_increment,
  `div_marker_id` bigint(20) default '0',
  `div_source_assay_id` bigint(20) default '0',
  `div_poly_type_id` bigint(20) default '0',
  `comments` varchar(50) default NULL,
  `assay_date` datetime default NULL,
  `name` varchar(50) default NULL,
  `producer` varchar(50) default NULL,
  `position` varchar(50) default NULL,
  `ref_seq` varchar(50) default NULL,
  `div_ref_stock_id` bigint(20) default '0',
  `fd_length` bigint(20) default '0',
  PRIMARY KEY  (`div_allele_assay_id`),
  KEY `div_marker_id` (`div_marker_id`),
  KEY `div_poly_type_id` (`div_poly_type_id`),
  KEY `div_ref_stock_id` (`div_ref_stock_id`),
  KEY `div_source_assay_id` (`div_source_assay_id`),
  KEY `genotypeExpID` (`div_allele_assay_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_annotation_type

#
CREATE TABLE `div_annotation_type` (
  `div_annotation_type_id` bigint(20) NOT NULL auto_increment,
  `anno_type` varchar(50) default NULL,
  PRIMARY KEY  (`div_annotation_type_id`),
  KEY `annotationTypeID` (`div_annotation_type_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_experiment

#
CREATE TABLE `div_experiment` (
  `div_experiment_id` bigint(20) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `design` varchar(50) default NULL,
  `originator` varchar(50) default NULL,
  `comments` varchar(50) default NULL,
  PRIMARY KEY  (`div_experiment_id`),
  KEY `phenotype_exp_id` (`div_experiment_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_generation

#
CREATE TABLE `div_generation` (
  `div_generation_id` bigint(20) NOT NULL auto_increment,
  `value` varchar(50) default NULL,
  PRIMARY KEY  (`div_generation_id`),
  KEY `div_generation_id` (`div_generation_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_locality

#
CREATE TABLE `div_locality` (
  `div_locality_id` bigint(20) NOT NULL auto_increment,
  `elevation` bigint(20) default '0',
  `city` varchar(50) default NULL,
  `country` varchar(50) default NULL,
  `origcty` varchar(50) default NULL,
  `latitude` bigint(20) default '0',
  `longitude` bigint(20) default '0',
  `locality_name` varchar(50) default NULL,
  `state_province` varchar(50) default NULL,
  PRIMARY KEY  (`div_locality_id`),
  KEY `localityID` (`div_locality_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_locus

#
CREATE TABLE `div_locus` (
  `div_locus_id` bigint(20) NOT NULL auto_increment,
  `chromosome_number` bigint(20) default '0',
  `comments` varchar(50) default NULL,
  `genetic_bin` varchar(50) default NULL,
  `genetic_map` varchar(50) default NULL,
  `genetic_position` bigint(20) default '0',
  `locus_type` varchar(50) default NULL,
  `name` varchar(50) default NULL,
  `physical_position` bigint(20) default '0',
  PRIMARY KEY  (`div_locus_id`),
  KEY `locusID` (`div_locus_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_marker

#
CREATE TABLE `div_marker` (
  `div_marker_id` bigint(20) NOT NULL auto_increment,
  `div_locus_id` bigint(20) default '0',
  `name` varchar(50) default NULL,
  `ref_seq` varchar(50) default NULL,
  `div_ref_stock_id` bigint(20) default '0',
  PRIMARY KEY  (`div_marker_id`),
  KEY `diversity_locus_id` (`div_locus_id`),
  KEY `diversity_maker_id` (`div_marker_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_obs_unit

#
CREATE TABLE `div_obs_unit` (
  `div_obs_unit_id` bigint(20) NOT NULL auto_increment,
  `div_experiment_id` bigint(20) default '0',
  `div_stock_id` bigint(20) default '0',
  `div_locality_id` bigint(20) default '0',
  `name` varchar(50) default NULL,
  `field_coord_x` bigint(20) default '0',
  `field_coord_y` bigint(20) default '0',
  `rep` varchar(50) default NULL,
  `block` varchar(50) default NULL,
  `plot` varchar(50) default NULL,
  `plant` varchar(50) default NULL,
  `planting_date` datetime default NULL,
  `harvest_date` datetime default NULL,
  `summary` varchar(255) default NULL,
  PRIMARY KEY  (`div_obs_unit_id`),
  KEY `div_experiment_id` (`div_experiment_id`),
  KEY `div_stock_id` (`div_stock_id`),
  KEY `locality_id` (`div_locality_id`),
  KEY `obs_unit_id` (`div_obs_unit_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_obs_unit_sample

#
CREATE TABLE `div_obs_unit_sample` (
  `div_obs_unit_sample_id` bigint(20) NOT NULL auto_increment,
  `div_obs_unit_id` bigint(20) default '0',
  `sample_date` datetime default NULL,
  `name` varchar(50) default NULL,
  `producer` varchar(50) default NULL,
  `comments` varchar(50) default NULL,
  PRIMARY KEY  (`div_obs_unit_sample_id`),
  KEY `div_obsunit_id` (`div_obs_unit_id`),
  KEY `div_stock_sample_id` (`div_obs_unit_sample_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_passport

#
CREATE TABLE `div_passport` (
  `div_passport_id` bigint(20) NOT NULL auto_increment,
  `div_locality_id` bigint(20) default '0',
  `accename` varchar(50) default NULL,
  `collnumb` varchar(50) default NULL,
  `collector` varchar(50) default NULL,
  `remarks` varchar(50) default NULL,
  `genus` varchar(50) default NULL,
  `germplasm_type` varchar(50) default NULL,
  `local_name` varchar(50) default NULL,
  `population` varchar(50) default NULL,
  `race_name` varchar(50) default NULL,
  `reference` varchar(50) default NULL,
  `secondary_source` varchar(50) default NULL,
  `source` varchar(50) default NULL,
  `species` varchar(50) default NULL,
  `subspecies` varchar(50) default NULL,
  `instcode` varchar(50) default NULL,
  `accenumb` bigint(20) default '0',
  `collcode` varchar(50) default NULL,
  `spauthor` varchar(50) default NULL,
  `subtaxa` varchar(50) default NULL,
  `subtauthor` varchar(50) default NULL,
  `cropname` varchar(50) default NULL,
  `acqdate` datetime default NULL,
  `colldate` datetime default NULL,
  `bredcode` varchar(50) default NULL,
  `sampstat` varchar(50) default NULL,
  `collsrc` varchar(50) default NULL,
  `donorcode` varchar(50) default NULL,
  `donornumb` bigint(20) default '0',
  `othernumb` bigint(20) default '0',
  `duplsite` varchar(50) default NULL,
  `storage` varchar(50) default NULL,
  PRIMARY KEY  (`div_passport_id`),
  KEY `bredcode` (`bredcode`),
  KEY `collcode` (`collcode`),
  KEY `donorcode` (`donorcode`),
  KEY `instcode` (`instcode`),
  KEY `localityID` (`div_locality_id`),
  KEY `passportID` (`div_passport_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_poly_type

#
CREATE TABLE `div_poly_type` (
  `div_poly_type_id` bigint(20) NOT NULL auto_increment,
  `poly_type` varchar(50) default NULL,
  PRIMARY KEY  (`div_poly_type_id`),
  KEY `div_poly_type_id` (`div_poly_type_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_statistic_type

#
CREATE TABLE `div_statistic_type` (
  `div_statistic_type_id` bigint(20) NOT NULL auto_increment,
  `stat_type` varchar(50) default NULL,
  PRIMARY KEY  (`div_statistic_type_id`),
  KEY `div_statistic_type_id` (`div_statistic_type_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_stock

#
CREATE TABLE `div_stock` (
  `div_stock_id` bigint(20) NOT NULL auto_increment,
  `div_generation_id` bigint(20) default '0',
  `div_passport_id` bigint(20) default '0',
  `seed_lot` varchar(50) default NULL,
  PRIMARY KEY  (`div_stock_id`),
  KEY `div_generation_id` (`div_generation_id`),
  KEY `div_passport_id` (`div_passport_id`),
  KEY `div_stock_id` (`div_stock_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_stock_parent

#
CREATE TABLE `div_stock_parent` (
  `div_stock_parent_id` bigint(20) NOT NULL auto_increment,
  `div_stock_id` bigint(20) default '0',
  `div_parent_id` bigint(20) default '0',
  `recurrent` tinyint(4) default NULL,
  `role` varchar(50) default NULL,
  PRIMARY KEY  (`div_stock_parent_id`),
  KEY `parentID` (`div_parent_id`),
  KEY `stockID` (`div_stock_id`),
  KEY `stockParentID` (`div_stock_parent_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_trait

#
CREATE TABLE `div_trait` (
  `div_trait_id` bigint(20) NOT NULL auto_increment,
  `div_trait_uom_id` bigint(20) default '0',
  `div_statistic_type_id` bigint(20) default '0',
  `div_obs_unit_id` bigint(20) default '0',
  `date_measured` datetime default NULL,
  `value` varchar(50) default NULL,
  PRIMARY KEY  (`div_trait_id`),
  KEY `div_obsunit_id` (`div_obs_unit_id`),
  KEY `div_statistic_type_id` (`div_statistic_type_id`),
  KEY `div_trait_uom_id` (`div_trait_uom_id`),
  KEY `phenotypeID` (`div_trait_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_trait_uom

#
CREATE TABLE `div_trait_uom` (
  `div_trait_uom_id` bigint(20) NOT NULL auto_increment,
  `qtl_trait_ontology_id` bigint(20) default '0',
  `div_unit_of_measure_id` bigint(20) default '0',
  `local_trait_name` varchar(50) default NULL,
  PRIMARY KEY  (`div_trait_uom_id`),
  KEY `div_trait_uom_id` (`div_trait_uom_id`),
  KEY `div_unit_of_measure_id` (`div_unit_of_measure_id`),
  KEY `qtl_trait_ontology_id` (`qtl_trait_ontology_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_treatment

#
CREATE TABLE `div_treatment` (
  `div_treatment_id` bigint(20) NOT NULL auto_increment,
  `div_treatment_uom_id` bigint(20) default '0',
  `div_obs_unit_id` bigint(20) default '0',
  `value` varchar(50) default NULL,
  PRIMARY KEY  (`div_treatment_id`),
  KEY `div_entry_treatment_id` (`div_treatment_id`),
  KEY `div_obsunit_id` (`div_obs_unit_id`),
  KEY `div_treatment_uom_id` (`div_treatment_uom_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_treatment_uom

#
CREATE TABLE `div_treatment_uom` (
  `div_treatment_uom_id` bigint(20) NOT NULL auto_increment,
  `qtl_treatment_ontology_id` bigint(20) default '0',
  `div_unit_of_measure_id` bigint(20) default '0',
  `local_treatment_name` varchar(50) default NULL,
  PRIMARY KEY  (`div_treatment_uom_id`),
  KEY `div_treatment_id` (`qtl_treatment_ontology_id`),
  KEY `div_treatment_uom_id` (`div_treatment_uom_id`),
  KEY `div_unit_of_measure_id` (`div_unit_of_measure_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for div_unit_of_measure

#
CREATE TABLE `div_unit_of_measure` (
  `div_unit_of_measure_id` bigint(20) NOT NULL auto_increment,
  `unit_type` varchar(50) default NULL,
  PRIMARY KEY  (`div_unit_of_measure_id`),
  KEY `div_unit_of_measure_id` (`div_unit_of_measure_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for qtl_trait_ontology

#
CREATE TABLE `qtl_trait_ontology` (
  `qtl_trait_ontology_id` bigint(20) NOT NULL auto_increment,
  PRIMARY KEY  (`qtl_trait_ontology_id`),
  KEY `ontologyID` (`qtl_trait_ontology_id`)
) TYPE=MyISAM;
#
# Dumping Table Structure for qtl_treatment_ontology

#
CREATE TABLE `qtl_treatment_ontology` (
  `qtl_treatment_ontology_id` bigint(20) NOT NULL auto_increment,
  PRIMARY KEY  (`qtl_treatment_ontology_id`),
  KEY `ontologyID` (`qtl_treatment_ontology_id`)
) TYPE=MyISAM;
#