-- 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)
);