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',
  curstreak SMALLINT NOT NULL DEFAULT '0',
  winstreak SMALLINT NOT NULL DEFAULT '0',
  losestreak SMALLINT NOT NULL DEFAULT '0',
  rounds SMALLINT NOT NULL DEFAULT '0',
  hide SMALLINT NOT NULL DEFAULT '0',
  fixed_name VARCHAR(32) NOT NULL DEFAULT '',
  id_token VARCHAR(10) NOT NULL DEFAULT '',
  FOREIGN KEY(client_id) REFERENCES clients(id)
);