Database DDL script for JdbcConnectionRepository?

[mers]

Hi,

Is there a DDL script running around to create a database schema for the JdbcConnectionRepository? From what I can see, it's just a single Connection table with VARCHAR fields "accountId", "providerId", "accessToken", "secret", "refreshToken", "providerAccountId", but I don't know if there's a script somewhere that I'm not seeing.

Cheers,
Emerson

[habuma]

No, there's no script doing that for you. There is a DDL at org/springframework/social/connect/jdbc/ConnectionRepositorySchema.sql in the core module's JAR, though.

The Spring Social Showcase sample runs that script automatically as part of the embedded-database setup (see data.xml). But Spring Social itself does no automatic creation of tables.

[mers]

Ah, there it is. Thanks.