View file dragon/dragon.sql

File size: 2.26Kb
-- phpMyAdmin SQL Dump
-- version 3.5.2.2
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Сен 25 2014 г., 15:56
-- Версия сервера: 5.1.67
-- Версия 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 */;

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

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

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

CREATE TABLE IF NOT EXISTS `dragon_chat` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(10) unsigned NOT NULL,
  `time` int(10) unsigned NOT NULL,
  `text` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;

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

INSERT INTO `dragon_chat` (`id`, `id_user`, `time`, `text`) VALUES
(20, 1, 1411555670, 'fff'),
(21, 2, 1411555826, '99999'),
(22, 2, 1411558717, 'yyyyyyyy');

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

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

CREATE TABLE IF NOT EXISTS `pit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `pit` int(11) NOT NULL,
  `name` varchar(20) DEFAULT NULL,
  `time` int(11) NOT NULL,
  `sila` int(11) NOT NULL,
  `sila_time` int(11) NOT NULL,
  `zdorov` int(11) NOT NULL,
  `zdorov_time` int(11) NOT NULL,
  `zashita` int(11) NOT NULL,
  `zashita_time` int(11) NOT NULL,
  `boi` int(11) NOT NULL,
  `win` int(11) NOT NULL,
  `lose` int(11) NOT NULL,
  `timenap` int(11) NOT NULL,
  `lasttime` int(11) NOT NULL,
  `lastsoul` int(11) NOT NULL,
  `money` int(11) NOT NULL,
  `ok_souls` int(11) NOT NULL,
  `souls` int(11) NOT NULL DEFAULT '5',
  `angeltrap` int(11) NOT NULL,
  `cave_time` int(11) NOT NULL,
  `cave` enum('0','1') NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

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