-- AlterTable
ALTER TABLE "house" ADD COLUMN     "admin_id" INTEGER NOT NULL,
ADD COLUMN     "invite_code" TEXT NOT NULL;

-- CreateIndex
CREATE UNIQUE INDEX "house_invite_code_key" ON "house"("invite_code");

-- AddForeignKey
ALTER TABLE "house" ADD CONSTRAINT "house_admin_id_fkey" FOREIGN KEY ("admin_id") REFERENCES "user_profiles"("id") ON DELETE RESTRICT ON UPDATE CASCADE;
