onasty: migrations/20250821143449_change_email

onasty/migrations/20250821143449_change_email_tokens.up.sql (view raw)

Olexandr Smirnov feat(api): change email (#191)..., 9 months ago

CREATE TABLE change_email_tokens (
    id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (),
    user_id uuid NOT NULL REFERENCES users (id),
    token varchar(255) NOT NULL UNIQUE,
    new_email 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 change_email_tokens (
2	id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (),
3	user_id uuid NOT NULL REFERENCES users (id),
4	token varchar(255) NOT NULL UNIQUE,
5	new_email varchar(255) NOT NULL UNIQUE,
6	created_at timestamptz NOT NULL DEFAULT now(),
7	expires_at timestamptz NOT NULL,
8	used_at timestamptz DEFAULT NULL
9	);