c80394aac5768aa53379e5f43d1c6d30c22a2074
baertsch
  Fri May 20 15:58:06 2011 -0700
trackDb and sql changes for retrotracks
diff --git src/hg/lib/ucscRetroInfo.sql src/hg/lib/ucscRetroInfo.sql
index 0245596..d79b27a 100644
--- src/hg/lib/ucscRetroInfo.sql
+++ src/hg/lib/ucscRetroInfo.sql
@@ -1,22 +1,21 @@
 # ucscRetroInfo.sql was originally generated by the autoSql program, which also 
 # generated ucscRetroInfo.c and ucscRetroInfo.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #Retrogenes based on cDNA alignments that are expressed or processed pseudogenes.
-drop table ucscRetroInfo;
 CREATE TABLE ucscRetroInfo (
     chrom varchar(255) not null,	# Reference sequence chromosome or scaffold col1
     chromStart int unsigned not null,	# pseudogene alignment start position col2
     chromEnd int unsigned not null,	# pseudogene alignment end position col3
     name varchar(255) not null,	# Name of pseudogene col4
     score int unsigned not null,	# score of pseudogene with gene col5
     strand char(2) not null,	# + or -
     thickStart int unsigned not null,	# Start of where display should be thick (start codon)
     thickEnd int unsigned not null,	# End of where display should be thick (stop codon)
     reserved int unsigned not null,	# Always zero for now
     blockCount int not null,	# Number of blocks
     blockSizes longblob not null,	# Comma separated list of block sizes
     chromStarts longblob not null,	# Start positions relative to chromStart
     retroExonCount int not null,	# number of exons in retroGene col13
     axtScore int not null,	# blastz score, parent mrna aligned to pseudogene col14
@@ -48,17 +47,19 @@
     rStart int not null,	# refSeq alignment start position col40
     rEnd int not null,	# refSeq alignment end position col41
     mgc varchar(255) not null,	# Name of closest mgc to gene col42
     mStart int not null,	# mgc alignment start position col43
     mEnd int not null,	# mgc alignment end position col44
     kgName varchar(255) not null,	# Name of closest knownGene to gene col45
     kStart int not null,	# kg alignment start position col46
     kEnd int not null,	# kg alignment end position col47
     overName varchar(255) not null,	# name of overlapping mrna col48
     overStart int not null,	# overlapping mrna start position col49
     overExonCover int not null,	# count of overlapping mrna exons col50
     overStrand char(2) not null,	# strand of overlapping mrna col51
     posConf float not null,	# pvalue for positive col52
     polyAlen int unsigned not null,	# length of polyA col53
               #Indices
-    PRIMARY KEY(name)
+    PRIMARY KEY(name),
+    index(kgName(10)),
+    index(refSeq(10))
 );