g1t/services/packages/migrations/0004_checksums.sql
| 1 | -- The checksums Maven asks for beside every file (`.md5`, `.sha1`, |
| 2 | -- `.sha512`; `.sha256` is the blob's digest), worked out once when the |
| 3 | -- file is uploaded so a download never reads a file twice. Kept by digest, |
| 4 | -- as blobs are, and let go with them. |
| 5 | CREATE TABLE checksums ( |
| 6 | digest TEXT PRIMARY KEY, |
| 7 | md5 TEXT NOT NULL, |
| 8 | sha1 TEXT NOT NULL, |
| 9 | sha512 TEXT NOT NULL |
| 10 | ); |