Davidutz_
Davidutz_
PostsComments
DTDrizzle Team
Created by Davidutz_ on 12/28/2023 in #help
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 ?
1 replies