migrations: Add migration_logs

Created by: efritz

Fixes #29543 (closed). This PR creates the following table on-demand and writes to it on migration operations. Does not currently read from it, but this will later become the replacement for the migrations table today.

CREATE TABLE IF NOT EXISTS migration_logs (
	id SERIAL PRIMARY KEY,
	schema text NOT NULL,
	version integer NOT NULL,
	up bool NOT NULL,
	started_at timestamptz NOT NULL,
	finished_at timestamptz,
	success boolean,
	error_message text
);