   `is_current` tinyint(1) NOT NULL DEFAULT '1',
   `is_constitutive` tinyint(1) NOT NULL DEFAULT '0',
   `stable_id` varchar(128) DEFAULT NULL,
-  `version` smallint(5) unsigned DEFAULT NULL,
+  `version` smallint(5) unsigned NOT NULL DEFAULT '1',
   `created_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `modified_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   PRIMARY KEY (`exon_id`),
   KEY `seq_region_idx` (`seq_region_id`,`seq_region_start`),
   KEY `stable_id_idx` (`stable_id`,`version`)
-) ENGINE=MyISAM  ;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 CREATE TABLE `exon_transcript` (
-  `exon_id` int(10) unsigned NOT NULL,
-  `transcript_id` int(10) unsigned NOT NULL,
-  `rank` int(10) NOT NULL,
+  `exon_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `transcript_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `rank` int(10) NOT NULL DEFAULT '0',
   PRIMARY KEY (`exon_id`,`transcript_id`,`rank`),
   KEY `transcript` (`transcript_id`),
   KEY `exon` (`exon_id`)
-) ENGINE=MyISAM ;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
 
 CREATE TABLE `external_db` (
-  `external_db_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `db_name` varchar(100) NOT NULL,
-  `db_release` varchar(255) DEFAULT NULL,
-  `status` enum('KNOWNXREF','KNOWN','XREF','PRED','ORTH','PSEUDO') NOT NULL,
-  `dbprimary_acc_linkable` tinyint(1) NOT NULL DEFAULT '1',
-  `display_label_linkable` tinyint(1) NOT NULL DEFAULT '0',
-  `priority` int(11) NOT NULL,
+  `external_db_id` int(11) NOT NULL DEFAULT '0',
+  `db_name` varchar(27) NOT NULL DEFAULT '',
+  `db_release` varchar(40) NOT NULL DEFAULT '',
+  `status` enum('KNOWNXREF','KNOWN','XREF','PRED','ORTH','PSEUDO') NOT NULL DEFAULT 'KNOWNXREF',
+  `priority` int(11) NOT NULL DEFAULT '0',
   `db_display_name` varchar(255) DEFAULT NULL,
   `type` enum('ARRAY','ALT_TRANS','ALT_GENE','MISC','LIT','PRIMARY_DB_SYNONYM','ENSEMBL') DEFAULT NULL,
   `secondary_db_name` varchar(255) DEFAULT NULL,
   `secondary_db_table` varchar(255) DEFAULT NULL,
-  `description` text,
+  `description` text COLLATE latin1_bin,
   PRIMARY KEY (`external_db_id`)
-) ENGINE=MyISAM  ;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
 
 CREATE TABLE `external_synonym` (
-  `xref_id` int(10) unsigned NOT NULL,
-  `synonym` varchar(100) NOT NULL,
+  `xref_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `synonym` varchar(40) NOT NULL DEFAULT '',
   PRIMARY KEY (`xref_id`,`synonym`),
   KEY `name_index` (`synonym`)
-) ENGINE=MyISAM ;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
 
 CREATE TABLE `gene` (
   `gene_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  PRIMARY KEY (`object_xref_id`),
  KEY `dependent` (`dependent_xref_id`),
  KEY `master_idx` (`master_xref_id`)
) ENGINE=MyISAM ;

CREATE TABLE `ditag` (
  `ditag_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `type` varchar(30) NOT NULL DEFAULT '',
  `tag_count` smallint(6) unsigned NOT NULL DEFAULT '1',
  `sequence` tinytext NOT NULL,
  PRIMARY KEY (`ditag_id`)
) ENGINE=MyISAM ;

CREATE TABLE `ditag_feature` (
  `ditag_feature_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  PRIMARY KEY (`intron_supporting_evidence_id`),
  UNIQUE KEY `analysis_id` (`analysis_id`,`seq_region_id`,`seq_region_start`,`seq_region_end`,`seq_region_strand`,`hit_name`),
  KEY `seq_region_idx` (`seq_region_id`,`seq_region_start`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `karyotype` (
  `karyotype_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `seq_region_id` int(10) unsigned NOT NULL DEFAULT '0',
  `seq_region_start` int(10) NOT NULL DEFAULT '0',
  `seq_region_end` int(10) NOT NULL DEFAULT '0',
  `band` varchar(40) DEFAULT NULL,
  `stain` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`karyotype_id`),
  KEY `region_band_idx` (`seq_region_id`,`band`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

CREATE TABLE `map` (
  `map_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `map_name` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`map_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

CREATE TABLE `mapping_session` (
  `mapping_session_id` int(11) NOT NULL AUTO_INCREMENT,
  `old_db_name` varchar(80) NOT NULL DEFAULT '',
  `new_db_name` varchar(80) NOT NULL DEFAULT '',
  `old_release` varchar(5) NOT NULL DEFAULT '',
