Drizzle Team•9mo ago

Migrations issues with Mysql2

Hi, I've some issues with the migrations system of drizzle-kit (specially when using Mysql2 adapter). When I executed the migration function from drizzle-kit, It return an error:

sqlMessage: "Table 'game_player_ban' already exists"

sqlMessage: "Table 'game_player_ban' already exists"

, and that's true. The migrations are created by the command

pnpm drizzle-kit generate:mysql

pnpm drizzle-kit generate:mysql

but in the .sql file there is any instructions like

CREATE TABLE IF NOT EXISTS

CREATE TABLE IF NOT EXISTS

and same for the foreign keys with the ALTER instruction. I saw that was implemented in the Postgres adapter but not for mysql (or other). Do you think it's normal ? Are any issues on github ? Thanks for reading and could you help me please ?

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Migrations issues with Mysql2