· 7 years ago · Dec 18, 2018, 12:38 PM
1CREATE TABLE IF NOT EXISTS `transaction_log` (
2`id` int(11) NOT NULL AUTO_INCREMENT,
3`pid` int(11) NOT NULL,
4`response_code` int(11) NOT NULL,
5`payment_data` text NOT NULL,
6`response_data` text NOT NULL,
7PRIMARY KEY (`id`)
8) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;