Skip to content
Find file
Fetching contributors…
Cannot retrieve contributors at this time
31 lines (28 sloc) 753 Bytes
CREATE TABLE scores (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
category VARCHAR(25) NOT NULL,
name VARCHAR(15) NOT NULL,
server VARCHAR(100) NOT NULL,
score REAL NOT NULL
);
CREATE TABLE w3mmdplayers (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
botid INT NOT NULL,
category VARCHAR(25) NOT NULL,
gameid INT NOT NULL,
pid INT NOT NULL,
name VARCHAR(15) NOT NULL,
flag VARCHAR(32) NOT NULL,
leaver INT NOT NULL,
practicing INT NOT NULL
);
CREATE TABLE w3mmdvars (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
botid INT NOT NULL,
gameid INT NOT NULL,
pid INT NOT NULL,
varname VARCHAR(25) NOT NULL,
value_int INT DEFAULT NULL,
value_real REAL DEFAULT NULL,
value_string VARCHAR(100) DEFAULT NULL
);
Something went wrong with that request. Please try again.