# 表结构地址 spring-security-oauth2-authorization-server
#          org.springframework.security.oauth2.server.authorization.oauth2-authorization-schema.sql
create table oauth2_authorization_consent
(
    registered_client_id varchar(100)  not null,
    principal_name       varchar(200)  not null,
    authorities          varchar(1000) not null,
    primary key (registered_client_id, principal_name)
);

INSERT INTO learn_security.oauth2_authorization_consent (registered_client_id, principal_name, authorities)
VALUES ('1', 'admin', 'SCOPE_message.read,SCOPE_message.write');