 CREATE TABLE `predicted_feature` (
   `predicted_feature_id` int(10) unsigned NOT NULL auto_increment,
   `seq_region_id` int(10) unsigned NOT NULL default '0',
-  `seq_region_start` int(11) unsigned NOT NULL default '0',
-  `seq_region_end` int(11) unsigned NOT NULL default '0',
+  `seq_region_start` int(10) unsigned NOT NULL default '0',
+  `seq_region_end` int(10) unsigned NOT NULL default '0',
   `seq_region_strand` tinyint(1) NOT NULL default '0',
   `coord_system_id` int(10) unsigned NOT NULL default '0',	
   `display_label` varchar(60) default NULL,


DROP TABLE IF EXISTS `array`;
CREATE TABLE `array` (
   `array_id` int(11) unsigned NOT NULL auto_increment,
   `name` varchar(40) default NULL,
   `format` varchar(20) default NULL,
   `vendor` varchar(40) default NULL,

   `analysis_id` int(10) unsigned default NULL,
   `name` varchar(40) default NULL,
   PRIMARY KEY  (`result_set_id`),
   UNIQUE KEY  `name_analysis_idx` (`name`, `analysis_id`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- This is still v hard to impose unique constraints without key's of every combination of 2 :(
