ALTER TABLE "users"
  ADD COLUMN "auth_role" TEXT,
  ADD COLUMN "primary_organization_id" UUID,
  ADD COLUMN "primary_organization_name" TEXT,
  ADD COLUMN "primary_organization_type" TEXT,
  ADD COLUMN "department" TEXT,
  ADD COLUMN "position" TEXT;

CREATE INDEX "users_auth_role_idx" ON "users"("auth_role");
CREATE INDEX "users_primary_organization_id_idx" ON "users"("primary_organization_id");