diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2018-12-26 22:49:41 -0800 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2018-12-26 22:49:41 -0800 |
| commit | 892b102d3c24cdde448d36c6ced35a75e368fe8c (patch) | |
| tree | a002bcf82053f3d0baaa116d5259d97e9a9fe580 /rust/migrations/2018-05-12-001226_init | |
| parent | 2089289d7d34c16d9530699f4635ff0f69d7d556 (diff) | |
| download | fatcat-892b102d3c24cdde448d36c6ced35a75e368fe8c.tar.gz fatcat-892b102d3c24cdde448d36c6ced35a75e368fe8c.zip | |
webcapture: status_code nullable; cdx timestamp string
Diffstat (limited to 'rust/migrations/2018-05-12-001226_init')
| -rw-r--r-- | rust/migrations/2018-05-12-001226_init/up.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql index 9b6a00a6..eadc2e8a 100644 --- a/rust/migrations/2018-05-12-001226_init/up.sql +++ b/rust/migrations/2018-05-12-001226_init/up.sql @@ -256,10 +256,10 @@ CREATE TABLE webcapture_rev_cdx ( id BIGSERIAL PRIMARY KEY, webcapture_rev UUID REFERENCES webcapture_rev(id) NOT NULL, surt TEXT NOT NULL, - timestamp BIGINT NOT NULL, -- TODO: timestamp type, or text? + timestamp TEXT NOT NULL, -- TODO: timestamp type? url TEXT NOT NULL, mimetype TEXT, - status_code BIGINT NOT NULL, + status_code BIGINT, sha1 TEXT CHECK(octet_length(sha1) = 40) NOT NULL, sha256 TEXT CHECK(octet_length(sha256) = 64) -- could extend with: language (detection), simhash, redirect |