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 1000000 -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
@@ -1,19 +1,21 @@
 # makeItemsItem.sql was originally generated by the autoSql program, which also 
 # generated makeItemsItem.c and makeItemsItem.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #An item in a makeItems type track.
 CREATE TABLE makeItemsItem (
     bin int unsigned not null,	# Bin for range index
     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)
 );