diff options
| -rw-r--r-- | proposals/2021-09-09_fileset_ingest.md | 12 | ||||
| -rw-r--r-- | sql/migrations/2019-12-19-060141_init/up.sql | 12 |
2 files changed, 12 insertions, 12 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: diff --git a/sql/migrations/2019-12-19-060141_init/up.sql b/sql/migrations/2019-12-19-060141_init/up.sql index e478616..3e08ffd 100644 --- a/sql/migrations/2019-12-19-060141_init/up.sql +++ b/sql/migrations/2019-12-19-060141_init/up.sql @@ -172,17 +172,17 @@ CREATE TABLE IF NOT EXISTS ingest_fileset_platform ( 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: |