DROP TABLE IF EXISTS `iyzico_response_item`;
CREATE TABLE `iyzico_response_item` (
                                        `id` int NOT NULL AUTO_INCREMENT,
                                        `response_id` int NOT NULL,
                                        `product_id` int NOT NULL,
                                        `paymentTransactionId` int NOT NULL,
                                        `blockageResolvedDate` datetime NOT NULL,
                                        `subMerchantKey` varchar(150) NOT NULL,
                                        `paidPrice` decimal(15,6) NOT NULL,
                                        `iyziCommissionRateAmount` decimal(15,6) NOT NULL,
                                        `iyziCommissionFee` decimal(15,6) NOT NULL,
                                        `blockageRateAmountMerchant` decimal(15,6) NOT NULL,
                                        `blockageRateAmountSubMerchant` decimal(15,6) NOT NULL,
                                        `subMerchantPayoutAmount` decimal(15,6) NOT NULL,
                                        `merchantPayoutAmount` decimal(15,6) NOT NULL,
                                        `iyziConversionRate` decimal(15,6) NOT NULL,
                                        `iyziConversionRateAmount` decimal(15,6) NOT NULL,
                                        `transactionStatus` tinyint(1) NOT NULL,
                                        `sale_id` int NOT NULL,
                                        `status` tinyint(1) NOT NULL DEFAULT '0',
                                        PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;