38 lines
866 B
SQL
38 lines
866 B
SQL
-- Your SQL goes here
|
|
CREATE TABLE IF NOT EXISTS processing_status (
|
|
demo_id TEXT PRIMARY KEY,
|
|
info int2 NOT NULL -- the processing_status of the basic demo info
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS demo_info (
|
|
demo_id TEXT PRIMARY KEY,
|
|
map TEXT NOT NULL
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS demo_players (
|
|
demo_id TEXT NOT NULL,
|
|
steam_id TEXT NOT NULL,
|
|
name TEXT NOT NULL,
|
|
team int2 NOT NULL,
|
|
color int2 NOT NULL,
|
|
PRIMARY KEY (demo_id, steam_id)
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS demo_player_stats (
|
|
demo_id TEXT NOT NULL,
|
|
steam_id TEXT NOT NULL,
|
|
kills int2 NOT NULL,
|
|
deaths int2 NOT NULL,
|
|
damage int2 NOT NULL,
|
|
assists int2 NOT NULL,
|
|
PRIMARY KEY (demo_id, steam_id)
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS demo_teams (
|
|
demo_id TEXT NOT NULL,
|
|
team int2 NOT NULL,
|
|
end_score int2 NOT NULL,
|
|
start_name TEXT NOT NULL,
|
|
PRIMARY KEY (demo_id, team)
|
|
);
|