src/hg/instinct/bioInt2/createTables.c 1.4

Index: src/hg/instinct/bioInt2/createTables.c
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/instinct/bioInt2/createTables.c,v
retrieving revision 1.3
retrieving revision 1.4
diff -b -B -U 4 -r1.3 -r1.4
--- src/hg/instinct/bioInt2/createTables.c	1 Sep 2009 05:18:02 -0000	1.3
+++ src/hg/instinct/bioInt2/createTables.c	5 Sep 2009 01:12:01 -0000	1.4
@@ -297,12 +297,14 @@
 {
 struct dyString *dy = newDyString(1024);
 dyStringPrintf(dy, "CREATE TABLE %s (\n", tableName);
 dyStringPrintf(dy, "pathway_id int unsigned not null,\n");
+dyStringPrintf(dy, "cohort_id int unsigned not null,\n");
 dyStringPrintf(dy, "dataset_id int unsigned not null,\n");
 dyStringPrintf(dy, "parent_state int unsigned not null,\n");
 dyStringPrintf(dy, "child_state int unsigned not null,\n");
 dyStringPrintf(dy, "val float not null,\n");
+dyStringPrintf(dy, "KEY(cohort_id),\n");
 dyStringPrintf(dy, "KEY(pathway_id, dataset_id)\n");
 dyStringPrintf(dy, ")\n");
 sqlUpdate(biConn,dy->string);
 dyStringFree(&dy);