CREATE TABLE game (
 -- basic information about each game
 -- INT columns only when required for sorting
 game INT, -- game number
 map, -- game map
 gametype, -- (S)tandard, (C)Terminator, (A)ssassin, (D)oubles, (T)riples or 
 -- (Q)uadruples
 initialtroops, -- initial troops, (E)Automatic or (M)anual
 playorder, -- play order,(S)equential or (F)reestyle
 spoils, -- spoils, (1)No Spoils, (2)Escalating, (3)Flat Rate or (4)Nuclear
 reinforcements, -- reinforcements, (C)hained, (O)Adjacent or (M)Unlimited
 fogofwar, -- Fog of war? (Y/N)
 start, -- game start time
 end -- game end time
);
CREATE UNIQUE INDEX igame ON game(game);
CREATE TABLE chatnlog(
 -- chat and log messages for each game
 game, -- game number
 time, -- message time
 person, -- message owner or "*" for system
 chatorlog, -- is this a chat message or a log message?
 msg -- the message itself
);
CREATE TABLE players(
 -- game players and their status
 -- INT columns only when required for sorting
 game, -- game number
 player, -- player username
 points INT, -- points player gained/lost
 elim -- time when player was eliminated or won game
);
CREATE UNIQUE INDEX iplayer ON players(game, player);