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;