/*
  Warnings:

  - You are about to drop the column `transfer_route_id` on the `order_items` table. All the data in the column will be lost.
  - You are about to drop the `transfer_routes` table. If the table is not empty, all the data it contains will be lost.

*/
-- DropForeignKey
ALTER TABLE `order_items` DROP FOREIGN KEY `order_items_transfer_route_id_fkey`;

-- DropForeignKey
ALTER TABLE `transfer_routes` DROP FOREIGN KEY `transfer_routes_assigned_runner_id_fkey`;

-- DropForeignKey
ALTER TABLE `transfer_routes` DROP FOREIGN KEY `transfer_routes_from_station_id_fkey`;

-- DropForeignKey
ALTER TABLE `transfer_routes` DROP FOREIGN KEY `transfer_routes_shop_id_fkey`;

-- DropForeignKey
ALTER TABLE `transfer_routes` DROP FOREIGN KEY `transfer_routes_to_station_id_fkey`;

-- DropIndex
DROP INDEX `order_items_transfer_route_id_idx` ON `order_items`;

-- AlterTable
ALTER TABLE `order_items` DROP COLUMN `transfer_route_id`;

-- DropTable
DROP TABLE `transfer_routes`;
