· 6 years ago · Mar 18, 2019, 02:06 AM
1CREATE TABLE IF NOT EXISTS `pagseguro_transactions` (
2 `transaction_code` VARCHAR(36) NOT NULL,
3 `name` VARCHAR(200) DEFAULT NULL,
4 `payment_method` VARCHAR(50) NOT NULL,
5 `status` VARCHAR(50) NOT NULL,
6 `item_count` INT(11) NOT NULL,
7 `data` DATETIME NOT NULL,
8 UNIQUE KEY `transaction_code` (`transaction_code`,`status`),
9 KEY `name` (`name`),
10 KEY `status` (`status`)
11) ENGINE=MyISAM;
12
13
14no linux
15
16
17sudo apt-get install php5-curl
18sudo service apache2 restart