# Host: 192.168.0.3
# Database: migration
# Table: 'div_aa_annotation'
# 
CREATE TABLE `div_aa_annotation` (
  `div_aa_annotation_id` int(11) NOT NULL default '0',
  `div_annotation_type_id` int(11) default NULL,
  `div_allele_assay_id` int(11) default NULL,
  `annotation_value` varchar(50) default NULL,
  PRIMARY KEY  (`div_aa_annotation_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_allele'
# 
CREATE TABLE `div_allele` (
  `div_allele_id` int(11) NOT NULL default '0',
  `div_obs_unit_sample_id` int(11) default NULL,
  `div_allele_assay_id` int(11) default NULL,
  `allele_num` int(11) default NULL,
  `quality` longtext,
  `value` longtext,
  `proportion` int(11) default NULL,
  `total_n` int(11) default NULL,
  PRIMARY KEY  (`div_allele_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_allele_assay'
# 
CREATE TABLE `div_allele_assay` (
  `div_allele_assay_id` int(11) NOT NULL default '0',
  `div_marker_id` int(11) default NULL,
  `div_poly_type_id` int(11) default NULL,
  `comments` varchar(50) default NULL,
  `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` int(11) default NULL,
  `source_assay` varchar(50) default NULL,
  `length` int(11) default NULL,
  PRIMARY KEY  (`div_allele_assay_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_annotation_type'
# 
CREATE TABLE `div_annotation_type` (
  `div_annotation_type_id` int(11) NOT NULL default '0',
  `anno_type` varchar(50) default NULL,
  PRIMARY KEY  (`div_annotation_type_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_experiment'
# 
CREATE TABLE `div_experiment` (
  `div_experiment_id` int(11) NOT NULL default '0',
  `name` varchar(50) default NULL,
  `design` varchar(50) default NULL,
  `originator` varchar(50) default NULL,
  PRIMARY KEY  (`div_experiment_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_generation'
# 
CREATE TABLE `div_generation` (
  `div_generation_id` int(11) NOT NULL default '0',
  `value` varchar(50) default NULL,
  PRIMARY KEY  (`div_generation_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_locality'
# 
CREATE TABLE `div_locality` (
  `div_locality_id` int(11) NOT NULL default '0',
  `elevation` int(11) default NULL,
  `city` varchar(50) default NULL,
  `country` varchar(50) default NULL,
  `origcty` varchar(50) default NULL,
  `latitude` int(11) default NULL,
  `longitude` int(11) default NULL,
  `locality_name` varchar(50) default NULL,
  `state_province` varchar(50) default NULL,
  PRIMARY KEY  (`div_locality_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_locus'
# 
CREATE TABLE `div_locus` (
  `div_locus_id` int(11) NOT NULL default '0',
  `chromosome_number` int(11) default NULL,
  `comments` varchar(50) default NULL,
  `genetic_bin` varchar(50) default NULL,
  `genetic_map` varchar(50) default NULL,
  `genetic_position` int(11) default NULL,
  `locus_type` varchar(50) default NULL,
  `name` varchar(50) default NULL,
  `physical_position` int(11) default NULL,
  PRIMARY KEY  (`div_locus_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_marker'
# 
CREATE TABLE `div_marker` (
  `div_marker_id` int(11) NOT NULL default '0',
  `div_locus_id` int(11) default NULL,
  `name` varchar(50) default NULL,
  `ref_seq` varchar(50) default NULL,
  `div_ref_stock_id` int(11) default NULL,
  PRIMARY KEY  (`div_marker_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_obs_unit'
# 
CREATE TABLE `div_obs_unit` (
  `div_obs_unit_id` int(11) NOT NULL default '0',
  `div_experiment_id` int(11) default NULL,
  `div_stock_id` int(11) default NULL,
  `div_locality_id` int(11) default NULL,
  `name` varchar(50) default NULL,
  `field_coord_x` int(11) default NULL,
  `field_coord_y` int(11) default NULL,
  `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`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_obs_unit_sample'
# 
CREATE TABLE `div_obs_unit_sample` (
  `div_obs_unit_sample_id` int(11) NOT NULL default '0',
  `div_obs_unit_id` int(11) default NULL,
  `date` datetime default NULL,
  `name` varchar(50) default NULL,
  `producer` varchar(50) default NULL,
  PRIMARY KEY  (`div_obs_unit_sample_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_passport'
# 
CREATE TABLE `div_passport` (
  `div_passport_id` int(11) NOT NULL default '0',
  `div_locality_id` int(11) default NULL,
  `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` int(11) default NULL,
  `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` int(11) default NULL,
  `othernumb` int(11) default NULL,
  `duplsite` varchar(50) default NULL,
  `storage` varchar(50) default NULL,
  PRIMARY KEY  (`div_passport_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_poly_type'
# 
CREATE TABLE `div_poly_type` (
  `div_poly_type_id` int(11) NOT NULL default '0',
  `poly_type` varchar(50) default NULL,
  PRIMARY KEY  (`div_poly_type_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_statistic_type'
# 
CREATE TABLE `div_statistic_type` (
  `div_statistic_type_id` int(11) NOT NULL default '0',
  `stat_type` varchar(50) default NULL,
  PRIMARY KEY  (`div_statistic_type_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_stock'
# 
CREATE TABLE `div_stock` (
  `div_stock_id` int(11) NOT NULL default '0',
  `div_generation_id` int(11) default NULL,
  `div_passport_id` int(11) default NULL,
  `seed_lot` varchar(50) default NULL,
  PRIMARY KEY  (`div_stock_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_stock_parent'
# 
CREATE TABLE `div_stock_parent` (
  `div_stock_parent_id` int(11) NOT NULL default '0',
  `div_stock_id` int(11) default NULL,
  `div_parent_id` int(11) default NULL,
  `recurrent` tinyint(1) default NULL,
  `role` varchar(50) default NULL,
  PRIMARY KEY  (`div_stock_parent_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_trait'
# 
CREATE TABLE `div_trait` (
  `div_trait_id` int(11) NOT NULL default '0',
  `div_trait_uom_id` int(11) default NULL,
  `div_statistic_type_id` int(11) default NULL,
  `div_obs_unit_id` int(11) default NULL,
  `date` datetime default NULL,
  `value` varchar(50) default NULL,
  PRIMARY KEY  (`div_trait_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_trait_uom'
# 
CREATE TABLE `div_trait_uom` (
  `div_trait_uom_id` int(11) NOT NULL default '0',
  `qtl_trait_ontology_id` int(11) default NULL,
  `div_unit_of_measure_id` int(11) default NULL,
  `local_trait_name` varchar(50) default NULL,
  PRIMARY KEY  (`div_trait_uom_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_treatment'
# 
CREATE TABLE `div_treatment` (
  `div_treatment_id` int(11) NOT NULL default '0',
  `div_treatment_uom_id` int(11) default NULL,
  `div_obs_unit_id` int(11) default NULL,
  `value` varchar(50) default NULL,
  PRIMARY KEY  (`div_treatment_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_treatment_uom'
# 
CREATE TABLE `div_treatment_uom` (
  `div_treatment_uom_id` int(11) NOT NULL default '0',
  `qtl_treatment_ontology_id` int(11) default NULL,
  `div_unit_of_measure_id` int(11) default NULL,
  `local_treatment_name` varchar(50) default NULL,
  PRIMARY KEY  (`div_treatment_uom_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'div_unit_of_measure'
# 
CREATE TABLE `div_unit_of_measure` (
  `div_unit_of_measure_id` int(11) NOT NULL default '0',
  `unit_type` varchar(50) default NULL,
  PRIMARY KEY  (`div_unit_of_measure_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'qtl_trait_ontology'
# 
CREATE TABLE `qtl_trait_ontology` (
  `qtl_trait_ontology_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`qtl_trait_ontology_id`)
) TYPE=MyISAM; 

# Host: 192.168.0.3
# Database: migration
# Table: 'qtl_treatment_ontology'
# 
CREATE TABLE `qtl_treatment_ontology` (
  `qtl_treatment_ontology_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`qtl_treatment_ontology_id`)
) TYPE=MyISAM;