-- DropForeignKey
ALTER TABLE `guildmember` DROP FOREIGN KEY `GuildMember_guildId_fkey`;

-- DropForeignKey
ALTER TABLE `guildmember` DROP FOREIGN KEY `GuildMember_memberId_fkey`;

-- DropIndex
DROP INDEX `User_guildId_fkey` ON `user`;

-- AddForeignKey
ALTER TABLE `GuildMember` ADD CONSTRAINT `GuildMember_guildId_fkey` FOREIGN KEY (`guildId`) REFERENCES `Guild`(`guildId`) ON DELETE CASCADE ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `GuildMember` ADD CONSTRAINT `GuildMember_memberId_fkey` FOREIGN KEY (`memberId`) REFERENCES `User`(`userId`) ON DELETE CASCADE ON UPDATE CASCADE;
