sql.txt

/*
CREATE TABLE BOARD_TABLE(
ID INT PRIMARY KEY AUTO_INCREMENT,
TITLE VARCHAR(255) NOT NULL,
description text NULL,
created datetime NOT NULL
*/
/*
CREATE TABLE DMSERVER_TABLE(
ID INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(24) NOT NULL,
PASS VARCHAR(24) NOT NULL,
USERIP VARCHAR(16) NOT NULL,
ADMIN INT(1) NOT NULL,
TEAM INT(2) NOT NULL,
MONEY INT(10) NOT NULL,
LEVEL INT(3) NOT NULL,
EXP INT(3) NOT NULL,
KILLS INT(5) NOT NULL,
DEATHS INT(5) NOT NULL,
SKIN INT(5) NOT NULL,
WEP1 INT(2) NOT NULL,
AMMO1 INT(4) NOT NULL,
INTERIOR INT(2) NOT NULL,
WORLD INT(1) NOT NULL,
POS_X DECIMAL (10,5) NOT NULL,
POS_Y DECIMAL (10,5) NOT NULL,
POS_Z DECIMAL (10,5) NOT NULL,
ANGLE DECIMAL (10,5) NOT NULL,
HP DECIMAL (3,0) NOT NULL,
AM DECIMAL (3,0) NOT NULL
) ENGINE=INNODB;

*/

/*
CREATE TABLE POKETMON_TABLE(
ID INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(24) NOT NULL,
TYPE INT(3) NOT NULL,
MONNAME VARCHAR(24) NOT NULL,
CP INT(4) NOT NULL,
HEALTH INT(3) NOT NULL,
THIRST INT(3) NOT NULL,
HUNGER INT(3) NOT NULL,
TIRED INT(3) NOT NULL,
CLEAN INT(3) NOT NULL,
FUNNY INT(3) NOT NULL
) ENGINE=INNODB;

*/