81bc6ac87d240fee77cd8827f3ce117ba35d4172 max Wed Jan 22 07:52:08 2014 -0800 fixing typo in last commit diff --git src/hg/lib/pubsBingSequenceAnnot.sql src/hg/lib/pubsBingSequenceAnnot.sql index e8eaa81..1762817 100644 --- src/hg/lib/pubsBingSequenceAnnot.sql +++ src/hg/lib/pubsBingSequenceAnnot.sql @@ -1,16 +1,16 @@ #publications track sequence data table -CREATE TABLE pubsSequenceAnnot ( +CREATE TABLE pubsBingSequenceAnnot ( articleId bigint not null, # identifier of the article where the sequence was found fileId int not null, # identifier of the file where the sequence was found seqId bigint not null, # unique identifier of this sequence within a file annotId bigint not null, # articleId(10)+fileId(3)+seqId(5), refd by pubsSequenceAnnot fileDesc varchar(2000) not null, # description of file where sequence was found fileUrl varchar(2000) not null, # url of file where sequence was found sequence longblob not null, # sequence snippet longblob not null, # flanking characters around sequence in article locations varchar(5000), # comma-sep list of genomic locations where this sequence matches #Indices KEY seqIdIdx(seqId), KEY annotIdx(annotId), KEY artIdIdx(articleId) );