DB tables are missing constraints - Githubissues

karlmdavis / rps-tourney

An online multi-player Rock-Paper-Scissors game. Just because.

https://rpstourney.com/

1 stars 2 forks source link

DB tables are missing constraints #106

Closed karlmdavis closed 8 years ago

karlmdavis commented 8 years ago

This is rather horrifying, and I'm glad I caught it now. Apparently, either my Liquibase syntax is wrong or Liquibase itself has a huge bug.

I've identified the following missing FKs:

AccountRoles.accountId
AuthTokens.accountId
GuestLoginIdentities.id
Games.player1Id
Games.player2Id
Players.humanAccountId
GameRounds.gameid
LoginIdentities.accountId
AuditAccountMerges.targetAccountId
AuditAccountLoginMerges.auditAccountMergeId
AuditAccountLoginMerges.loginidentityid
AuditAccountGameMerges.parentAuditAccountMergeId
AuditAccountGameMerges.gameid

Basically, every single FK except for GameLoginIdentities.id is missing. Gah!!!!