CREATE TABLE IF NOT EXISTS users (
  id            INTEGER PRIMARY KEY AUTOINCREMENT,
  email         TEXT,
  password_hash TEXT,
  created_at    DATETIME
);

CREATE UNIQUE INDEX IF NOT EXISTS idx_users_email ON users (email);

CREATE TABLE IF NOT EXISTS posts (
  id         INTEGER PRIMARY KEY AUTOINCREMENT,
  author_id  INTEGER,
  author     TEXT,
  body       TEXT,
  created_at DATETIME
);

CREATE INDEX IF NOT EXISTS idx_posts_author_id ON posts (author_id);