Файл: public_html/db.sql
Строк: 103
DROP TABLE IF EXISTS `item`;
CREATE TABLE `item` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user` varchar(100) NOT NULL,
`tip` varchar(100) NOT
NULL,
`name` varchar(100) NOT NULL,
`cena` int(11) NOT NULL,
`zashita` int(11) NOT NULL,
`antirad` int(11) NOT NULL,
`dalnost`
int(11) NOT NULL,
`uron` int(11) NOT NULL,
`ves` int(11) NOT NULL,
`exp` int(11) NOT NULL,
`odet` int(1) NOT NULL,
`sost` int(11) NOT
NULL,
`bullet` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
INSERT INTO item
VALUES("1","ItemoFIL","armor","Тестовая
броня","100","20","35","0","0","1","0","1","100","");
INSERT
INTO item
VALUES("2","ADMINd","armor","Тестовая
броня","100","20","35","0","0","1","0","0","100","");
DROP
TABLE IF EXISTS `locations`;
CREATE TABLE `locations` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`x` int(11) NOT NULL,
`y` int(11) NOT NULL,
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`img` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`radiation` int(11) DEFAULT NULL,
`nl` int(11) NOT NULL,
`nu` int(11)
NOT NULL,
`nr` int(11) NOT NULL,
`nd` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
INSERT INTO
locations
VALUES("1","0","0","Начальная
локация","","","0","0","0","0");
INSERT
INTO locations
VALUES("2","0","1","Верхняя
локация","","10","0","0","0","0");
INSERT
INTO locations
VALUES("5","1","0","Правая
локация","","5","0","0","0","0");
INSERT
INTO locations
VALUES("6","-1","0","Левая
локация","","3","0","0","0","0");
INSERT
INTO locations
VALUES("7","-2","0","Ещё одна
левая
локация","","1","0","0","0","0");
INSERT
INTO locations
VALUES("8","-1","-1","Угловая
локация","","5","0","0","0","0");
INSERT
INTO locations
VALUES("9","0","-1","Нижняя
локация","","0","0","0","0","0");
DROP
TABLE IF EXISTS `mutants`;
CREATE TABLE `mutants` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`x` int(11) NOT
NULL,
`y` int(11) NOT NULL,
`status` varchar(100) DEFAULT NULL,
`uron` int(11) NOT NULL,
`zashita` int(11) NOT NULL,
`hp` int(11) NOT
NULL,
`maxhp` int(11) DEFAULT NULL,
`resp` int(11) NOT NULL,
`timeresp` int(11) NOT NULL,
`skorost` int(11) NOT NULL,
`agr` int(11)
NOT NULL,
`dalnost` int(11) NOT NULL,
`drop` varchar(100) NOT NULL,
`exp` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB
AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO mutants
VALUES("1","Тестовый
мутант","0","0","off","15","10","150","150","60","1401918966","15","0","0","1,2","1009");
DROP
TABLE IF EXISTS `pvelog`;
CREATE TABLE `pvelog` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`user` varchar(100) NOT NULL,
`mutant` int(11) NOT
NULL,
`log` varchar(200) NOT NULL,
`userpos` int(11) NOT NULL,
`mutantpos` int(11) NOT NULL,
`lastime` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
DROP
TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) NOT NULL
AUTO_INCREMENT,
`login` varchar(20) NOT NULL,
`pass` varchar(255) NOT
NULL,
`sex` varchar(1) NOT NULL,
`name` varchar(30) NOT NULL,
`email`
varchar(40) NOT NULL,
`datareg` varchar(255) NOT NULL,
`viz` int(11)
NOT NULL,
`level` varchar(1) NOT NULL,
`rub` int(11) NOT NULL,
`exp`
int(11) NOT NULL,
`x` int(11) NOT NULL,
`y` int(11) NOT NULL,
`hp`
int(11) NOT NULL,
`energy` int(11) NOT NULL,
`lastenergy` int(11)
DEFAULT NULL,
`lastrad` int(11) DEFAULT NULL,
`radiation` int(11) NOT
NULL,
`sila` int(11) DEFAULT NULL,
`skorost` int(11) DEFAULT NULL,
`metkost` int(11) DEFAULT NULL,
`userkill` int(11) DEFAULT NULL,
`mutantkill` int(11) DEFAULT NULL,
`dies` int(11) DEFAULT NULL,
`pve`
int(11) DEFAULT NULL,
`pvp` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
INSERT INTO users
VALUES("1","ADMIN","2a7188191601981b19574cad02173cf2","1","Алексей","Soul_eaterman@mail.ru","1400883986","1401970099","3","0","1009","0","0","50","100","1401970099","1401970060","0","10","5","3","1","8","23","0","");
INSERT
INTO users
VALUES("2","ADMIN","2a7188191601981b19574cad02173cf2","","","","1401056618","1401056621","0","0","0","0","0","0","100","1401970099","1401970060","0","","","","","","","","");
INSERT
INTO users
VALUES("3","ADMIN","2a7188191601981b19574cad02173cf2","","","","1401305781","1401305786","0","0","0","0","0","0","100","1401970099","1401970060","0","5","3","9","5","15","6","","");
INSERT
INTO users
VALUES("4","ADMIN","429a01ad9c1dbdc484472d2da1c892dc","","","","1401308229","1401308573","0","0","0","0","0","0","100","1401970099","1401970060","0","","","","","","","","");
INSERT
INTO users
VALUES("5","ADMIN","6d8b6f4f91c53e98b9f0dac3b2aeebdb","","","","1401308685","1401308702","0","0","0","0","0","0","100","1401970099","1401970060","0","","","","","","","","");
INSERT
INTO users
VALUES("6","ADMIN","2a7188191601981b19574cad02173cf2","","","","1401572267","1401577719","0","0","0","0","0","0","100","1401970099","1401970060","0","","","","","","","","");
INSERT
INTO users
VALUES("7","ADMIN","2a7188191601981b19574cad02173cf2","","","","1401577765","1401829295","0","0","0","0","0","0","100","1401970099","1401970060","0","","","","","","","","");
INSERT
INTO users
VALUES("8","ADMIN","2a7188191601981b19574cad02173cf2","","","","1401633257","1401635898","0","0","0","0","0","0","100","1401970099","1401970060","0","","","","","","","","");