
-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Дек 27 2014 г., 13:54
-- Версия сервера: 5.1.69
-- Версия PHP: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- База данных: `u183897047_era`
--

-- --------------------------------------------------------

--
-- Структура таблицы `antihak`
--

CREATE TABLE IF NOT EXISTS `antihak` (
  `id` int(11) NOT NULL,
  `ip` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `brauser` varchar(55) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Структура таблицы `arena`
--

CREATE TABLE IF NOT EXISTS `arena` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `enemy` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `xod` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tip` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ltime` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `block` int(30) NOT NULL,
  `udar` int(30) NOT NULL,
  `mag` int(11) NOT NULL,
  `pk` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `arenalog`
--

CREATE TABLE IF NOT EXISTS `arenalog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `oponent` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `log` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `money` int(11) NOT NULL,
  `exp` int(25) NOT NULL,
  `myudar` int(10) NOT NULL,
  `userudar` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `arti`
--

CREATE TABLE IF NOT EXISTS `arti` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `kompl` int(11) NOT NULL,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cena` int(11) NOT NULL,
  `hp` int(11) NOT NULL,
  `mp` int(11) NOT NULL,
  `krit` int(11) NOT NULL,
  `ukrit` int(11) NOT NULL,
  `sila` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `prot` int(11) NOT NULL,
  `klas` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `nlvl` int(11) NOT NULL,
  `img` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `auction`
--

CREATE TABLE IF NOT EXISTS `auction` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lat_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `what` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `give` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `kol` int(20) NOT NULL,
  `cena` int(11) NOT NULL,
  `mycena` int(20) NOT NULL,
  `time` int(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `aurs`
--

CREATE TABLE IF NOT EXISTS `aurs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `actimer` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `ban`
--

CREATE TABLE IF NOT EXISTS `ban` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `admin` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `ban_time` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `block` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `boss`
--

CREATE TABLE IF NOT EXISTS `boss` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lvl` int(11) NOT NULL,
  `hp` int(11) NOT NULL,
  `hpall` int(11) NOT NULL,
  `uron` int(11) NOT NULL,
  `prot` int(11) NOT NULL,
  `krit` int(11) NOT NULL,
  `ukrit` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `money` int(11) NOT NULL,
  `exp` int(11) NOT NULL,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `oponent` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `drop` int(11) NOT NULL,
  `rang` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Дамп данных таблицы `boss`
--

INSERT INTO `boss` (`id`, `name`, `lvl`, `hp`, `hpall`, `uron`, `prot`, `krit`, `ukrit`, `lovk`, `money`, `exp`, `tip`, `status`, `oponent`, `image`, `drop`, `rang`) VALUES
(1, 'Огненный Пёс', 5, 5, 5, 5, 5, 100, 100, 5, 0, 150, 'boss', 'on', '', '', 0, 0),
(2, 'Рыцарь смерти', 10, 10, 10, 10, 10, 100, 100, 10, 0, 135, 'boss', 'on', '', '', 0, 0),
(3, 'Палач', 15, 15, 15, 15, 15, 100, 100, 15, 0, 120, 'boss', 'on', '', '', 0, 0),
(4, 'Горгулья', 20, 20, 20, 20, 20, 100, 100, 20, 0, 105, 'boss', 'on', '', '', 0, 0),
(5, 'Змий', 25, 25, 25, 25, 25, 100, 100, 25, 0, 90, 'boss', 'on', '', '', 0, 0),
(6, 'Минотавр', 30, 30, 30, 30, 30, 100, 100, 30, 0, 75, 'boss', 'on', '', '', 0, 0),
(7, 'Повелитель огня', 35, 35, 35, 35, 35, 100, 100, 35, 0, 60, 'boss', 'on', '', '', 0, 0),
(8, 'Всадник апокалипсиса', 40, 40, 40, 40, 40, 100, 100, 40, 0, 45, 'boss', 'on', '', '', 0, 0),
(9, 'Горлум', 45, 45, 45, 45, 45, 100, 100, 45, 0, 30, 'boss', 'on', '', '', 0, 0),
(10, 'Варлорд', 50, 50, 50, 50, 50, 100, 100, 50, 0, 15, 'boss', 'on', '', '', 0, 0);

-- --------------------------------------------------------

--
-- Структура таблицы `boy_game`
--

CREATE TABLE IF NOT EXISTS `boy_game` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `type` set('start','game','end') NOT NULL DEFAULT 'start',
  `win` varchar(8) NOT NULL DEFAULT '0',
  `time` varchar(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `boy_list`
--

CREATE TABLE IF NOT EXISTS `boy_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `game` int(11) NOT NULL,
  `text` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `boy_users`
--

CREATE TABLE IF NOT EXISTS `boy_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `game` int(11) NOT NULL DEFAULT '0',
  `kom` set('1','2') NOT NULL,
  `dead` int(1) NOT NULL DEFAULT '0',
  `user` int(11) NOT NULL DEFAULT '0',
  `end` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `clan`
--

CREATE TABLE IF NOT EXISTS `clan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lider` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `money` int(11) NOT NULL,
  `almaz` int(11) NOT NULL,
  `emblema` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `logo` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `desk` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `site` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `set_m` int(11) NOT NULL,
  `set_d` int(11) NOT NULL,
  `level` int(11) NOT NULL,
  `reiting` varchar(11) NOT NULL,
  `max` int(11) NOT NULL,
  `exp` int(19) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `clanchat`
--

CREATE TABLE IF NOT EXISTS `clanchat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clan` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `msg` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `usr` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `clanlog`
--

CREATE TABLE IF NOT EXISTS `clanlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clan` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `msg` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(50) NOT NULL,
  `log` varchar(10) NOT NULL,
  `user` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `clanwar`
--

CREATE TABLE IF NOT EXISTS `clanwar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clan` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `timeout` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `clan_buildings`
--

CREATE TABLE IF NOT EXISTS `clan_buildings` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `clan` varchar(255) NOT NULL,
  `tip` varchar(255) NOT NULL,
  `bonus` varchar(255) NOT NULL,
  `timer` int(255) NOT NULL,
  `lvl` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `clan_user_time`
--

CREATE TABLE IF NOT EXISTS `clan_user_time` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `clan` varchar(255) NOT NULL,
  `user` varchar(255) NOT NULL,
  `tip` varchar(255) NOT NULL,
  `time` int(255) NOT NULL,
  `bonus` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `domination`
--

CREATE TABLE IF NOT EXISTS `domination` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `white` int(11) NOT NULL,
  `black` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Дамп данных таблицы `domination`
--

INSERT INTO `domination` (`id`, `white`, `black`) VALUES
(1, 132, 68);

-- --------------------------------------------------------

--
-- Структура таблицы `dost`
--

CREATE TABLE IF NOT EXISTS `dost` (
  `id` int(10) NOT NULL,
  `usr` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `glad` int(11) NOT NULL,
  `shah` int(11) NOT NULL,
  `dob` int(11) NOT NULL,
  `ohot` int(11) NOT NULL,
  `rud` int(11) NOT NULL,
  `proshah` int(11) NOT NULL,
  `prorud` int(11) NOT NULL,
  `prodob` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Структура таблицы `dozor`
--

CREATE TABLE IF NOT EXISTS `dozor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `over` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `last` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `dlit` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `drop`
--

CREATE TABLE IF NOT EXISTS `drop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lat_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `what` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `give` varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cena` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Дамп данных таблицы `drop`
--

INSERT INTO `drop` (`id`, `name`, `lat_name`, `tip`, `what`, `give`, `cena`) VALUES
(1, 'Железо', 'jelezo', 'res', 'res', '50', 10),
(2, 'Оникс', 'serebro', 'res', 'res', '50', 10),
(3, 'Нефрит', 'nefrit', 'res', 'res', '50', 10),
(4, 'Обсидиан', 'obsidian', 'res', 'res', '50', 10),
(5, 'Камень', 'kamen', 'res', 'res', '50', 10),
(6, 'Молоток ремонта', 'remont', 'artefact', 'res', '10', 100),
(7, 'Свиток закалки', 'zakal', 'artefact', 'res', '10', 100);

-- --------------------------------------------------------

--
-- Структура таблицы `drop_oz`
--

CREATE TABLE IF NOT EXISTS `drop_oz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `exp` int(11) NOT NULL,
  `expmax` int(11) NOT NULL,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lat_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `what` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `give` varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cena` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `duel`
--

CREATE TABLE IF NOT EXISTS `duel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `minlvl` int(11) NOT NULL,
  `maxlvl` int(11) NOT NULL,
  `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `zav` int(11) NOT NULL,
  `zavmax` int(11) NOT NULL,
  `time` int(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=176 ;

-- --------------------------------------------------------

--
-- Структура таблицы `duellog`
--

CREATE TABLE IF NOT EXISTS `duellog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `uron` int(25) NOT NULL,
  `opon` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `umen` int(11) NOT NULL,
  `timer` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `fortuna`
--

CREATE TABLE IF NOT EXISTS `fortuna` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `kapital` int(20) NOT NULL,
  `proig` int(20) NOT NULL,
  `viig` int(20) NOT NULL,
  `alm` int(20) NOT NULL,
  `time` int(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `forum_cats`
--

CREATE TABLE IF NOT EXISTS `forum_cats` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `id_cat` int(3) NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- Дамп данных таблицы `forum_cats`
--

INSERT INTO `forum_cats` (`id`, `id_cat`, `name`) VALUES
(1, 0, 'Новости игры'),
(2, 0, 'Помощь по игре'),
(3, 0, 'Разговоры тут'),
(4, 0, 'Предложения'),
(5, 0, 'Вопросы по оплате'),
(6, 0, 'Ошибки'),
(7, 0, 'Кланы Титанов'),
(8, 0, 'Кланы Богов');

-- --------------------------------------------------------

--
-- Структура таблицы `forum_msg`
--

CREATE TABLE IF NOT EXISTS `forum_msg` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `id_cat` int(3) NOT NULL,
  `id_topic` int(5) NOT NULL,
  `text` text NOT NULL,
  `login` varchar(20) DEFAULT NULL,
  `time` varchar(10) NOT NULL,
  `edit_login` varchar(20) NOT NULL,
  `edit_time` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `forum_topics`
--

CREATE TABLE IF NOT EXISTS `forum_topics` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `id_cat` int(3) NOT NULL,
  `title` varchar(50) DEFAULT NULL,
  `authour` varchar(20) NOT NULL,
  `time` varchar(10) NOT NULL,
  `closed` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `guest`
--

CREATE TABLE IF NOT EXISTS `guest` (
  `ip` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `laikas` int(20) DEFAULT NULL,
  `brauser` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ip`),
  KEY `laikas` (`laikas`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Структура таблицы `invite`
--

CREATE TABLE IF NOT EXISTS `invite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `clan` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `item_aura`
--

CREATE TABLE IF NOT EXISTS `item_aura` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `ava` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `lovk` int(20) NOT NULL,
  `cena` int(11) NOT NULL,
  `acena` int(11) NOT NULL,
  `sila` int(11) NOT NULL,
  `protect` int(11) NOT NULL,
  `hp` int(11) NOT NULL,
  `mp` int(11) NOT NULL,
  `krit` int(11) NOT NULL,
  `ukrit` int(11) NOT NULL,
  `nlvl` int(11) NOT NULL,
  `actime` int(32) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `karma`
--

CREATE TABLE IF NOT EXISTS `karma` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `from` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `komentarai`
--

CREATE TABLE IF NOT EXISTS `komentarai` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `nick` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `komentaras` text COLLATE utf8_unicode_ci NOT NULL,
  `kada` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `komplekt`
--

CREATE TABLE IF NOT EXISTS `komplekt` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lvl` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Дамп данных таблицы `komplekt`
--

INSERT INTO `komplekt` (`id`, `name`, `lvl`) VALUES
(1, 'Комплект Искателя', 1),
(2, 'Комплект Новичка', 1),
(3, 'Комплект Ученика', 6),
(4, 'Комплект Ополченца', 6),
(5, 'Комплект Воина', 24),
(6, 'Комплект Рыцаря', 24),
(7, 'Комплект Берсерка', 48),
(8, 'Комплект Паладина', 48),
(9, 'Комплект Ассасина', 200),
(10, 'Комплект Атланта', 200),
(11, 'Комплект Олимпийца', 250),
(12, 'Комплект Ветерана', 250);

-- --------------------------------------------------------

--
-- Структура таблицы `library`
--

CREATE TABLE IF NOT EXISTS `library` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `text` text,
  `author` varchar(255) DEFAULT NULL,
  `time` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `limit`
--

CREATE TABLE IF NOT EXISTS `limit` (
  `usr` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `almaz` int(30) NOT NULL,
  `bank` int(30) NOT NULL,
  `clan` int(20) NOT NULL,
  `mob` int(20) NOT NULL,
  `mobtime` int(11) NOT NULL,
  `gifttime` int(11) NOT NULL,
  `giftday` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Структура таблицы `log`
--

CREATE TABLE IF NOT EXISTS `log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `text` text COLLATE utf8_unicode_ci NOT NULL,
  `kto` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `place` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `timer` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `logi`
--

CREATE TABLE IF NOT EXISTS `logi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `log` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `userup` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `userout` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `text` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(25) CHARACTER SET cp1250 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `mag`
--

CREATE TABLE IF NOT EXISTS `mag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `yarost` int(5) NOT NULL,
  `bronya` int(5) NOT NULL,
  `vihr` int(5) NOT NULL,
  `stoika` int(5) NOT NULL,
  `vihr2` int(5) NOT NULL,
  `cena` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `mdrop`
--

CREATE TABLE IF NOT EXISTS `mdrop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lat_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `what` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `give` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cena` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=14 ;

--
-- Дамп данных таблицы `mdrop`
--

INSERT INTO `mdrop` (`id`, `name`, `lat_name`, `tip`, `what`, `give`, `cena`) VALUES
(1, 'HP-10', 'HP-10', 'elexir', 'hp', '10', 10),
(2, 'MP-10', 'MP-10', 'elexir', 'hp', '10', 10),
(3, 'HP-15', 'HP-15', 'elexir', 'hp', '15', 15),
(4, 'MP-15', 'MP-15', 'elexir', 'mp', '15', 15),
(5, 'Серебро', 'serebro', 'res', 'res', '0', 10),
(6, 'Нефрит', 'nefrit', 'res', 'res', '0', 10),
(7, 'Обсидиан', 'obsidian', 'res', 'res', '0', 10),
(8, 'Камень', 'kamen', 'res', 'res', '0', 10),
(9, 'Железо', 'jelezo', 'res', 'res', '0', 10),
(10, 'Молоток ремонта', 'remont', 'res', 'prot', '10', 100),
(11, 'Свиток закалки', 'zakal', 'artefact', 'zakal', '10', 100),
(12, 'Лунный кристал', 'luniy_kristal', 'artefact', 'res', '0', 100),
(13, 'Элемент огня', 'fire_element', 'artefact', 'res', '0', 100);

-- --------------------------------------------------------

--
-- Структура таблицы `mesto`
--

CREATE TABLE IF NOT EXISTS `mesto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `place` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `city` int(11) NOT NULL,
  `x` int(3) NOT NULL,
  `y` int(3) NOT NULL,
  `towers` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `msg_i`
--

CREATE TABLE IF NOT EXISTS `msg_i` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_from` varchar(25) NOT NULL,
  `user_to` varchar(25) DEFAULT NULL,
  `time` varchar(25) DEFAULT NULL,
  `mail_msg` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `msg_r`
--

CREATE TABLE IF NOT EXISTS `msg_r` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_from` varchar(25) NOT NULL,
  `user_to` varchar(25) DEFAULT NULL,
  `time` varchar(25) DEFAULT NULL,
  `read` tinyint(1) DEFAULT NULL,
  `mail_msg` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `msg_users`
--

CREATE TABLE IF NOT EXISTS `msg_users` (
  `user_id` int(10) NOT NULL,
  `contact` varchar(255) NOT NULL,
  `ignor` varchar(255) CHARACTER SET cp1250 NOT NULL,
  `time` varchar(25) NOT NULL,
  PRIMARY KEY (`user_id`,`contact`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

-- --------------------------------------------------------

--
-- Структура таблицы `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `text` text NOT NULL,
  `nick` varchar(20) NOT NULL,
  `time` varchar(25) DEFAULT NULL,
  `read` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

-- --------------------------------------------------------

--
-- Структура таблицы `online`
--

CREATE TABLE IF NOT EXISTS `online` (
  `usr` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `laikas` int(20) DEFAULT NULL,
  `lvl` int(11) NOT NULL,
  PRIMARY KEY (`usr`),
  KEY `laikas` (`laikas`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Структура таблицы `out`
--

CREATE TABLE IF NOT EXISTS `out` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `timeout` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `partner`
--

CREATE TABLE IF NOT EXISTS `partner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `site` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `zaschit` int(11) NOT NULL,
  `nezaschit` int(11) NOT NULL,
  `balans` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `wmr` varchar(13) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `pit`
--

CREATE TABLE IF NOT EXISTS `pit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `hozyain` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `old` int(11) NOT NULL,
  `korm` int(20) NOT NULL,
  `lvl` int(11) NOT NULL,
  `dies` int(11) NOT NULL,
  `skill` int(11) NOT NULL,
  `hp` int(11) NOT NULL,
  `hpall` int(11) NOT NULL,
  `exp` int(11) NOT NULL,
  `ataka` int(11) NOT NULL,
  `mataka` int(11) NOT NULL,
  `nabros` int(11) NOT NULL,
  `mlovk` int(11) NOT NULL,
  `cena` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `ava` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `nlvl` int(11) NOT NULL,
  `eda` int(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `pitomec`
--

CREATE TABLE IF NOT EXISTS `pitomec` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ava` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `old` int(11) NOT NULL,
  `hp` int(25) NOT NULL,
  `hpall` int(11) NOT NULL,
  `ataka` int(11) NOT NULL,
  `mataka` int(11) NOT NULL,
  `nabros` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `mlovk` int(11) NOT NULL,
  `cena` int(11) NOT NULL,
  `lvl` int(11) NOT NULL,
  `nlvl` int(10) NOT NULL,
  `exp` int(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=20 ;

--
-- Дамп данных таблицы `pitomec`
--

INSERT INTO `pitomec` (`id`, `ava`, `name`, `old`, `hp`, `hpall`, `ataka`, `mataka`, `nabros`, `lovk`, `mlovk`, `cena`, `lvl`, `nlvl`, `exp`) VALUES
(17, 'volk1.png', 'Волка', 1, 50, 50, 0, 50, 0, 0, 50, 1250, 0, 0, 0),
(18, 'volk2.png', 'Волк', 2, 50, 50, 25, 50, 0, 25, 50, 2500, 20, 0, 0),
(19, 'volk3.png', 'Волк', 3, 50, 50, 50, 50, 0, 50, 50, 5000, 40, 0, 0);

-- --------------------------------------------------------

--
-- Структура таблицы `pk`
--

CREATE TABLE IF NOT EXISTS `pk` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `enemy` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `napal` int(11) NOT NULL,
  `xod` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ltime` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `block` int(11) NOT NULL,
  `udar` int(11) NOT NULL,
  `mag` int(11) NOT NULL,
  `pk` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `price`
--

CREATE TABLE IF NOT EXISTS `price` (
  `id` int(11) NOT NULL,
  `sum` varchar(25) NOT NULL,
  `id_shop` int(25) NOT NULL,
  `v1` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Структура таблицы `referer`
--

CREATE TABLE IF NOT EXISTS `referer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `brauser` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ref` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `day` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `regenerator`
--

CREATE TABLE IF NOT EXISTS `regenerator` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `last` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `relict`
--

CREATE TABLE IF NOT EXISTS `relict` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `a1` int(1) NOT NULL,
  `a2` int(1) NOT NULL,
  `a3` int(1) NOT NULL,
  `a4` int(1) NOT NULL,
  `b1` int(1) NOT NULL,
  `b2` int(1) NOT NULL,
  `b3` int(1) NOT NULL,
  `b4` int(1) NOT NULL,
  `c1` int(1) NOT NULL,
  `c2` int(1) NOT NULL,
  `c3` int(1) NOT NULL,
  `c4` int(1) NOT NULL,
  `d1` int(1) NOT NULL,
  `d2` int(1) NOT NULL,
  `d3` int(1) NOT NULL,
  `d4` int(1) NOT NULL,
  `e1` int(1) NOT NULL,
  `e2` int(1) NOT NULL,
  `e3` int(1) NOT NULL,
  `e4` int(1) NOT NULL,
  `f1` int(1) NOT NULL,
  `f2` int(1) NOT NULL,
  `f3` int(1) NOT NULL,
  `f4` int(1) NOT NULL,
  `g1` int(1) NOT NULL,
  `g2` int(1) NOT NULL,
  `g3` int(1) NOT NULL,
  `g4` int(1) NOT NULL,
  `h1` int(1) NOT NULL,
  `h2` int(1) NOT NULL,
  `h3` int(1) NOT NULL,
  `h4` int(1) NOT NULL,
  `i1` int(1) NOT NULL,
  `i2` int(1) NOT NULL,
  `i3` int(1) NOT NULL,
  `i4` int(1) NOT NULL,
  `j1` int(1) NOT NULL,
  `j2` int(1) NOT NULL,
  `j3` int(1) NOT NULL,
  `j4` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `res`
--

CREATE TABLE IF NOT EXISTS `res` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lat_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `what` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `give` varchar(400) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `kol` int(11) NOT NULL,
  `cena` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `rydnik`
--

CREATE TABLE IF NOT EXISTS `rydnik` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `over` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `last` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `udar` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `set`
--

CREATE TABLE IF NOT EXISTS `set` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(35) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `pol` varchar(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `familu` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `icq` int(11) NOT NULL,
  `data` int(11) NOT NULL,
  `strana` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `gorod` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `brauser` varchar(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `referer` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `prim` varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `pred` int(11) NOT NULL,
  `site` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `part` int(1) NOT NULL,
  `city` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `music` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `clan` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `int` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `inf` varchar(110) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `datareg` int(20) NOT NULL,
  `cid` int(11) NOT NULL,
  `graph` int(1) NOT NULL,
  `ref` varchar(25) NOT NULL,
  `dclan` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `friend` int(11) NOT NULL,
  `fon` varchar(25) NOT NULL,
  `avatar` varchar(29) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `vip` varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `viptime` int(29) NOT NULL,
  `lvl` int(11) NOT NULL,
  `hp` int(11) NOT NULL,
  `mp` int(11) NOT NULL,
  `sila` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `prot` int(11) NOT NULL,
  `ukrit` int(11) NOT NULL,
  `arenainv` int(3) NOT NULL,
  `invmax` int(3) NOT NULL,
  `arenaloses` int(11) NOT NULL,
  `arenawins` int(11) NOT NULL,
  `artime` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `shahter` int(2) NOT NULL,
  `kuznec` int(3) NOT NULL,
  `razb` int(2) NOT NULL,
  `sunduki` int(30) NOT NULL,
  `sunduk` int(11) DEFAULT NULL,
  `allwins` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `shop`
--

CREATE TABLE IF NOT EXISTS `shop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cena` int(11) NOT NULL,
  `umin` int(11) NOT NULL,
  `umax` int(11) NOT NULL,
  `pgolova` int(11) NOT NULL,
  `pbody` int(11) NOT NULL,
  `pnogi` int(11) NOT NULL,
  `hp` int(11) NOT NULL,
  `mp` int(11) NOT NULL,
  `krit` int(11) NOT NULL,
  `ukrit` int(11) NOT NULL,
  `antikrit` int(11) NOT NULL,
  `sila` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `um` int(11) NOT NULL,
  `prot` int(11) NOT NULL,
  `klas` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `nsila` int(11) NOT NULL,
  `num` int(11) NOT NULL,
  `nlovk` int(11) NOT NULL,
  `nlvl` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `shopelexirs`
--

CREATE TABLE IF NOT EXISTS `shopelexirs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lat_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `what` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `give` int(11) NOT NULL,
  `cena` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- Дамп данных таблицы `shopelexirs`
--

INSERT INTO `shopelexirs` (`id`, `city`, `name`, `lat_name`, `tip`, `what`, `give`, `cena`) VALUES
(1, 'fornost', 'HP-10', 'HP-10', 'elexir', 'hp', 10, 100),
(2, 'fornost', 'MP-10', 'MP-10', 'elexir', 'mp', 10, 100),
(3, 'fornost', 'HP-20', 'HP-20', 'elexir', 'hp', 20, 200),
(4, 'fornost', 'MP-20', 'MP-20', 'elexir', 'mp', 20, 200),
(5, 'fornost', 'HP-40', 'HP-40', 'elexir', 'hp', 40, 400),
(6, 'fornost', 'MP-40', 'MP-40', 'elexir', 'mp', 40, 400),
(7, 'fornost', 'HP-60', 'HP-60', 'elexir', 'hp', 60, 600),
(8, 'fornost', 'MP-60', 'MP-60', 'elexir', 'mp', 60, 600),
(9, 'fornost', 'HP-80', 'HP-80', 'elexir', 'hp', 80, 800),
(10, 'fornost', 'MP-80', 'MP-80', 'elexir', 'mp', 80, 800),
(11, 'fornost', 'HP-100', 'HP-100', 'elexir', 'hp', 100, 1000),
(12, 'fornost', 'MP-100', 'MP-100', 'elexir', 'mp', 100, 1000);

-- --------------------------------------------------------

--
-- Структура таблицы `shops`
--

CREATE TABLE IF NOT EXISTS `shops` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `kompl` int(11) NOT NULL,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cena` int(11) NOT NULL,
  `hp` int(11) NOT NULL,
  `mp` int(11) NOT NULL,
  `krit` int(11) NOT NULL,
  `ukrit` int(11) NOT NULL,
  `sila` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `prot` int(11) NOT NULL,
  `klas` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `nlvl` int(11) NOT NULL,
  `img` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=61 ;

--
-- Дамп данных таблицы `shops`
--

INSERT INTO `shops` (`id`, `tip`, `kompl`, `name`, `cena`, `hp`, `mp`, `krit`, `ukrit`, `sila`, `lovk`, `prot`, `klas`, `nlvl`, `img`) VALUES
(1, 'golova', 1, 'Искателя', 50, 5, 5, 20, 5, 5, 5, 5, '', 1, ''),
(2, 'body', 1, 'Искателя', 50, 5, 5, 20, 5, 5, 5, 5, '', 1, ''),
(3, 'nogi', 1, 'Искателя', 50, 5, 5, 20, 5, 5, 5, 5, '', 1, ''),
(4, 'weapon', 1, 'Искателя', 50, 5, 5, 20, 5, 5, 5, 5, '', 1, ''),
(5, 'shit', 1, 'Искателя', 50, 5, 5, 20, 5, 5, 5, 5, '', 1, ''),
(6, 'golova', 2, 'Новичка', 80, 10, 10, 20, 10, 10, 10, 10, '', 1, ''),
(7, 'body', 2, 'Новичка', 80, 10, 10, 20, 10, 10, 10, 10, '', 1, ''),
(8, 'nogi', 2, 'Новичка', 80, 10, 10, 20, 10, 10, 10, 10, '', 1, ''),
(9, 'weapon', 2, 'Новичка', 80, 10, 10, 20, 10, 10, 10, 10, '', 1, ''),
(10, 'shit', 2, 'Новичка', 80, 10, 10, 20, 10, 10, 10, 10, '', 1, ''),
(11, 'golova', 3, 'Ученика', 110, 15, 15, 20, 15, 15, 15, 15, '', 6, ''),
(12, 'body', 3, 'Ученика', 110, 15, 15, 20, 15, 15, 15, 15, '', 6, ''),
(13, 'nogi', 3, 'Ученика', 110, 15, 15, 20, 15, 15, 15, 15, '', 6, ''),
(14, 'weapon', 3, 'Ученика', 110, 15, 15, 20, 15, 15, 15, 15, '', 6, ''),
(15, 'shit', 3, 'Ученика', 110, 15, 15, 20, 15, 15, 15, 15, '', 6, ''),
(16, 'golova', 4, 'Ополченца', 140, 20, 20, 20, 20, 20, 20, 20, '', 6, ''),
(17, 'body', 4, 'Ополченца', 140, 20, 20, 20, 20, 20, 20, 20, '', 6, ''),
(18, 'nogi', 4, 'Ополченца', 140, 20, 20, 20, 20, 20, 20, 20, '', 6, ''),
(19, 'weapon', 4, 'Ополченца', 140, 20, 20, 20, 20, 20, 20, 20, '', 6, ''),
(20, 'shit', 4, 'Ополченца', 140, 20, 20, 20, 20, 20, 20, 20, '', 6, ''),
(21, 'golova', 5, 'Воина', 170, 25, 25, 20, 25, 25, 25, 25, '', 24, ''),
(22, 'body', 5, 'Воина', 170, 25, 25, 20, 25, 25, 25, 25, '', 24, ''),
(23, 'nogi', 5, 'Воина', 170, 25, 25, 20, 25, 25, 25, 25, '', 24, ''),
(24, 'weapon', 5, 'Воина', 170, 25, 25, 20, 25, 25, 25, 25, '', 24, ''),
(25, 'shit', 5, 'Воина', 170, 25, 25, 20, 25, 25, 25, 25, '', 24, ''),
(26, 'golova', 6, 'Рыцаря', 200, 30, 30, 20, 30, 30, 30, 30, '', 24, ''),
(27, 'body', 6, 'Рыцаря', 200, 30, 30, 20, 30, 30, 30, 30, '', 24, ''),
(28, 'nogi', 6, 'Рыцаря', 200, 30, 30, 20, 30, 30, 30, 30, '', 24, ''),
(29, 'weapon', 6, 'Рыцаря', 200, 30, 30, 20, 30, 30, 30, 30, '', 24, ''),
(30, 'shit', 6, 'Рыцаря', 200, 30, 30, 20, 30, 30, 30, 30, '', 24, ''),
(31, 'golova', 7, 'Берсерка', 230, 35, 35, 20, 35, 35, 35, 35, '', 48, ''),
(32, 'body', 7, 'Берсерка', 230, 35, 35, 20, 35, 35, 35, 35, '', 48, ''),
(33, 'nogi', 7, 'Берсерка', 230, 35, 35, 20, 35, 35, 35, 35, '', 48, ''),
(34, 'weapon', 7, 'Берсерка', 230, 35, 35, 20, 35, 35, 35, 35, '', 48, ''),
(35, 'shit', 7, 'Берсерка', 230, 35, 35, 20, 35, 35, 35, 35, '', 48, ''),
(36, 'golova', 8, 'Паладина', 260, 40, 40, 20, 40, 40, 40, 40, '', 48, ''),
(37, 'body', 8, 'Паладина', 260, 40, 40, 20, 40, 40, 40, 40, '', 48, ''),
(38, 'nogi', 8, 'Паладина', 260, 40, 40, 20, 40, 40, 40, 40, '', 48, ''),
(39, 'weapon', 8, 'Паладина', 260, 40, 40, 20, 40, 40, 40, 40, '', 48, ''),
(40, 'shit', 8, 'Паладина', 260, 40, 40, 20, 40, 40, 40, 40, '', 48, ''),
(41, 'golova', 9, 'Ассасина', 290, 45, 45, 20, 45, 45, 45, 45, '', 200, ''),
(42, 'body', 9, 'Ассасина', 290, 45, 45, 20, 45, 45, 45, 45, '', 200, ''),
(43, 'nogi', 9, 'Ассасина', 290, 45, 45, 20, 45, 45, 45, 45, '', 200, ''),
(44, 'weapon', 9, 'Ассасина', 290, 45, 45, 20, 45, 45, 45, 45, '', 200, ''),
(45, 'shit', 9, 'Ассасина', 290, 45, 45, 20, 45, 45, 45, 45, '', 200, ''),
(46, 'golova', 10, 'Атланта', 320, 50, 50, 20, 50, 50, 50, 50, '', 200, ''),
(47, 'body', 10, 'Атланта', 320, 50, 50, 20, 50, 50, 50, 50, '', 200, ''),
(48, 'nogi', 10, 'Атланта', 320, 50, 50, 20, 50, 50, 50, 50, '', 200, ''),
(49, 'weapon', 10, 'Атланта', 320, 50, 50, 20, 50, 50, 50, 50, '', 200, ''),
(50, 'shit', 10, 'Атланта', 320, 50, 50, 20, 50, 50, 50, 50, '', 200, ''),
(51, 'golova', 11, 'Олимпийца', 350, 55, 55, 20, 55, 55, 55, 55, '', 250, ''),
(52, 'body', 11, 'Олимпийца', 350, 55, 55, 20, 55, 55, 55, 55, '', 250, ''),
(53, 'nogi', 11, 'Олимпийца', 350, 55, 55, 20, 55, 55, 55, 55, '', 250, ''),
(54, 'weapon', 11, 'Олимпийца', 350, 55, 55, 20, 55, 55, 55, 55, '', 250, ''),
(55, 'shit', 11, 'Олимпийца', 350, 55, 55, 20, 55, 55, 55, 55, '', 250, ''),
(56, 'golova', 12, 'Ветерана', 380, 60, 60, 20, 60, 60, 60, 60, '', 250, ''),
(57, 'body', 12, 'Ветерана', 380, 60, 60, 20, 60, 60, 60, 60, '', 250, ''),
(58, 'nogi', 12, 'Ветерана', 380, 60, 60, 20, 60, 60, 60, 60, '', 250, ''),
(59, 'weapon', 12, 'Ветерана', 380, 60, 60, 20, 60, 60, 60, 60, '', 250, ''),
(60, 'shit', 12, 'Ветерана', 380, 60, 60, 20, 60, 60, 60, 60, '', 0, '');

-- --------------------------------------------------------

--
-- Структура таблицы `shops_drop`
--

CREATE TABLE IF NOT EXISTS `shops_drop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `exp` int(11) NOT NULL,
  `expmax` int(11) NOT NULL,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `kompl` int(11) NOT NULL,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cena` int(11) NOT NULL,
  `hp` int(11) NOT NULL,
  `mp` int(11) NOT NULL,
  `krit` int(11) NOT NULL,
  `ukrit` int(11) NOT NULL,
  `sila` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `prot` int(11) NOT NULL,
  `klas` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `nlvl` int(11) NOT NULL,
  `img` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `shop_aura`
--

CREATE TABLE IF NOT EXISTS `shop_aura` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `ava` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `lat_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `cena` int(11) NOT NULL,
  `acena` int(20) NOT NULL,
  `sila` int(20) NOT NULL,
  `protect` int(11) NOT NULL,
  `lovk` int(20) NOT NULL,
  `hp` int(11) NOT NULL,
  `mp` int(11) NOT NULL,
  `krit` int(11) NOT NULL,
  `ukrit` int(11) NOT NULL,
  `nlvl` int(11) NOT NULL,
  `actime` int(32) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `tchat`
--

CREATE TABLE IF NOT EXISTS `tchat` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `nick` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `komentaras` text COLLATE utf8_unicode_ci NOT NULL,
  `kada` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `time` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `temp`
--

CREATE TABLE IF NOT EXISTS `temp` (
  `id` int(11) NOT NULL,
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lvl` int(11) NOT NULL,
  `hp` int(11) NOT NULL,
  `hpall` int(11) NOT NULL,
  `uron` int(11) NOT NULL,
  `prot` int(11) NOT NULL,
  `krit` int(11) NOT NULL,
  `ukrit` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `money` int(11) NOT NULL,
  `exp` int(11) NOT NULL,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `oponent` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `bitva` int(11) NOT NULL,
  `drop` int(11) NOT NULL,
  `user` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ltime` int(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Структура таблицы `tmp`
--

CREATE TABLE IF NOT EXISTS `tmp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mob` int(11) NOT NULL,
  `city` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `location` int(11) NOT NULL,
  `ltime` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `towers`
--

CREATE TABLE IF NOT EXISTS `towers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `hp` int(11) NOT NULL,
  `hpall` int(11) NOT NULL,
  `point` int(11) NOT NULL,
  `exp` int(11) NOT NULL,
  `money` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `control` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `lvl` int(11) NOT NULL,
  `mlvl` int(11) NOT NULL,
  `cena` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;

--
-- Дамп данных таблицы `towers`
--

INSERT INTO `towers` (`id`, `name`, `hp`, `hpall`, `point`, `exp`, `money`, `control`, `lvl`, `mlvl`, `cena`) VALUES
(1, 'Врата Искателя', 1817, 2500, 1, 25, '1000', 'black', 0, 10, 0),
(2, 'Врата Новичка', 3333, 5000, 2, 50, '2000', 'black', 5, 15, 0),
(3, 'Врата Ученика', 6667, 10000, 3, 100, '3000', 'black', 10, 20, 0),
(4, 'Врата Ополченца', 12774, 20000, 4, 200, '4000', 'white', 15, 25, 0),
(5, 'Врата Воина', 20000, 30000, 5, 300, '5000', 'white', 20, 30, 0),
(6, 'Врата Рыцаря', 26667, 40000, 6, 400, '6000', 'white', 25, 35, 0),
(7, 'Врата Берсерка', 33333, 50000, 7, 500, '7000', 'white', 30, 40, 0),
(8, 'Врата Паладина', 40000, 60000, 8, 600, '8000', 'black', 35, 45, 0),
(9, 'Врата Ассасина', 46717, 70000, 9, 700, '9000', 'white', 40, 50, 0),
(10, 'Врата Атланта', 53333, 80000, 10, 800, '10000', 'white', 45, 55, 0),
(11, 'Врата Олимпийца', 60000, 90000, 11, 900, '11000', 'white', 50, 60, 0),
(12, 'Врата Ветерана', 66817, 100000, 12, 1000, '12000', 'white', 55, 65, 0);

-- --------------------------------------------------------

--
-- Структура таблицы `undying`
--

CREATE TABLE IF NOT EXISTS `undying` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` int(11) NOT NULL DEFAULT '0',
  `end` enum('0','1') NOT NULL DEFAULT '0',
  `start` enum('0','1') NOT NULL DEFAULT '0',
  `opponents` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `undying_member`
--

CREATE TABLE IF NOT EXISTS `undying_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `battle` int(11) NOT NULL DEFAULT '0',
  `user` int(11) NOT NULL DEFAULT '0',
  `dead` enum('0','1') NOT NULL DEFAULT '0',
  `exit` enum('0','1') NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `kills` int(11) NOT NULL DEFAULT '0',
  `dmg` int(11) NOT NULL DEFAULT '0',
  `mana` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `unitpay_payments`
--

CREATE TABLE IF NOT EXISTS `unitpay_payments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `unitpayId` varchar(255) NOT NULL,
  `account` varchar(255) NOT NULL,
  `sum` float NOT NULL,
  `itemsCount` int(11) NOT NULL DEFAULT '1',
  `dateCreate` datetime NOT NULL,
  `dateComplete` datetime DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `userduel`
--

CREATE TABLE IF NOT EXISTS `userduel` (
  `duid` int(11) NOT NULL,
  `usr` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lvl` int(11) NOT NULL,
  `storona` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `hp` int(11) NOT NULL,
  `status` varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sudar` int(11) NOT NULL,
  `sfera` int(11) NOT NULL,
  `dies` int(11) NOT NULL,
  `time` int(29) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Структура таблицы `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `news` int(11) NOT NULL,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `pass` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(35) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `pol` varchar(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `prava` int(1) NOT NULL,
  `storona` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lvl` int(11) NOT NULL,
  `money` int(11) NOT NULL,
  `almaz` int(11) NOT NULL,
  `skill` int(11) NOT NULL,
  `hp` int(11) NOT NULL,
  `hpall` int(11) NOT NULL,
  `mp` int(11) NOT NULL,
  `mpall` int(11) NOT NULL,
  `exp` int(11) NOT NULL,
  `sila` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `prot` int(11) NOT NULL,
  `krit` int(11) NOT NULL,
  `ukrit` int(11) NOT NULL,
  `umin` int(11) NOT NULL,
  `umax` int(11) NOT NULL,
  `key` int(11) NOT NULL,
  `s1` int(11) NOT NULL,
  `s2` int(11) NOT NULL,
  `s3` int(11) NOT NULL,
  `s4` int(11) NOT NULL,
  `s5` int(11) NOT NULL,
  `logotip` int(11) NOT NULL,
  `city` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `klas` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `clan` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `lvisit` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `loses` int(11) NOT NULL,
  `wins` int(11) NOT NULL,
  `arenaloses` int(11) NOT NULL,
  `arenawins` int(11) NOT NULL,
  `slava` int(11) NOT NULL,
  `predatel` int(11) NOT NULL,
  `karma` int(11) NOT NULL,
  `super` int(11) NOT NULL,
  `ref` varchar(25) NOT NULL,
  `sb` varchar(15) NOT NULL,
  `pan` int(11) NOT NULL,
  `avatar` varchar(25) NOT NULL,
  `dolz` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `clanexp` int(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `weapon`
--

CREATE TABLE IF NOT EXISTS `weapon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usr` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `tip` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cena` int(11) NOT NULL,
  `kompl` int(11) NOT NULL,
  `proch` int(11) NOT NULL,
  `hp` int(11) NOT NULL,
  `mp` int(11) NOT NULL,
  `krit` int(11) NOT NULL,
  `ukrit` int(11) NOT NULL,
  `sila` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `prot` int(11) NOT NULL,
  `nlvl` int(11) NOT NULL,
  `image` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mob` int(11) NOT NULL,
  `zakal` int(11) NOT NULL,
  `runa` int(11) NOT NULL,
  `ncena` int(11) NOT NULL,
  `opis` varchar(35) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `time` int(25) NOT NULL,
  `img` varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `worldkassa`
--

CREATE TABLE IF NOT EXISTS `worldkassa` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID платежа (Внутренний ID)',
  `id_user` int(11) unsigned NOT NULL COMMENT 'ID пользователя',
  `id_bill` int(11) unsigned NOT NULL COMMENT 'ID платежа в Worldkassa',
  `time` int(11) unsigned NOT NULL COMMENT 'Время инициализации платежа',
  `time_oplata` int(11) unsigned DEFAULT '0' COMMENT 'Время оплаты',
  `summa` decimal(11,2) NOT NULL DEFAULT '0.00' COMMENT 'Сумма',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Статистика платежей через WorldKassa' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `zametka`
--

CREATE TABLE IF NOT EXISTS `zametka` (
  `id` int(3) NOT NULL,
  `log` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(550) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
