file-uploader/prisma/migrations/20240829084742_thumbnails/migration.sql

13 lines
464 B
MySQL
Raw Permalink Normal View History

2024-08-29 10:24:27 +00:00
-- 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;