OpenCart 🇺🇦

$this->db->query("
	CREATE TABLE `" . DB_PREFIX . "paypal_payflow_iframe_order` (
		`order_id` int(11) DEFAULT NULL,
		`secure_token_id` varchar(255) NOT NULL,
		`transaction_reference` varchar(255) DEFAULT NULL,
		`transaction_type` varchar(1) DEFAULT NULL,
		`complete` tinyint(4) NOT NULL DEFAULT '0',
		PRIMARY KEY(`order_id`),
		KEY `secure_token_id` (`secure_token_id`)
	) ENGINE=MyISAM DEFAULT COLLATE=utf8_general_ci");

$this->db->query("
	CREATE TABLE `" . DB_PREFIX . "paypal_payflow_iframe_order_transaction` (
		`order_id` int(11) NOT NULL,
		`transaction_reference` varchar(255) NOT NULL,
		`transaction_type` char(1) NOT NULL,
		`time` datetime NOT NULL,
		`amount` decimal(10,4) DEFAULT NULL,
		PRIMARY KEY (`transaction_reference`),
		KEY `order_id` (`order_id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8;");