Issue with push command

Hello. I pushed migrations to database using
drizzle-kit push:mysql
and It worked fine. Running it again gave me error. (check image)

My Table:
export const linksVisitor = mysqlTable(
  "links_visitor",
  {
    linkId: varchar("link_id", { length: 24 }).references(() => links.id, {
      onDelete: "cascade",
    }),
    viewedAt: timestamp("viewed_at").defaultNow(),
    linkCreator: varchar("link_creator", { length: 255 })
      .references(() => user.id, { onDelete: "cascade" })
      .notNull(),
    ip: varchar("ip", { length: 20 }).notNull(),
  },
  (self) => ({
    pk: primaryKey({
      columns: [self.linkId, self.ip],
    }),
  })
);
Screenshot_2024-04-02_at_7.50.46_PM.png
Was this page helpful?