migration.sql 486 B

123456789101112
  1. -- DropForeignKey
  2. ALTER TABLE "vendor_experiences" DROP CONSTRAINT "vendor_experiences_userKeycloakId_fkey";
  3. -- DropForeignKey
  4. ALTER TABLE "vendor_experiences" DROP CONSTRAINT "vendor_experiences_user_id_fkey";
  5. -- AlterTable
  6. ALTER TABLE "vendor_experiences" ADD COLUMN "userId" TEXT;
  7. -- AddForeignKey
  8. ALTER TABLE "vendor_experiences" ADD CONSTRAINT "vendor_experiences_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "keycloak_users"("id") ON DELETE RESTRICT ON UPDATE CASCADE;