onasty: migrations/20250503144157_oauth_identities.up.sql (babda7d)

onasty/migrations/20250503144157_oauth_identities.up.sql (view raw)

Smirnov Oleksandr feat: add oauth2 login for google and github (#109)..., 1 year ago

CREATE TYPE provider_enum AS ENUM (
    'google',
    'github'
);

CREATE TABLE oauth_identities (
    id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (),
    user_id uuid REFERENCES users (id) ON DELETE CASCADE,
    provider provider_enum NOT NULL,
    provider_id varchar(50),
    created_at timestamptz NOT NULL DEFAULT now(),
    UNIQUE (provider, provider_id)
);

1	CREATE TYPE provider_enum AS ENUM (
2	'google',
3	'github'
4	);
5
6	CREATE TABLE oauth_identities (
7	id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (),
8	user_id uuid REFERENCES users (id) ON DELETE CASCADE,
9	provider provider_enum NOT NULL,
10	provider_id varchar(50),
11	created_at timestamptz NOT NULL DEFAULT now(),
12	UNIQUE (provider, provider_id)
13	);