CREATE TABLE posts (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  slug        TEXT UNIQUE NOT NULL,
  title       TEXT NOT NULL,
  content     TEXT NOT NULL,
  content_type TEXT DEFAULT "markdown",
  summary     TEXT DEFAULT "",
  tags        TEXT DEFAULT "[]",
  category    TEXT DEFAULT "tech",
  featured    INTEGER DEFAULT 0,
  published   INTEGER DEFAULT 1,
  cover       TEXT,
  date        TEXT NOT NULL,
  reading_time INTEGER DEFAULT 0
);

CREATE TABLE media (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  filename    TEXT NOT NULL,
  mime_type   TEXT NOT NULL,
  size        INTEGER DEFAULT 0,
  data        BLOB NOT NULL
);