User:Lindenb/Notebook/UMR915/20100702

20100701        Top        20100705       

create table to store PPH2 data

CREATE TABLE `polyphen` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `variation_id` int(10) unsigned NOT NULL,
 `alt` varchar(50) NOT NULL,
 `library` enum('HumDiv','HumVar') NOT NULL,
 `meta` text,
 `creation` datetime default NULL,
 `modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 `prediction` enum('PROBABLY_DAMAGING','POSSIBLY_DAMAGING','BENIGN','UNKNOWN','NIL') NOT NULL default 'NIL',
 `prob` float default NULL,
 `fpr` float default NULL,
 `tpr` float default NULL,
 PRIMARY KEY  (`id`),
 KEY `variation_id` (`variation_id`),
 CONSTRAINT `polyphen_ibfk_1` FOREIGN KEY (`variation_id`) REFERENCES `variation` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8