src/hg/instinct/bioInt2/bioIntDb.sql 1.6

Index: src/hg/instinct/bioInt2/bioIntDb.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/instinct/bioInt2/bioIntDb.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -b -B -U 4 -r1.5 -r1.6
--- src/hg/instinct/bioInt2/bioIntDb.sql	27 Apr 2009 06:15:48 -0000	1.5
+++ src/hg/instinct/bioInt2/bioIntDb.sql	30 Apr 2009 19:54:28 -0000	1.6
@@ -170,8 +170,19 @@
               #Indices
     PRIMARY KEY(sample_id)
 );
 
+#All pathway vals
+CREATE TABLE pathwayVals (
+    pathway_id int unsigned not null,	# Pathway Id
+    sample_id int unsigned not null,	# Sample Id
+    feature_id int unsigned not null,	# Analysis Feature Id
+    val float not null,	# Val
+    conf float not null,	# Confidence
+              #Indices
+    PRIMARY KEY(pathway_id)
+);
+
 #Cohort Correlation tables
 CREATE TABLE cohortCorr (
     cohort_id int unsigned not null,	# Cohort Id
     result_table varchar(255) not null,	# Result Table