7f33fb42a1fb58a02a3f798e56332e5beac65133 max Sat Mar 17 13:21:09 2012 -0700 renaming all publications tracks tables to pubsXXXX diff --git src/hg/lib/t2gArticle.sql src/hg/lib/t2gArticle.sql deleted file mode 100644 index d0feecc..0000000 --- src/hg/lib/t2gArticle.sql +++ /dev/null @@ -1,17 +0,0 @@ -#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) -);