-- AlterTable
ALTER TABLE `transactions` ALTER COLUMN `transaction_date` DROP DEFAULT;

-- AlterTable
ALTER TABLE `users` ADD COLUMN `selected_society_id` INTEGER UNSIGNED NULL;

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