onasty: migrations/20240729115827_verification_tokens.up.sql (00d1621a13f2d5cfc18ea9585223b5c0cbc413f6)

onasty/migrations/20240729115827_verification_tokens.up.sql (view raw)

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

CREATE TABLE verification_tokens (
    id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (),
    user_id uuid NOT NULL UNIQUE REFERENCES users (id),
    token varchar(255) NOT NULL UNIQUE,
    created_at timestamptz NOT NULL DEFAULT now(),
    expires_at timestamptz NOT NULL,
    used_at timestamptz DEFAULT NULL
);

1	CREATE TABLE verification_tokens (
2	id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (),
3	user_id uuid NOT NULL UNIQUE REFERENCES users (id),
4	token varchar(255) NOT NULL UNIQUE,
5	created_at timestamptz NOT NULL DEFAULT now(),
6	expires_at timestamptz NOT NULL,
7	used_at timestamptz DEFAULT NULL
8	);