src/hg/lib/makeItemsItem.sql 1.4

Index: src/hg/lib/makeItemsItem.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/makeItemsItem.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -b -B -U 1000000 -r1.3 -r1.4
--- src/hg/lib/makeItemsItem.sql	10 Apr 2010 01:13:58 -0000	1.3
+++ src/hg/lib/makeItemsItem.sql	10 Apr 2010 06:11:51 -0000	1.4
@@ -1,21 +1,23 @@
 # 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
     score int unsigned not null,	# 0-1000.  Higher numbers are darker.
     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
+    id int auto_increment,
               #Indices
+    PRIMARY KEY(id),
     INDEX(chrom(16),bin)
 );