7b63853e7d35a5af80fea81bc221910e2f55c1f5
max
  Thu Jan 16 03:52:10 2014 -0800
adding .as files for publications track, ref #12212
diff --git src/hg/lib/pubsBingArticle.sql src/hg/lib/pubsBingArticle.sql
index 5979ff4..6b23008 100644
--- src/hg/lib/pubsBingArticle.sql
+++ src/hg/lib/pubsBingArticle.sql
@@ -1,19 +1,23 @@
-CREATE TABLE pubsArticle (
+# information about a website, some fields are always empty (like pmid) to stay compatible with pubsArticle, fields like authors and title are extracted from meta tags of the html (Dublin core, etc)
+CREATE TABLE pubsBingArticle (
     articleId bigint not null,	# internal article ID, created during download
     extId varchar(255) not null,	# publisher ID e.g. PMCxxxx or doi or sciencedirect ID
     pmid bigint not null,               # PubmedID if available
     doi varchar(255) not null,               # DOI 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
     firstAuthor varchar(255) default null,	# first author family name
     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 extIdx(extId),
+    KEY urlIdx(url),
+    KEY pmidIdx(pmid),
+    KEY doiIdx(doi),
     FULLTEXT INDEX (citation, title, authors, abstract)
 );