• Home
• org.hspconsortium.reference
• hspc-reference-messaging
• 1.4.0
• source code
• messaging-client.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.openidconnect.mysql.messaging-client.sql Maven / Gradle / Ivy

SET AUTOCOMMIT = 0;

START TRANSACTION;

# reference messaging client
INSERT INTO client_details (client_id, client_name, jwks_uri, token_endpoint_auth_method, access_token_validity_seconds) VALUES
	('messaging_client', 'Reference Messaging', 'https://auth.hspconsortium.org/jwk', 'PRIVATE_KEY', 86400);

INSERT INTO client_scope (owner_id, scope) VALUES
	((SELECT id from client_details where client_id = 'messaging_client'), 'system/*.read'),
	((SELECT id from client_details where client_id = 'messaging_client'), 'system/*.write'),
	((SELECT id from client_details where client_id = 'messaging_client'), 'offline_access');

INSERT INTO client_grant_type (owner_id, grant_type) VALUES
	((SELECT id from client_details where client_id = 'messaging_client'), 'client_credentials'),
	((SELECT id from client_details where client_id = 'messaging_client'), 'refresh_token');

COMMIT;

SET AUTOCOMMIT = 1;