Drizzle migration error with Example table.

dex · 2023-10-21T10:45:35.135Z

Any reason why I am getting this error when I do `pnpm db:push` for the 2nd time? No changes made.

D

dexOP•10/21/23, 10:52 AM

For more context: I created a t3-app, put in the env variables needed, ran

db:push

db:push

db:push

db:push, changed the users schema then tried to run

db:push

db:push

db:push

db:push again. But I get this error because of the example table which I did not change.

D

dexOP•10/21/23, 11:06 AM

export const example = mysqlTable(
  "example",
  {
    id: bigint("id", { mode: "number" }).primaryKey().autoincrement(),
    name: varchar("name", { length: 256 }),
    createdAt: timestamp("created_at")
      .default(sql`CURRENT_TIMESTAMP`)
      .notNull(),
    updatedAt: timestamp("updatedAt").onUpdateNow(),
  },
  (example) => ({
    nameIndex: uniqueIndex("name_idx").on(example.name),
  }),
);

export const example = mysqlTable(
  "example",
  {
    id: bigint("id", { mode: "number" }).primaryKey().autoincrement(),
    name: varchar("name", { length: 256 }),
    createdAt: timestamp("created_at")
      .default(sql`CURRENT_TIMESTAMP`)
      .notNull(),
    updatedAt: timestamp("updatedAt").onUpdateNow(),
  },
  (example) => ({
    nameIndex: uniqueIndex("name_idx").on(example.name),
  }),
);

export const example = mysqlTable(
  "example",
  {
    id: bigint("id", { mode: "number" }).primaryKey().autoincrement(),
    name: varchar("name", { length: 256 }),
    createdAt: timestamp("created_at")
      .default(sql`CURRENT_TIMESTAMP`)
      .notNull(),
    updatedAt: timestamp("updatedAt").onUpdateNow(),
  },
  (example) => ({
    nameIndex: uniqueIndex("name_idx").on(example.name),
  }),
);

export const example = mysqlTable(
  "example",
  {
    id: bigint("id", { mode: "number" }).primaryKey().autoincrement(),
    name: varchar("name", { length: 256 }),
    createdAt: timestamp("created_at")
      .default(sql`CURRENT_TIMESTAMP`)
      .notNull(),
    updatedAt: timestamp("updatedAt").onUpdateNow(),
  },
  (example) => ({
    nameIndex: uniqueIndex("name_idx").on(example.name),
  }),
);

Ddex For more context: I created a t3-app, put in the env variables needed, ran `db:p...

D

dragonflyof99•11/15/23, 1:08 AM

did you ever figure this out?

D

dexOP•11/20/23, 9:14 AM

nope @dragonflyof99 i just did

drizzle-kit generate

drizzle-kit generate

and manually copies the migrations to TablePlus

Drizzle migration error with Example table.

Similar Threads

Similar Threads

Similar Threads