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

Index: src/hg/instinct/bioInt2/bioIntDb.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/instinct/bioInt2/bioIntDb.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -b -B -U 4 -r1.2 -r1.3
--- src/hg/instinct/bioInt2/bioIntDb.sql	21 Mar 2009 19:54:10 -0000	1.2
+++ src/hg/instinct/bioInt2/bioIntDb.sql	22 Mar 2009 01:07:28 -0000	1.3
@@ -156,18 +156,28 @@
 #All analyses run
 CREATE TABLE analyses (
     id int unsigned not null,	# Analysis id
     cohort_id int unsigned not null,	# Cohort Id
-    module varchar(255) not null,	# Analysis Module
+    module_id int unsigned not null,	# Module Id
     result_table varchar(255) not null,	# Table containing result
+    input_tables longblob not null,	# Comma-separated list of input tables
+              #Indices
+    PRIMARY KEY(id)
+);
+
+#All analysis modules
+CREATE TABLE analysisModules (
+    id int unsigned not null,	# Module Id
+    name varchar(255) not null,	# Module Name
+    type varchar(255) not null,	# Module Type (gene, geneset, etc.)
               #Indices
     PRIMARY KEY(id)
 );
 
 #All analysis parameters
 CREATE TABLE analysisParams (
-    analysis_id int unsigned not null,	# Module Id
-    key varchar(255) not null,	# Parameter key
+    analysis_id int unsigned not null,	# Analysis Id
+    name varchar(255) not null,	# Parameter name
     val varchar(255) not null,	# Parameter val
               #Indices
     PRIMARY KEY(analysis_id)
 );