src/hg/instinct/raToDb/raDb.sql 1.2

Index: src/hg/instinct/raToDb/raDb.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/instinct/raToDb/raDb.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -b -B -U 4 -r1.1 -r1.2
--- src/hg/instinct/raToDb/raDb.sql	9 Apr 2010 19:31:15 -0000	1.1
+++ src/hg/instinct/raToDb/raDb.sql	9 Apr 2010 22:58:36 -0000	1.2
@@ -1,23 +1,25 @@
-# ra.sql was originally generated by the autoSql program, which also 
-# generated ra.c and ra.h.  This creates the database representation of
+# raDb.sql was originally generated by the autoSql program, which also 
+# generated raDb.c and raDb.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #ra info
-CREATE TABLE ra (
+CREATE TABLE raDb (
     id int unsigned,	# Unique id
     name varchar(255),	# Table name for genomic data
     accessTable varchar(255),	# Down-sampled table
     shortLabel varchar(255),	# Short label
     longLabel varchar(255),	# Long label
-    group varchar(255),	# Group for organization
+    expCount int unsigned,	# Number of samples
+    groupName varchar(255),	# Group name
     raFile varchar(255),	# RA file containing clinical info
     patDb varchar(255),	# Clinical info db
     sampleField varchar(255),	# Sample field
     patTable varchar(255),	# Patient to sample mapping
     patField varchar(255),	# Patient field
     aliasTable varchar(255),	# Probe to gene mapping
+    displayNameTable varchar(255),	# Display names for aliases
     dataType varchar(255),	# data type (bed 15)
     platform varchar(255),	# Expression, SNP, etc.
     expScale float,	# Scaling factor
     gainFull float,	# Gain Full