onasty/migrations/20240613092532_sessions.up.sql(view raw)
1 2 3 4 5 6
CREATE TABLE sessions ( id uuid PRIMARY KEY DEFAULT uuid_generate_v4(), user_id uuid REFERENCES users (id), refresh_token varchar(255) NOT NULL UNIQUE, expires_at timestamptz NOT NULL );