CREATE TABLE `predictor` (
  `predictor` smallint(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `description` text,
  `comments` text,
  `citation` text,
  `url` varchar(2000) DEFAULT NULL,
  `colour` char(6) NOT NULL,
  `has_probs` tinyint(1) NOT NULL,
  `private_group` int(11) NOT NULL DEFAULT '0',
  `type` enum('disorder','binding','structure','transmem','coil') NOT NULL DEFAULT 'disorder',
  `loaded_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `display_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `include` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`predictor`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8
