-- phpMyAdmin SQL Dump
-- version 3.5.3
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Июл 17 2014 г., 09:55
-- Версия сервера: 5.6.16
-- Версия PHP: 5.3.5

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 */;

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

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

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

CREATE TABLE IF NOT EXISTS `anketa` (
  `name` varchar(20) DEFAULT NULL,
  `id_us` int(11) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `osebe` varchar(500) DEFAULT NULL,
  `interes` varchar(500) DEFAULT NULL,
  `data` varchar(20) NOT NULL DEFAULT '0',
  UNIQUE KEY `nick` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `bashni` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `sila` int(11) NOT NULL,
  `health` int(11) NOT NULL,
  `max_health` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `zashit` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 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,
  `sila` int(11) NOT NULL,
  `health` int(11) NOT NULL,
  `lovk` int(11) NOT NULL,
  `zashit` int(11) NOT NULL,
  `gold` int(11) NOT NULL,
  `exp` int(11) NOT NULL,
  `image` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `chat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `time` int(11) NOT NULL,
  `msg` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `forum_comm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` varchar(10024) DEFAULT NULL,
  `time` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `id_topic` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `forum_razdel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(10024) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `forum_topic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(10024) DEFAULT NULL,
  `msg` varchar(10024) DEFAULT NULL,
  `time` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `id_razdel` int(11) NOT NULL,
  `close` int(11) NOT NULL DEFAULT '0',
  `verh` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `gold_zapros` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) DEFAULT NULL,
  `time` int(11) NOT NULL,
  `sum` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `ignor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto` int(11) DEFAULT NULL,
  `kogo` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `inventar` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `plus` varchar(12) NOT NULL,
  `class` int(12) NOT NULL,
  `id_user` int(12) NOT NULL,
  `img` varchar(50) NOT NULL,
  `status` varchar(10) NOT NULL,
  `id_resa` int(12) NOT NULL,
  `lvl` int(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `ipban` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `kompl` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `id_komp` int(12) NOT NULL,
  `name` varchar(50) NOT NULL,
  `type` varchar(200) NOT NULL,
  `cena` int(12) NOT NULL,
  `url` varchar(50) NOT NULL,
  `stats` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `komplekt` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `lvl` int(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `kompl_us` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `id_komp` int(12) NOT NULL,
  `act` int(1) NOT NULL DEFAULT '0',
  `id_us` int(11) DEFAULT NULL,
  `type` char(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `magazin` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `class` int(12) NOT NULL,
  `name` varchar(50) NOT NULL,
  `xoru` varchar(12) NOT NULL,
  `cena` int(12) NOT NULL,
  `url` varchar(50) NOT NULL,
  `lvl_d` int(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `mail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_kont` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `msg` varchar(1024) NOT NULL,
  `read` set('0','1') NOT NULL DEFAULT '0',
  `unlink` int(11) DEFAULT '0',
  `show_vk` int(1) DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `id_user` (`id_user`,`id_kont`),
  KEY `read` (`read`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `mypets` (
  `id_pets` int(255) NOT NULL,
  `id_user` int(255) NOT NULL,
  `pets` varchar(255) CHARACTER SET cp1251 NOT NULL,
  `petsname` varchar(255) CHARACTER SET cp1251 NOT NULL,
  `silapets` int(3) NOT NULL,
  `healthpets` int(3) NOT NULL,
  `vinoslpets` int(3) NOT NULL,
  `tun_1_lev` int(10) NOT NULL DEFAULT '1',
  `tun_2_lev` int(10) NOT NULL DEFAULT '1',
  `tun_3_lev` int(10) NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `msg` varchar(10024) DEFAULT NULL,
  `time` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `title` varchar(32) DEFAULT NULL,
  `main_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `news_kom` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `msg` varchar(1024) NOT NULL,
  `time` int(11) NOT NULL,
  `id_news` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `pets` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `pets` varchar(255) CHARACTER SET cp1251 NOT NULL,
  `petsname` varchar(255) CHARACTER SET cp1251 NOT NULL,
  `price` int(255) NOT NULL,
  `level` int(3) NOT NULL,
  `silapets` int(4) NOT NULL,
  `vinoslpets` int(255) NOT NULL,
  `healthpets` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `ref` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_us` int(11) DEFAULT NULL,
  `nak` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `smiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `adres` varchar(1024) NOT NULL,
  `name` varchar(250) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `ticket` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kto` int(11) DEFAULT NULL,
  `act` int(1) NOT NULL,
  `nazv` char(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timereg` int(11) DEFAULT NULL,
  `nick` varchar(20) DEFAULT NULL,
  `pol` int(11) DEFAULT NULL,
  `pass` varchar(100) DEFAULT NULL,
  `online` varchar(10) DEFAULT NULL,
  `level` varchar(10) DEFAULT '1',
  `exp` varchar(10) DEFAULT '0',
  `health` varchar(10) DEFAULT NULL,
  `max_health` varchar(10) DEFAULT NULL,
  `mana` varchar(10) DEFAULT NULL,
  `max_mana` varchar(10) DEFAULT NULL,
  `gold` varchar(10) DEFAULT '0',
  `silver` varchar(10) DEFAULT '0',
  `sila` int(11) NOT NULL DEFAULT '0',
  `lovk` int(11) NOT NULL DEFAULT '0',
  `zashit` int(11) NOT NULL DEFAULT '0',
  `param` int(11) NOT NULL DEFAULT '0',
  `avatar` int(11) NOT NULL DEFAULT '0',
  `prava` int(11) NOT NULL DEFAULT '0',
  `set_p_str` int(11) NOT NULL DEFAULT '10',
  `duel_rating` int(11) NOT NULL DEFAULT '0',
  `podarok` int(11) NOT NULL DEFAULT '0',
  `boss_pobed` int(11) NOT NULL DEFAULT '0',
  `baza_gold` int(11) NOT NULL DEFAULT '1',
  `baza_silver` int(11) NOT NULL DEFAULT '1',
  `baza_mana` int(11) NOT NULL DEFAULT '1',
  `baza_health` int(11) NOT NULL DEFAULT '1',
  `news_read` int(11) NOT NULL DEFAULT '0',
  `ban` int(11) NOT NULL DEFAULT '0',
  `boss_mission` int(11) NOT NULL DEFAULT '0',
  `duel_mission` int(11) NOT NULL DEFAULT '0',
  `time_pohod` int(255) NOT NULL,
  `time_pohod_money` int(255) NOT NULL,
  `pohod` int(255) NOT NULL,
  `pohod_start` int(255) NOT NULL,
  `pohod_time` int(255) NOT NULL,
  `ip` varchar(200) DEFAULT NULL,
  `pets` varchar(255) NOT NULL,
  `healthpets` int(255) NOT NULL,
  `petsname` varchar(255) NOT NULL DEFAULT 'Нет питомца',
  `silapets` int(255) NOT NULL,
  `vinoslpets` int(255) NOT NULL,
  `petschek` int(3) NOT NULL,
  `arenaweek` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `nick` (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `users_konts` (
  `id_user` int(11) NOT NULL,
  `id_kont` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `new_msg` int(11) NOT NULL DEFAULT '0',
  `name` varchar(64) DEFAULT NULL,
  UNIQUE KEY `id_user` (`id_user`,`id_kont`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `user_podarok` (
  `user_id` int(255) NOT NULL,
  `last_auth` int(255) NOT NULL,
  `stage` int(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Структура таблицы `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 'Сумма',
  `type` enum('0','1','2') DEFAULT '0' COMMENT 'Тип пополнения 1 - рубины, 2 - монеты',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Статистика платежей через WorldKassa' AUTO_INCREMENT=1 ;

/*!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 */;