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

--
-- Table structure for table `sgdCanonical`
--

CREATE TABLE sgdCanonical (
  chrom varchar(255) NOT NULL default '',
  chromStart int(11) NOT NULL default '0',
  chromEnd int(11) NOT NULL default '0',
  clusterId int(10) unsigned NOT NULL default '0',
  transcript varchar(255) NOT NULL default '',
  protein varchar(255) NOT NULL default '',
  UNIQUE KEY clusterId (clusterId),
  KEY transcript (transcript(9)),
  KEY protein (protein(8))
) ENGINE=MyISAM;
