[#64961974] Cherrypicking Joe's changes to User.pm and Profile.pm. Updating the tests.
[Fixes #68050486] Changing the 'user_id' fkey to 'user', for the case of consistency.
Adding a unique constraint to comp years.
Various schema updates
[Delivers #68493330] Adding a message for folks trying to use the old login or account-management path.
[Delivers #68414302] Pseudonym display now actually works.
[Delivers #68057118] Reformatting subtitles.
[Delivers #68051024] Using advice from http://stackoverflow.com/questions/9047703/fixed-position-navbar-obscures-anchors to un-obscure anchor-link header text.
[Delivers #68565724] those darn apostrophes
[Delivers #68544514] Correcting the redirect on bad argument to the comp-results page.
[Delivers #68556386] Removing the line I understood the least from a CSS block I pasted in from Stack Overflow to fix another problem seems to have fixed this.
[#68508196] Applying page cacheing magic.
Merge branch 'dev'