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) );