 
 );
 
-################################################################################
-#
-# Table structure for table 'gene_description'
-#
-
-CREATE TABLE gene_description (
-
-  gene_id                     int unsigned NOT NULL,
-  description                 text,
-  PRIMARY KEY (gene_id)
-
-);
 
 ################################################################################
 #

  seq_region_end              int(10) unsigned NOT NULL, 
  seq_region_strand           tinyint(2) NOT NULL, 
  display_xref_id             int unsigned,

  PRIMARY KEY (transcript_id),
  KEY seq_region_idx( seq_region_id, seq_region_start ),

CREATE TABLE gene (

  gene_id                     int unsigned NOT NULL auto_increment,
  biotype                     VARCHAR(40) NOT NULL,
  analysis_id                 int,
  seq_region_id               int(10) unsigned NOT NULL, 
  seq_region_start            int(10) unsigned NOT NULL, 
  seq_region_end              int(10) unsigned NOT NULL, 
  seq_region_strand           tinyint(2) NOT NULL,       
  display_xref_id             int unsigned,
  source                      VARCHAR(20) NOT NULL,
  confidence                  enum( 'KNOWN', 'NOVEL', 'PUTATIVE', 'PREDICTED' ),
  description                 text,

  PRIMARY KEY (gene_id),
  KEY seq_region_idx( seq_region_id, seq_region_start ),
