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

Index: src/hg/instinct/bioInt2/bioIntDb.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/instinct/bioInt2/bioIntDb.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -b -B -U 4 -r1.3 -r1.4
--- src/hg/instinct/bioInt2/bioIntDb.sql	22 Mar 2009 01:07:28 -0000	1.3
+++ src/hg/instinct/bioInt2/bioIntDb.sql	29 Mar 2009 01:40:43 -0000	1.4
@@ -198,4 +198,21 @@
     conf float not null,	# Confidence
               #Indices
     PRIMARY KEY(sample_id)
 );
+
+#Cohort Correlation tables
+CREATE TABLE cohortCorr (
+    cohort_id int unsigned not null,	# Cohort Id
+    result_table varchar(255) not null,	# Result Table
+              #Indices
+    PRIMARY KEY(cohort_id)
+);
+
+#Correlation results
+CREATE TABLE corrResults (
+    feature_id1 int unsigned not null,	# Feature Id1
+    feature_id2 int unsigned not null,	# Feature Id2
+    val float not null,	# Correlation Value
+              #Indices
+    PRIMARY KEY(feature_id1)
+);