/mysql_create_tables_v1.sql
http://ghostcb.googlecode.com/ · SQL · 97 lines · 91 code · 6 blank · 0 comment · 0 complexity · 2d320f80f3ba2aaa9dcf6c7d366e7425 MD5 · raw file
- CREATE TABLE admins (
- id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- botid INT NOT NULL,
- name VARCHAR(15) NOT NULL,
- server VARCHAR(100) NOT NULL
- );
-
- CREATE TABLE bans (
- id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- botid INT NOT NULL,
- server VARCHAR(100) NOT NULL,
- name VARCHAR(15) NOT NULL,
- ip VARCHAR(15) NOT NULL,
- date DATETIME NOT NULL,
- gamename VARCHAR(31) NOT NULL,
- admin VARCHAR(15) NOT NULL,
- reason VARCHAR(255) NOT NULL
- );
-
- CREATE TABLE games (
- id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- botid INT NOT NULL,
- server VARCHAR(100) NOT NULL,
- map VARCHAR(100) NOT NULL,
- datetime DATETIME NOT NULL,
- gamename VARCHAR(31) NOT NULL,
- ownername VARCHAR(15) NOT NULL,
- duration INT NOT NULL,
- gamestate INT NOT NULL,
- creatorname VARCHAR(15) NOT NULL,
- creatorserver VARCHAR(100) NOT NULL
- );
-
- CREATE TABLE gameplayers (
- id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- botid INT NOT NULL,
- gameid INT NOT NULL,
- name VARCHAR(15) NOT NULL,
- ip VARCHAR(15) NOT NULL,
- spoofed INT NOT NULL,
- reserved INT NOT NULL,
- loadingtime INT NOT NULL,
- `left` INT NOT NULL,
- leftreason VARCHAR(100) NOT NULL,
- team INT NOT NULL,
- colour INT NOT NULL,
- spoofedrealm VARCHAR(100) NOT NULL,
- INDEX( gameid )
- );
-
- CREATE TABLE dotagames (
- id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- botid INT NOT NULL,
- gameid INT NOT NULL,
- winner INT NOT NULL,
- min INT NOT NULL,
- sec INT NOT NULL
- );
-
- CREATE TABLE dotaplayers (
- id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- botid INT NOT NULL,
- gameid INT NOT NULL,
- colour INT NOT NULL,
- kills INT NOT NULL,
- deaths INT NOT NULL,
- creepkills INT NOT NULL,
- creepdenies INT NOT NULL,
- assists INT NOT NULL,
- gold INT NOT NULL,
- neutralkills INT NOT NULL,
- item1 CHAR(4) NOT NULL,
- item2 CHAR(4) NOT NULL,
- item3 CHAR(4) NOT NULL,
- item4 CHAR(4) NOT NULL,
- item5 CHAR(4) NOT NULL,
- item6 CHAR(4) NOT NULL,
- hero CHAR(4) NOT NULL,
- newcolour INT NOT NULL,
- towerkills INT NOT NULL,
- raxkills INT NOT NULL,
- courierkills INT NOT NULL,
- INDEX( gameid, colour )
- );
-
- CREATE TABLE downloads (
- id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
- botid INT NOT NULL,
- map VARCHAR(100) NOT NULL,
- mapsize INT NOT NULL,
- datetime DATETIME NOT NULL,
- name VARCHAR(15) NOT NULL,
- ip VARCHAR(15) NOT NULL,
- spoofed INT NOT NULL,
- spoofedrealm VARCHAR(100) NOT NULL,
- downloadtime INT NOT NULL
- );