CREATE SCHEMA IF NOT EXISTS partsltd_dev;

CREATE TABLE IF NOT EXISTS MCMPS_player_stats (
	id BIGINT AUTO_INCREMENT PRIMARY KEY,
	player_uuid VARCHAR(36),
	stat_type VARCHAR(50),
	stat_value INT,
	item_id VARCHAR(100),
	timestamp TIMESTAMP,
	INDEX idx_player_uuid (player_uuid),
	INDEX idx_stat_type (stat_type)
);

CREATE TABLE IF NOT EXISTS MCMPS_player_locations (
	id BIGINT AUTO_INCREMENT PRIMARY KEY,
	player_uuid VARCHAR(36),
	x DOUBLE,
	y DOUBLE,
	z DOUBLE,
	dimension VARCHAR(50),
	timestamp TIMESTAMP,
	INDEX idx_player_uuid (player_uuid)
);

