BEGIN;

DROP TABLE IF EXISTS people;

CREATE TABLE people (
  id int PRIMARY KEY,
  name text,
  hasMother int REFERENCES people(id),
  hasFather int REFERENCES people(id)
);

INSERT INTO people VALUES
(1, 'Blank', NULL, NULL),
(2, 'Peter', NULL, NULL),
(3, 'Mina', NULL, NULL),
(4, 'Ole', NULL, NULL),
(5, 'Maria', NULL, NULL),
(6, 'Karl', 3, 2),
(7, 'Mary', 5, 4),
(8, 'Bob', 7, 6);

COMMIT;
