7fd86d24ec58a7e91f2abcc696bc7c108a866400
max
  Tue Mar 20 11:43:40 2012 -0700
changed table names in sql files as hiram code review, redmine #7363
diff --git src/hg/lib/pubsArticle.sql src/hg/lib/pubsArticle.sql
index ee78569..7e4c5b6 100644
--- src/hg/lib/pubsArticle.sql
+++ src/hg/lib/pubsArticle.sql
@@ -1,19 +1,19 @@
-#Text to Genome project article data table
-CREATE TABLE t2gArticle (
+#publication track article data table
+CREATE TABLE pubsArticle (
     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 or sciencedirect ID
     pmid bigint not null,               # PubmedID if available
+    source varchar(255) not null,       # data source, e.g. elsevier or pmcftp
     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),
     FULLTEXT INDEX (citation, title, authors, abstract)
 );