source: network-game/server/dbmod.txt@ 5037b4b

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 unsigned NOT NULL DEFAULT 0,
   wins INT unsigned NOT NULL DEFAULT 0,
   losses INT unsigned 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
);