source: network-game/server/dbmod.txt@ 84754c0

SQL statements for creating the db tables are stored here

CREATE TABLE users (
   id INT NOT NULL AUTO_INCREMENT,
   name varchar(64) NOT NULL,
   password binary(60) NOT NULL,
   class INT unsigned DEFAULT NULL,
   level INT unsigned NOT NULL DEFAULT 0,
   experience INT unsigned NOT NULL DEFAULT 0,
   honor INT NOT NULL DEFAULT 0,
   wins INT NOT NULL DEFAULT 0,
   losses INT NOT NULL DEFAULT 0,
   PRIMARY KEY (id),
   UNIQUE KEY name (name)
);


CREATE TABLE gameHistory (
   id INT NOT NULL AUTO_INCREMENT,
   user_id INT NOT NULL,
   user_team INT NOT NULL,
   red_score INT NOT NULL,
   blue_score INT NOT NULL,
   PRIMARY KEY (id),
   CONSTRAINT fk_users FOREIGN KEY
   fki_users (user_id)
   REFERENCES users (id)
   ON DELETE CASCADE
   ON UPDATE CASCADE
);