src/hg/visiGene/vgProbeTrack/vgProbeTrack.c 1.17

1.17 2009/10/22 16:38:51 galt
slightly faster
Index: src/hg/visiGene/vgProbeTrack/vgProbeTrack.c
===================================================================
RCS file: /projects/compbio/cvsroot/kent/src/hg/visiGene/vgProbeTrack/vgProbeTrack.c,v
retrieving revision 1.16
retrieving revision 1.17
diff -b -B -U 4 -r1.16 -r1.17
--- src/hg/visiGene/vgProbeTrack/vgProbeTrack.c	14 Oct 2009 19:03:02 -0000	1.16
+++ src/hg/visiGene/vgProbeTrack/vgProbeTrack.c	22 Oct 2009 16:38:51 -0000	1.17
@@ -1435,11 +1435,11 @@
 "hgPepPred %s generic vgRemapTemp %s "
 ,database,fasta);
 verbose(1,"%s\n",cmd); system(cmd);
 
-sqlUpdate(conn, "create index seq on vgRemapTemp(seq(40));");
 /* required for mysql 5 longtext for case-insensitive comparisons of blobs */
 sqlUpdate(conn, "ALTER table vgRemapTemp modify seq longtext;");
+sqlUpdate(conn, "create index seq on vgRemapTemp(seq(40));");
 
 /* get remapped psl probes not yet aligned */
 dyStringClear(dy);
 dyStringPrintf(dy,