onDelete cascade, Error: VT10001: foreign key constraints are not allowed

import { relations } from "drizzle-orm";
import { mysqlTable, index, varchar, double } from "drizzle-orm/mysql-core";
import { request } from "./request";

export const requestItem = mysqlTable(
  "RequestItem",
  {
    id: varchar("id", { length: 191 }).primaryKey().notNull(),
    requestId: varchar("requestId", { length: 191 })
      .notNull()
      .references(() => request.id, { onDelete: "cascade" }),
    title: varchar("title", { length: 191 }).notNull(),
    description: varchar("description", { length: 191 }).notNull(),
    estimatedValue: double("estimatedValue", {
      precision: 10,
      scale: 2,
    }),
  },
  (table) => {
    return {
      requestIdIdx: index("RequestItem_requestId_idx").on(table.requestId),
    };
  }
);

export const requestItemRelations = relations(requestItem, ({ one }) => ({
  request: one(request, {
    fields: [requestItem.requestId],
    references: [request.id],
  }),
}));

import { relations } from "drizzle-orm";
import { mysqlTable, index, varchar, double } from "drizzle-orm/mysql-core";
import { request } from "./request";

export const requestItem = mysqlTable(
  "RequestItem",
  {
    id: varchar("id", { length: 191 }).primaryKey().notNull(),
    requestId: varchar("requestId", { length: 191 })
      .notNull()
      .references(() => request.id, { onDelete: "cascade" }),
    title: varchar("title", { length: 191 }).notNull(),
    description: varchar("description", { length: 191 }).notNull(),
    estimatedValue: double("estimatedValue", {
      precision: 10,
      scale: 2,
    }),
  },
  (table) => {
    return {
      requestIdIdx: index("RequestItem_requestId_idx").on(table.requestId),
    };
  }
);

export const requestItemRelations = relations(requestItem, ({ one }) => ({
  request: one(request, {
    fields: [requestItem.requestId],
    references: [request.id],
  }),
}));