SpringSecurity+oauth2实现授权认证管理系统
是为线上项目做的demo，具体思路请看CSDN
CSDN：https://blog.csdn.net/a624193873/article/details/106417218
数据库表：
client项目：
登录表：
CREATE TABLE test_user (
user_name varchar(255) NOT NULL,
password varchar(255) DEFAULT NULL,
user_desc varchar(255) DEFAULT NULL,
PRIMARY KEY (user_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
token令牌表：
CREATE TABLE oauth_token (
id varchar(64) CHARACTER SET utf8 NOT NULL,
access_token varchar(64) CHARACTER SET utf8 DEFAULT NULL,
token_type varchar(64) CHARACTER SET utf8 DEFAULT NULL,
refresh_token varchar(64) CHARACTER SET utf8 DEFAULT NULL,
expires_in varchar(64) CHARACTER SET utf8 DEFAULT NULL,
scope varchar(64) CHARACTER SET utf8 DEFAULT NULL,
create_datetime varchar(64) DEFAULT NULL,
del_flag varchar(64) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
oauth-resource项目：
登录表：
CREATE TABLE test_resource_user (
user_name varchar(255) NOT NULL,
password varchar(255) DEFAULT NULL,
user_desc varchar(255) DEFAULT NULL,
PRIMARY KEY (user_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
oauth-autho项目：
client信息表：
CREATE TABLE oauth_client_details (
client_id varchar(48) NOT NULL,
resource_ids varchar(256) DEFAULT NULL,
client_secret varchar(256) DEFAULT NULL,
scope varchar(256) DEFAULT NULL,
authorized_grant_types varchar(256) DEFAULT NULL,
web_server_redirect_uri varchar(256) DEFAULT NULL,
authorities varchar(256) DEFAULT NULL,
access_token_validity int(11) DEFAULT NULL,
refresh_token_validity int(11) DEFAULT NULL,
additional_information varchar(4096) DEFAULT NULL,
autoapprove varchar(256) DEFAULT NULL,
PRIMARY KEY (client_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;