21 lines
775 B
MySQL
21 lines
775 B
MySQL
|
/*
|
||
|
|
Warnings:
|
||
|
|
|
||
|
|
- You are about to drop the `ingredients` table. If the table is not empty, all the data it contains will be lost.
|
||
|
|
|
||
|
|
*/
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "public"."recipe_ingredients" ADD COLUMN "recipesId" INTEGER;
|
||
|
|
|
||
|
|
-- AlterTable
|
||
|
|
ALTER TABLE "public"."recipe_steps" ADD COLUMN "recipesId" INTEGER;
|
||
|
|
|
||
|
|
-- DropTable
|
||
|
|
DROP TABLE "public"."ingredients";
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE "public"."recipe_ingredients" ADD CONSTRAINT "recipe_ingredients_recipesId_fkey" FOREIGN KEY ("recipesId") REFERENCES "public"."recipes"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE "public"."recipe_steps" ADD CONSTRAINT "recipe_steps_recipesId_fkey" FOREIGN KEY ("recipesId") REFERENCES "public"."recipes"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|