Add check constraint to schema_version.version

mbucc / shmig

Database migration tool written in BASH.

BSD 3-Clause "New" or "Revised" License

458 stars 49 forks source link

Closed mbucc closed 7 years ago

mbucc commented 10 years ago

shmig creates version numbers as the seconds since epoch.

It runs migrations that have a version number greater than what is in the schema_version.version field.

If someone inserts a big integer, schema migrations will stop. We probably shouldn't let this happen.

mbucc commented 7 years ago

Leave as is. Seems like a far-fetched use case that doesn't justify adding code.