CREATE TABLE IF NOT EXISTS `identities` (
    `id` UUID PRIMARY KEY DEFAULT UUID(),
    `userId` UUID NOT NULL,
    `providerId` UUID NOT NULL,
    `providerUserId` VARCHAR(255) NOT NULL,
    `createdAt` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,

    CONSTRAINT `fk_identities_userId` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE,
    CONSTRAINT `fk_identities_providerId` FOREIGN KEY (`providerId`) REFERENCES `providers` (`id`) ON DELETE CASCADE,
    CONSTRAINT `uq_identities_provider_subject` UNIQUE (`providerId`, `providerUserId`)
)