CREATE TABLE IF NOT EXISTS oauth_accounts (
  id                  uuid        PRIMARY KEY DEFAULT gen_random_uuid(),
  user_id             uuid        NOT NULL REFERENCES users (id) ON DELETE CASCADE,
  provider            text        NOT NULL,
  provider_user_id    text        NOT NULL,
  provider_username   text,
  created_at          timestamptz DEFAULT now(),
  UNIQUE (provider, provider_user_id)
);
