Schema not added to FK constraints

export const mySchema = mysqlSchema('my')

export const categories = mySchema.table('categories', {
  id: tinyint('id').primaryKey(),
  name: varchar('name', { length: 256 }).notNull(),
})

export const items = mySchema.table('items', {
  id: int('item_id').notNull().primaryKey(),
  name: varchar('name', { length: 256 }).notNull(),
  category: tinyint('category')
    .notNull()
    .references(() => categories.id, {
      onDelete: 'cascade',
    })
})

CREATE DATABASE `my`;

CREATE TABLE `my`.`categories` (
    `id` tinyint PRIMARY KEY NOT NULL,
    `name` varchar(256) NOT NULL);

CREATE TABLE `my`.`items` (
    `item_id` int PRIMARY KEY NOT NULL,
    `name` varchar(256) NOT NULL,
    `category` tinyint NOT NULL);

ALTER TABLE `items` ADD CONSTRAINT `items_category_categories_id_fk` FOREIGN KEY (`category`) REFERENCES `categories`(`id`) ON DELETE cascade ON UPDATE no action;