onasty: migrations/20240613092532_sessions.up.sql (e73c44f)

onasty/migrations/20240613092532_sessions.up.sql (view raw)

Smirnov Oleksandr feat: notes manipulations for the note authors (#117)..., 1 year ago

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
);

1	CREATE TABLE sessions (
2	id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (),
3	user_id uuid REFERENCES users (id),
4	refresh_token varchar(255) NOT NULL UNIQUE,
5	expires_at timestamptz NOT NULL
6	);