67ce69b2d6be585fcad3cb0dd5fc927e95c327ff
chmalee
  Mon Oct 14 13:48:54 2019 -0700
Rework of hgHubConnect hub searching to not use trackDb or udc so searches can be sped up. The hubSearchText table now has an extra column for the parent track names (if any) of a search result to a track. hgHubConnect has been changed to use this field of the table instead of using trackDb. hubCrawl has been changed to generate this additional column, refs #23812

diff --git src/hg/lib/hubSearchText.sql src/hg/lib/hubSearchText.sql
index f74fd9f..8c33591 100644
--- src/hg/lib/hubSearchText.sql
+++ src/hg/lib/hubSearchText.sql
@@ -1,18 +1,19 @@
 # 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
               #Indices
     KEY (textLength),
     INDEX (track),
     FULLTEXT INDEX (text)
 );