Файл: dragon.sql
Строк: 46
-- 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 */;