From 3f01f73563f40869c82b7ad3e21c4183fdee8206 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Wed, 1 Dec 2021 19:06:33 -0800 Subject: update fatcat_file SQL table schema, and add backfill notes --- sql/migrations/2019-12-19-060141_init/up.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/sql/migrations/2019-12-19-060141_init/up.sql b/sql/migrations/2019-12-19-060141_init/up.sql index 18972cb..23a935e 100644 --- a/sql/migrations/2019-12-19-060141_init/up.sql +++ b/sql/migrations/2019-12-19-060141_init/up.sql @@ -42,7 +42,9 @@ CREATE INDEX file_meta_md5hex_idx ON file_meta(md5hex); CREATE TABLE IF NOT EXISTS fatcat_file ( sha1hex TEXT PRIMARY KEY CHECK (octet_length(sha1hex) = 40), file_ident TEXT CHECK (octet_length(file_ident) = 26), - first_release_ident TEXT CHECK (octet_length(first_release_ident) = 26) + first_release_ident TEXT CHECK (octet_length(first_release_ident) = 26), + any_url BOOLEAN, + content_scope TEXT CHECK (octet_length(content_scope) >= 1) ); CREATE TABLE IF NOT EXISTS petabox ( -- cgit v1.2.3