[keycloak-dev] more db schema changes

[Marek Posolda]

Hi,

just wanted to point that all recent DB changes seem to break databases 
(or at least MySQL). Actually when running testsuite with MySQL, then at 
the end of some tests during Hibernate schema cleanup, it hangs. Just 
figured out that it's this SQL command which causes hang of MySQL: alter 
table AUTHENTICATION_LINK drop foreign key FK582E5612EF007A6;

Actually not sure if it's related to compound primary key of 
AuthenticationLinkEntity or foreign key with UserEntity... Will look at 
it more on Monday, just wanted to point that databases doesn't work ATM.

Marek

On 17.7.2014 22:36, Bill Burke wrote:
> * created @NamedQuery for every creatQuery we have
> * Use @Column, @JoinColumn, and @JoinTable, and @Table everywhere.
> names are uppercase with "_".  At least 10+ years ago, this was the
> standard naming convention.
> * CredentialEntity now has a generated String ID.  We will want to have
> multiple TOTP entries in the future.
>
> Bill
>