422154600ea64376ef82472e05379cf974b111e2
braney
  Thu Nov 14 10:27:14 2019 -0800
add index on transcript in knownIsoforms refs #24486

diff --git src/hg/lib/knownIsoforms.sql src/hg/lib/knownIsoforms.sql
index a32299f..cc854bc 100644
--- src/hg/lib/knownIsoforms.sql
+++ src/hg/lib/knownIsoforms.sql
@@ -1,12 +1,13 @@
 # knownIsoforms.sql was originally generated by the autoSql program, which also 
 # generated knownIsoforms.c and knownIsoforms.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #Links together various transcripts of a gene into a cluster
 CREATE TABLE knownIsoforms (
     clusterId int not null,	# Unique id for transcript cluster (aka gene)
     transcript varchar(255) not null,	# Corresponds to name in knownGene table, transcript in knownCanonical
               #Indices
+    UNIQUE KEY `transcript` (`transcript`),
     INDEX(clusterId)
 );