CREATE TABLE `player_recent_purchases` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`player_id` INT(11) NOT NULL DEFAULT '0',
	`catalog_item` INT(11) NOT NULL DEFAULT '0',
	`amount` INT(11) NOT NULL DEFAULT '0',
	`data` VARCHAR(255) NOT NULL DEFAULT '',
	`purchase_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`),
	INDEX `player_id` (`player_id`)
)
ENGINE=InnoDB
;


ALTER TABLE `server_configuration`
	ADD COLUMN `log_catalog_purchases` ENUM('true','false') NULL DEFAULT 'false' AFTER `max_connections_per_ip`;
