Drizzle Team•2y ago

db push when adding notNull column with default() value

I've added this column to my table: fullfilled: boolean("fullfilled").default(false).notNull(), But when running drizzle-kit push:mysql I get this:

 
You're about to add not-null fullfilled column without default value, which contains 9 items
THIS ACTION WILL CAUSE DATA LOSS AND CANNOT BE REVERTED

 
You're about to add not-null fullfilled column without default value, which contains 9 items
THIS ACTION WILL CAUSE DATA LOSS AND CANNOT BE REVERTED

Is there a way to push this column without dropping table, it it has default? Is is a bug, or am I doing something wrong?

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

db push when adding notNull column with default() value