Файл: www/sql.sql
Строк: 770
/*
Navicat MySQL Data Transfer
Source Server :
localhost
Source Server Version : 50045
Source Host :
localhost:3306
Source Database : sql
Target Server Type :
MYSQL
Target Server Version : 50045
File Encoding :
65001
Date: 2013-04-23 15:30:28
*/
SET FOREIGN_KEY_CHECKS=0;
--
----------------------------
-- Table structure for `account`
--
----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE
`account` (
`id` int(11) NOT NULL auto_increment,
`login` varchar(25)
NOT NULL,
`password` varchar(50) default NULL,
`x` varchar(50)
default NULL,
`y` varchar(50) default NULL,
`name` varchar(50)
default NULL,
`status` char(255) default NULL,
`class` char(255)
default NULL,
`hp` int(11) default NULL,
`mp` int(11) default NULL,
`race` char(255) default NULL,
`power` int(11) default NULL,
`vitality` int(11) default NULL,
`spirit` int(11) default NULL,
`dexterity` int(11) default NULL,
`wit` int(11) default NULL,
`armor_head` int(11) default NULL,
`armor_body` int(11) default NULL,
`armor_pants` int(11) default NULL,
`armor_gloves` int(11) default
NULL,
`armor_belt` int(11) default NULL,
`armor_ring` int(11) default
NULL,
`armor_boots` int(11) default NULL,
`armor_earring` int(11)
default NULL,
`weapon_right` int(11) default NULL,
`weaponshield_left` int(11) default NULL,
`lvl` int(11) default NULL,
`armor_shoulder` int(11) default NULL,
`armor_neckleace` int(11) default
NULL,
`exp` int(11) default NULL,
`gold` int(11) default NULL,
`last_hp` int(11) default NULL,
`last_mp` int(11) default NULL,
`x1`
int(11) default NULL,
`y1` int(11) default NULL,
`battle` int(11)
default NULL,
`battle_attack` int(11) default NULL,
`battle_target_type` char(255) default '0',
`battle_last_attack` int(11)
default NULL,
`secret` char(11) default NULL,
`last_active` int(11)
default NULL,
`specialization` int(11) default '0',
`party` int(11)
default '0',
`skill_point` int(11) default '0',
`character_point`
int(11) default '0',
`historyread` int(11) NOT NULL default '0',
`clan` int(11) NOT NULL,
`clan_status` varchar(255) NOT NULL,
`duel_battle` int(11) NOT NULL,
`set_loccompress` varchar(255) default
NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of account
--
----------------------------
-- ----------------------------
-- Table
structure for `battle`
-- ----------------------------
DROP TABLE IF
EXISTS `battle`;
CREATE TABLE `battle` (
`id` int(11) NOT NULL
auto_increment,
`x` int(11) default NULL,
`y` int(11) default NULL,
`x1` int(11) default NULL,
`y1` int(11) default NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of battle
--
----------------------------
-- ----------------------------
-- Table
structure for `battle_log`
-- ----------------------------
DROP TABLE IF
EXISTS `battle_log`;
CREATE TABLE `battle_log` (
`id` int(11) NOT NULL
auto_increment,
`account` int(11) default NULL,
`mess` char(255)
default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;
-- ----------------------------
-- Records of
battle_log
-- ----------------------------
--
----------------------------
-- Table structure for `brain`
--
----------------------------
DROP TABLE IF EXISTS `brain`;
CREATE TABLE
`brain` (
`id` int(255) NOT NULL auto_increment,
`question` text,
`answer` text,
`active` text,
`time` text,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 PACK_KEYS=0;
--
----------------------------
-- Records of brain
--
----------------------------
INSERT INTO brain VALUES ('1',
'Капризное поведение ребенка.', 'нытье', '0',
'1356531487');
INSERT INTO brain VALUES ('2', 'Японское
миниатюрное произведение из слоновой
кости, дерева, металла.', 'нэцкэ', '0',
'1356202662');
INSERT INTO brain VALUES ('3', 'Маневр
автомобиля.', 'обгон', '0', '1356113066');
INSERT INTO
brain VALUES ('4', 'Ложь, неправда.', 'обман', '0',
'1356204373');
INSERT INTO brain VALUES ('5', 'Завязка у
лаптя.', 'обора', '0', '1356099130');
INSERT INTO brain VALUES
('6', 'Маневр войск при наступлении.',
'обход', '0', '1356372434');
INSERT INTO brain VALUES ('7',
'Персонаж рассказа А.Чехова
\"Лошадиная фамилия\".', 'овсов', '0',
'1356203569');
INSERT INTO brain VALUES ('8', 'Место,
пропущенное при вспашке.', 'огрех', '0',
'1356277163');
INSERT INTO brain VALUES ('9', 'Трава в тундре,
корм для оленей.', 'ожика', '0', '1356625755');
INSERT
INTO brain VALUES ('10', 'Осенний посев зерновых.',
'озимь', '0', '1356202105');
INSERT INTO brain VALUES ('11',
'Резкий возглас с угрозой.', 'окрик', '0',
'1356202954');
INSERT INTO brain VALUES ('12', 'Обращенный к
кому-либо, зовущий возглас.', 'оклик', '0',
'1356202358');
INSERT INTO brain VALUES ('13', 'Смесь жидких
жирных кислот.', 'олеин', null, null);
INSERT INTO brain
VALUES ('14', 'Крупное парнокопытное животное
с ветвистыми рогами.', 'олень', '0',
'1355952348');
INSERT INTO brain VALUES ('15', 'Маслянистая
жидкость, применяемая в производстве
красителей, взрывчатых веществ.', 'олеум',
'0', '1356202526');
INSERT INTO brain VALUES ('16', 'Маслина
культурная.', 'олива', '0', '1356292882');
INSERT INTO
brain VALUES ('17', 'Обмотки для ног под лапоть.',
'онучи', '0', '1356450432');
INSERT INTO brain VALUES ('18',
'Японский кинорежиссер, к/ф \"Империя
страсти\".', 'осима', '0', '1356098631');
INSERT INTO
brain VALUES ('19', 'Ощеренная пасть.', 'оскал', '0',
'1356265800');
INSERT INTO brain VALUES ('20', 'Династия
турецких султанов.', 'осман', '0',
'1356452655');
INSERT INTO brain VALUES ('21', 'Важная
персона.', 'особа', null, null);
INSERT INTO brain VALUES
('22', 'Самостоятельно существующий
организм, индивидуум.', 'особь', '0',
'1356625637');
INSERT INTO brain VALUES ('23', 'Каркас
корабля, здания.', 'остов', '0', '1356204462');
INSERT
INTO brain VALUES ('24', 'Естественный конкурс на
выживание в природе.', 'отбор', '0',
'1356458568');
INSERT INTO brain VALUES ('25', 'Заявление об
отстранении от участия в чем-либо.',
'отвод', '0', '1356203444');
INSERT INTO brain VALUES ('26',
'Обратное движение ствола орудия после
выстрела.', 'откат', '0', '1356202472');
INSERT INTO brain
VALUES ('27', 'Активная защита.', 'отпор', '0',
'1356107833');
INSERT INTO brain VALUES ('28', 'Количество
очков, расстояние, выигранное у
отставших.', 'отрыв', '0', '1356450641');
INSERT INTO brain
VALUES ('29', 'Разность между поступающими и
поступившими абитуриентами.', 'отсев', '0',
'1356202318');
INSERT INTO brain VALUES ('30', 'Толщина
дерева по окружности.', 'охват', '0',
'1356097563');
INSERT INTO brain VALUES ('31', 'Студент
дневного отделения.', 'очник', '0',
'1356097392');
INSERT INTO brain VALUES ('32', 'Часть мясной
туши.', 'ошеек', '0', '1356203316');
INSERT INTO brain VALUES
('33', 'Женское имя (лат. маленькая).', 'павла',
'0', '1355953114');
INSERT INTO brain VALUES ('34', 'Способ
получения неразъемного соединения.',
'пайка', '0', '1356202425');
INSERT INTO brain VALUES ('35',
'Действующий вулкан в Исландии подо
льдом.', 'катла', null, null);
INSERT INTO brain VALUES ('36',
'Кошачий лемур.', 'катта', '0', '1356610391');
INSERT
INTO brain VALUES ('37', 'Разменная монета Гвинеи.',
'каури', '0', '1356554083');
INSERT INTO brain VALUES ('38',
'Брюхоногий моллюск, фарфоровая улитка.',
'каури', '0', '1356203131');
INSERT INTO brain VALUES ('39',
'Кавказское и азиатское жаркое.', 'кебаб',
'0', '1356528660');
INSERT INTO brain VALUES ('40',
'Торгово-политический союз
северо-немецких городов в средние века.',
'ганза', '0', '1356202583');
-- ----------------------------
--
Table structure for `brainchat`
-- ----------------------------
DROP
TABLE IF EXISTS `brainchat`;
CREATE TABLE `brainchat` (
`id` int(255)
NOT NULL auto_increment,
`user` varchar(10) default NULL,
`text`
text,
`time` varchar(10) default NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0;
--
----------------------------
-- Records of brainchat
--
----------------------------
-- ----------------------------
-- Table
structure for `brain_time`
-- ----------------------------
DROP TABLE IF
EXISTS `brain_time`;
CREATE TABLE `brain_time` (
`id` int(255) NOT NULL
auto_increment,
`time` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 PACK_KEYS=0;
--
----------------------------
-- Records of brain_time
--
----------------------------
INSERT INTO brain_time VALUES ('2',
'1356625800');
-- ----------------------------
-- Table structure for
`chat`
-- ----------------------------
DROP TABLE IF EXISTS
`chat`;
CREATE TABLE `chat` (
`id` int(11) NOT NULL auto_increment,
`account` varchar(500) NOT NULL,
`msg` varchar(500) NOT NULL,
`time`
int(11) default NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;
-- ----------------------------
-- Records of chat
--
----------------------------
-- ----------------------------
-- Table
structure for `clan`
-- ----------------------------
DROP TABLE IF EXISTS
`clan`;
CREATE TABLE `clan` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) character set cp1251 NOT NULL,
`lvl` int(11) NOT
NULL,
`exp` int(11) NOT NULL,
`kazna_gold` int(11) NOT NULL,
`power` int(11) NOT NULL default '1',
`vitality` int(11) NOT NULL
default '1',
`spirit` int(11) NOT NULL default '1',
`wit` int(11) NOT
NULL default '1',
`dexterity` int(11) NOT NULL default '1',
PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
----------------------------
-- Records of clan
--
----------------------------
-- ----------------------------
-- Table
structure for `clan_add`
-- ----------------------------
DROP TABLE IF
EXISTS `clan_add`;
CREATE TABLE `clan_add` (
`id` int(11) NOT NULL
auto_increment,
`user` int(11) NOT NULL,
`account` int(11) NOT
NULL,
`clan` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of
clan_add
-- ----------------------------
--
----------------------------
-- Table structure for `clan_chat`
--
----------------------------
DROP TABLE IF EXISTS `clan_chat`;
CREATE
TABLE `clan_chat` (
`id` int(11) NOT NULL auto_increment,
`user`
int(11) NOT NULL,
`time` int(11) NOT NULL,
`msg` varchar(255)
character set cp1251 NOT NULL,
`clan` int(11) NOT NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
----------------------------
-- Records of clan_chat
--
----------------------------
-- ----------------------------
-- Table
structure for `clan_forum_msg`
-- ----------------------------
DROP TABLE
IF EXISTS `clan_forum_msg`;
CREATE TABLE `clan_forum_msg` (
`id`
int(11) NOT NULL auto_increment,
`user` int(11) NOT NULL,
`time`
int(11) NOT NULL,
`msg` varchar(255) character set cp1251 NOT NULL,
`them` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=latin1;
-- ----------------------------
-- Records of
clan_forum_msg
-- ----------------------------
--
----------------------------
-- Table structure for `clan_forum_them`
--
----------------------------
DROP TABLE IF EXISTS
`clan_forum_them`;
CREATE TABLE `clan_forum_them` (
`id` int(11) NOT
NULL auto_increment,
`name` varchar(255) character set cp1251 NOT
NULL,
`msg` varchar(255) character set cp1251 NOT NULL,
`user`
int(11) NOT NULL,
`time` int(11) NOT NULL,
`clan` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
----------------------------
-- Records of clan_forum_them
--
----------------------------
-- ----------------------------
-- Table
structure for `dialogs`
-- ----------------------------
DROP TABLE IF
EXISTS `dialogs`;
CREATE TABLE `dialogs` (
`id` int(11) NOT NULL
auto_increment,
`talk_name` char(255) default NULL,
`talk_otvet_npc`
char(255) default NULL,
`talk_id_ref` int(11) default NULL,
`action`
char(255) default NULL,
`quest` int(11) default NULL,
`npc` int(11)
default NULL,
`quest_completed` int(11) default NULL,
`quest_need`
int(11) default NULL,
`questd` int(11) default NULL,
`quest_need_complete` int(11) default NULL,
`quest_need_be_completed`
int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;
-- ----------------------------
-- Records of
dialogs
-- ----------------------------
--
----------------------------
-- Table structure for `duel_add`
--
----------------------------
DROP TABLE IF EXISTS `duel_add`;
CREATE
TABLE `duel_add` (
`id` int(11) NOT NULL auto_increment,
`user`
int(11) default NULL,
`account` int(11) default NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
----------------------------
-- Records of duel_add
--
----------------------------
-- ----------------------------
-- Table
structure for `effect`
-- ----------------------------
DROP TABLE IF
EXISTS `effect`;
CREATE TABLE `effect` (
`id` int(11) NOT NULL
auto_increment,
`fear` int(11) default NULL,
`sleep` int(11) default
NULL,
`stun` int(11) default NULL,
`paralich` int(11) default NULL,
`effect_damage` int(11) default NULL,
`effect_hp_regen` int(11) default
NULL,
`effect_hp_regen_percent` int(11) default NULL,
`effect_time`
int(11) default NULL,
`effect_every_sec` int(11) default NULL,
`account` int(11) default NULL,
`target_type` char(255) default '0',
`target` int(11) default '0',
`skill` int(11) default NULL,
`last_cast` int(11) default NULL,
`time` int(11) default NULL,
`dota`
int(11) default NULL,
`baph` int(11) default NULL,
`baph_adding`
int(11) default NULL,
`baph_will` int(11) default NULL,
`baph_reaction` int(11) default NULL,
`baph_max_hp` int(11) default
NULL,
`baph_max_mp` int(11) default NULL,
`baph_feature_armor_weapon`
int(11) default NULL,
`baph_feature_armor_arrow` int(11) default NULL,
`baph_feature_armor_magic` int(11) default NULL,
`baph_feature_attack_weapon` int(11) default NULL,
`baph_feature_attack_arrow` int(11) default NULL,
`baph_feature_attack_magic` int(11) default NULL,
`baph_hp_regen`
int(11) default NULL,
`baph_mp_regen` int(11) default NULL,
`baph_power` int(11) default NULL,
`baph_wit` int(11) default NULL,
`baph_dexterity` int(11) default NULL,
`baph_vitality` int(11) default
NULL,
`baph_spirit` int(11) default NULL,
`debaph` int(11) default
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=86 DEFAULT
CHARSET=cp1251;
-- ----------------------------
-- Records of
effect
-- ----------------------------
--
----------------------------
-- Table structure for `forum_mess`
--
----------------------------
DROP TABLE IF EXISTS `forum_mess`;
CREATE
TABLE `forum_mess` (
`id` int(11) NOT NULL auto_increment,
`id_theme`
int(11) default NULL,
`account` int(11) default NULL,
`msg`
varchar(255) default NULL,
`time` int(11) default NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of forum_mess
--
----------------------------
-- ----------------------------
-- Table
structure for `forum_razdel`
-- ----------------------------
DROP TABLE
IF EXISTS `forum_razdel`;
CREATE TABLE `forum_razdel` (
`id` int(11)
NOT NULL auto_increment,
`name` varchar(255) default NULL,
`about`
varchar(255) default NULL,
`type` varchar(255) default '',
PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of forum_razdel
--
----------------------------
-- ----------------------------
-- Table
structure for `forum_theme`
-- ----------------------------
DROP TABLE IF
EXISTS `forum_theme`;
CREATE TABLE `forum_theme` (
`id` int(11) NOT
NULL auto_increment,
`id_razdel` int(11) default NULL,
`name`
varchar(255) default NULL,
`msg` longtext,
`time` int(11) default
NULL,
`account` int(11) default NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of forum_theme
--
----------------------------
-- ----------------------------
-- Table
structure for `friends`
-- ----------------------------
DROP TABLE IF
EXISTS `friends`;
CREATE TABLE `friends` (
`id` int(11) NOT NULL
auto_increment,
`user` int(11) NOT NULL,
`friend` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
----------------------------
-- Records of friends
--
----------------------------
-- ----------------------------
-- Table
structure for `inventory`
-- ----------------------------
DROP TABLE IF
EXISTS `inventory`;
CREATE TABLE `inventory` (
`amount` int(11) NOT
NULL,
`id` int(11) NOT NULL auto_increment,
`name` varchar(255)
default NULL,
`type` char(255) default NULL,
`feature_pover` int(11)
default NULL,
`feature_vitality` int(11) default NULL,
`feature_dexterity` int(11) default NULL,
`feature_wit` int(11) default
NULL,
`feature_spirit` int(11) default NULL,
`feature_armor_arrow`
int(11) default NULL,
`feature_armor_weapon` int(11) default NULL,
`feature_armor_magic` int(11) default NULL,
`feature_attack_arrow`
int(11) default NULL,
`feature_attack_weapon` int(11) default NULL,
`feature_attack_magic` int(11) default NULL,
`feature_hp_regen` float
default NULL,
`feature_mp_regen` float default NULL,
`cast_hp_regen`
float(11,0) default NULL,
`cast_mp_regen` float(11,0) default NULL,
`min_lvl` int(11) default NULL,
`coast` int(11) default NULL,
`cast_add_skill` int(11) default NULL,
`cast_add_feature` int(11)
default NULL,
`about` varchar(255) default NULL,
`icon` int(11)
default NULL,
`attack_min_damag` int(11) default NULL,
`attack_max_damag` int(11) default NULL,
`account` int(11) default
NULL,
`twohands` int(11) default NULL,
`subtype` varchar(255) default
NULL,
`ident_id` int(11) default NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of inventory
--
----------------------------
-- ----------------------------
-- Table
structure for `items`
-- ----------------------------
DROP TABLE IF
EXISTS `items`;
CREATE TABLE `items` (
`id` int(11) NOT NULL
auto_increment,
`name` char(11) default NULL,
`type` char(255)
default NULL,
`feature_pover` int(11) default NULL,
`feature_vitality` int(11) default NULL,
`feature_dexterity` int(11)
default NULL,
`feature_wit` int(11) default NULL,
`feature_spirit`
int(11) default NULL,
`feature_armor_arrow` int(11) default NULL,
`feature_armor_weapon` int(11) default NULL,
`feature_armor_magic`
int(11) default NULL,
`feature_attack_arrow` int(11) default NULL,
`feature_attack_weapon` int(11) default NULL,
`feature_attack_magic`
int(11) default NULL,
`feature_hp_regen` float default NULL,
`feature_mp_regen` float default NULL,
`cast_hp_regen` float(11,0)
default NULL,
`cast_mp_regen` float(11,0) default NULL,
`min_lvl`
int(11) default NULL,
`coast` int(11) default NULL,
`about`
varchar(255) default NULL,
`attack_min_damag` int(11) default NULL,
`attack_max_damag` int(11) default NULL,
`subtype` int(11) default
NULL,
`twohands` int(11) default NULL,
`icon` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT
CHARSET=cp1251;
-- ----------------------------
-- Records of items
--
----------------------------
INSERT INTO items VALUES ('1', 'Топор',
'weapon_exe', '2', '1', '0', '0', '0', '0', '0', '0', '0', '10', '0', '0',
'0', '0', '0', '2', '10', 'Ржавый ни на что не годный
топор', '5', '10', '0', '1', '1');
INSERT INTO items VALUES ('4',
'Кольчужная', 'armor_body', '1', '2', '0', '0', '0', '1', '2',
'1', '0', '0', '0', '0', '0', '0', '0', '1', '15', 'Старая
кольчужная броня...', '0', '0', '0', '0', '1');
--
----------------------------
-- Table structure for `location`
--
----------------------------
DROP TABLE IF EXISTS `location`;
CREATE
TABLE `location` (
`id` int(11) NOT NULL auto_increment,
`name`
char(255) default NULL,
`y` int(11) default NULL,
`x` int(11) default
NULL,
`img` int(11) default NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of location
--
----------------------------
INSERT INTO location VALUES ('1', 'Лес',
'1', '1', '1');
INSERT INTO location VALUES ('4', 'Лесная
тропа', '2', '1', '2');
-- ----------------------------
-- Table
structure for `lvl`
-- ----------------------------
DROP TABLE IF EXISTS
`lvl`;
CREATE TABLE `lvl` (
`id` int(11) NOT NULL auto_increment,
`exp` varchar(25) NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=51 DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of lvl
--
----------------------------
INSERT INTO lvl VALUES ('1', '0');
INSERT
INTO lvl VALUES ('2', '40');
INSERT INTO lvl VALUES ('3', '230');
INSERT
INTO lvl VALUES ('4', '360');
INSERT INTO lvl VALUES ('5', '560');
INSERT
INTO lvl VALUES ('6', '840');
INSERT INTO lvl VALUES ('7',
'1230');
INSERT INTO lvl VALUES ('8', '1730');
INSERT INTO lvl VALUES
('9', '2400');
INSERT INTO lvl VALUES ('10', '3110');
INSERT INTO lvl
VALUES ('11', '4200');
INSERT INTO lvl VALUES ('12', '5800');
INSERT INTO
lvl VALUES ('13', '7400');
INSERT INTO lvl VALUES ('14', '9000');
INSERT
INTO lvl VALUES ('15', '11000');
INSERT INTO lvl VALUES ('16',
'12400');
INSERT INTO lvl VALUES ('17', '14600');
INSERT INTO lvl VALUES
('18', '16000');
INSERT INTO lvl VALUES ('19', '23100');
INSERT INTO lvl
VALUES ('20', '36000');
INSERT INTO lvl VALUES ('21', '90000');
INSERT
INTO lvl VALUES ('22', '99000');
INSERT INTO lvl VALUES ('23',
'114000');
INSERT INTO lvl VALUES ('24', '137000');
INSERT INTO lvl
VALUES ('25', '144000');
INSERT INTO lvl VALUES ('26', '155000');
INSERT
INTO lvl VALUES ('27', '164000');
INSERT INTO lvl VALUES ('28',
'175000');
INSERT INTO lvl VALUES ('29', '184000');
INSERT INTO lvl
VALUES ('30', '214000');
INSERT INTO lvl VALUES ('31', '257000');
INSERT
INTO lvl VALUES ('32', '279000');
INSERT INTO lvl VALUES ('33',
'303000');
INSERT INTO lvl VALUES ('34', '333000');
INSERT INTO lvl
VALUES ('35', '363000');
INSERT INTO lvl VALUES ('36', '401000');
INSERT
INTO lvl VALUES ('37', '441000');
INSERT INTO lvl VALUES ('38',
'490000');
INSERT INTO lvl VALUES ('39', '547000');
INSERT INTO lvl
VALUES ('40', '615000');
INSERT INTO lvl VALUES ('41', '700000');
INSERT
INTO lvl VALUES ('42', '754000');
INSERT INTO lvl VALUES ('43',
'865000');
INSERT INTO lvl VALUES ('44', '920000');
INSERT INTO lvl
VALUES ('45', '1064000');
INSERT INTO lvl VALUES ('46',
'1119000');
INSERT INTO lvl VALUES ('47', '1228000');
INSERT INTO lvl
VALUES ('48', '1660000');
INSERT INTO lvl VALUES ('49',
'1741000');
INSERT INTO lvl VALUES ('50', '1875000');
--
----------------------------
-- Table structure for `mail`
--
----------------------------
DROP TABLE IF EXISTS `mail`;
CREATE TABLE
`mail` (
`id` int(11) NOT NULL auto_increment,
`user` int(11) default
NULL,
`to` int(11) default NULL,
`msg` char(255) default NULL,
`read` int(11) default NULL,
`time` int(11) default NULL,
PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of mail
--
----------------------------
-- ----------------------------
-- Table
structure for `mobs`
-- ----------------------------
DROP TABLE IF EXISTS
`mobs`;
CREATE TABLE `mobs` (
`id` int(11) NOT NULL auto_increment,
`name` char(255) default NULL,
`x` int(11) default NULL,
`y` int(11)
default NULL,
`x1` int(11) default NULL,
`y1` int(11) default NULL,
`hp` int(11) default NULL,
`mp` int(11) default NULL,
`power`
int(11) default NULL,
`vitality` int(11) default NULL,
`spirit`
int(11) default NULL,
`dexterity` int(11) default NULL,
`wit` int(11)
default NULL,
`exp` int(11) default NULL,
`battle` int(11) default
NULL,
`last_death` int(11) default NULL,
`death_time` int(11) default
NULL,
`agrored` int(11) default NULL,
`max_hp` int(11) default
NULL,
`max_mp` int(11) default NULL,
`min_damag` int(11) default
NULL,
`max_damag` int(11) default NULL,
`ident_id` int(11) default
NULL,
`last_damag` int(11) default NULL,
`damag_every_sec` int(11)
default NULL,
`icon` int(11) default NULL,
`drop_gold` int(11)
default NULL,
`drop_items` char(255) default NULL,
`battle_attack`
int(11) default NULL,
`lvl` int(11) NOT NULL default '1',
PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of mobs
--
----------------------------
INSERT INTO mobs VALUES ('8', 'Волк',
'1', '1', '7', '8', '30', '30', '5', '5', '1', '5', '1', '100', '506',
'1356596972', '30', '0', '30', '30', '5', '10', '1', '1356597494', '10',
'1', '100', '1:20', '24', '3');
INSERT INTO mobs VALUES ('9', 'Волк',
'1', '1', '6', '9', '30', '30', '5', '5', '1', '5', '1', '100', '0',
'1356543292', '30', '0', '30', '30', '5', '10', '1', '1356543285', '10',
'1', '100', '1:20', '24', '3');
INSERT INTO mobs VALUES ('13',
'Волчица', '1', '1', '5', '3', '181', '200', '25', '25', '25', '25',
'25', '10000', '0', '1356552378', '60', '0', '200', '200', '25', '100',
'1', '0', '10', '1', '10000', '1:30', '0', '10');
INSERT INTO mobs VALUES
('14', 'Волк Страж', '1', '1', '6', '7', '229', '300', '50', '50',
'50', '50', '50', '90000', '0', '1356624775', '10', '0', '300', '300',
'100', '100', '1', '0', '100', '1', '10000', '1:30', '0', '20');
INSERT
INTO mobs VALUES ('15', 'Дикий Волк', '1', '2', '2', '5', '150',
'100', '25', '25', '25', '25', '25', '500', '0', '1356452209', '30', '0',
'150', '100', '10', '45', '1', '1356452202', '10', '1', '500', '1:30',
'24', '5');
INSERT INTO mobs VALUES ('16', 'Волк Страж', '1',
'1', '7', '7', '300', '300', '25', '25', '25', '25', '25', '90000', '0',
'1356625660', '10', '0', '300', '300', '10', '100', '1', '1356625638',
'100', '1', '10000', '1:30', '24', '20');
--
----------------------------
-- Table structure for `msg_list`
--
----------------------------
DROP TABLE IF EXISTS `msg_list`;
CREATE
TABLE `msg_list` (
`id` int(11) NOT NULL auto_increment,
`acount`
int(11) default NULL,
`msg` longtext,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of msg_list
--
----------------------------
-- ----------------------------
-- Table
structure for `npc`
-- ----------------------------
DROP TABLE IF EXISTS
`npc`;
CREATE TABLE `npc` (
`id` int(11) NOT NULL auto_increment,
`name` char(255) default NULL,
`x` int(11) default NULL,
`y` int(11)
default NULL,
`x1` int(11) default NULL,
`y1` int(11) default NULL,
`talk` char(255) default NULL,
`icon` int(11) default NULL,
`items`
char(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM
AUTO_INCREMENT=3 DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of npc
--
----------------------------
INSERT INTO npc VALUES ('1',
'Артиллерист', '1', '1', '9', '4', 'Привет мой юный
друг! Не можешь ли ты мне помочь? На мою
хижину стали чаще нападать злобные
волки! Не мог бы ты отбиться от них, тем
самым меня спасешь от них? За это я тебя
отблагодарю!', '1', '1:100');
INSERT INTO npc VALUES ('2',
'экзо мастер', '1', '1', '10', '4', 'Приветствую, я
герой этих земель.', '1', '');
--
----------------------------
-- Table structure for `party`
--
----------------------------
DROP TABLE IF EXISTS `party`;
CREATE TABLE
`party` (
`id` int(11) NOT NULL auto_increment,
`account` int(11)
default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=cp1251;
-- ----------------------------
-- Records of party
--
----------------------------
-- ----------------------------
-- Table
structure for `party_add`
-- ----------------------------
DROP TABLE IF
EXISTS `party_add`;
CREATE TABLE `party_add` (
`id` int(11) NOT NULL
auto_increment,
`account` int(11) default NULL,
`party` int(11)
default NULL,
`user` int(11) default NULL,
`time` int(11) default
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of party_add
--
----------------------------
-- ----------------------------
-- Table
structure for `party_chat`
-- ----------------------------
DROP TABLE IF
EXISTS `party_chat`;
CREATE TABLE `party_chat` (
`id` int(11) NOT NULL
auto_increment,
`account` int(11) default NULL,
`msg` varchar(500)
default NULL,
`time` int(11) default NULL,
`party` int(11) default
NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of party_chat
--
----------------------------
-- ----------------------------
-- Table
structure for `quest`
-- ----------------------------
DROP TABLE IF
EXISTS `quest`;
CREATE TABLE `quest` (
`id` int(11) NOT NULL
auto_increment,
`name` char(255) default NULL,
`about` char(255)
default NULL,
`task` int(11) default NULL,
`kill_mob` int(11) default
NULL,
`kill_mob_col` int(11) default NULL,
`items` int(11) NOT NULL
default '0',
`gold` int(11) NOT NULL default '0',
`exp` int(11) NOT
NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9
DEFAULT CHARSET=cp1251;
-- ----------------------------
-- Records of
quest
-- ----------------------------
INSERT INTO quest VALUES ('5',
'Убить волков!', 'Убейте 5 волков', '0', '1', '5',
'1', '500', '500');
-- ----------------------------
-- Table structure
for `quests`
-- ----------------------------
DROP TABLE IF EXISTS
`quests`;
CREATE TABLE `quests` (
`id` int(11) NOT NULL
auto_increment,
`quest` int(11) default NULL,
`account` int(11)
default NULL,
`completed` int(11) default '0',
`kill_mob` int(11)
default NULL,
`kill_mob_col` int(11) default NULL,
`task` int(11)
default NULL,
`task_with` int(11) default NULL,
`res_need` int(11)
default NULL,
`res_need_col` int(11) default NULL,
`time_completed`
int(11) default '0',
`kill_mob_col_kill` int(11) default '0',
`complet` int(11) default '0',
`gold` int(11) NOT NULL default '0',
`exp` int(11) NOT NULL default '0',
`items` int(11) NOT NULL default
'0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of quests
--
----------------------------
-- ----------------------------
-- Table
structure for `skill`
-- ----------------------------
DROP TABLE IF
EXISTS `skill`;
CREATE TABLE `skill` (
`id` int(11) NOT NULL
auto_increment,
`name` char(255) default NULL,
`class` char(255)
default NULL,
`specialization` int(11) default NULL,
`damage` int(11)
default NULL,
`heal` int(11) default NULL,
`fear` int(11) default
NULL,
`stun` int(11) default NULL,
`sleep` int(11) default NULL,
`paralich` int(11) default NULL,
`effect_damage` int(11) default NULL,
`effect_hp_regen` int(11) default NULL,
`no_fear` int(11) default
NULL,
`no_stun` int(11) default NULL,
`no_sleep` int(11) default
NULL,
`no_paralich` int(11) default NULL,
`about` char(255) default
NULL,
`hp_regen_percent` int(11) default NULL,
`effect_hp_regen_percent` int(11) default NULL,
`account` int(11)
default NULL,
`type` char(255) default NULL,
`res_time` int(11)
default NULL,
`last_cast` int(11) default NULL,
`icon` int(11)
default NULL,
`effect_time` int(11) default NULL,
`effect_every_sec`
int(11) default NULL,
`dota` int(11) default NULL,
`baph` int(11)
default NULL,
`baph_adding` int(11) default NULL,
`baph_will` int(11)
default NULL,
`baph_reaction` int(11) default NULL,
`baph_max_hp`
int(11) default NULL,
`baph_max_mp` int(11) default NULL,
`baph_feature_armor_weapon` int(11) default NULL,
`baph_feature_armor_arrow` int(11) default NULL,
`baph_feature_armor_magic` int(11) default NULL,
`baph_feature_atack_weapon` int(11) default NULL,
`baph_feature_attack_arrow` int(11) default NULL,
`baph_feature_attack_magic` int(11) default NULL,
`baph_hp_regen`
int(11) default NULL,
`baph_mp_regen` int(11) default NULL,
`baph_power` int(11) default NULL,
`baph_wit` int(11) default NULL,
`baph_dexterity` int(11) default NULL,
`baph_vitality` int(11) default
NULL,
`baph_spirit` int(11) default NULL,
`debaph` int(11) default
NULL,
`ident_id` int(11) default NULL,
`mp_need_from_cast` int(11)
default NULL,
`lvl` int(11) default NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251;
--
----------------------------
-- Records of skill
--
----------------------------
-- ----------------------------
-- Table
structure for `skills`
-- ----------------------------
DROP TABLE IF
EXISTS `skills`;
CREATE TABLE `skills` (
`id` int(11) NOT NULL
auto_increment,
`name` char(255) default NULL,
`class` char(255)
default NULL,
`specialization` int(11) default NULL,
`damage` int(11)
default NULL,
`heal` int(11) default NULL,
`fear` int(11) default
NULL,
`stun` int(11) default NULL,
`sleep` int(11) default NULL,
`paralich` int(11) default NULL,
`effect_damage` int(11) default NULL,
`effect_hp_regen` int(11) default NULL,
`no_fear` int(11) default
NULL,
`no_stun` int(11) default NULL,
`no_sleep` int(11) default
NULL,
`no_paralich` int(11) default NULL,
`about` char(255) default
NULL,
`hp_regen_percent` int(11) default NULL,
`effect_hp_regen_percent` int(11) default NULL,
`type` char(255) default
NULL,
`res_time` int(11) default NULL,
`icon` int(11) default NULL,
`effect_time` int(11) default NULL,
`effect_every_sec` int(11) default
NULL,
`dota` int(11) default NULL,
`baph` int(11) default NULL,
`baph_adding` int(11) default NULL,
`baph_will` int(11) default NULL,
`baph_reaction` int(11) default NULL,
`baph_max_hp` int(11) default
NULL,
`baph_max_mp` int(11) default NULL,
`baph_feature_armor_weapon`
int(11) default NULL,
`baph_feature_armor_arrow` int(11) default NULL,
`baph_feature_armor_magic` int(11) default NULL,
`baph_feature_attack_weapon` int(11) default NULL,
`baph_feature_attack_arrow` int(11) default NULL,
`baph_feature_attack_magic` int(11) default NULL,
`baph_hp_regen`
int(11) default NULL,
`baph_mp_regen` int(11) default NULL,
`baph_power` int(11) default NULL,
`baph_wit` int(11) default NULL,
`baph_dexterity` int(11) default NULL,
`baph_vitality` int(11) default
NULL,
`baph_spirit` int(11) default NULL,
`debaph` int(11) default
NULL,
`mp_need_from_cast` int(11) default NULL,
`ident_id` int(11)
default NULL,
`lvl` int(11) default NULL,
`min_lvl` int(11) default
NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT
CHARSET=cp1251;
-- ----------------------------
-- Records of
skills
-- ----------------------------
--
----------------------------
-- Table structure for `sublocation`
--
----------------------------
DROP TABLE IF EXISTS `sublocation`;
CREATE
TABLE `sublocation` (
`id` int(11) NOT NULL auto_increment,
`name`
char(255) default NULL,
`x` int(11) default NULL,
`y` int(11) default
NULL,
`x1` int(11) default NULL,
`y1` int(11) default NULL,
`x_tp`
int(11) default NULL,
`y_tp` int(11) default NULL,
`x1_tp` int(11)
default NULL,
`y1_tp` int(11) default NULL,
`cant_go` int(11) default
'0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=136 DEFAULT
CHARSET=cp1251;
-- ----------------------------
-- Records of
sublocation
-- ----------------------------
INSERT INTO sublocation
VALUES ('1', 'Тропа', '1', '1', '7', '7', '0', '0', '0', '0',
'0');
INSERT INTO sublocation VALUES ('2', 'Тропа', '1', '1', '7',
'6', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('3',
'Камень', '1', '1', '7', '5', '0', '0', '0', '0', '1');
INSERT INTO
sublocation VALUES ('4', 'Тропа', '1', '1', '6', '6', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('6', 'Тропа', '1', '1',
'6', '7', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('7',
'Тропа', '1', '1', '6', '8', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('8', 'Тропа', '1', '1', '6', '5', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('9', 'Тропа', '1', '1',
'6', '9', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('10',
'Тропа', '1', '1', '6', '10', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('91', 'Тропа', '1', '1', '10', '5', '1', '2', '1',
'5', '0');
INSERT INTO sublocation VALUES ('90', 'Тропа', '1', '1',
'9', '6', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('14',
'Тропа', '1', '1', '7', '8', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('15', 'Тропа', '1', '1', '8', '6', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('16', 'Тропа', '1', '1',
'8', '5', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('17',
'Тропа', '1', '1', '5', '6', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('18', 'Тропа', '1', '1', '5', '5', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('21', 'Тропа', '1', '1',
'7', '9', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('22',
'Тропа', '1', '1', '7', '10', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('23', 'Лес', '1', '1', '5', '7', '0', '0', '0', '0',
'0');
INSERT INTO sublocation VALUES ('28', 'Тропа', '1', '1', '5',
'1', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('29',
'Тропа', '1', '1', '6', '1', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('30', 'Тропа', '1', '1', '6', '2', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('31', 'Тропа', '1', '1',
'5', '2', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('32',
'Тропа', '1', '1', '6', '3', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('33', 'Тропа', '1', '1', '6', '4', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('34', 'Тропа', '1', '1',
'5', '4', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('35',
'Тропа', '1', '1', '5', '3', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('36', 'Тропа', '1', '1', '8', '4', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('37', 'Тропа', '1', '1',
'9', '4', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('39',
'Тропа', '1', '1', '5', '8', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('40', 'Тропа', '1', '1', '5', '9', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('41', 'Тропа', '1', '1',
'5', '10', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('42',
'Тропа', '1', '1', '7', '4', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('43', 'Тропа', '1', '1', '9', '5', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('46', 'Тропа', '1', '1',
'10', '6', '1', '2', '1', '6', '0');
INSERT INTO sublocation VALUES ('47',
'Тропа', '1', '1', '10', '4', '1', '2', '1', '4', '0');
INSERT INTO
sublocation VALUES ('92', 'Тропа', '1', '2', '1', '4', '1', '1', '10',
'4', '0');
INSERT INTO sublocation VALUES ('93', 'Тропа', '1', '2',
'2', '4', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('94',
'Тропа', '1', '2', '3', '4', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('95', 'Тропа', '1', '2', '4', '4', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('96', 'Тропа', '1', '2',
'5', '4', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('97',
'Тропа', '1', '2', '1', '5', '1', '1', '10', '5', '0');
INSERT INTO
sublocation VALUES ('98', 'Тропа', '1', '2', '2', '5', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('99', 'Тропа', '1', '2',
'1', '6', '1', '1', '10', '6', '0');
INSERT INTO sublocation VALUES
('100', 'Тропа', '1', '2', '3', '5', '0', '0', '0', '0', '0');
INSERT
INTO sublocation VALUES ('101', 'Тропа', '1', '2', '4', '5', '0', '0',
'0', '0', '0');
INSERT INTO sublocation VALUES ('102', 'Тропа', '1',
'2', '2', '6', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES
('103', 'Тропа', '1', '2', '3', '6', '0', '0', '0', '0', '0');
INSERT
INTO sublocation VALUES ('104', 'Тропа', '1', '2', '4', '6', '0', '0',
'0', '0', '0');
INSERT INTO sublocation VALUES ('105', 'Тропа', '1',
'2', '5', '6', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES
('106', 'Тропа', '1', '2', '5', '5', '0', '0', '0', '0', '0');
INSERT
INTO sublocation VALUES ('107', 'Тропа', '1', '2', '6', '5', '0', '0',
'0', '0', '0');
INSERT INTO sublocation VALUES ('108', 'Тропа', '1',
'2', '6', '6', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES
('109', 'Тропа', '1', '2', '7', '5', '0', '0', '0', '0', '0');
INSERT
INTO sublocation VALUES ('110', 'Тропа', '1', '2', '8', '4', '0', '0',
'0', '0', '0');
INSERT INTO sublocation VALUES ('111', 'Тропа', '1',
'2', '7', '6', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES
('112', 'Тропа', '1', '2', '8', '5', '0', '0', '0', '0', '0');
INSERT
INTO sublocation VALUES ('113', 'Тропа', '1', '2', '8', '6', '0', '0',
'0', '0', '0');
INSERT INTO sublocation VALUES ('114', 'Тропа', '1',
'2', '9', '5', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES
('115', 'Тропа', '1', '2', '9', '6', '0', '0', '0', '0', '0');
INSERT
INTO sublocation VALUES ('116', 'Тропа', '1', '2', '10', '5', '0',
'0', '0', '0', '0');
INSERT INTO sublocation VALUES ('117', 'Тропа',
'1', '2', '9', '4', '0', '0', '0', '0', '0');
INSERT INTO sublocation
VALUES ('118', 'Тропа', '1', '2', '10', '6', '0', '0', '0', '0',
'0');
INSERT INTO sublocation VALUES ('119', 'Тропа', '1', '2', '10',
'4', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('120',
'Тропа', '1', '2', '5', '7', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('121', 'Тропа', '1', '2', '6', '7', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('122', 'Тропа', '1', '2',
'7', '7', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('123',
'Тропа', '1', '2', '5', '8', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('124', 'Тропа', '1', '2', '6', '8', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('125', 'Тропа', '1', '2',
'7', '8', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('126',
'Тропа', '1', '2', '5', '9', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('127', 'Тропа', '1', '2', '6', '9', '0', '0', '0',
'0', '0');
INSERT INTO sublocation VALUES ('128', 'Тропа', '1', '2',
'7', '9', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('129',
'Тропа', '1', '2', '5', '10', '0', '0', '0', '0', '0');
INSERT INTO
sublocation VALUES ('130', 'Тропа', '1', '2', '6', '10', '0', '0',
'0', '0', '0');
INSERT INTO sublocation VALUES ('131', 'Тропа', '1',
'2', '7', '10', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES
('132', 'Лес', '1', '1', '4', '1', '0', '0', '0', '0', '0');
INSERT
INTO sublocation VALUES ('133', 'Лес', '1', '1', '3', '1', '0', '0',
'0', '0', '0');
INSERT INTO sublocation VALUES ('134', 'Лес', '1', '1',
'2', '1', '0', '0', '0', '0', '0');
INSERT INTO sublocation VALUES ('135',
'Лес', '1', '1', '1', '1', '0', '0', '0', '0', '0');