-- MySQL dump 9.11
--
-- Host: localhost    Database: dp3
-- ------------------------------------------------------
-- Server version	4.0.21

--
-- Table structure for table `flyBase2004Xref`
--

CREATE TABLE flyBase2004Xref (
  name varchar(255) NOT NULL default '',
  symbol varchar(255) NOT NULL default '',
  synonyms longblob NOT NULL,
  fbtr varchar(255) NOT NULL default '',
  fbgn varchar(255) NOT NULL default '',
  fbpp varchar(255) NOT NULL default '',
  fban varchar(255) NOT NULL default '',
  type varchar(255) NOT NULL default '',
  PRIMARY KEY  (name(10)),
  KEY symbol (symbol(16)),
  KEY fbtr (fbtr(11)),
  KEY fbgn (fbgn(11)),
  KEY fbpp (fbpp(11)),
  KEY fban (fban(11)),
  KEY type (type(5))
) ENGINE=MyISAM;
