QTuKfnpX

1DROP TABLE IF EXISTS `cms_transactions`;
2/*!40101 SET @saved_cs_client     = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `cms_transactions` (
5  `id` int(11) NOT NULL AUTO_INCREMENT,
6  `user_id` int(11) NOT NULL,
7  `refunded` enum('0','1') DEFAULT '0',
8  `gateway` enum('stripe','paypal','braintree') DEFAULT NULL,
9  `transaction_id` varchar(25) NOT NULL,
10  `amount` char(7) NOT NULL,
11  `package` int(1) NOT NULL,
12  `email` varchar(255) DEFAULT NULL,
13  `nonce` varchar(255) NOT NULL,
14  `purchase_date` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
15  PRIMARY KEY (`id`)
16) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
17/*!40101 SET character_set_client = @saved_cs_client */;