src/hg/lib/pgSnp.sql 1.3

Index: src/hg/lib/pgSnp.sql
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/lib/pgSnp.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -b -B -U 1000000 -r1.2 -r1.3
--- src/hg/lib/pgSnp.sql	17 Jun 2008 21:49:52 -0000	1.2
+++ src/hg/lib/pgSnp.sql	12 Oct 2009 16:32:18 -0000	1.3
@@ -1,18 +1,18 @@
 # pgSnp.sql was originally generated by the autoSql program, which also 
 # generated pgSnp.c and pgSnp.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #personal genome SNP
 CREATE TABLE pgSnp (
     bin smallint unsigned not null,	# A field to speed indexing
     chrom varchar(255) not null,	# Chromosome
     chromStart int unsigned not null,	# Start position in chrom
     chromEnd int unsigned not null,	# End position in chrom
     name varchar(255) not null,	# alleles
     alleleCount int not null,	# number of alleles
     alleleFreq varchar(255) not null,	# comma separated list of frequency of each allele
     alleleScores varchar(255) not null,	# comma separated list of quality scores
               #Indices
-    INDEX(bin)
+    INDEX(chrom,bin)
 );