-- MySQL dump 9.08
--
-- Host: localhost    Database: tscsnp
---------------------------------------------------------
-- Server version	4.0.13-Max-log

--
-- Table structure for table 'tbl_snp_env'
--

CREATE TABLE tbl_snp_env (
  dbsnp_id int(11) NOT NULL default '0',
  snp_id int(11) default NULL,
  institute_code varchar(32) NOT NULL default '',
  extension_probe varchar(255) default NULL,
  left_flank varchar(255) default NULL,
  right_flank varchar(255) default NULL,
  first_primer varchar(255) default NULL,
  second_primer varchar(255) default NULL,
  taqman_probe1 varchar(255) default NULL,
  taqman_probe2 varchar(255) default NULL,
  reversed_old enum('N','Y') default NULL,
  reversed enum('N','Y') default NULL,
  PRIMARY KEY  (dbsnp_id,institute_code),
  KEY snp_id (snp_id,institute_code)
) TYPE=MyISAM;