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 ?

Drizzle Team•3y ago

Davidutz_

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

Migrations issues with Mysql2

Similar Threads

Migrations issues with Mysql2

Similar Threads

Similar Threads

Similar Threads