parley/schema.sql

CREATE TABLE IF NOT EXISTS games
  ( id INTEGER PRIMARY KEY ASC
  , name TEXT NOT NULL
  );
CREATE TABLE IF NOT EXISTS chat
  ( id INTEGER PRIMARY KEY ASC
  , game INTEGER NOT NULL
  , user TEXT NOT NULL
  , content TEXT NOT NULL
  , FOREIGN KEY(game) REFERENCES games(id)
  );