/*
  Warnings:

  - You are about to drop the column `shopItemId` on the `transactiondetail` table. All the data in the column will be lost.

*/
-- DropForeignKey
ALTER TABLE `transactiondetail` DROP FOREIGN KEY `TransactionDetail_shopItemId_fkey`;

-- AlterTable
ALTER TABLE `transactiondetail` DROP COLUMN `shopItemId`,
    MODIFY `itemId` INTEGER NULL;

-- AddForeignKey
ALTER TABLE `TransactionDetail` ADD CONSTRAINT `TransactionDetail_itemId_fkey` FOREIGN KEY (`itemId`) REFERENCES `ShopItem`(`itemId`) ON DELETE SET NULL ON UPDATE CASCADE;