mk6i-open-oscar-server/state/migrations/0004_chat_rooms.up.sql

CREATE TABLE chatRoom
(
    cookie   TEXT PRIMARY KEY,
    exchange INTEGER,
    name     TEXT,
    created  TIMESTAMP,
    creator  TEXT,
    UNIQUE (exchange, name)
);