   UNIQUE KEY `df_unq_idx` (`coord_system_id`,`analysis_id`,`name`,`file_type`),
   KEY `df_name_idx` (`name`),
   KEY `df_analysis_idx` (`analysis_id`)
-) ENGINE=MyISAM ;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 CREATE TABLE `density_feature` (
-  `density_feature_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `density_type_id` int(10) unsigned NOT NULL,
-  `seq_region_id` int(10) unsigned NOT NULL,
-  `seq_region_start` int(10) unsigned NOT NULL,
-  `seq_region_end` int(10) unsigned NOT NULL,
-  `density_value` float NOT NULL,
+  `density_feature_id` int(11) NOT NULL AUTO_INCREMENT,
+  `density_type_id` int(11) NOT NULL DEFAULT '0',
+  `seq_region_id` int(11) NOT NULL DEFAULT '0',
+  `seq_region_start` int(11) NOT NULL DEFAULT '0',
+  `seq_region_end` int(11) NOT NULL DEFAULT '0',
+  `density_value` float NOT NULL DEFAULT '0',
   PRIMARY KEY (`density_feature_id`),
   KEY `seq_region_idx` (`density_type_id`,`seq_region_id`,`seq_region_start`),
   KEY `seq_region_id_idx` (`seq_region_id`)
-) ENGINE=MyISAM ;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
 
 CREATE TABLE `density_type` (
-  `density_type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  `analysis_id` smallint(5) unsigned NOT NULL,
-  `block_size` int(11) NOT NULL,
-  `region_features` int(11) NOT NULL,
-  `value_type` enum('sum','ratio') NOT NULL,
+  `density_type_id` int(11) NOT NULL AUTO_INCREMENT,
+  `analysis_id` int(11) NOT NULL DEFAULT '0',
+  `block_size` int(11) NOT NULL DEFAULT '0',
+  `region_features` int(11) NOT NULL DEFAULT '0',
+  `value_type` enum('sum','ratio') NOT NULL DEFAULT 'sum',
   PRIMARY KEY (`density_type_id`),
-  UNIQUE KEY `analysis_idx` (`analysis_id`,`block_size`,`region_features`)
-) ENGINE=MyISAM ;
+  UNIQUE KEY `analysis_id` (`analysis_id`,`block_size`,`region_features`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
 
 CREATE TABLE `dependent_xref` (
   `object_xref_id` int(10) unsigned NOT NULL,

  PRIMARY KEY (`genome_statistics_id`),
  UNIQUE KEY `stats_uniq` (`statistic`,`attrib_type_id`,`species_id`),
  KEY `stats_idx` (`statistic`,`attrib_type_id`,`species_id`)
) ENGINE=MyISAM ;

CREATE TABLE `identity_xref` (
  `object_xref_id` int(10) unsigned NOT NULL,
  `xref_identity` int(5) DEFAULT NULL,
  `ensembl_identity` int(5) DEFAULT NULL,
  `xref_start` int(11) DEFAULT NULL,
  `xref_end` int(11) DEFAULT NULL,
  `ensembl_start` int(11) DEFAULT NULL,
  `ensembl_end` int(11) DEFAULT NULL,
  `cigar_line` text,
  `score` double DEFAULT NULL,
  `evalue` double DEFAULT NULL,
  PRIMARY KEY (`object_xref_id`)
) ENGINE=MyISAM ;

CREATE TABLE `interpro` (
  `interpro_ac` varchar(40) NOT NULL,
  `id` varchar(40) NOT NULL,
  UNIQUE KEY `accession_idx` (`interpro_ac`,`id`),
  KEY `id_idx` (`id`)
) ENGINE=MyISAM ;

CREATE TABLE `intron_supporting_evidence` (
  `intron_supporting_evidence_id` int(10) unsigned NOT NULL AUTO_INCREMENT,

  KEY `xref_id_index` (`display_xref_id`),
  KEY `analysis_idx` (`analysis_id`),
  KEY `stable_id_idx` (`stable_id`,`version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `transcript_attrib` (
  `transcript_id` int(10) unsigned NOT NULL DEFAULT '0',
  `attrib_type_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `value` text NOT NULL,
  UNIQUE KEY `transcript_attribx` (`transcript_id`,`attrib_type_id`,`value`(500)),
  KEY `type_val_idx` (`attrib_type_id`,`value`(40)),
  KEY `transcript_idx` (`transcript_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

CREATE TABLE `transcript_intron_supporting_evidence` (
  `transcript_id` int(10) unsigned NOT NULL,
