-- MySQL dump 9.08 -- -- Host: localhost Database: tscsnp --------------------------------------------------------- -- Server version 4.0.13-Max-log -- -- Table structure for table 'tbl_allele_freq' -- CREATE TABLE tbl_allele_freq ( dbsnp_id int(11) NOT NULL default '0', snp_id int(11) default NULL, pop_type varchar(64) NOT NULL default '', institute_code varchar(32) NOT NULL default '', allele_a_freq float default NULL, allele_c_freq float default NULL, allele_g_freq float default NULL, allele_t_freq float default NULL, pooled_data char(1) default NULL, num_people_typed int(7) default NULL, outcome char(2) default NULL, protocol varchar(64) default NULL, panel_id varchar(64) default NULL, KEY snp_id (snp_id), KEY dbsnp_id (dbsnp_id), KEY panel_id (panel_id), KEY outcome (outcome) ) TYPE=MyISAM;