diff options
Diffstat (limited to 'sql/migrations')
| -rw-r--r-- | sql/migrations/2019-12-19-060141_init/up.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/migrations/2019-12-19-060141_init/up.sql b/sql/migrations/2019-12-19-060141_init/up.sql index a27796b..688487f 100644 --- a/sql/migrations/2019-12-19-060141_init/up.sql +++ b/sql/migrations/2019-12-19-060141_init/up.sql @@ -37,6 +37,7 @@ CREATE TABLE IF NOT EXISTS file_meta ( size_bytes BIGINT, mimetype TEXT CHECK (octet_length(mimetype) >= 1) ); +CREATE INDEX file_meta_md5hex_idx ON file_meta(md5hex); CREATE TABLE IF NOT EXISTS fatcat_file ( sha1hex TEXT PRIMARY KEY CHECK (octet_length(sha1hex) = 40), |