• Home
• org.hspconsortium.reference
• hspc-reference-api-mysql
• 0.10
• source code
• resource-server-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.resource-server-client.sql Maven / Gradle / Ivy

SET AUTOCOMMIT = 0;

START TRANSACTION;

-- HSPC Resource Server
INSERT INTO client_details (client_id, client_secret, client_name, dynamically_registered, refresh_token_validity_seconds, access_token_validity_seconds, id_token_validity_seconds, allow_introspection) VALUES
	('hspc_resource_server', 'secret', 'HSPC Resource Server', false, null, 3600, 600, true);

INSERT INTO client_scope (owner_id, scope) VALUES
	((SELECT id from client_details where client_id = 'hspc_resource_server'), 'openid'),
	((SELECT id from client_details where client_id = 'hspc_resource_server'), 'launch'),
	((SELECT id from client_details where client_id = 'hspc_resource_server'), 'patient/*.read'),
	((SELECT id from client_details where client_id = 'hspc_resource_server'), 'user/*.*'),
	((SELECT id from client_details where client_id = 'hspc_resource_server'), 'smart/orchestrate_launch');

INSERT INTO client_grant_type (owner_id, grant_type) VALUES
	((SELECT id from client_details where client_id = 'hspc_resource_server'), 'authorization_code');

COMMIT;

SET AUTOCOMMIT = 1;