mirror of
https://github.com/pocket-id/pocket-id.git
synced 2026-07-19 19:21:28 +02:00
19 lines
574 B
PL/PgSQL
19 lines
574 B
PL/PgSQL
PRAGMA foreign_keys= OFF;
|
|
BEGIN;
|
|
|
|
CREATE TABLE oidc_pushed_authorization_requests (
|
|
id TEXT NOT NULL PRIMARY KEY,
|
|
created_at INTEGER NOT NULL,
|
|
request_uri TEXT NOT NULL UNIQUE,
|
|
client_id TEXT NOT NULL REFERENCES oidc_clients(id) ON DELETE CASCADE,
|
|
parameters TEXT NOT NULL DEFAULT '{}',
|
|
expires_at INTEGER NOT NULL
|
|
);
|
|
|
|
CREATE INDEX idx_oidc_par_expires_at ON oidc_pushed_authorization_requests (expires_at);
|
|
|
|
ALTER TABLE oidc_clients ADD COLUMN requires_pushed_authorization_requests BOOLEAN NOT NULL DEFAULT FALSE;
|
|
|
|
COMMIT;
|
|
PRAGMA foreign_keys= ON;
|