diff options
| -rw-r--r-- | fatcat-openapi2.yml | 6 | ||||
| -rw-r--r-- | rust/migrations/2018-05-12-001226_init/up.sql | 4 |
2 files changed, 4 insertions, 6 deletions
diff --git a/fatcat-openapi2.yml b/fatcat-openapi2.yml index 3eada7e4..eb0528d5 100644 --- a/fatcat-openapi2.yml +++ b/fatcat-openapi2.yml @@ -238,16 +238,14 @@ definitions: - surt - timestamp - url - - status_code - sha1 properties: surt: type: string example: "org,asheesh)/apus/ch1/node15.html" timestamp: - type: integer - example: 20020429162520 - format: int64 + type: string + example: "20020429162520" url: type: string example: "http://www.asheesh.org:80/APUS/ch1/node15.html" 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 |