-- MySQL dump 8.22
--
-- Host: localhost    Database: mm2
---------------------------------------------------------
-- Server version	3.23.54

--
-- Table structure for table 'ensemblXref'
--

CREATE TABLE ensemblXref (
  db varchar(40) NOT NULL default '',
  gene_id int(10) unsigned NOT NULL default '0',
  gene_name varchar(40) NOT NULL default 'unknown',
  transcript_id int(10) unsigned NOT NULL default '0',
  transcript_name varchar(40) NOT NULL default '',
  translation_id int(10) unsigned NOT NULL default '0',
  translation_name varchar(40) NOT NULL default '',
  external_db varchar(40) NOT NULL default '',
  external_name varchar(40) NOT NULL default '',
  KEY gene_id (gene_id,transcript_id),
  KEY transcript (transcript_name),
  KEY translation (translation_name),
  KEY db (db,gene_id),
  KEY db_2 (db,external_db,external_name),
  KEY external_name (external_name)
) TYPE=MyISAM;
