aboutsummaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2021-12-01 19:06:33 -0800
committerBryan Newbold <bnewbold@archive.org>2021-12-07 19:10:23 -0800
commit3f01f73563f40869c82b7ad3e21c4183fdee8206 (patch)
tree06b17b012e83a1ad722dc70c191e09ebac490c18 /sql
parent4f02b47f57364195e7302ec80565ce51fd20048d (diff)
downloadsandcrawler-3f01f73563f40869c82b7ad3e21c4183fdee8206.tar.gz
sandcrawler-3f01f73563f40869c82b7ad3e21c4183fdee8206.zip
update fatcat_file SQL table schema, and add backfill notes
Diffstat (limited to 'sql')
-rw-r--r--sql/migrations/2019-12-19-060141_init/up.sql4
1 files changed, 3 insertions, 1 deletions
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 (