aboutsummaryrefslogtreecommitdiffstats
path: root/proposals
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2021-11-01 20:08:11 -0700
committerBryan Newbold <bnewbold@archive.org>2021-11-01 20:08:11 -0700
commit58acf442af343b4b74f2e206cea1e95145dce744 (patch)
treef27fa4fbf5050a4fc4d7b52bbc1030791687dd83 /proposals
parent7ccfd1989fe4192d66a3d6f8dd9807dcfee055a5 (diff)
downloadsandcrawler-58acf442af343b4b74f2e206cea1e95145dce744.tar.gz
sandcrawler-58acf442af343b4b74f2e206cea1e95145dce744.zip
sql: fixes to ingest_fileset_platform schema (from table creation)
Diffstat (limited to 'proposals')
-rw-r--r--proposals/2021-09-09_fileset_ingest.md12
1 files changed, 6 insertions, 6 deletions
diff --git a/proposals/2021-09-09_fileset_ingest.md b/proposals/2021-09-09_fileset_ingest.md
index beb9d6a..b0d273e 100644
--- a/proposals/2021-09-09_fileset_ingest.md
+++ b/proposals/2021-09-09_fileset_ingest.md
@@ -259,17 +259,17 @@ Note that this table *complements* `ingest_file_result`, doesn't replace it.
hit BOOLEAN NOT NULL,
status TEXT CHECK (octet_length(status) >= 1),
- platform_name TEXT NOT NULL CHECK (octet_length(platform) >= 1),
+ platform_name TEXT NOT NULL CHECK (octet_length(platform_name) >= 1),
platform_domain TEXT NOT NULL CHECK (octet_length(platform_domain) >= 1),
platform_id TEXT NOT NULL CHECK (octet_length(platform_id) >= 1),
ingest_strategy TEXT CHECK (octet_length(ingest_strategy) >= 1),
total_size BIGINT,
- file_count INT,
- archiveorg_item_name TEXT CHECK (octet_length(item_name) >= 1),
+ file_count BIGINT,
+ archiveorg_item_name TEXT CHECK (octet_length(archiveorg_item_name) >= 1),
- archiveorg_item_bundle_path TEXT CHECK (octet_length(item_path_bundle) >= 1),
- web_bundle_url TEXT CHECK (octet_length(terminal_url) >= 1),
- web_bundle_dt TEXT CHECK (octet_length(terminal_dt) = 14),
+ archiveorg_item_bundle_path TEXT CHECK (octet_length(archiveorg_item_bundle_path) >= 1),
+ web_bundle_url TEXT CHECK (octet_length(web_bundle_url) >= 1),
+ web_bundle_dt TEXT CHECK (octet_length(web_bundle_dt) = 14),
manifest JSONB,
-- list, similar to fatcat fileset manifest, plus extra: