DROP TABLE IF EXISTS users;
DROP TABLE IF EXISTS entities;

PRAGMA foreign_keys = ON;

CREATE TABLE IF NOT EXISTS users (
  id   INTEGER PRIMARY KEY,
  name VARCHAR(64) UNIQUE
);

CREATE TABLE IF NOT EXISTS entities (
  id         INTEGER PRIMARY KEY,
  user_id    INTEGER NOT NULL,
  name       VARCHAR(64), 
  spawn_line VARCHAR(64),
  FOREIGN KEY(user_id) REFERENCES users(id)
);