c0a6048e07b4cae079738ca5b3cb076493dbd19e
braney
  Fri Jan 4 10:00:37 2019 -0800
modify some knownGene SQL files to use full query for index #22713

diff --git src/hg/lib/knownCanonical.sql src/hg/lib/knownCanonical.sql
index 39b93c2..d378010 100644
--- src/hg/lib/knownCanonical.sql
+++ src/hg/lib/knownCanonical.sql
@@ -1,18 +1,18 @@
 # knownCanonical.sql was originally generated by the autoSql program, which also 
 # generated knownCanonical.c and knownCanonical.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #Describes the canonical splice variant of a gene
 CREATE TABLE knownCanonical (
     chrom varchar(255) not null,	# Chromosome
     chromStart int not null,	# Start position (0 based). Represents transcription start for + strand genes, end for - strand genes
     chromEnd int not null,	# End position (non-inclusive). Represents transcription end for + strand genes, start for - strand genes
     clusterId int not null,	# Which cluster of transcripts this belongs to in knownIsoforms
     transcript varchar(255) not null,	# Corresponds to knownGene name field.
     protein varchar(255) not null,	# Accession of the associated protein, or UCSC ID in newer tables.
               #Indices
     UNIQUE(clusterId),
-    INDEX(transcript(12)),
-    INDEX(protein(12))
+    INDEX(transcript),
+    INDEX(protein)
 );