Drizzle-kit push not creating new column

I have a basic schema for a user, which I set up the database for using

drizzle-kit push

drizzle-kit push

drizzle-kit push

drizzle-kit push. I added a new

avatar

avatar

avatar

avatar field to the users, and tried to use

push

push

to update the schema, but instead got this:

LibsqlError: SQLITE_ERROR: no such column: avatar

LibsqlError: SQLITE_ERROR: no such column: avatar

LibsqlError: SQLITE_ERROR: no such column: avatar

LibsqlError: SQLITE_ERROR: no such column: avatar
Looking at the generated SQL it's trying to copy over the new column, and doesn't try to create it.

INSERT INTO `__new_users`("id", "name", "email", "avatar", "created_at") SELECT "id", "name", "email", "avatar", "created_at" FROM `users`;

INSERT INTO `__new_users`("id", "name", "email", "avatar", "created_at") SELECT "id", "name", "email", "avatar", "created_at" FROM `users`;

INSERT INTO `__new_users`("id", "name", "email", "avatar", "created_at") SELECT "id", "name", "email", "avatar", "created_at" FROM `users`;

INSERT INTO `__new_users`("id", "name", "email", "avatar", "created_at") SELECT "id", "name", "email", "avatar", "created_at" FROM `users`;

I'm not sure what I'm doing wrong, this seems very simple yet doesn't work.

No replies yetBe the first to reply to this messageJoin

Drizzle-kit push not creating new column

Similar Threads

Similar Threads

Similar Threads