34 lines
603 B
Plaintext
34 lines
603 B
Plaintext
|
CREATE TABLE hero (
|
||
|
|
id INTEGER PRIMARY KEY,
|
||
|
|
name VARCHAR(255)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE matches (
|
||
|
|
id BIGINT PRIMARY KEY,
|
||
|
|
start_time INTEGER,
|
||
|
|
leagueid INTEGER,
|
||
|
|
radiant_team_id INTEGER,
|
||
|
|
dire_team_id INTEGER,
|
||
|
|
radiant_win BOOLEAN,
|
||
|
|
source VARCHAR(255)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE details_match (
|
||
|
|
match_id BIGINT,
|
||
|
|
hero_id INTEGER,
|
||
|
|
team INTEGER,
|
||
|
|
"order" INTEGER,
|
||
|
|
players_id BIGINT,
|
||
|
|
pos INTEGER
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE teams (
|
||
|
|
id BIGINT PRIMARY KEY,
|
||
|
|
name VARCHAR(255)
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE TABLE pro_players (
|
||
|
|
id BIGINT PRIMARY KEY,
|
||
|
|
name VARCHAR(255),
|
||
|
|
team_id BIGINT
|
||
|
|
);
|