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

-- AlterTable
ALTER TABLE `user_otps` ADD COLUMN `email` VARCHAR(255) NULL,
    MODIFY `mobile_number` VARCHAR(15) NULL;

-- CreateIndex
CREATE INDEX `idx_email_otp` ON `user_otps`(`email`, `otp`);