Drizzle Team•4d ago

Column not created even though appears in migration file

Hey team - I'm noticing a column that isn't created in my database, even though the schema + migration file clearly show that it is. Setup: - docker postgres running locally - drizzle-kit: "^0.28.0" - drizzle-orm: "^0.36.1" I've confirmed it's in the migration file.

--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "licenses" (
    OTHER COLS
    "status" text DEFAULT 'not_verified'
);

--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "licenses" (
    OTHER COLS
    "status" text DEFAULT 'not_verified'
);

But then it does not appear in the database. Any tips for diagnosing this?

1 Reply

Mario564•4d ago

Have you deleted and then regenerated a migration that you may have applied earlier? Since Kit currently doesn't support down migrations, that could be a possible issue here

Gaming

Programming

Column not created even though appears in migration file