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

Index: src/hg/instinct/bioInt2/createTables.c
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/instinct/bioInt2/createTables.c,v
retrieving revision 1.2
retrieving revision 1.3
diff -b -B -U 4 -r1.2 -r1.3
--- src/hg/instinct/bioInt2/createTables.c	30 Apr 2009 19:54:28 -0000	1.2
+++ src/hg/instinct/bioInt2/createTables.c	1 Sep 2009 05:18:02 -0000	1.3
@@ -292,4 +292,18 @@
 sqlUpdate(biConn,dy->string);
 dyStringFree(&dy);
 }  
 
+void createPathwayEMValsTable(struct sqlConnection *biConn, char *tableName)
+{
+struct dyString *dy = newDyString(1024);
+dyStringPrintf(dy, "CREATE TABLE %s (\n", tableName);
+dyStringPrintf(dy, "pathway_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(pathway_id, dataset_id)\n");
+dyStringPrintf(dy, ")\n");
+sqlUpdate(biConn,dy->string);
+dyStringFree(&dy);
+}        
\ No newline at end of file