Kysely•2y ago

is this uuid() correct in mysql?

export async function up(db: Kysely<any>): Promise<void> { await db.schema .createTable("Payment") .addColumn("id", "char", (col) => col.defaultTo(raw("UUID()")).primaryKey())

1 Reply

Igal•2y ago

Hey 👋 Try this out:

await db.schema
  .createTable("Payment")
  .addColumn("id", "varchar(36)", (cb) =>
    cb.primaryKey().defaultTo(sql`(uuid())`),
  )
  .execute()

await db.schema
  .createTable("Payment")
  .addColumn("id", "varchar(36)", (cb) =>
    cb.primaryKey().defaultTo(sql`(uuid())`),
  )
  .execute()

https://kyse.link/?p=s&i=G2STlnUKzAqM9heKsHES

Gaming

Programming

is this uuid() correct in mysql?