The recommended way to do a many-to-one relationship in the docs is

export const cities = mysqlTable('cities', {
  id: serial('id').primaryKey(),
  name: text('name'),
})

export const users = mysqlTable('users', {
  id: serial('id').primaryKey(),
  name: text('name'),
  cityId: int('city_id').references(() => cities.id),
})

but this produces

CREATE TABLE `cities` (
	`id` serial AUTO_INCREMENT PRIMARY KEY NOT NULL,
	`name` text
);

CREATE TABLE `users` (
	`id` serial AUTO_INCREMENT PRIMARY KEY NOT NULL,
	`name` text,
	`city_id` int
);

ALTER TABLE `users` ADD CONSTRAINT `users_city_id_cities_id_fk` FOREIGN KEY (`city_id`) REFERENCES `cities`(`id`);

which gives this error.

Referencing column 'city_id' and referenced column 'id' in foreign key constraint 'users_city_id_cities_id_fk' are incompatible.

because serial in MySQL is a BigInt Unsigned, not an int.

When I manually change the city_id to BigInt Unsigned in the raw SQL, the problem disappears. Unfortunately, I can't find a way to change bigint to unsigned using drizzle. Is there something I'm missing or has this not been implemented?