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)
);