79e2e0421ffa1203d75e66351a2046085129528e
jcasper
  Thu Jun 15 15:16:16 2017 -0700
hgHubConnect now displays search details and indexes description content, refs #13625

diff --git src/hg/lib/hubSearchText.sql src/hg/lib/hubSearchText.sql
new file mode 100644
index 0000000..61ac57d
--- /dev/null
+++ src/hg/lib/hubSearchText.sql
@@ -0,0 +1,17 @@
+# 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)
+    text longtext,	# Description text
+              #Indices
+    KEY (textLength),
+    FULLTEXT INDEX (text)
+);