- 24 Mar 2017, 13:30
#72740
Executo no sql:
CREATE TABLE IF NOT EXISTS `oc_paypal_order_transaction` (
`paypal_order_transaction_id` int(11) NOT NULL AUTO_INCREMENT,
`paypal_order_id` int(11) NOT NULL,
`transaction_id` char(20) NOT NULL,
`parent_id` char(20) NOT NULL,
`date_added` datetime NOT NULL,
`note` varchar(255) NOT NULL,
`msgsubid` char(38) NOT NULL,
`receipt_id` char(20) NOT NULL,
`payment_type` enum('none','echeck','instant','refund','void') DEFAULT NULL,
`payment_status` char(20) NOT NULL,
`pending_reason` char(50) NOT NULL,
`transaction_entity` char(50) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`debug_data` text NOT NULL,
`call_data` text NOT NULL,
PRIMARY KEY (`paypal_order_transaction_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;