src/hg/lib/makeItemsItem.sql 1.4
1.4 2010/04/10 06:11:51 kent
Adding id field to makeItemsItem.
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 4 -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
@@ -15,7 +15,9 @@
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)
);