-- MySQL dump 9.10
--
-- Host: localhost    Database: proteins040315
-- ------------------------------------------------------
-- Server version	4.0.17-standard

--
-- Table structure for table `spXref3`
--

CREATE TABLE spXref3 (
  accession varchar(40) NOT NULL default '',
  displayID varchar(40) NOT NULL default '',
  division varchar(40) NOT NULL default '',
  bioentryID int(11) NOT NULL default '0',
  biodatabaseID int(11) NOT NULL default '0',
  description varchar(255) NOT NULL default '',
  hugoSymbol varchar(40) NOT NULL default '',
  hugoDesc varchar(255) NOT NULL default '',
  KEY accession (accession),
  KEY displayID (displayID),
  KEY hugoSymbol (hugoSymbol),
  KEY ii1 (accession),
  KEY ii2 (displayID),
  KEY ii3 (hugoSymbol)
) TYPE=MyISAM;
