CREATE TABLE IF NOT EXISTS authors (
  id INTEGER PRIMARY KEY,
  author TEXT UNIQUE NOT NULL
);