CONSTRAINT `Albums_AlbumRoots` FOREIGN KEY (`albumRoot`) REFERENCES `AlbumRoots` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `Albums_Images` FOREIGN KEY (`icon`) REFERENCES `Images` (`id`) ON DELETE SET NULL ON UPDATE CASCADE CONSTRAINT `CustomIdentifiers_Thumbnails` FOREIGN KEY (`thumbId`) REFERENCES `Thumbnails` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `FilePaths_Thumbnails` FOREIGN KEY (`thumbId`) REFERENCES `Thumbnails` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `ImageComments_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `ImageCopyright_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `ImageHaarMatrix_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `ImageHistory_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `ImageInformation_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `ImageMetadata_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `ImagePositions_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `ImageProperties_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `ImageRelations_ImagesO` FOREIGN KEY (`object`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `ImageRelations_ImagesS` FOREIGN KEY (`subject`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `Images_Albums` FOREIGN KEY (`album`) REFERENCES `Albums` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `ImageTagProperties_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `ImageTagProperties_Tags` FOREIGN KEY (`tagid`) REFERENCES `Tags` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `ImageTags_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `ImageTags_Tags` FOREIGN KEY (`tagid`) REFERENCES `Tags` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `TagProperties_Tags` FOREIGN KEY (`tagid`) REFERENCES `Tags` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `Tags_Images` FOREIGN KEY (`icon`) REFERENCES `Images` (`id`) ON DELETE SET NULL ON UPDATE CASCADE CONSTRAINT `UniqueHashes_Thumbnails` FOREIGN KEY (`thumbId`) REFERENCES `Thumbnails` (`id`) ON DELETE CASCADE ON UPDATE CASCADE CONSTRAINT `VideoMetadata_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
Comments
0 B
|👍
/👎