From 87a9bb4ed81b503f03e6e77d6b082249523e67d4 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Wed, 2 Jun 2021 00:26:51 -0700 Subject: crossref DB proposal, and include in SQL schema --- sql/migrations/2019-12-19-060141_init/up.sql | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'sql/migrations/2019-12-19-060141_init') diff --git a/sql/migrations/2019-12-19-060141_init/up.sql b/sql/migrations/2019-12-19-060141_init/up.sql index 73bd7f1..10a5183 100644 --- a/sql/migrations/2019-12-19-060141_init/up.sql +++ b/sql/migrations/2019-12-19-060141_init/up.sql @@ -175,3 +175,10 @@ CREATE TABLE IF NOT EXISTS shadow ( PRIMARY KEY(shadow_corpus, shadow_id) ); CREATE INDEX shadow_sha1hex_idx ON shadow(sha1hex); + +CREATE TABLE IF NOT EXISTS crossref ( + doi TEXT NOT NULL CHECK (octet_length(doi) >= 4 AND doi = LOWER(doi)), + indexed TIMESTAMP WITH TIME ZONE NOT NULL, + record JSON NOT NULL, + PRIMARY KEY(doi) +); -- cgit v1.2.3