CREATE TABLE IF NOT EXISTS %s (
  id SERIAL PRIMARY KEY,
  client_id INTEGER NOT NULL DEFAULT '0',
  kills INTEGER NOT NULL DEFAULT '0',
  deaths INTEGER NOT NULL DEFAULT '0',
  teamkills SMALLINT NOT NULL DEFAULT '0',
  teamdeaths SMALLINT NOT NULL DEFAULT '0',
  suicides SMALLINT NOT NULL DEFAULT '0',
  ratio FLOAT NOT NULL DEFAULT '0',
  skill FLOAT NOT NULL DEFAULT '0',
  assists INTEGER NOT NULL DEFAULT '0',
  assistskill FLOAT NOT NULL DEFAULT '0',
  winstreak SMALLINT NOT NULL DEFAULT '0',
  losestreak SMALLINT NOT NULL DEFAULT '0',
  rounds SMALLINT NOT NULL DEFAULT '0',
  year INTEGER NOT NULL,
  month INTEGER NOT NULL,
  week INTEGER NOT NULL,
  day INTEGER NOT NULL
);