CREATE TABLE `dis_experiment` (
  `external_db` int(11) unsigned NOT NULL,
  `protein` int(11) unsigned NOT NULL,
  `db_id` varchar(20) NOT NULL DEFAULT '',
  `classification` enum('ordered','disordered','unknown') NOT NULL DEFAULT 'unknown',
  `up_id` varchar(10) NOT NULL DEFAULT '',
  `start` int(7) unsigned NOT NULL,
  `end` int(7) unsigned NOT NULL,
  `comments` text,
  PRIMARY KEY (`external_db`,`protein`,`db_id`,`start`,`end`),
  KEY `protein_experiment` (`protein`),
  KEY `protein_classified_experiment` (`protein`,`classification`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
