Fresh Next better-auth drizzle mysql error

dialect.ts:75:3) {
    code: 'ER_BLOB_KEY_WITHOUT_LENGTH',
    errno: 1170,
    sql: '\n' +
      'ALTER TABLE `account` ADD CONSTRAINT `account_user_id_user_id_fk` FOREIGN KEY (`user_id`) REFERENCES `user`(`id`) ON DELETE cascade ON UPDATE no action;',
    sqlState: '42000',
    sqlMessage: "BLOB/TEXT column 'user_id' used in key specification without a key length"
  }
}