Drizzle Team•15mo ago

Enum type gets lost

Setup: I have a server-side db schema definition which I push with bunx drizzle-kit push:sqlite and pull on the website with bunx drizzle-kit introspect:sqlite in my schema definition I have the following table

export const vaults = sqliteTable("vaults", {
  name: text("name").primaryKey().notNull(),
  icon: text("icon").notNull(),
  label: text("label").notNull(),
  risk: text("risk", { enum: ["high", "medium", "low"] }).notNull(),
});

export const vaults = sqliteTable("vaults", {
  name: text("name").primaryKey().notNull(),
  icon: text("icon").notNull(),
  label: text("label").notNull(),
  risk: text("risk", { enum: ["high", "medium", "low"] }).notNull(),
});

but on the website, the pulled schema looks like this:

export const vaults = sqliteTable("vaults", {
    name: text("name").primaryKey().notNull(),
    icon: text("icon").notNull(),
    label: text("label").notNull(),
    risk: text("risk").notNull(),
});

export const vaults = sqliteTable("vaults", {
    name: text("name").primaryKey().notNull(),
    icon: text("icon").notNull(),
    label: text("label").notNull(),
    risk: text("risk").notNull(),
});

where the enum type got lost. Should I use another command to push and pull, or how can I fix this issue?

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Enum type gets lost