src/hg/lib/t2gArticle.sql 1.1

Index: src/hg/lib/t2gArticle.sql
===================================================================
RCS file: src/hg/lib/t2gArticle.sql
diff -N src/hg/lib/t2gArticle.sql
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ src/hg/lib/t2gArticle.sql	20 May 2010 18:29:08 -0000	1.1
@@ -0,0 +1,15 @@
+#Text to Genome project article data table
+CREATE TABLE t2gArticle (
+    pmcId bigint not null,	# PMC ID
+    displayId varchar(255) not null,	# display ID
+    authors varchar(6000) default null,	# author list for this article
+    title varchar(2000) default null,	# article title
+    journal varchar(1000) default null,	# source journal
+    year varchar(255) default null,	# publication year
+    pages varchar(255) default null,	# publication pages
+    pmid varchar(255) default null,	# PM ID
+    abstract blob not null,	# article abstract
+              #Indices
+    PRIMARY KEY(pmcId),
+    KEY displayIdx(displayId)
+);