a48e4a31e870414b9ed4a9731bf4ca694e6ff008
chmalee
  Wed Oct 30 11:36:15 2019 -0700
Fixes to hub searching after code review: Angie noticed that links were broken due to a bug, but it turns out they were broken in a much bigger way as subtrack search hits were not linking out to the right parent tracks. This has been fixed by adding a new column to the hubSearchText table to encode the parent type of the parent tracks (comp, super, etc), and then building the links the correct way, refs #24338

diff --git src/hg/lib/hubSearchText.sql src/hg/lib/hubSearchText.sql
index 8c33591..3415959 100644
--- src/hg/lib/hubSearchText.sql
+++ src/hg/lib/hubSearchText.sql
@@ -1,19 +1,20 @@
 # hubSearchText.sql was originally generated by the autoSql program, which also 
 # generated hubSearchText.c and hubSearchText.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #Track hub descriptions
 CREATE TABLE hubSearchText (
     hubUrl longblob,	# Hub URL
     db varchar(255),	# Assembly name (UCSC format) for Assembly and Track descriptions, NULL for hub descriptions
     track varchar(255),	# Track name for track descriptions, NULL for others
     label varchar(255),	# Name to display in search results
-    parents longblob,	# Comma separated list of parent track of this track, NULL for others
     textLength enum("Short", "Long", "Meta"),	# Length of text (short for labels, long for description pages, meta for metadata)
     text longtext,	# Description text
+    parents longblob,	# Comma separated list of parent track of this track, NULL for others
+    parentTypes longblob, # Comma separated list of parent track types
               #Indices
     KEY (textLength),
     INDEX (track),
     FULLTEXT INDEX (text)
 );