-- Convert schema 'GDPDM_mySQL_20060419.sql' to 'GDPDM_mySQL_20080611.sql':

-- 
-- Created by SQL::Translator::Producer::MySQL
-- Created on Thu Jul 24 00:40:53 2008
-- 
SET foreign_key_checks=0;


--
-- 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;


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


LOCK TABLES `div_annotation_type` WRITE;
INSERT INTO `div_annotation_type` VALUES
(12, 'SCORING_TECHNOLOGY');
UNLOCK TABLES;


SET foreign_key_checks=1;


ALTER TABLE cdv_allele_curated_allele ADD cdv_allele_curated_allele_acc varchar(255) DEFAULT NULL;
ALTER TABLE cdv_curated_allele ADD cdv_curated_allele_acc varchar(255) DEFAULT NULL;
ALTER TABLE cdv_curation ADD cdv_curation_acc varchar(255) DEFAULT NULL;
ALTER TABLE cdv_map_feature ADD cdv_map_feature_acc varchar(255) DEFAULT NULL;
ALTER TABLE cdv_map_feature CHANGE chromosome_name chromosome_name text DEFAULT NULL;
ALTER TABLE cdv_map_feature_annotation ADD cdv_map_feature_annotation_acc varchar(255) DEFAULT NULL;
ALTER TABLE cdv_map_feature_annotation_type ADD cdv_map_feature_annotation_type_acc varchar(255) DEFAULT NULL;
ALTER TABLE cdv_marker ADD cdv_marker_acc varchar(255) DEFAULT NULL;
ALTER TABLE cdv_marker_annotation ADD cdv_marker_annotation_acc varchar(255) DEFAULT NULL;
ALTER TABLE cdv_marker_annotation_type ADD cdv_marker_annotation_type_acc varchar(255) DEFAULT NULL;
ALTER TABLE cdv_passport_group ADD cdv_passport_group_acc varchar(255) DEFAULT NULL;
ALTER TABLE cdv_passport_set ADD cdv_passport_set_acc varchar(255) DEFAULT NULL;
ALTER TABLE cdv_reason ADD cdv_reason_acc varchar(255) DEFAULT NULL;
ALTER TABLE cdv_source ADD cdv_source_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_aa_annotation ADD div_aa_annotation_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_accession_collecting ADD div_accession_collecting_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_allele ADD div_allele_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_allele CHANGE proportion proportion double DEFAULT NULL;
ALTER TABLE div_allele_assay ADD div_allele_assay_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_annotation_type ADD div_annotation_type_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_experiment ADD div_experiment_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_generation ADD div_generation_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_locality ADD div_locality_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_locality ADD lo_accession varchar(255) DEFAULT NULL;
ALTER TABLE div_obs_unit ADD div_obs_unit_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_obs_unit_sample ADD div_obs_unit_sample_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_passport ADD div_passport_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_poly_type ADD div_poly_type_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_scoring_tech_type ADD div_scoring_tech_type_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_statistic_type ADD div_statistic_type_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_stock ADD div_stock_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_stock_parent ADD div_stock_parent_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_synonym ADD div_synonym_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_taxonomy ADD div_taxonomy_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_trait ADD div_trait_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_trait_uom ADD div_trait_uom_acc varchar(255) DEFAULT NULL;
ALTER TABLE div_trait_uom CHANGE local_trait_name local_trait_name varchar(255) NOT NULL;
ALTER TABLE div_unit_of_measure ADD div_unit_of_measure_acc varchar(255) DEFAULT NULL;
ALTER TABLE cdv_allele_curated_allele ADD UNIQUE  (cdv_allele_curated_allele_acc);
ALTER TABLE cdv_curated_allele ADD UNIQUE  (cdv_curated_allele_acc);
ALTER TABLE cdv_curation ADD UNIQUE  (cdv_curation_acc);
ALTER TABLE cdv_map_feature ADD UNIQUE  (cdv_map_feature_acc);
ALTER TABLE cdv_map_feature_annotation ADD UNIQUE  (cdv_map_feature_annotation_acc);
ALTER TABLE cdv_map_feature_annotation_type ADD UNIQUE  (cdv_map_feature_annotation_type_acc);
ALTER TABLE cdv_marker ADD UNIQUE  (cdv_marker_acc);
ALTER TABLE cdv_marker_annotation ADD UNIQUE  (cdv_marker_annotation_acc);
ALTER TABLE cdv_marker_annotation_type ADD UNIQUE  (cdv_marker_annotation_type_acc);
ALTER TABLE cdv_passport_group ADD UNIQUE  (cdv_passport_group_acc);
ALTER TABLE cdv_passport_set ADD UNIQUE  (cdv_passport_set_acc);
ALTER TABLE cdv_reason ADD UNIQUE  (cdv_reason_acc);
ALTER TABLE cdv_source ADD UNIQUE  (cdv_source_acc);
ALTER TABLE div_aa_annotation ADD UNIQUE  (div_aa_annotation_acc);
ALTER TABLE div_accession_collecting ADD UNIQUE  (div_accession_collecting_acc);
ALTER TABLE div_allele ADD UNIQUE  (div_allele_acc);
ALTER TABLE div_allele_assay ADD UNIQUE  (div_allele_assay_acc);
ALTER TABLE div_annotation_type ADD UNIQUE  (div_annotation_type_acc);
ALTER TABLE div_experiment ADD UNIQUE  (div_experiment_acc);
ALTER TABLE div_generation ADD UNIQUE  (div_generation_acc);
ALTER TABLE div_locality ADD UNIQUE  (div_locality_acc);
ALTER TABLE div_obs_unit ADD UNIQUE  (div_obs_unit_acc);
ALTER TABLE div_obs_unit_sample ADD UNIQUE  (div_obs_unit_sample_acc);
ALTER TABLE div_passport ADD UNIQUE  (div_passport_acc);
ALTER TABLE div_poly_type ADD UNIQUE  (div_poly_type_acc);
ALTER TABLE div_scoring_tech_type ADD UNIQUE  (div_scoring_tech_type_acc);
ALTER TABLE div_statistic_type ADD UNIQUE  (div_statistic_type_acc);
ALTER TABLE div_stock ADD UNIQUE  (div_stock_acc);
ALTER TABLE div_stock_parent ADD UNIQUE  (div_stock_parent_acc);
ALTER TABLE div_synonym ADD UNIQUE  (div_synonym_acc);
ALTER TABLE div_taxonomy ADD UNIQUE  (div_taxonomy_acc);
ALTER TABLE div_trait ADD UNIQUE  (div_trait_acc);
ALTER TABLE div_trait_uom ADD UNIQUE  (local_trait_name);
ALTER TABLE div_trait_uom ADD UNIQUE  (div_trait_uom_acc);
ALTER TABLE div_unit_of_measure ADD UNIQUE  (div_unit_of_measure_acc);