Fix database and dependencies

This is next step after https://github.com/Hounddog/modules.zendframework.com/pull/54.

I updated dependencies to avoid different problems (like this one: https://github.com/SocalNick/ScnSocialAuth/issues/91), and to make it more predictable in future (most vendors are now in stable versions).

Then I added missing `state` column into database script and prepared migration file.

Finally, I had to make a few changes to avoid getting `created_at column cannot be NULL` errors.

After all above changes, you can finally clone this repo, `vagrant up` and setup Github keys to get whole application working.