e7b66711387ac5b785cd52148ca4ce1180609167
hiram
  Fri Sep 27 11:13:00 2024 -0700
add the FULLTEXT index refs #32596

diff --git src/hg/lib/genark.sql src/hg/lib/genark.sql
index 73befa8..e42c2dd 100644
--- src/hg/lib/genark.sql
+++ src/hg/lib/genark.sql
@@ -2,17 +2,18 @@
 # generated genark.c and genark.h.  This creates the database representation of
 # an object which can be loaded and saved from RAM in a fairly 
 # automatic way.
 
 #index to UCSC assembly hubs
 CREATE TABLE genark (
     gcAccession varchar(255) not null,	# GC[AF] accssion identifier, e.g.: GCF_000001405.39
     hubUrl varchar(255) not null,	# path name to hub.txt: GCF/000/001/405/GCF_000001405.39/hub.txt
     asmName varchar(255) not null,	# assembly name: GRCh38.p13
     scientificName varchar(255) not null,	# scientific name: Homo sapiens
     commonName varchar(255) not null,	# common name: human
     taxId int not null,	# taxon id: 9606
     priority int not null,	# search priority to order hgGateway results
     clade varchar(255) not null,	# clade group in the GenArk system
               #Indices
+    FULLTEXT gIdx (gcAccession, asmName, scientificName, commonName, clade),
     PRIMARY KEY(gcAccession)
 );