14 lines
No EOL
389 B
SQL
14 lines
No EOL
389 B
SQL
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)
|
|
); |