/**
* 1 to many relationship with paypal order table, many transactions per 1 order
*/
$this->db->query("INSERT INTO `" . DB_PREFIX . "paypal_order_transaction` SET
`paypal_order_id` = '".(int)$transaction_data['paypal_order_id']."',
`transaction_id` = '".$this->db->escape($transaction_data['transaction_id'])."',
`parent_transaction_id` = '".$this->db->escape($transaction_data['parent_transaction_id'])."',
`created` = NOW(),
`note` = '".$this->db->escape($transaction_data['note'])."',
`msgsubid` = '".$this->db->escape($transaction_data['msgsubid'])."',
`receipt_id` = '".$this->db->escape($transaction_data['receipt_id'])."',
`payment_type` = '".$this->db->escape($transaction_data['payment_type'])."',
`payment_status` = '".$this->db->escape($transaction_data['payment_status'])."',
`pending_reason` = '".$this->db->escape($transaction_data['pending_reason'])."',
`transaction_entity` = '".$this->db->escape($transaction_data['transaction_entity'])."',
`amount` = '".(double)$transaction_data['amount']."',
`debug_data` = '".$this->db->escape($transaction_data['debug_data'])."'");
