Clean up schema for table application_settings
<!--IssueSummary start-->
<details>
<summary>
Everyone can contribute. [Help move this issue forward](https://handbook.gitlab.com/handbook/marketing/developer-relations/contributor-success/community-contributors-workflows/#contributor-links) while earning points, leveling up and collecting rewards.
</summary>
- [Close this issue](https://contributors.gitlab.com/manage-issue?action=close&projectId=278964&issueIid=17951)
</details>
<!--IssueSummary end-->
From https://gitlab.com/gitlab-com/infrastructure/issues/1709 (private to GitLab
employees):
* Wrong data type: created_at should be timestamptz
* Wrong data type: updated_at should be timestamptz
* Missing constraint: created_at NOT NULL
* Missing constraint: updated_at NOT NULL
~~We also need to add a constraint (in the DB) to enforce only a single row being allowed in this table.~~ Done as of https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/14718
issue