file-uploader/prisma/migrations/20240829084742_thumbnails/migration.sql
2024-08-29 06:24:27 -04:00

12 lines
464 B
SQL

-- CreateTable
CREATE TABLE `Thumbnail` (
`id` VARCHAR(191) NOT NULL,
`uploadId` VARCHAR(191) NOT NULL,
`placeholder` VARCHAR(191) NOT NULL,
UNIQUE INDEX `Thumbnail_uploadId_key`(`uploadId`),
PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-- AddForeignKey
ALTER TABLE `Thumbnail` ADD CONSTRAINT `Thumbnail_uploadId_fkey` FOREIGN KEY (`uploadId`) REFERENCES `Upload`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;