afa3152ef687939b36da0fe4b684d76edeb4e783
larrym
  Fri Mar 16 14:04:28 2012 -0700
add FULLTEXT index
diff --git src/hg/lib/t2gArticle.sql src/hg/lib/t2gArticle.sql
index d0feecc..024e6f0 100644
--- src/hg/lib/t2gArticle.sql
+++ src/hg/lib/t2gArticle.sql
@@ -1,17 +1,18 @@
 #Text to Genome project article data table
 CREATE TABLE t2gArticle (
     articleId bigint not null,	# internal article ID, created during download
     displayId varchar(255) not null,	# display ID shown on browser, format: <author><year><letters>
     extId varchar(255) not null,	# publisher ID e.g. PMCxxxx or doi 
     citation varchar(2000) default null,	# source journal citation
     year int not null,	# year of publication or 0 if not defined
     title varchar(6000) default null,	# article title
     authors varchar(12000) default null,	# author list for this article
     abstract varchar(32000) not null,	# article abstract
     url varchar(1000) default null,	# url to fulltext of article
     dbs varchar(500) default null,      # list of DBs with matches to this article
               #Indices
     PRIMARY KEY(articleId),
     KEY displayIdx(displayId),
-    KEY extIdx(extId)
+    KEY extIdx(extId),
+    FULLTEXT INDEX (citation, title, authors, abstract)
 );