sql.globals.V7__create_session_table.sql Maven / Gradle / Ivy

Go to download

CREATE TABLE sessions (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid (),
    username TEXT NOT NULL REFERENCES users(username) ON DELETE CASCADE ON UPDATE CASCADE,
    creation TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);