From e213f0792b0d52ee9e4768cd30cf7507d5d83f37 Mon Sep 17 00:00:00 2001 From: Přemysl Eric Janouch Date: Sat, 16 Dec 2023 21:14:27 +0100 Subject: Store image dimensions in DB --- initialize.sql | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) (limited to 'initialize.sql') diff --git a/initialize.sql b/initialize.sql index 31f4b13..f42e55b 100644 --- a/initialize.sql +++ b/initialize.sql @@ -1,8 +1,10 @@ CREATE TABLE IF NOT EXISTS image( - sha1 TEXT NOT NULL, -- SHA-1 hash of file in lowercase hexadecimal - thumbw INTEGER, -- cached thumbnail width, if known - thumbh INTEGER, -- cached thumbnail height, if known - dhash INTEGER, -- uint64 perceptual hash as a signed integer + sha1 TEXT NOT NULL, -- SHA-1 hash of file in lowercase hexadecimal + width INTEGER NOT NULL, -- cached media width + height INTEGER NOT NULL, -- cached media height + thumbw INTEGER, -- cached thumbnail width, if known + thumbh INTEGER, -- cached thumbnail height, if known + dhash INTEGER, -- uint64 perceptual hash as a signed integer PRIMARY KEY (sha1) ) STRICT; -- cgit v1.2.3-70-g09d2