-- Royal Pass - Individual Player Rankings Table
-- Created by the .sma plugin automatically, but here for reference

CREATE TABLE IF NOT EXISTS `rp_players` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `player_uid` INT NOT NULL UNIQUE,
    `player_name` VARCHAR(32) NOT NULL,
    `steamid` VARCHAR(32) DEFAULT '',
    `points` INT DEFAULT 0,
    `played_time` INT DEFAULT 0,
    `team_uid` INT DEFAULT 0,
    `team_name` VARCHAR(32) DEFAULT '',
    `last_login` INT DEFAULT 0,
    `updated_at` INT DEFAULT 0,
    INDEX `idx_points` (`points` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
