Drizzle TeamDT
Drizzle Team•2y ago
fantasy

uuid becomes text in migration

In my schema i have a user table (based on auth.js requirements):
export const users = pgTable("user", {
    id: uuid("id").primaryKey().defaultRandom(),
    name: text("name"),
    email: text("email").notNull(),
    emailVerified: timestamp("emailVerified", { mode: "date" }),
    image: text("image"),
});


However in the resulting migration, the column is marked as text and is missing the DEFAULT gen_random_uuid():
CREATE TABLE IF NOT EXISTS "user" (
    "id" text PRIMARY KEY NOT NULL,
...

This does not happen for other tables, for example:
export const roles = pgTable("role", {
    id: uuid("id").primaryKey().defaultRandom(),
...

CREATE TABLE IF NOT EXISTS "role" (
    "id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
...


I'm using the latest drizzle-kit 0.21.1 version.
Was this page helpful?