Add database versioning

[todo[bot]]

https://github.com/fmnas/fmnas-site/blob/6f40a509151303c3d50a546760e6c9ce281a5410/admin/db.php#L7-L10

---

This issue was generated by todo based on a todo comment in 6f40a509151303c3d50a546760e6c9ce281a5410. It's been assigned to @TortoiseWrath because they committed the code.

[TortoiseWrath]

Some options:

• Use immutable rows and insert new rows on write rather than updating
• Use something like liquibase (not sure if dreamhost can support this)
• Dump the database on every write from db.php, and track the dumps in a Git repo.
  • This sounds like a bad idea, but it would work for our use case because we'd be talking about queries per month rather than queries per second.
  • Also solves #88 if we push the git repo to a remote.
  • Currently, this database contains no customer PII or anything.
  • We may have to exclude tables from the dump if we do something like storing a list of submitted applications.

[TortoiseWrath]

If we hosted or replicated the database somewhere other than dreamhost and used temporal tables that would work. Unfortunately no support in MySQL so can't happen on dreamhost (yet). But MariaDB has them now.

https://www.dolthub.com/blog/2021-09-17-database-version-control/

SQL Server allows a publisher with non-temporal and a subscriber with temporal data: https://stackoverflow.com/questions/45819401/can-you-replicate-a-normal-table-to-a-system-versioned-temporal-table. No idea if MariaDB does.

[TortoiseWrath]

Blocked on schema changes for #169, #162, #22, and eventually #175 for #80