CREATE TABLE `tbl_array` (
  `rsname` varchar(15) DEFAULT NULL,
  `genomebuild` varchar(4) DEFAULT NULL,
  `chr` varchar(4) DEFAULT NULL,
  `mapinfo` varchar(12) DEFAULT NULL,
  `arrayid` varchar(9) DEFAULT NULL,
  `flank_down` varchar(255) DEFAULT NULL,
  `flank_up` varchar(255) DEFAULT NULL,
  `subsnp_id` varchar(20) DEFAULT NULL,
  `snp_id` varchar(20) DEFAULT NULL,
  KEY `k1` (`rsname`),
  KEY `k2` (`snp_id`),
  KEY `k3` (`subsnp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
