21 lines
721 B
SQL
21 lines
721 B
SQL
create table "account_session_revocation" (
|
|
"id" uuid primary key,
|
|
"version" integer not null,
|
|
"created_at" timestamptz not null,
|
|
"updated_at" timestamptz not null,
|
|
"session" text not null,
|
|
"state" text not null,
|
|
"pending" jsonb not null,
|
|
"delivered" jsonb not null,
|
|
"attempts" integer not null,
|
|
"next_attempt_at" text not null,
|
|
"claimed_until" text,
|
|
"last_failure" text,
|
|
"requested_at" text not null,
|
|
"completed_at" text
|
|
);
|
|
|
|
alter table "account_session_revocation" add constraint "account_session_revocation_session_key" unique nulls not distinct ("session");
|
|
|
|
create index "account_session_revocation_state_next_attempt_at_idx" on "account_session_revocation" ("state", "next_attempt_at");
|