CREATE TABLE stat (
        stat_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
        race_id TINYINT UNSIGNED NOT NULL,
        stat_name VARCHAR(50),

        PRIMARY KEY (stat_id)
) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE user_stat (
        user_id INT UNSIGNED NOT NULL,
        stat_id INT UNSIGNED NOT NULL,
        stat INT NOT NULL
) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE user_commander_stat (
        user_id INT UNSIGNED NOT NULL,
        stat_id INT UNSIGNED NOT NULL,
        stat INT NOT NULL
) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE user_weapon_stat (
        user_id INT UNSIGNED NOT NULL,
        stat_id INT UNSIGNED NOT NULL,
        stat INT NOT NULL
) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE user_match_stat (
    user_id INT UNSIGNED NOT NULL,
    match_id INT UNSIGNED NOT NULL,
    stat_id INT UNSIGNED NOT NULL,
    stat INT NOT NULL
) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE user_match_commander_stat (
    user_id INT UNSIGNED NOT NULL,
    match_id INT UNSIGNED NOT NULL,
    stat_id INT UNSIGNED NOT NULL,
    stat INT NOT NULL
) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE TABLE user_match_weapon_stat (
    user_id INT UNSIGNED NOT NULL,
    match_id INT UNSIGNED NOT NULL,
    stat_id INT UNSIGNED NOT NULL,
    race_id TINYINT UNSIGNED NOT NULL,
    stat INT NOT NULL
) ENGINE = INNODB CHARACTER SET utf8 COLLATE utf8_general_ci;