Anti Cheat Database

[James]

Alright, this is completely off topic, so please bare with me.

   

   I'm working on my midterm for my Database class and I need to create a "fake" database.

   

   Requirements are as follows

   Atleast 4 Tables

   Each Table needs atleast 4 fields and atleast 12 rows.

   

   My idea is to create a fake anticheat Database System (think of it as DMW).

   Now I'm not exactly sure how DMW works, but maybe someone can help me out here.

   Basically I need to figure out what to add to my database so if I had a client AC that would require some kind of network communication similar to that of DMW how would I go about doing it?

   

   Here is an example of what I currently have:

   

   

   /*Create all of our tables*/
   
   CREATE TABLE User
   (
      userid int(10) unsigned NOT NULL auto_increment,
      username varchar(100) NOT NULL default '',
      password char(32) NOT NULL default '',
      email char(100) NOT NULL default '',
      ipaddress char(15) NOT NULL default '',
      sessionid int(10) unsigned NOT NULL default '0',
      warnings int(10) unsigned NOT NULL default '0',
   
      PRIMARY KEY  (userid),
      KEY username (username),
      KEY sessionid (sessionid)
   );
   
   /*Insert all of our values into the tables created above*/
   
   INSERT INTO User VALUES('1', 'username1', 'password1', 'user1@user1.com', '111.111.111.111', '0', '0');
   INSERT INTO User VALUES('2', 'username2', 'password2', 'user2@user2.com', '222.222.222.222', '0', '0');
   INSERT INTO User VALUES('3', 'username3', 'password3', 'user3@user3.com', '333.333.333.333', '0', '0');
   INSERT INTO User VALUES('4', 'username4', 'password4', 'user4@user4.com', '444.444.444.444', '0', '0');
   INSERT INTO User VALUES('5', 'username5', 'password5', 'user5@user5.com', '555.555.555.555', '0', '0');
   INSERT INTO User VALUES('6', 'username6', 'password6', 'user6@user6.com', '666.666.666.666', '0', '0');
   INSERT INTO User VALUES('7', 'username7', 'password7', 'user7@user7.com', '777.777.777.777', '0', '0');
   INSERT INTO User VALUES('8', 'username8', 'password8', 'user8@user8.com', '888.888.888.888', '0', '0');
   INSERT INTO User VALUES('9', 'username9', 'password9', 'user9@user9.com', '999.999.999.999', '0', '0');
   INSERT INTO User VALUES('10', 'username10', 'password10', 'user10@user10.com', '100.100.100.100', '0', '0');
   INSERT INTO User VALUES('11', 'username11', 'password11', 'user11@user11.com', '110.110.110.110', '0', '0');
   INSERT INTO User VALUES('12', 'username12', 'password12', 'user12@user12.com', '120.120.120.120', '0', '0');
   INSERT INTO User VALUES('13', 'username13', 'password13', 'user13@user13.com', '130.130.130.130', '0', '0');
   INSERT INTO User VALUES('14', 'username14', 'password14', 'user14@user14.com', '140.140.140.140', '0', '0');
   

   

   Any help would be MUCH appreciated.