-- AlterTable
ALTER TABLE `photos` ADD COLUMN `youtubeUrl` VARCHAR(191) NULL;

-- AlterTable
ALTER TABLE `profiles` ADD COLUMN `avatarPhotoId` VARCHAR(191) NULL;

-- CreateIndex
CREATE UNIQUE INDEX `profiles_avatarPhotoId_key` ON `profiles`(`avatarPhotoId`);

-- AddForeignKey
ALTER TABLE `profiles` ADD CONSTRAINT `profiles_avatarPhotoId_fkey` FOREIGN KEY (`avatarPhotoId`) REFERENCES `photos`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;