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

Index: src/hg/instinct/bioInt2/createTables.c
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/instinct/bioInt2/createTables.c,v
retrieving revision 1.1
retrieving revision 1.2
diff -b -B -U 4 -r1.1 -r1.2
--- src/hg/instinct/bioInt2/createTables.c	27 Apr 2009 17:00:16 -0000	1.1
+++ src/hg/instinct/bioInt2/createTables.c	30 Apr 2009 19:54:28 -0000	1.2
@@ -37,10 +37,8 @@
 dyStringPrintf(dy, "type_id int unsigned not null,\n");
 dyStringPrintf(dy, "num_samples int unsigned not null,\n");
 dyStringPrintf(dy, "name varchar(255) not null,\n");
 dyStringPrintf(dy, "data_table varchar(255) not null,\n");
-//dyStringPrintf(dy, "probe_table varchar(255) not null,\n");
-//dyStringPrintf(dy, "probe_to_gene_table varchar(255) not null,\n");
 dyStringPrintf(dy, "PRIMARY KEY(id)\n");
 dyStringPrintf(dy, ")\n");
 sqlUpdate(biConn,dy->string);
 dyStringFree(&dy);
@@ -237,8 +235,24 @@
 sqlUpdate(biConn,dy->string);
 dyStringFree(&dy);
 }        
 
+void createPathwayValsTable(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, "sample_id int unsigned not null,\n");
+dyStringPrintf(dy, "feature_id int unsigned not null,\n");
+dyStringPrintf(dy, "val float not null,\n");
+dyStringPrintf(dy, "conf float not null,\n");
+dyStringPrintf(dy, "KEY(pathway_id, feature_id, sample_id),\n");
+dyStringPrintf(dy, "KEY(pathway_id, sample_id, feature_id)\n");
+dyStringPrintf(dy, ")\n");
+sqlUpdate(biConn,dy->string);
+dyStringFree(&dy);
+}        
+
 void createAnalysisModulesTable(struct sqlConnection *biConn, char *tableName)
 {
 struct dyString *dy = newDyString(1024);
 dyStringPrintf(dy, "CREATE TABLE %s (\n", tableName);