# MySQL dump 8.14
#
# Host: localhost    Database: hg12
#--------------------------------------------------------
# Server version	3.23.41

#
# Table structure for table 'refLink'
#

CREATE TABLE refLink (
  name varchar(255) NOT NULL default '',
  product varchar(255) NOT NULL default '',
  mrnaAcc varchar(255) NOT NULL default '',
  protAcc varchar(255) NOT NULL default '',
  geneName int(10) unsigned NOT NULL default '0',
  prodName int(10) unsigned NOT NULL default '0',
  locusLinkId int(10) unsigned NOT NULL default '0',
  omimId int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (mrnaAcc(12)),
  KEY name (name(10)),
  KEY protAcc (protAcc(10)),
  KEY locusLinkId (locusLinkId),
  KEY omimId (omimId),
  KEY prodName (prodName),
  KEY geneName (geneName)
) TYPE=MyISAM;
