Skip to content

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

@chlorophant

Description

@chlorophant

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions