· 8 years ago · Jan 14, 2018, 06:14 PM
1CREATE TABLE IF NOT EXISTS `vip_purchases` (
2 `id` int(10) NOT NULL AUTO_INCREMENT,
3 `email` varchar(500) DEFAULT NULL,
4 `username` varchar(500) DEFAULT NULL,
5 `amount` int(10) DEFAULT NULL,
6 `transaction_id` text,
7 `everything_else` text,
8 `timestamp` int(10) DEFAULT NULL,
9 PRIMARY KEY (`id`)
10) ENGINE=InnoDB DEFAULT CHARSET=latin1;