[BUG]: sqlite __drizzle_migrations id is of "SERIAL" type, which is not a valid type in sqlite

### What version of `drizzle-orm` are you using?

0.28.6

### What version of `drizzle-kit` are you using?

0.19.13

### Describe the Bug

sqlite __drizzle_migrations id shows that it is of "SERIAL" type, which is not a valid type in sqlite

Some tools which introspect dbs such as atlasgo error due to this

### Expected behavior

The migrations table should use a valid sqlite data type

### Environment & setup

_No response_

Start by locating the SQLite migration-table generation path in drizzle-kit and inspect how the __drizzle_migrations id column type is selected. Verify the generated schema with SQLite and an introspection tool such as Atlas; done means the id uses a valid SQLite type and migration setup still works.

Written by the indexing model from the issue text.