· 6 years ago · Jun 22, 2019, 04:22 PM
1CREATE TABLE IF NOT EXISTS `payments` (
2 `id` int(6) NOT NULL AUTO_INCREMENT,
3 `txnid` varchar(20) NOT NULL,
4 `payment_amount` decimal(7,2) NOT NULL,
5 `payment_status` varchar(25) NOT NULL,
6 `itemid` varchar(25) NOT NULL,
7 `createdtime` datetime NOT NULL,
8 PRIMARY KEY (`id`)
9) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;