SQL File

CREATE TABLE IF NOT EXISTS `arena_players` (
    `identifier` VARCHAR(64) NOT NULL,
    `display_name` VARCHAR(32) DEFAULT NULL,
    `rank_points` INT(11) NOT NULL DEFAULT 1000,
    `rank_tier` VARCHAR(32) NOT NULL DEFAULT 'Silver I',
    `highest_rank_points` INT(11) NOT NULL DEFAULT 1000,
    `kills` INT(11) UNSIGNED NOT NULL DEFAULT 0,
    `deaths` INT(11) UNSIGNED NOT NULL DEFAULT 0,
    `matches_won` INT(11) UNSIGNED NOT NULL DEFAULT 0,
    `matches_played` INT(11) UNSIGNED NOT NULL DEFAULT 0,
    `win_streak` INT(11) NOT NULL DEFAULT 0,
    `arena_balance` INT(11) NOT NULL DEFAULT 0,
    `bet_earnings` BIGINT(20) NOT NULL DEFAULT 0,
    `last_played` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`identifier`),
    KEY `idx_arena_rank` (`rank_points` DESC),
    KEY `idx_kills` (`kills`),
    KEY `idx_matches_won` (`matches_won`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `arena_saved_inventories` (
    `identifier` VARCHAR(64) NOT NULL,
    `items` LONGTEXT NOT NULL,
    `saved_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;