Synchronise SQL comments in structure and upgrade files.
Add comment on adding unique keys later, remove another,
initialise contest shortname with longer string to improve
chance of uniqueness, and set deactivatetime to something
clearly non-user set.