persistence/sql/migratest/testdata/20220513000001_testdata.sql
INSERT INTO hydra_client (
id,
nid,
client_name,
client_secret,
redirect_uris,
grant_types,
response_types,
scope,
owner,
policy_uri,
tos_uri,
client_uri,
logo_uri,
contacts,
client_secret_expires_at,
sector_identifier_uri,
jwks,
jwks_uri,
request_uris,
token_endpoint_auth_method,
request_object_signing_alg,
userinfo_signed_response_alg,
subject_type,
allowed_cors_origins,
pk_deprecated,
audience,
created_at,
updated_at,
frontchannel_logout_uri,
frontchannel_logout_session_required,
post_logout_redirect_uris,
backchannel_logout_uri,
backchannel_logout_session_required,
metadata,
token_endpoint_auth_signing_alg,
pk,
registration_access_token_signature)
VALUES (
'client-21',
(SELECT id FROM networks LIMIT 1),
'Client 21',
'secret-21',
'["http://redirect/21_1","http://redirect/21_2"]',
'["grant-21_1","grant-21_2"]',
'["response-21_1","response-21_2"]',
'scope-21',
'owner-21',
'http://policy/21',
'http://tos/21',
'http://client/21',
'http://logo/21',
'["contact-21_1","contact-21_2"]',
0,
'http://sector_id/21',
'',
'http://jwks/21',
'["http://request/21_1","http://request/21_2"]',
'token_auth-21',
'r_alg-21',
'u_alg-21',
'subject-21',
'["http://cors/21_1","http://cors/21_2"]',
0,
'["autdience-21_1","autdience-21_2"]',
'2022-02-15 22:20:23.004598',
'2022-02-15 22:20:23.004598',
'http://front_logout/21',
true,
'["http://post_redirect/21_1","http://post_redirect/21_2"]',
'http://back_logout/21',
true,
'{"migration": "21"}',
'',
'47434cc1-ae2d-4791-83d2-afb46cb84ee3',
''
);
INSERT INTO hydra_oauth2_authentication_session (
id,
nid,
authenticated_at,
subject,
remember
) VALUES (
'auth_session-0015',
(SELECT id FROM networks LIMIT 1),
CURRENT_TIMESTAMP,
'subject-0015',
false
);
INSERT INTO hydra_oauth2_flow (
login_challenge,
nid,
requested_scope,
login_verifier,
login_csrf,
subject,
request_url,
login_skip,
client_id,
requested_at,
oidc_context,
login_session_id,
requested_at_audience,
login_initialized_at,
state,
login_remember,
login_remember_for,
login_error,
acr,
login_authenticated_at,
login_was_used,
forced_subject_identifier,
context,
amr,
consent_challenge_id,
consent_verifier,
consent_skip,
consent_csrf,
granted_scope,
consent_remember,
consent_remember_for,
consent_error,
session_access_token,
session_id_token,
consent_was_used,
granted_at_audience,
consent_handled_at
) VALUES (
'challenge-0015',
(SELECT id FROM networks LIMIT 1),
'["requested_scope-0015_1","requested_scope-0015_2"]',
'verifier-0015',
'csrf-0015',
'subject-0015',
'http://request/0015',
true,
'client-21',
CURRENT_TIMESTAMP,
'{"display": "display-0015"}',
'auth_session-0015',
'["requested_audience-0015_1","requested_audience-0015_2"]',
CURRENT_TIMESTAMP,
128,
true,
15,
'{}',
'acr-0015',
CURRENT_TIMESTAMP,
true,
'force_subject_id-0015',
'{"context": "0015"}',
'["amr-0015-1","amr-0015-2"]',
'challenge-0015',
'verifier-0015',
true,
'csrf-0015',
'["granted_scope-0015_1","granted_scope-0015_2"]',
true,
15,
'{}',
'{"session_access_token-0015": "0015"}',
'{"session_id_token-0015": "0015"}',
true,
'["granted_audience-0015_1","granted_audience-0015_2"]',
CURRENT_TIMESTAMP
);