Change the type of schema versions from VARCHAR to BIGINT. - Githubissues

fukamachi / mito

An ORM for Common Lisp with migrations, relationships and PostgreSQL support

284 stars 31 forks source link

Change the type of schema versions from VARCHAR to BIGINT. #140

Closed fukamachi closed 3 months ago

fukamachi commented 3 months ago

Make some changes to schema_migrations table.

Change the data type of version from VARCHAR to BIGINT
Add NOT NULL constraint to applied_at
Add a new column dirty (it's currently not used yet)

If schema_migrations table already exists, it'll be migrated automatically in Mito.

Note

If version contains non-numeric values, the automatic migration fails.
If applied_at contains null values, the automatic migration fails.