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 1000000 -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,39 +1,41 @@
-# 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
     gainSet float,	# Gain Set
     type varchar(255),	# Unknown
     visibility varchar(255),	# Default visibility
     priority float,	# Priority for sorting
     url varchar(255),	# Pubmed URL
     security varchar(255),	# Security setting (public, private)
     local_url varchar(255),	# URL to local details page
     profile varchar(255),	# Database profile
     wrangler varchar(255),	# Wrangler
     citation varchar(255),	# Citation
     article_title longblob,	# Title of publication
     author_list longblob,	# Author list
     wrangling_procedure longblob,	# Wrangling
               #Indices
     PRIMARY KEY(id)
 );