744a3b2e1774459ae0348822c983a24746776f96 jcasper Fri Feb 16 12:26:31 2018 -0800 Hub text search now includes metadata tags, behaves better when encountering missing tracks/assemblies, and includes a MySQL index on the track field of hubSearchText refs #20761, #18865, #20694 diff --git src/hg/lib/hubSearchText.sql src/hg/lib/hubSearchText.sql index 1058f5b..f74fd9f 100644 --- src/hg/lib/hubSearchText.sql +++ src/hg/lib/hubSearchText.sql @@ -1,18 +1,18 @@ # 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 - textLength enum("Short", "Long"), # Length of text (short for labels, long for description pages) + 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) );