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

1.3 2010/04/09 23:56:03 jsanborn
updated
Index: src/hg/instinct/raToDb/raDb.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/instinct/raToDb/raDb.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -b -B -U 1000000 -r1.2 -r1.3
--- src/hg/instinct/raToDb/raDb.sql	9 Apr 2010 22:58:36 -0000	1.2
+++ src/hg/instinct/raToDb/raDb.sql	9 Apr 2010 23:56:03 -0000	1.3
@@ -1,41 +1,42 @@
 # 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 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
     expCount int unsigned,	# Number of samples
+    height int unsigned,	# Image Height (only for bed 4)
     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)
 );