My personal photography website
steve.phot
stevedylan.dev
portfolio
photography
svelte
sveltekit
1CREATE TABLE IF NOT EXISTS photos (
2 id INTEGER PRIMARY KEY AUTOINCREMENT,
3 slug TEXT UNIQUE NOT NULL,
4 title TEXT NOT NULL,
5 date TEXT NOT NULL,
6 image_key TEXT NOT NULL,
7 thumb_key TEXT NOT NULL,
8 type TEXT DEFAULT 'photo',
9 camera TEXT,
10 lens TEXT,
11 aperture TEXT,
12 exposure TEXT,
13 focal_length TEXT,
14 iso TEXT,
15 make TEXT,
16 tags TEXT
17);
18
19CREATE INDEX idx_photos_date ON photos(date DESC);
20CREATE INDEX idx_photos_slug ON photos(slug);