# Pastebin yK7jxqbb
CREATE TABLE listens_new (
    listened_at     TIMESTAMP WITH TIME ZONE NOT NULL,
    tz_offset       INTERVAL, -- offset to apply to listened_at to get listen's local timestamp
    created         TIMESTAMP WITH TIME ZONE DEFAULT NOW() NOT NULL,
    recording_msid  UUID                     NOT NULL,
    user_id         INTEGER                  NOT NULL,
    data            JSONB                    NOT NULL
);