-- MySQL dump 10.9
-- May 5, 2005
--
-- ------------------------------------------------------
-- Server version	4.1.11-standard

/*!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_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`),
  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,
  `name` varchar(255) default NULL,
  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_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`),
  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,
  `chromosome_name` text,
  `comments` text,
  `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,
  `name` varchar(255) default NULL,
  `physical_position` double default NULL,
  PRIMARY KEY  (`cdv_map_feature_id`),
  KEY `xref_map_id` (`xref_map_id`)
) ENGINE=InnoDB;

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

CREATE TABLE `cdv_marker` (
  `cdv_marker_id` int unsigned NOT NULL auto_increment,
  `cdv_map_feature_id` int unsigned default NULL,
  `name` varchar(255) default NULL,
  `position` varchar(255) default NULL,
  `length` int default NULL,
  `ref_seq` text,
  `div_ref_stock_id` int unsigned default NULL,
  `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`),
  CONSTRAINT `cdv_marker_ibfk_1` FOREIGN KEY (`cdv_map_feature_id`) REFERENCES `cdv_map_feature` (`cdv_map_feature_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,
  `group_name` varchar(255) default NULL,
  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,
  `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`),
  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,
  `description` text,
  PRIMARY KEY  (`cdv_reason_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_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`),
  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_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,
  PRIMARY KEY  (`div_accession_collecting_id`),
  KEY `collcode` (`collcode`),
  KEY `div_locality_id` (`div_locality_id`),
  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_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` int 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`),
  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_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,
  `comments` text,
  `assay_date` datetime default NULL,
  `name` varchar(255) default NULL,
  `producer` varchar(255) default NULL,
  `position` varchar(255) default NULL,
  `ref_seq` text,
  `div_ref_stock_id` int unsigned default NULL,
  `length` int default NULL,
  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 `div_ref_stock_id` (`div_ref_stock_id`),
  KEY `assay_date` (`assay_date`),
  KEY `name` (`name`),
  KEY `div_scoring_tech_type_id` (`div_scoring_tech_type_id`),
  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`),
  CONSTRAINT `div_allele_assay_ibfk_4` FOREIGN KEY (`div_ref_stock_id`) REFERENCES `div_stock` (`div_stock_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,
  `anno_type` varchar(255) default NULL,
  PRIMARY KEY  (`div_annotation_type_id`)
) ENGINE=InnoDB;

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

CREATE TABLE `div_experiment` (
  `div_experiment_id` int unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `design` varchar(255) default NULL,
  `originator` varchar(255) default NULL,
  `comments` text,
  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,
  `value` varchar(255) default NULL,
  `comments` text,
  `icis_id` text,
  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,
  `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,
  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_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`),
  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_id` int unsigned default NULL,
  `sample_date` datetime default NULL,
  `name` varchar(255) 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`),
  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_taxonomy_id` int unsigned default NULL,
  `div_accession_collecting_id` int unsigned default NULL,
  `accename` varchar(255) default NULL,
  `comments` text,
  `germplasm_type` varchar(255) default NULL,
  `source` varchar(255) default NULL,
  `accenumb` varchar(255) default NULL,
  `sampstat` varchar(255) default NULL,
  PRIMARY KEY  (`div_passport_id`),
  KEY `div_taxonomy_id` (`div_taxonomy_id`),
  KEY `div_accession_collecting_id` (`div_accession_collecting_id`),
  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`)
) ENGINE=InnoDB;

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

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

--
-- 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,
  `scoring_tech_type` varchar(255) default NULL,
  PRIMARY KEY  (`div_scoring_tech_type_id`)
) ENGINE=InnoDB;

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

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

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

CREATE TABLE `div_stock` (
  `div_stock_id` int unsigned NOT NULL auto_increment,
  `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`),
  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_id` int unsigned default NULL,
  `div_parent_id` int unsigned default NULL,
  `recurrent` tinyint(4) default NULL,
  `role` varchar(255) default NULL,
  PRIMARY KEY  (`div_stock_parent_id`),
  KEY `div_stock_id` (`div_stock_id`),
  KEY `div_parent_id` (`div_parent_id`),
  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_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`),
  CONSTRAINT `div_synonym_ibfk_1` FOREIGN KEY (`div_passport_id`) REFERENCES `div_passport` (`div_passport_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_taxa_family`
--

CREATE TABLE `div_taxa_family` (
  `div_taxa_family_id` int unsigned NOT NULL auto_increment,
  `kingdom` varchar(255) default NULL,
  `division` varchar(255) default NULL,
  `class` varchar(255) default NULL,
  `subclass` varchar(255) default NULL,
  `order` varchar(255) default NULL,
  `family` varchar(255) default NULL,
  `subfamily` varchar(255) default NULL,
  `tribe` varchar(255) default NULL,
  PRIMARY KEY  (`div_taxa_family_id`)
) ENGINE=InnoDB;

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

CREATE TABLE `div_taxonomy` (
  `div_taxonomy_id` int unsigned NOT NULL auto_increment,
  `div_taxa_family_id` int unsigned 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,
  PRIMARY KEY  (`div_taxonomy_id`),
  KEY `div_taxa_family_id` (`div_taxa_family_id`),
  CONSTRAINT `div_taxonomy_ibfk_1` FOREIGN KEY (`div_taxa_family_id`) REFERENCES `div_taxa_family` (`div_taxa_family_id`)
) ENGINE=InnoDB;

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

CREATE TABLE `div_trait` (
  `div_trait_id` int unsigned NOT NULL auto_increment,
  `div_trait_uom_id` int unsigned default NULL,
  `div_statistic_type_id` int unsigned default NULL,
  `div_obs_unit_id` int unsigned default NULL,
  `date_measured` datetime default NULL,
  `value` varchar(255) 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`),
  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,
  `to_accession` varchar(255) default NULL,
  `div_unit_of_measure_id` int unsigned default NULL,
  `local_trait_name` varchar(255) default NULL,
  `trait_protocol` text,
  PRIMARY KEY  (`div_trait_uom_id`),
  KEY `div_unit_of_measure_id` (`div_unit_of_measure_id`),
  KEY `to_accession` (`to_accession`),
  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_treatment`
--

CREATE TABLE `div_treatment` (
  `div_treatment_id` int unsigned NOT NULL auto_increment,
  `div_treatment_uom_id` int unsigned default NULL,
  `div_obs_unit_id` int unsigned default NULL,
  `value` varchar(255) default NULL,
  PRIMARY KEY  (`div_treatment_id`),
  KEY `div_treatment_uom_id` (`div_treatment_uom_id`),
  KEY `div_obs_unit_id` (`div_obs_unit_id`),
  CONSTRAINT `div_treatment_ibfk_1` FOREIGN KEY (`div_treatment_uom_id`) REFERENCES `div_treatment_uom` (`div_treatment_uom_id`),
  CONSTRAINT `div_treatment_ibfk_2` FOREIGN KEY (`div_obs_unit_id`) REFERENCES `div_obs_unit` (`div_obs_unit_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `div_treatment_uom`
--

CREATE TABLE `div_treatment_uom` (
  `div_treatment_uom_id` int unsigned NOT NULL auto_increment,
  `eo_accession` varchar(255) default NULL,
  `div_unit_of_measure_id` int unsigned default NULL,
  `local_treatment_name` varchar(255) default NULL,
  `treatment_protocol` varchar(255) default NULL,
  PRIMARY KEY  (`div_treatment_uom_id`),
  KEY `eo_accession` (`eo_accession`),
  KEY `div_unit_of_measure_id` (`div_unit_of_measure_id`),
  CONSTRAINT `div_treatment_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,
  `unit_type` varchar(255) default NULL,
  PRIMARY KEY  (`div_unit_of_measure_id`)
) ENGINE=InnoDB;

/*!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 */;