diff options
| author | Bryan Newbold <bnewbold@archive.org> | 2021-12-01 19:06:33 -0800 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@archive.org> | 2021-12-07 19:10:23 -0800 |
| commit | 3f01f73563f40869c82b7ad3e21c4183fdee8206 (patch) | |
| tree | 06b17b012e83a1ad722dc70c191e09ebac490c18 /sql | |
| parent | 4f02b47f57364195e7302ec80565ce51fd20048d (diff) | |
| download | sandcrawler-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.sql | 4 |
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 ( |