CREATE TABLE authors (
  id        INT NOT NULL PRIMARY KEY,
  name      TEXT NOT NULL,
  parent_id INT
);