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/pubsSequenceAnnot.sql src/hg/lib/pubsSequenceAnnot.sql index 1a3afea..36ebe67 100644 --- src/hg/lib/pubsSequenceAnnot.sql +++ src/hg/lib/pubsSequenceAnnot.sql @@ -1,13 +1,13 @@ -#Text to Genome project sequence data table -CREATE TABLE t2gSequence ( +#publication track sequence annotation table +CREATE TABLE pubsSequenceAnnot ( 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 fileDesc varchar(2000) not null, # description 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 artIdIdx(articleId) );