diff options
| author | Přemysl Eric Janouch <p@janouch.name> | 2023-12-16 21:14:27 +0100 |
|---|---|---|
| committer | Přemysl Eric Janouch <p@janouch.name> | 2023-12-16 23:50:10 +0100 |
| commit | e213f0792b0d52ee9e4768cd30cf7507d5d83f37 (patch) | |
| tree | 9523cff275ef3cb6478d7f06ad1be8281d9ce62e /initialize.sql | |
| parent | 87eb786498e598a319dfa305cf43c4ab664d26a4 (diff) | |
| download | gallery-e213f0792b0d52ee9e4768cd30cf7507d5d83f37.tar.gz gallery-e213f0792b0d52ee9e4768cd30cf7507d5d83f37.tar.xz gallery-e213f0792b0d52ee9e4768cd30cf7507d5d83f37.zip | |
Store image dimensions in DB
Diffstat (limited to 'initialize.sql')
| -rw-r--r-- | initialize.sql | 10 |
1 files changed, 6 insertions, 4 deletions
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; |