bugs introduced with making state not required

[Ben Shum]

Evergreen master

When we merged bug 1079041, we introduced a few unexpected problems by making state not required for user addresses:

1) The library settings were created with "au" instead of "aua" and thus the UI wasn't picking them up and leaving the field as not required even if the settings were made.

2) The auditor logs still include a NOT NULL requirement from upgraded systems, so there'd be errors trying to insert NULL values to the table.

In response, I worked with tsbere to whip up a branch to address these issues by changing the name of the library settings to fit correctly and also fixing the auditor table. Along the way, we discovered that the table config.org_unit_setting_type_log which tracks library settings was inflexible and needed to be adjusted with "DEFERRED INITIALLY DEFERRABLE" in order to allow us to make the necessary fixes.

Will attach working branch once I have the bug number.

[Ben Shum (bshum)]

Working branch at tip of working/user/bshum/fix-aua-state-settings

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/bshum/fix-aua-state-settings

[Ben Shum (bshum)]

Actually that's supposed to be "DEFERRABLE INITIALLY DEFERRED".

[Jason Stephenson (jstephenson)]

Thanks, Ben!

Fixes the problems in my development environment, and we've used a version of this in production for over a week, now.

Pushed to master.