JdbcUsersConnectionRepository.sql isn't compatible with MySQL

spring-attic / spring-social

Allows you to connect your applications with SaaS providers such as Facebook and Twitter.

http://projects.spring.io/spring-social

Apache License 2.0

619 stars 351 forks source link

JdbcUsersConnectionRepository.sql isn't compatible with MySQL #24

Open danwashusen opened 12 years ago

danwashusen commented 12 years ago

Running JdbcUsersConnectionRepository.sql on MySQL 5.1 gives the following error: [ERROR in query 1] Specified key was too long; max key length is 1000 bytes

The culprit being: primary key (userId, providerId, providerUserId)

Reducing the size of the userId, providerId and/or providerUserId columns resolves the issue...