Spring Security Oauth2 SQL Schema for Postgres?

Question

I intend to use: JdbcTokenStore.

As far as I can tell it uses two tables: oauth_access_token and oauth_refresh_token

I can reverse engineer the table structure; it isn't quite clear if there are references from one table to the other for which I should create a foreign key or not?

Is there a postgres specific schema somewhere? Or another schema that I can refer to?

Batch, for instance, includes the schemas in their dist. I wonder if Oauth2 could do that also?

Many thanks, Matt

hello, i am new in oauth and spring-security. I also want to implement with JDBC, but i am confuse, how many tables are created for Oauth? — Harmeet Singh Taara
– Harmeet Singh Taara, Commented Jul 22, 2014 at 12:36
Are these the correct tables? github.com/spring-projects/spring-security-oauth/blob/master/… - Can someone from the oauth project please comment? — Matt Friedman
– Matt Friedman, Commented Sep 18, 2014 at 16:20
@MattFriedman: Yes, this is valid schema to references. You should write your own answer to help other people easy to find. Thanks :) — Thanh Nguyen Van
– Thanh Nguyen Van, Commented Jan 20, 2015 at 3:08

hotzen · Accepted Answer · 2017-10-24 09:22:27Z

3

the schema is checked into git as well: https://github.com/spring-projects/spring-security-oauth/blob/master/spring-security-oauth2/src/test/resources/schema.sql

when using postgres you should use bytea instead of LONGVARBINARY

answered Oct 24, 2017 at 9:22

hotzen

2,8831 gold badge29 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring Security Oauth2 SQL Schema for Postgres?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related