realtalk403/realtalkserver — pull request #30 by joryrice (2013-05-15 07:02:54+00:00)
Title: Changed room ID from string to auto incrementing int, fixed delete account bug (most likely).

- Wiped the DB (so it could be altered)
- Changed room id from String to int, because it makes no sense for the android to send the server a room id string. It needs to be a unique integer.
- Changed the server side code to reflect that change.
- DB connections now close when exceptions are thrown. This should help with the connection limit problems.
- Fixed delete account bug (haven't tested but I'm pretty sure it will work): the remove user query wasn't removing users from the active users table before removing from the users table. If it tried to remove a user who was in at least 1 chat room, the removal would fail because it would violate a foreign key constraint from active_users to users. Which I believe would explain why Brandon could delete a user he just created but not one that had been created and had joined rooms.