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