CREATE TABLE `r_store_players` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`player_identifier` VARCHAR(46) NOT NULL COLLATE 'latin1_swedish_ci',
`coins` INT(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `player_identifier` (`player_identifier`) USING BTREE
);
CREATE TABLE `r_store_purchases` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`player_identifier` VARCHAR(46) NOT NULL COLLATE 'latin1_swedish_ci',
`item_name` VARCHAR(255) NOT NULL COLLATE 'latin1_swedish_ci',
`item_type` ENUM('vehicle','item','weapon','money') NOT NULL COLLATE 'latin1_swedish_ci',
`quantity` INT(11) NOT NULL DEFAULT 1,
`cost_coins` INT(11) NOT NULL,
`purchase_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`) USING BTREE,
INDEX `player_identifier` (`player_identifier`) USING BTREE
);