CREATE TABLE users (
    user_id integer PRIMARY KEY,
    nick text UNIQUE NOT NULL,
    email text NOT NULL,
    salt integer NOT NULL,
    password_hash text NOT NULL,
    created_on timestamp NOT NULL
);

CREATE TABLE rooms (
    room_id integer PRIMARY KEY,
    name text UNIQUE NOT NULL,
    created_on timestamp NOT NULL
);

CREATE TABLE messages (
    message_id integer PRIMARY KEY,
    user_id integer NOT NULL REFERENCES users,
    room_id integer NOT NULL REFERENCES rooms,
    content text NOT NULL,
    created_on timestamp NOT NULL
);

CREATE TABLE user_session (
    session_id integer PRIMARY KEY,
    user_id NOT NULL REFERENCES users,
    id_address text NOT NULL,
    ttl timestamp NOT NULL
);