-- MySQL dump 10.10
--
-- Host: localhost    Database: hg18
-- ------------------------------------------------------
-- Server version	5.0.27

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `gadAll`
--

DROP TABLE IF EXISTS `gadAll`;
CREATE TABLE `gadAll` (
  `id` varchar(20) default NULL,
  `association` char(1) default NULL,
  `broadPhen` varchar(255) default NULL,
  `diseaseClass` varchar(20) default NULL,
  `diseaseClassCode` varchar(20) default NULL,
  `meshTerm` blob,
  `chromosome` varchar(20) default NULL,
  `band` varchar(20) default NULL,
  `geneSymbol` varchar(40) default NULL,
  `chromStart` int(10) default NULL,
  `chromEnd` int(10) default NULL,
  `pValue` varchar(20) default NULL,
  `reference` varchar(255) default NULL,
  `pubMed` varchar(40) default NULL,
  `alleleAuthDes` varchar(255) default NULL,
  `alleleFunEffect` varchar(255) default NULL,
  `polymClass` varchar(40) default NULL,
  `geneName` varchar(255) default NULL,
  `refSeq` varchar(255) default NULL,
  `population` varchar(255) default NULL,
  `meshGeoloc` varchar(255) default NULL,
  `submitter` varchar(255) default NULL,
  `locusNum` varchar(40) default NULL,
  `unigene` varchar(20) default NULL,
  `narrowPhen` varchar(255) default NULL,
  `molePhenotype` varchar(255) default NULL,
  `journal` varchar(255) default NULL,
  `title` varchar(255) default NULL,
  `rsId` varchar(20) default NULL,
  `omimId` varchar(20) default NULL,
  `gadQ` varchar(255) default NULL,
  `gadCdc` varchar(255) default NULL,
  `year` varchar(10) default NULL,
  `conclusion` blob,
  `studyInfo` varchar(255) default NULL,
  `envFactor` varchar(255) default NULL,
  `giGeneA` varchar(255) default NULL,
  `giAlleleGeneA` varchar(255) default NULL,
  `giGeneB` varchar(255) default NULL,
  `giAlleleGeneB` varchar(255) default NULL,
  `giGeneC` varchar(255) default NULL,
  `giAlleleGeneC` varchar(255) default NULL,
  `giAssociation` varchar(255) default NULL,
  `giEnv` varchar(255) default NULL,
  `giDis` varchar(255) default NULL,
  KEY `id` (`id`),
  KEY `geneSymbol` (`geneSymbol`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2008-01-18 14:57:46
