Error running npx drizzle-kit push:mysql

When running the push command I get the error below. For example when I add a new table such as posts and run push
No description
No description
5 Replies
Angelelz
Angelelz17mo ago
Is boolean a custom type? Where are you importing that one from?
codefork
codeforkOP17mo ago
mysql not sqlite If I drop my users table I can db-push with no error but this is rather annoying
Andrii Sherman
Andrii Sherman17mo ago
If it's PlanetScale, the issue is with .defaultNow() I would suggest to use
.default(sql`CURRENT_TIMESTAMP`)
.default(sql`CURRENT_TIMESTAMP`)
This one will work well with PlanetScale. We also will deprecate .defaultNow() https://github.com/drizzle-team/drizzle-orm/issues/921
GitHub
[FEATURE]: replace .defaultNow() with .defaultCurrentTimestamp() · ...
Describe what you want To work properly with all MySQL dbs should use CURRENT_TIMESTAMP for dates
Want results from more Discord servers?
Add your server