User:Lindenb/Notebook/UMR915/20100702

=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=latin1