sql.txt

drop table user_info;
drop table clan_info;
drop table zone_info;
drop table vehicle_info;
drop table house_info;
drop table weapon_info;
drop table duel_info;

CREATE TABLE user_info(
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,
CLANID 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,
WEP2 INT(2) NOT NULL,
WEP3 INT(2) 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 clan_info(
ID INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(50) NOT NULL,
LEADER_ID INT NOT NULL,
KILLS INT(5) NOT NULL,
DEATHS INT(5) NOT NULL,
COLOR INT(10) NOT NULL,
ZONE_LENGTH INT(3) NOT NULL,
SKIN INT(3) NOT NULL
) ENGINE=INNODB;

CREATE TABLE zone_info(
ID INT PRIMARY KEY AUTO_INCREMENT,
OWNER_CLAN INT(3) NOT NULL
) ENGINE=INNODB;

CREATE TABLE vehicle_info(
ID INT PRIMARY KEY AUTO_INCREMENT,
OWNER_ID INT 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,
COLOR1 INT(3) NOT NULL,
COLOR2 INT(3) NOT NULL
) ENGINE=INNODB;

CREATE TABLE house_info(
ID INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(24) NOT NULL,
OPEN INT(1) NOT NULL,
ENTER_POS_X DECIMAL (10,5) NOT NULL,
ENTER_POS_Y DECIMAL (10,5) NOT NULL,
ENTER_POS_Z DECIMAL (10,5) NOT NULL,
LEAVE_POS_X DECIMAL (10,5) NOT NULL,
LEAVE_POS_Y DECIMAL (10,5) NOT NULL,
LEAVE_POS_Z DECIMAL (10,5) NOT NULL
) ENGINE=INNODB;

CREATE TABLE weapon_info(
ID INT PRIMARY KEY AUTO_INCREMENT,
USER_ID INT NOT NULL,
MODEL INT(4) NOT NULL
) ENGINE=INNODB;

CREATE TABLE duel_info(
ID INT PRIMARY KEY AUTO_INCREMENT,
PID1 INT,
PID2 INT,
TYPE INT(1),
MONEY INT,
WIN_USER_ID INT,
WIN_HP DECIMAL (3,0) NOT NULL,
WIN_AM DECIMAL (3,0) NOT NULL
)