-- Convert schema 'GDPDM_mySQL_20100219.sql' to 'GDPDM_mySQL_20100526.sql':

-- 
-- 

SET foreign_key_checks=0;

--
-- Table structure for table `cdv_geno_set`
--

CREATE TABLE `cdv_geno_set` (
  `cdv_geno_set_id` int unsigned NOT NULL auto_increment,
  `cdv_geno_set_acc` varchar(255) default NULL,
  `cdv_g2p_study_id` int unsigned NOT NULL,
  `div_allele_id` int unsigned NOT NULL,
  UNIQUE(`cdv_geno_set_acc`),
  PRIMARY KEY  (`cdv_geno_set_id`),
  KEY `cdv_g2p_study_id` (`cdv_g2p_study_id`),
  KEY `div_allele_id` (`div_allele_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_pheno_set`
--

CREATE TABLE `cdv_pheno_set` (
  `cdv_pheno_set_id` int unsigned NOT NULL auto_increment,
  `cdv_pheno_set_acc` varchar(255) default NULL,
  `cdv_g2p_study_id` int unsigned NOT NULL,
  `div_trait_id` int unsigned NOT NULL,
  UNIQUE(`cdv_pheno_set_acc`),
  PRIMARY KEY  (`cdv_pheno_set_id`),
  KEY `cdv_g2p_study_id` (`cdv_g2p_study_id`),
  KEY `div_trait_id` (`div_trait_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_g2p_protocol`
--

CREATE TABLE `cdv_g2p_protocol` (
  `cdv_g2p_protocol_id` int unsigned NOT NULL auto_increment,
  `cdv_g2p_protocol_acc` varchar(255) default NULL,
  `analysis_method` text,
  UNIQUE(`cdv_g2p_protocol_acc`),
  PRIMARY KEY  (`cdv_g2p_protocol_id`)
) ENGINE=InnoDB;

--
-- Table structure for table `cdv_g2p_study`
--

CREATE TABLE `cdv_g2p_study` (
  `cdv_g2p_study_id` int unsigned NOT NULL auto_increment,
  `cdv_g2p_study_acc` varchar(255) default NULL,
  `cdv_g2p_protocol_id` int unsigned NOT NULL,
  `name` varchar(255) default NULL,
  `p_value_blob` mediumblob default NULL,
  `effect_blob` mediumblob default NULL,
  `bpp_blob` mediumblob default NULL,
  `producer` varchar(255) default NULL,
  `study_date` datetime default NULL,
  UNIQUE(`cdv_g2p_study_acc`),
  PRIMARY KEY  (`cdv_g2p_study_id`),
  KEY `cdv_g2p_protocol_id` (`cdv_g2p_protocol_id`)
) ENGINE=InnoDB;


SET foreign_key_checks=1;

ALTER TABLE div_allele ADD binary_imputation mediumblob DEFAULT NULL;