-- DropForeignKey
ALTER TABLE `society` DROP FOREIGN KEY `society_admin_member_id_fkey`;

-- DropIndex
DROP INDEX `society_admin_member_id_key` ON `society`;

-- CreateIndex
CREATE INDEX `idx_admin_member_id` ON `society`(`admin_member_id`);

-- AddForeignKey
ALTER TABLE `society` ADD CONSTRAINT `society_admin_member_id_fkey` FOREIGN KEY (`admin_member_id`) REFERENCES `users`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;