polycule-connect/polyculeconnect/migrations/1_create_auth_request.up.sql
Melora Hugues 9206c8e41e
Some checks failed
/ docker-build-only (push) Failing after 45s
/ go-test (push) Failing after 1m28s
Add start of auth request storage
2024-09-22 10:26:27 +02:00

11 lines
No EOL
338 B
SQL

CREATE TABLE "auth_request_2" (
id TEXT NOT NULL PRIMARY KEY,
client_id TEXT NOT NULL,
backend_id TEXT NOT NULL,
scopes blob NOT NULL, -- list of strings, json-encoded
redirect_uri TEXT NOT NULL,
state TEXT NOT NULL,
nonce TEXT NOT NULL,
response_type TEXT NOT NULL,
CREATION_TIME timestamp NOT NULL
);