From e213f0792b0d52ee9e4768cd30cf7507d5d83f37 Mon Sep 17 00:00:00 2001
From: Přemysl Eric Janouch <p@janouch.name>
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.3

