cd4b5b043806f6b09c8a3136d90f6565eee8ba12 braney Fri Jan 11 09:55:07 2019 -0800 add SQL file that describes gbLoaded table diff --git src/hg/lib/gbLoaded.sql src/hg/lib/gbLoaded.sql new file mode 100644 index 0000000..5ef9e54 --- /dev/null +++ src/hg/lib/gbLoaded.sql @@ -0,0 +1,11 @@ + +create table gbLoaded ( + srcDb enum('GenBank','RefSeq') not null, + type enum('EST','mRNA') not null, + loadRelease char(8) not null, + loadUpdate char(10) not null, + accPrefix char(2) not null, + time timestamp not null, + extFileUpdated tinyint(1) not null, + index(srcDb,loadRelease)); +