ory-am/hydra

INSERT INTO hydra_oauth2_access (signature, request_id, requested_at, client_id, scope, granted_scope, form_data, session_data, subject, active, requested_audience, granted_audience, challenge_id)
SELECT 'sig-0008', 'req-0008', now(), hc.id, 'scope-0008', 'granted_scope-0008', 'form_data-0008', 'session-0008', 'subject-0008', false, 'requested_audience-0008', 'granted_audience-0008', crh.challenge
FROM hydra_client hc, hydra_oauth2_consent_request_handled crh
ORDER BY hc.pk, crh.challenge DESC
LIMIT 1;

INSERT INTO hydra_oauth2_refresh (signature, request_id, requested_at, client_id, scope, granted_scope, form_data, session_data, subject, active, requested_audience, granted_audience, challenge_id)
SELECT 'sig-0008', 'req-0008', now(), hc.id, 'scope-0008', 'granted_scope-0008', 'form_data-0008', 'session-0008', 'subject-0008', false, 'requested_audience-0008', 'granted_audience-0008', crh.challenge
FROM hydra_client hc, hydra_oauth2_consent_request_handled crh
ORDER BY hc.pk, crh.challenge DESC
LIMIT 1;

INSERT INTO hydra_oauth2_code (signature, request_id, requested_at, client_id, scope, granted_scope, form_data, session_data, subject, active, requested_audience, granted_audience, challenge_id)
SELECT 'sig-0008', 'req-0008', now(), hc.id, 'scope-0008', 'granted_scope-0008', 'form_data-0008', 'session-0008', 'subject-0008', false, 'requested_audience-0008', 'granted_audience-0008', crh.challenge
FROM hydra_client hc, hydra_oauth2_consent_request_handled crh
ORDER BY hc.pk, crh.challenge DESC
LIMIT 1;

INSERT INTO hydra_oauth2_oidc (signature, request_id, requested_at, client_id, scope, granted_scope, form_data, session_data, subject, active, requested_audience, granted_audience, challenge_id)
SELECT 'sig-0008', 'req-0008', now(), hc.id, 'scope-0008', 'granted_scope-0008', 'form_data-0008', 'session-0008', 'subject-0008', false, 'requested_audience-0008', 'granted_audience-0008', crh.challenge
FROM hydra_client hc, hydra_oauth2_consent_request_handled crh
ORDER BY hc.pk, crh.challenge DESC
LIMIT 1;

INSERT INTO hydra_oauth2_pkce (signature, request_id, requested_at, client_id, scope, granted_scope, form_data, session_data, subject, active, requested_audience, granted_audience, challenge_id)
SELECT 'sig-0008', 'req-0008', now(), hc.id, 'scope-0008', 'granted_scope-0008', 'form_data-0008', 'session-0008', 'subject-0008', false, 'requested_audience-0008', 'granted_audience-0008', crh.challenge
FROM hydra_client hc, hydra_oauth2_consent_request_handled crh
ORDER BY hc.pk, crh.challenge DESC
LIMIT 1;