# MySQL dump 7.1
#
# Host: localhost    Database: hg6
#--------------------------------------------------------
# Server version	3.22.32

#
# Table structure for table 'refLink'
#
CREATE TABLE refLink (
  name varchar(255) DEFAULT '' NOT NULL,
  product varchar(255) DEFAULT '' NOT NULL,
  mrnaAcc varchar(255) DEFAULT '' NOT NULL,
  protAcc varchar(255) DEFAULT '' NOT NULL,
  geneName int(10) unsigned DEFAULT '0' NOT NULL,
  prodName int(10) unsigned DEFAULT '0' NOT NULL,
  locusLinkId int(10) unsigned DEFAULT '0' NOT NULL,
  omimId int(10) unsigned DEFAULT '0' NOT NULL,
  PRIMARY KEY (mrnaAcc(12)),
  KEY name (name(10)),
  KEY protAcc (protAcc(10)),
  KEY locusLinkId (locusLinkId),
  KEY omimId (omimId),
  KEY prodName (prodName),
  KEY geneName (geneName)
);
