src/hg/lib/makeItemsItem.sql 1.3

1.3 2010/04/10 01:13:58 kent
Taking a few more steps towards making the makeItems type custom track. It actually seems to be storing ranges in the customTrash database and displaying them now based on your javascript selections!

Index: src/hg/lib/makeItemsItem.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/makeItemsItem.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -b -B -U 4 -r1.2 -r1.3
--- src/hg/lib/makeItemsItem.sql	9 Apr 2010 17:45:57 -0000	1.2
+++ src/hg/lib/makeItemsItem.sql	10 Apr 2010 01:13:58 -0000	1.3
@@ -9,11 +9,13 @@
     chrom varchar(255) not null,	# Reference sequence chromosome or scaffold
     chromStart int unsigned not null,	# Start position in chromosome
     chromEnd int unsigned not null,	# End position in chromosome
     name varchar(255) not null,	# Name of item - up to 16 chars
-    strand char(1) not null,	# + or - for strand
     score int unsigned not null,	# 0-1000.  Higher numbers are darker.
-    color varchar(255) not null,	# Comma separated list of RGB components.  IE 255,0,0 for red
+    strand char(1) not null,	# + or - for strand
+    thickStart int unsigned not null,	# Start of thick part
+    thickEnd int unsigned not null,	# End position of thick part
+    itemRgb int unsigned not null,	# RGB 8 bits each as in bed
     description longblob not null,	# Longer item description
               #Indices
     INDEX(chrom(16),bin)
 );