CREATE DATABASE IF NOT EXISTS lol_analytics;
USE lol_analytics;
-- TODO: adjust size
CREATE TABLE IF NOT EXISTS user_ids (
    puuid VARCHAR(256) PRIMARY KEY,
    tier VARCHAR(256) NOT NULL,
);

CREATE TABLE IF NOT EXISTS matches (
    match_id VARCHAR(256) PRIMARY KEY,
    puuid VARCHAR(256) NOT NULL,
    tier VARCHAR(256) NOT NULL,
    FOREIGN KEY (puuid) REFERENCES user_ids(puuid)
);