TinyLog engine is unknown in clickhouse new versions (version 23.3.2.1)

[ahnazary]

Describe the Bug The schema_migrations table that stores the migration and version's data cant be build in new versions of clickhouse because TinyLog engine is not found. below is the shown error message:

SQL Error [56] [07000]: Code: 56. DB::Exception: Unknown table engine TinyLog. (UNKNOWN_STORAGE) (version 23.3.2.1)

Steps to Reproduce

1. Execute migrate create -ext sql -dir <path_to_sql_files> -seq init
2. Execute migrate -database <DB_URL> -path <migration_dir_path> up 1
3. For clickhouse version 23.3.2.1 the TinyLog engine is unknown.

Expected Behavior Creation of a table with the following DDL in the target DB:

CREATE TABLE schema_migrations
(

    `version` Int64,

    `dirty` UInt8,

    `sequence` UInt64
)
ENGINE = TinyLog
ORDER BY (version,
 dirty,
 sequence)
SETTINGS index_granularity = 8192;

Migrate Version v4.16.2

Loaded Source Drivers github-ee, gcs, s3, bitbucket, go-bindata, godoc-vfs, file, github, gitlab

Loaded Database Drivers spanner, sqlserver, yugabyte, stub, firebird, cockroach, cockroachdb, mongodb, mysql, neo4j, pgx4, pgx5, clickhouse, postgresql, postgres, firebirdsql, mongodb+srv, cassandra, pgx, redshift, yugabytedb, ysql, crdb-postgres

Go Version Go not installed, I am using the CLI tool (migrate -database ...)

Stacktrace Full error:

Error occurred during SQL query execution

Reason:
SQL Error [56] [07000]: Code: 56. DB::Exception: Unknown table engine TinyLog. (UNKNOWN_STORAGE) (version 23.3.2.1)

Additional context Nothing to add