/*
  Warnings:

  - Added the required column `categoryId` to the `ShopItem` table without a default value. This is not possible if the table is not empty.

*/
-- AlterTable
ALTER TABLE `shopitem` ADD COLUMN `categoryId` INTEGER NOT NULL;

-- AddForeignKey
ALTER TABLE `ShopItem` ADD CONSTRAINT `ShopItem_categoryId_fkey` FOREIGN KEY (`categoryId`) REFERENCES `ShopCategory`(`categoryID`) ON DELETE RESTRICT ON UPDATE CASCADE;