schema.sql 472 B raw
1
CREATE 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
  blur_data TEXT
18
);
19
20
CREATE INDEX idx_photos_date ON photos(date DESC);
21
CREATE INDEX idx_photos_slug ON photos(slug);