CREATE TABLE IF NOT EXISTS players (
    id BIGSERIAL PRIMARY KEY NOT NULL,
    connection_id TEXT NOT NULL,
    name TEXT NOT NULL,
    "type" TEXT NOT NULL,
    playing BIGINT NOT NULL DEFAULT 0,
    created TIMESTAMP NOT NULL DEFAULT NOW(),
    updated TIMESTAMP NOT NULL DEFAULT NOW()
);