ALTER TABLE `transactions_history_entries`
ADD COLUMN `otp_code` varchar(10) NULL,
ADD COLUMN `otp_expires_at` datetime NULL,
ADD COLUMN `otp_verified` tinyint(1) NOT NULL DEFAULT 0,
ADD COLUMN `otp_verified_at` datetime NULL;

-- If any of the columns already exist, run only the missing column lines manually.