--
-- GDPDM schema version 2.2
--
-- June 11, 2008
--
-- ------------------------------------------------------
--

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `cdv_allele_curated_allele`
--

CREATE TABLE `cdv_allele_curated_allele` (
  `cdv_allele_curated_allele_id` int unsigned NOT NULL auto_increment,
  `cdv_allele_curated_allele_acc` varchar(255) default NULL,
  `cdv_curated_allele_id` int unsigned default NULL,
  `div_allele_id` int unsigned default NULL,
  `cdv_curation_id` int unsigned default NULL,
  PRIMARY KEY  (`cdv_allele_curated_allele_id`),
  KEY `cdv_curated_allele_id` (`cdv_curated_allele_id`),
  KEY `cdv_curation_id` (`cdv_curation_id`),
  KEY `div_allele_id` (`div_allele_id`),
  UNIQUE(`cdv_allele_curated_allele_acc`),
  CONSTRAINT `cdv_allele_curated_allele_ibfk_1` FOREIGN KEY (`cdv_curated_allele_id`) REFERENCES `cdv_curated_allele` (`cdv_curated_allele_id`),
  CONSTRAINT `cdv_allele_curated_allele_ibfk_2` FOREIGN KEY (`cdv_curation_id`) REFERENCES `cdv_curation` (`cdv_curation_id`),
  CONSTRAINT `cdv_allele_curated_allele_ibfk_3` FOREIGN KEY (`div_allele_id`) REFERENCES `div_allele` (`div_allele_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_curated_allele`
--

CREATE TABLE `cdv_curated_allele` (
  `cdv_curated_allele_id` int unsigned NOT NULL auto_increment,
  `cdv_curated_allele_acc` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  UNIQUE(`cdv_curated_allele_acc`),
  PRIMARY KEY  (`cdv_curated_allele_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_curation`
--

CREATE TABLE `cdv_curation` (
  `cdv_curation_id` int unsigned NOT NULL auto_increment,
  `cdv_curation_acc` varchar(255) default NULL,
  `cdv_reason_id` int unsigned default NULL,
  `curator` varchar(255) default NULL,
  `curation_date` datetime default NULL,
  `comments` text,
  PRIMARY KEY  (`cdv_curation_id`),
  KEY `cdv_reason_id` (`cdv_reason_id`),
  UNIQUE(`cdv_curation_acc`),
  CONSTRAINT `cdv_curation_ibfk_1` FOREIGN KEY (`cdv_reason_id`) REFERENCES `cdv_reason` (`cdv_reason_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_map_feature`
--

CREATE TABLE `cdv_map_feature` (
  `cdv_map_feature_id` int unsigned NOT NULL auto_increment,
  `cdv_map_feature_acc` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `chromosome_name` text default NULL,
  `genetic_bin` varchar(255) default NULL,
  `xref_map_id` varchar(255) default NULL,
  `genetic_map` varchar(255) default NULL,
  `genetic_position` double default NULL,
  `locus_type` varchar(255) default NULL,
  `physical_position` double default NULL,
  `comments` text,
  UNIQUE(`cdv_map_feature_acc`),
  PRIMARY KEY  (`cdv_map_feature_id`),
  KEY `xref_map_id` (`xref_map_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_map_feature_annotation`
--

CREATE TABLE `cdv_map_feature_annotation` (
  `cdv_map_feature_annotation_id` int unsigned NOT NULL auto_increment,
  `cdv_map_feature_annotation_acc` varchar(255) default NULL,
  `cdv_map_feature_id` int unsigned NOT NULL,
  `cdv_map_feature_annotation_type_id` int unsigned NOT NULL,
  `annotation_value` text NOT NULL,
  PRIMARY KEY  (`cdv_map_feature_annotation_id`),
  KEY `cdv_map_feature_id` (`cdv_map_feature_id`),
  KEY `cdv_map_feature_annotation_type_id` (`cdv_map_feature_annotation_type_id`),
  UNIQUE(`cdv_map_feature_annotation_acc`),
  CONSTRAINT `cdv_map_feature_annotation_ibfk_1` FOREIGN KEY (`cdv_map_feature_id`) REFERENCES `cdv_map_feature` (`cdv_map_feature_id`),
  CONSTRAINT `cdv_map_feature_annotation_ibfk_2` FOREIGN KEY (`cdv_map_feature_annotation_type_id`) REFERENCES `cdv_map_feature_annotation_type` (`cdv_map_feature_annotation_type_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_map_feature_annotation_type`
--

CREATE TABLE `cdv_map_feature_annotation_type` (
  `cdv_map_feature_annotation_type_id` int unsigned NOT NULL auto_increment,
  `cdv_map_feature_annotation_type_acc` varchar(255) default NULL,
  `anno_type` varchar(255) NOT NULL,
  UNIQUE(`cdv_map_feature_annotation_type_acc`),
  PRIMARY KEY  (`cdv_map_feature_annotation_type_id`)
) ENGINE=InnoDB;


LOCK TABLES `cdv_map_feature_annotation_type` WRITE;
INSERT INTO `cdv_map_feature_annotation_type` VALUES
(1, NULL, 'ref_seq_cDNA'),(2, NULL, 'mean'),(3, NULL, 'standard
deviation'),(4, NULL, 'variance'),(5, NULL, 'mode'),(6, NULL, 'median'),(7, NULL, 'count');
UNLOCK TABLES;

--
-- Table structure for table `cdv_marker`
--

CREATE TABLE `cdv_marker` (
  `cdv_marker_id` int unsigned NOT NULL auto_increment,
  `cdv_marker_acc` varchar(255) default NULL,
  `cdv_map_feature_id` int unsigned default NULL,
  `div_ref_stock_id` int unsigned default NULL,
  `name` varchar(255) default NULL,
  `position` int default NULL,
  `length` int default NULL,
  `ref_seq` text,
  `marker_aid` varchar(255) default NULL,
  PRIMARY KEY  (`cdv_marker_id`),
  KEY `cdv_map_feature_id` (`cdv_map_feature_id`),
  KEY `marker_aid` (`marker_aid`),
  UNIQUE(`cdv_marker_acc`),
  CONSTRAINT `cdv_marker_ibfk_1` FOREIGN KEY (`cdv_map_feature_id`) REFERENCES `cdv_map_feature` (`cdv_map_feature_id`),
  CONSTRAINT `cdv_marker_ibfk_2` FOREIGN KEY (`div_ref_stock_id`) REFERENCES `div_stock` (`div_stock_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_marker_annotation`
--

CREATE TABLE `cdv_marker_annotation` (
  `cdv_marker_annotation_id` int unsigned NOT NULL auto_increment,
  `cdv_marker_annotation_acc` varchar(255) default NULL,
  `cdv_marker_id` int unsigned NOT NULL,
  `cdv_marker_annotation_type_id` int unsigned NOT NULL,
  `annotation_value` text NOT NULL,
  PRIMARY KEY  (`cdv_marker_annotation_id`),
  KEY `cdv_marker_id` (`cdv_marker_id`),
  KEY `cdv_marker_annotation_type_id` (`cdv_marker_annotation_type_id`),
  UNIQUE(`cdv_marker_annotation_acc`),
  CONSTRAINT `cdv_marker_annotation_ibfk_1` FOREIGN KEY (`cdv_marker_id`) REFERENCES `cdv_marker` (`cdv_marker_id`),
  CONSTRAINT `cdv_marker_annotation_ibfk_2` FOREIGN KEY (`cdv_marker_annotation_type_id`) REFERENCES `cdv_marker_annotation_type` (`cdv_marker_annotation_type_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_marker_annotation_type`
--

CREATE TABLE `cdv_marker_annotation_type` (
  `cdv_marker_annotation_type_id` int unsigned NOT NULL auto_increment,
  `cdv_marker_annotation_type_acc` varchar(255) default NULL,
  `anno_type` varchar(255) NOT NULL,
  UNIQUE(`cdv_marker_annotation_type_acc`),
  PRIMARY KEY  (`cdv_marker_annotation_type_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_passport_group`
--

CREATE TABLE `cdv_passport_group` (
  `cdv_passport_group_id` int unsigned NOT NULL auto_increment,
  `cdv_passport_group_acc` varchar(255) default NULL,
  `group_name` varchar(255) default NULL,
  UNIQUE(`cdv_passport_group_acc`),
  PRIMARY KEY  (`cdv_passport_group_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_passport_set`
--

CREATE TABLE `cdv_passport_set` (
  `cdv_passport_set_id` int unsigned NOT NULL auto_increment,
  `cdv_passport_set_acc` varchar(255) default NULL,
  `div_passport_id` int unsigned default NULL,
  `cdv_passport_group_id` int unsigned default NULL,
  PRIMARY KEY  (`cdv_passport_set_id`),
  KEY `div_passport_id` (`div_passport_id`),
  KEY `cdv_passport_group_id` (`cdv_passport_group_id`),
  UNIQUE(`cdv_passport_set_acc`),
  CONSTRAINT `cdv_passport_set_ibfk_1` FOREIGN KEY (`div_passport_id`) REFERENCES `div_passport` (`div_passport_id`),
  CONSTRAINT `cdv_passport_set_ibfk_2` FOREIGN KEY (`cdv_passport_group_id`) REFERENCES `cdv_passport_group` (`cdv_passport_group_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_reason`
--

CREATE TABLE `cdv_reason` (
  `cdv_reason_id` int unsigned NOT NULL auto_increment,
  `cdv_reason_acc` varchar(255) default NULL,
  `description` text,
  UNIQUE(`cdv_reason_acc`),
  PRIMARY KEY  (`cdv_reason_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_source`
--

CREATE TABLE `cdv_source` (
  `cdv_source_id` int unsigned NOT NULL auto_increment,
  `cdv_source_acc` varchar(255) default NULL,
  `source` varchar(255) NOT NULL,
  `contact` varchar(255) default NULL,
  `institute` varchar(255) default NULL,
  `department` varchar(255) default NULL,
  `address` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `state_province` varchar(255) default NULL,
  `country` varchar(255) default NULL,
  `phone` varchar(255) default NULL,
  `fax` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  `comments` varchar(255) default NULL,
  UNIQUE(`cdv_source_acc`),
  PRIMARY KEY  (`cdv_source_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_aa_annotation`
--

CREATE TABLE `div_aa_annotation` (
  `div_aa_annotation_id` int unsigned NOT NULL auto_increment,
  `div_aa_annotation_acc` varchar(255) default NULL,
  `div_annotation_type_id` int unsigned default NULL,
  `div_allele_assay_id` int unsigned default NULL,
  `annotation_value` text,
  PRIMARY KEY  (`div_aa_annotation_id`),
  KEY `div_annotation_type_id` (`div_annotation_type_id`),
  KEY `div_allele_assay_id` (`div_allele_assay_id`),
  UNIQUE(`div_aa_annotation_acc`),
  CONSTRAINT `div_aa_annotation_ibfk_1` FOREIGN KEY (`div_annotation_type_id`) REFERENCES `div_annotation_type` (`div_annotation_type_id`),
  CONSTRAINT `div_aa_annotation_ibfk_2` FOREIGN KEY (`div_allele_assay_id`) REFERENCES `div_allele_assay` (`div_allele_assay_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_accession_collecting`
--

CREATE TABLE `div_accession_collecting` (
  `div_accession_collecting_id` int unsigned NOT NULL auto_increment,
  `div_accession_collecting_acc` varchar(255) default NULL,
  `div_locality_id` int unsigned default NULL,
  `collector` varchar(255) default NULL,
  `collnumb` varchar(255) default NULL,
  `collsrc` varchar(255) default NULL,
  `collcode` varchar(255) default NULL,
  `col_date` datetime default NULL,
  PRIMARY KEY  (`div_accession_collecting_id`),
  KEY `collcode` (`collcode`),
  KEY `div_locality_id` (`div_locality_id`),
  UNIQUE(`div_accession_collecting_acc`),
  CONSTRAINT `div_accession_collecting_ibfk_1` FOREIGN KEY (`div_locality_id`) REFERENCES `div_locality` (`div_locality_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_allele`
--

CREATE TABLE `div_allele` (
  `div_allele_id` int unsigned NOT NULL auto_increment,
  `div_allele_acc` varchar(255) default NULL,
  `div_obs_unit_sample_id` int unsigned default NULL,
  `div_allele_assay_id` int unsigned default NULL,
  `accession` varchar(255) default NULL,
  `referencedb` varchar(255) default NULL,
  `allele_num` int default NULL,
  `quality` text,
  `value` text,
  `proportion` double default NULL,
  `total_n` int default NULL,
  PRIMARY KEY  (`div_allele_id`),
  KEY `div_obs_unit_sample_id` (`div_obs_unit_sample_id`),
  KEY `div_allele_assay_id` (`div_allele_assay_id`),
  KEY `allele_num` (`allele_num`),
  UNIQUE(`div_allele_acc`),
  CONSTRAINT `div_allele_ibfk_2` FOREIGN KEY (`div_allele_assay_id`) REFERENCES `div_allele_assay` (`div_allele_assay_id`),
  CONSTRAINT `div_allele_ibfk_3` FOREIGN KEY (`div_obs_unit_sample_id`) REFERENCES `div_obs_unit_sample` (`div_obs_unit_sample_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_allele_assay`
--

CREATE TABLE `div_allele_assay` (
  `div_allele_assay_id` int unsigned NOT NULL auto_increment,
  `div_allele_assay_acc` varchar(255) default NULL,
  `div_source_assay_id` int unsigned default NULL,
  `div_poly_type_id` int unsigned default NULL,
  `div_scoring_tech_type_id` int unsigned default NULL,
  `cdv_marker_id` int unsigned default NULL,
  `name` varchar(255) default NULL,
  `assay_date` datetime default NULL,
  `producer` varchar(255) default NULL,
  `comments` text,
  PRIMARY KEY  (`div_allele_assay_id`),
  KEY `div_source_assay_id` (`div_source_assay_id`),
  KEY `div_poly_type_id` (`div_poly_type_id`),
  KEY `cdv_marker_id` (`cdv_marker_id`),
  KEY `assay_date` (`assay_date`),
  KEY `name` (`name`),
  KEY `div_scoring_tech_type_id` (`div_scoring_tech_type_id`),
  UNIQUE(`div_allele_assay_acc`),
  CONSTRAINT `div_aa_annotation_ibfk_3` FOREIGN KEY (`div_scoring_tech_type_id`) REFERENCES `div_scoring_tech_type` (`div_scoring_tech_type_id`),
  CONSTRAINT `div_allele_assay_ibfk_1` FOREIGN KEY (`div_source_assay_id`) REFERENCES `div_allele_assay` (`div_allele_assay_id`),
  CONSTRAINT `div_allele_assay_ibfk_2` FOREIGN KEY (`div_poly_type_id`) REFERENCES `div_poly_type` (`div_poly_type_id`),
  CONSTRAINT `div_allele_assay_ibfk_3` FOREIGN KEY (`cdv_marker_id`) REFERENCES `cdv_marker` (`cdv_marker_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_annotation_type`
--

CREATE TABLE `div_annotation_type` (
  `div_annotation_type_id` int unsigned NOT NULL auto_increment,
  `div_annotation_type_acc` varchar(255) default NULL,
  `anno_type` varchar(255) default NULL,
  UNIQUE(`div_annotation_type_acc`),
  PRIMARY KEY  (`div_annotation_type_id`)
) ENGINE=InnoDB;

LOCK TABLES `div_annotation_type` WRITE;
INSERT INTO `div_annotation_type` VALUES
(1, NULL, 'PRIMER1'),(2, NULL, 'PRIMER2'),(3, NULL, 'SEQUENCING_DYE'),(4, NULL, 'ALLELE_REPEAT'),(5, NULL, 'CONTIG_PROGRAM'),(6, NULL, 'ALIGNMENT_ANNOTATION'),(7, NULL, 'CLONING_PROCESS'),(8, NULL, 'SOURCE_GENBANK'),(9, NULL, 'SOURCE_CONTIG_NAME'),(10, NULL, 'TRACKING_NAME'),(11, NULL, 'ALLELE_REPEAT_SIZE'),(12, NULL, 'SCORING_TECHNOLOGY');
UNLOCK TABLES;

--
-- Table structure for table `div_experiment`
--

CREATE TABLE `div_experiment` (
  `div_experiment_id` int unsigned NOT NULL auto_increment,
  `div_experiment_acc` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `design` varchar(255) default NULL,
  `originator` varchar(255) default NULL,
  `comments` text,
  UNIQUE(`div_experiment_acc`),
  PRIMARY KEY  (`div_experiment_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_generation`
--

CREATE TABLE `div_generation` (
  `div_generation_id` int unsigned NOT NULL auto_increment,
  `div_generation_acc` varchar(255) default NULL,
  `icis_id` text,
  `comments` text,
  `selfing_number` int default NULL,
  `sibbing_number` int default NULL,
  UNIQUE(`div_generation_acc`),
  PRIMARY KEY  (`div_generation_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_locality`
--

CREATE TABLE `div_locality` (
  `div_locality_id` int unsigned NOT NULL auto_increment,
  `div_locality_acc` varchar(255) default NULL,
  `elevation` int default NULL,
  `city` varchar(255) default NULL,
  `country` varchar(255) default NULL,
  `origcty` varchar(255) default NULL,
  `latitude` double default NULL,
  `longitude` double default NULL,
  `locality_name` varchar(255) default NULL,
  `state_province` varchar(255) default NULL,
  `lo_accession` varchar(255) default NULL,
  UNIQUE(`div_locality_acc`),
  PRIMARY KEY  (`div_locality_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_obs_unit`
--

CREATE TABLE `div_obs_unit` (
  `div_obs_unit_id` int unsigned NOT NULL auto_increment,
  `div_obs_unit_acc` varchar(255) default NULL,
  `div_experiment_id` int unsigned default NULL,
  `div_stock_id` int unsigned default NULL,
  `div_locality_id` int unsigned default NULL,
  `name` varchar(255) default NULL,
  `coord_x` int default NULL,
  `coord_y` int default NULL,
  `rep` varchar(255) default NULL,
  `block` varchar(255) default NULL,
  `plot` varchar(255) default NULL,
  `season` varchar(255) default NULL,
  `plant` varchar(255) default NULL,
  `planting_date` datetime default NULL,
  `harvest_date` datetime default NULL,
  `comments` text,
  PRIMARY KEY  (`div_obs_unit_id`),
  KEY `div_experiment_id` (`div_experiment_id`),
  KEY `div_stock_id` (`div_stock_id`),
  KEY `div_locality_id` (`div_locality_id`),
  UNIQUE(`div_obs_unit_acc`),
  CONSTRAINT `div_obs_unit_ibfk_1` FOREIGN KEY (`div_experiment_id`) REFERENCES `div_experiment` (`div_experiment_id`),
  CONSTRAINT `div_obs_unit_ibfk_2` FOREIGN KEY (`div_stock_id`) REFERENCES `div_stock` (`div_stock_id`),
  CONSTRAINT `div_obs_unit_ibfk_3` FOREIGN KEY (`div_locality_id`) REFERENCES `div_locality` (`div_locality_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_obs_unit_sample`
--

CREATE TABLE `div_obs_unit_sample` (
  `div_obs_unit_sample_id` int unsigned NOT NULL auto_increment,
  `div_obs_unit_sample_acc` varchar(255) default NULL,
  `div_obs_unit_id` int unsigned default NULL,
  `name` varchar(255) default NULL,
  `sample_date` datetime default NULL,
  `producer` varchar(255) default NULL,
  `comments` text,
  PRIMARY KEY  (`div_obs_unit_sample_id`),
  KEY `div_obs_unit_id` (`div_obs_unit_id`),
  UNIQUE(`div_obs_unit_sample_acc`),
  CONSTRAINT `div_obs_unit_sample_ibfk_1` FOREIGN KEY (`div_obs_unit_id`) REFERENCES `div_obs_unit` (`div_obs_unit_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_passport`
--

CREATE TABLE `div_passport` (
  `div_passport_id` int unsigned NOT NULL auto_increment,
  `div_passport_acc` varchar(255) default NULL,
  `div_taxonomy_id` int unsigned default NULL,
  `div_accession_collecting_id` int unsigned default NULL,
  `cdv_source_id` int unsigned default NULL,
  `accename` varchar(255) unique NOT NULL,
  `source` varchar(255) default NULL,
  `accenumb` varchar(255) default NULL,
  `sampstat` varchar(255) default NULL,
  `comments` text,
  PRIMARY KEY  (`div_passport_id`),
  KEY `div_taxonomy_id` (`div_taxonomy_id`),
  KEY `div_accession_collecting_id` (`div_accession_collecting_id`),
  KEY `cdv_source_id` (`cdv_source_id`),
  UNIQUE(`div_passport_acc`),
  CONSTRAINT `div_passport_ibfk_1` FOREIGN KEY (`div_taxonomy_id`) REFERENCES `div_taxonomy` (`div_taxonomy_id`),
  CONSTRAINT `div_passport_ibfk_2` FOREIGN KEY (`div_accession_collecting_id`) REFERENCES `div_accession_collecting` (`div_accession_collecting_id`),
  CONSTRAINT `div_passport_ibfk_3` FOREIGN KEY (`cdv_source_id`) REFERENCES `cdv_source` (`cdv_source_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_poly_type`
--

CREATE TABLE `div_poly_type` (
  `div_poly_type_id` int unsigned NOT NULL auto_increment,
  `div_poly_type_acc` varchar(255) default NULL,
  `poly_type` varchar(255) default NULL,
  UNIQUE(`div_poly_type_acc`),
  PRIMARY KEY  (`div_poly_type_id`)
) ENGINE=InnoDB;

LOCK TABLES `div_poly_type` WRITE;
INSERT INTO `div_poly_type` VALUES
(1, NULL, 'length'),(2, NULL, 'snp'),(3, NULL, 'sequence'),(4, NULL, 'categorical');
UNLOCK TABLES;

--
-- Table structure for table `div_sampstat`
--

CREATE TABLE `div_sampstat` (
  `div_sampstat_id` int unsigned NOT NULL auto_increment,
  `div_sampstat_acc` varchar(255) default NULL,
  `sampstat` varchar(255),
  `germplasm_type` varchar(255),
  UNIQUE(`div_sampstat_acc`),
  PRIMARY KEY  (`div_sampstat_id`)
) ENGINE=InnoDB;

LOCK TABLES `div_sampstat` WRITE;
INSERT INTO `div_sampstat` VALUES
(1, NULL, '100', 'Wild'),(2, NULL, '110', 'Natural'),(3, NULL, '114', 'Inbred developed from wild'),(4, NULL, '120', 'Semi-natural/wild'),(5, NULL, '200', 'Weedy'),(6, NULL, '300', 'Traditional cultivar/landrace'), (7, NULL, '314', 'Inbred developed from landrace'),(8, NULL, '400', 'Breeding/research material'),(9, NULL, '410', 'Breeder Line'),(10, NULL, '411', 'Synthetic Population'),(11, NULL, '412', 'Hybrid'),(12, NULL, '413', 'Founder stock'),(13, NULL, '414', 'Inbred'),(14, NULL, '415', 'Segregating Population'),(15, NULL, '420', 'Mutant/genetic stock'),(16, NULL, '500', 'Advanced');
UNLOCK TABLES;

--
-- Table structure for table `div_scoring_tech_type`
--

CREATE TABLE `div_scoring_tech_type` (
  `div_scoring_tech_type_id` int unsigned NOT NULL auto_increment,
  `div_scoring_tech_type_acc` varchar(255) default NULL,
  `scoring_tech_group` varchar(255) default NULL,
  `scoring_tech_type` varchar(255) default NULL,
  UNIQUE(`div_scoring_tech_type_acc`),
  PRIMARY KEY  (`div_scoring_tech_type_id`)
) ENGINE=InnoDB;

LOCK TABLES `div_scoring_tech_type` WRITE;
INSERT INTO `div_scoring_tech_type` VALUES (1, NULL, 'SSR','SSR length scored
on capillary'),(2, NULL, 'SNP','Single-base extension scored by mass
spectrometer'),(3, NULL, 'Sequencing','Sequencing of direct
PCR'),(4, NULL, 'Isozyme','Isozyme electrophoretic migration scored on starch
gels'),(5, NULL, 'RFLP','RFLP'),(6, NULL, 'INDEL','insertion/deletion polymorphism
scored on agarose gels'),(7, NULL, 'CAPS','Cleaved amplified polymorphic site
score on agarose gels'),(8, NULL, 'AFLP','AFLP');
UNLOCK TABLES;

--
-- Table structure for table `div_statistic_type`
--

CREATE TABLE `div_statistic_type` (
  `div_statistic_type_id` int unsigned NOT NULL auto_increment,
  `div_statistic_type_acc` varchar(255) default NULL,
  `stat_type` varchar(255) default NULL,
  UNIQUE(`div_statistic_type_acc`),
  PRIMARY KEY  (`div_statistic_type_id`)
) ENGINE=InnoDB;

LOCK TABLES `div_statistic_type` WRITE;
INSERT INTO `div_statistic_type` VALUES
(1, NULL, 'measure'),(2, NULL, 'mean'),(3, NULL, 'standard
deviation'),(4, NULL, 'variance'),(5, NULL, 'mode'),(6, NULL, 'median'),(7, NULL, 'count');
UNLOCK TABLES;

--
-- Table structure for table `div_stock`
--

CREATE TABLE `div_stock` (
  `div_stock_id` int unsigned NOT NULL auto_increment,
  `div_stock_acc` varchar(255) default NULL,
  `div_generation_id` int unsigned default NULL,
  `div_passport_id` int unsigned default NULL,
  `seed_lot` varchar(255) default NULL,
  `stock_source` varchar(255) default NULL,
  `comments` text,
  PRIMARY KEY  (`div_stock_id`),
  KEY `div_generation_id` (`div_generation_id`),
  KEY `div_passport_id` (`div_passport_id`),
  UNIQUE(`div_stock_acc`),
  CONSTRAINT `div_stock_ibfk_1` FOREIGN KEY (`div_generation_id`) REFERENCES `div_generation` (`div_generation_id`),
  CONSTRAINT `div_stock_ibfk_2` FOREIGN KEY (`div_passport_id`) REFERENCES `div_passport` (`div_passport_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_stock_parent`
--

CREATE TABLE `div_stock_parent` (
  `div_stock_parent_id` int unsigned NOT NULL auto_increment,
  `div_stock_parent_acc` varchar(255) default NULL,
  `div_stock_id` int unsigned default NULL,
  `div_parent_id` int unsigned default NULL,
  `role` varchar(255) default NULL,
  `recurrent` tinyint(4) default NULL,
  PRIMARY KEY  (`div_stock_parent_id`),
  KEY `div_stock_id` (`div_stock_id`),
  KEY `div_parent_id` (`div_parent_id`),
  UNIQUE(`div_stock_parent_acc`),
  CONSTRAINT `div_stock_parent_ibfk_1` FOREIGN KEY (`div_stock_id`) REFERENCES `div_stock` (`div_stock_id`),
  CONSTRAINT `div_stock_parent_ibfk_2` FOREIGN KEY (`div_parent_id`) REFERENCES `div_stock` (`div_stock_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_synonym`
--

CREATE TABLE `div_synonym` (
  `div_synonym_id` int unsigned NOT NULL auto_increment,
  `div_synonym_acc` varchar(255) default NULL,
  `div_passport_id` int unsigned default NULL,
  `synonym` varchar(255) default NULL,
  `comments` text,
  PRIMARY KEY  (`div_synonym_id`),
  KEY `div_passport_id` (`div_passport_id`),
  UNIQUE(`div_synonym_acc`),
  CONSTRAINT `div_synonym_ibfk_1` FOREIGN KEY (`div_passport_id`) REFERENCES `div_passport` (`div_passport_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_taxonomy`
--

CREATE TABLE `div_taxonomy` (
  `div_taxonomy_id` int unsigned NOT NULL auto_increment,
  `div_taxonomy_acc` varchar(255) default NULL,
  `genus` varchar(255) default NULL,
  `species` varchar(255) default NULL,
  `subspecies` varchar(255) default NULL,
  `subtaxa` varchar(255) default NULL,
  `race` varchar(255) default NULL,
  `population` varchar(255) default NULL,
  `common_name` varchar(255) default NULL,
  `term_accession` varchar(255) default NULL,
  UNIQUE(`div_taxonomy_acc`),
  PRIMARY KEY  (`div_taxonomy_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_trait`
--

CREATE TABLE `div_trait` (
  `div_trait_id` int unsigned NOT NULL auto_increment,
  `div_trait_acc` varchar(255) default NULL,
  `div_trait_uom_id` int unsigned default NULL,
  `div_statistic_type_id` int unsigned default NULL,
  `div_obs_unit_id` int unsigned default NULL,
  `value` varchar(255) default NULL,
  `date_measured` datetime default NULL,
  PRIMARY KEY  (`div_trait_id`),
  KEY `div_trait_uom_id` (`div_trait_uom_id`),
  KEY `div_statistic_type_id` (`div_statistic_type_id`),
  KEY `div_obs_unit_id` (`div_obs_unit_id`),
  UNIQUE(`div_trait_acc`),
  CONSTRAINT `div_trait_ibfk_1` FOREIGN KEY (`div_trait_uom_id`) REFERENCES `div_trait_uom` (`div_trait_uom_id`),
  CONSTRAINT `div_trait_ibfk_2` FOREIGN KEY (`div_statistic_type_id`) REFERENCES `div_statistic_type` (`div_statistic_type_id`),
  CONSTRAINT `div_trait_ibfk_3` FOREIGN KEY (`div_obs_unit_id`) REFERENCES `div_obs_unit` (`div_obs_unit_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_trait_uom`
--

CREATE TABLE `div_trait_uom` (
  `div_trait_uom_id` int unsigned NOT NULL auto_increment,
  `div_trait_uom_acc` varchar(255) default NULL,
  `div_unit_of_measure_id` int unsigned default NULL,
  `local_trait_name` varchar(255) unique NOT NULL,
  `trait_protocol` text,
  `to_accession` varchar(255) default NULL,
  `eo_accession` varchar(255) default NULL,
  PRIMARY KEY  (`div_trait_uom_id`),
  KEY `div_unit_of_measure_id` (`div_unit_of_measure_id`),
  KEY `to_accession` (`to_accession`),
  KEY `eo_accession` (`eo_accession`),
  UNIQUE(`div_trait_uom_acc`),
  CONSTRAINT `div_trait_uom_ibfk_1` FOREIGN KEY (`div_unit_of_measure_id`) REFERENCES `div_unit_of_measure` (`div_unit_of_measure_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_unit_of_measure`
--

CREATE TABLE `div_unit_of_measure` (
  `div_unit_of_measure_id` int unsigned NOT NULL auto_increment,
  `div_unit_of_measure_acc` varchar(255) default NULL,
  `unit_type` varchar(255) default NULL,
  UNIQUE(`div_unit_of_measure_acc`),
  PRIMARY KEY  (`div_unit_of_measure_id`)
) ENGINE=InnoDB;

LOCK TABLES `div_unit_of_measure` WRITE;
INSERT INTO `div_unit_of_measure` VALUES (1, NULL, 'mm'),(2, NULL, 'm'),(3, NULL, 'km'),(4, NULL, 'mg'),(5, NULL, 'g'),(6, NULL, 'kg'),(7, NULL, 'days');
UNLOCK TABLES;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;