904db7ae68c3500ca6b72c927cfc0612550dd68f
cline
  Tue Jan 24 13:08:11 2012 -0800
Follow-up to changing knownCanonical.as as part of this week's code review: changing the products of knownCanonical.as
diff --git src/hg/lib/knownCanonical.sql src/hg/lib/knownCanonical.sql
index 0930de8..3a7685e 100644
--- src/hg/lib/knownCanonical.sql
+++ src/hg/lib/knownCanonical.sql
@@ -1,16 +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). Corresponds to txStart for + strand genes
-    chromEnd int not null,	# End position (non-inclusive). Corresponds to txEnd for + strand genes
+    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,	# UniProt ID of the associated protein, if any.
               #Indices
-    PRIMARY KEY(chrom)
+    UNIQUE(clusterId),
+    INDEX(transcript(12)),
+    INDEX(protein(12))
 );