dmcquillan314/YouthMinistryHibernate — pull request #1 by ckilbride (2013-05-30 05:48:24+00:00)
Title: Experimental Schma Changes

These are a few schema changes I was playing around with. They are currently in a new branch called `schemachanges`.

I've created a second new branch called `review` that is currently identical to `master`. If this pull request is merged, that's where it will go.

**These changes require total annihilation of the existing tables.**

Here's what I was thinking:

- I was getting a signup problem. The first signup would succeed. Subsequent signups would fail because of a unique index violation. These fix that.

- There was a mix of caps/camel case and singular/plural names. It was causing me problems. Some tables were duplicated. I had trouble with `JOIN_TABLES.sql`. These fix that.

- I'm really hoping there's a way to eliminate `JOIN_TABLES.sql`. These changes are meant to generate a schema without the need for `JOIN_TABLES.sql`. Do they succeed at this? I dunno.

I'd like to try the use case that generates deadlocks against these and see what happens.

Perhaps we can discuss at your convenience ...