DROP TABLE IF EXISTS `iyzico_response`;
CREATE TABLE `iyzico_response` (
                                   `id` int NOT NULL AUTO_INCREMENT,
                                   `status` varchar(20) NOT NULL,
                                   `conversationId` int NOT NULL,
                                   `price` decimal(15,6) NOT NULL,
                                   `paidPrice` decimal(15,6) NOT NULL,
                                   `installment` int NOT NULL,
                                   `paymentId` int NOT NULL,
                                   `iyziCommissionRateAmount` decimal(15,6) NOT NULL,
                                   `iyziCommissionFee` decimal(15,6) NOT NULL,
                                   `cardFamily` varchar(10) NOT NULL,
                                   `binNumber` varchar(6) NOT NULL,
                                   `lastFourDigits` varchar(4) NOT NULL,
                                   `systemTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
                                   `currency` varchar(5) NOT NULL,
                                   PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;