-- phpMyAdmin SQL Dump
-- version 3.5.7
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Апр 13 2013 г., 04:58
-- Версия сервера: 5.1.67
-- Версия PHP: 5.3.3

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

--
-- База данных: `counter-strike`
--

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

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

CREATE TABLE IF NOT EXISTS `elfchat_ban` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `type` char(255) NOT NULL DEFAULT 'id',
  `ban` char(64) NOT NULL DEFAULT '',
  `comment` text NOT NULL,
  `time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `elfchat_messages` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `room` char(255) NOT NULL DEFAULT 'main',
  `fordet` char(64) NOT NULL DEFAULT '',
  `fromdet` char(64) NOT NULL DEFAULT '',
  `seen` int(2) NOT NULL DEFAULT '0',
  `name` char(255) NOT NULL DEFAULT '',
  `htmlname` text NOT NULL,
  `time` double NOT NULL DEFAULT '0',
  `type` varchar(8) NOT NULL DEFAULT 'msg',
  `msg` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

INSERT INTO `elfchat_messages` (`id`, `room`, `fordet`, `fromdet`, `seen`, `name`, `htmlname`, `time`, `type`, `msg`) VALUES
(1, 'global', '', '', 0, 'Shur1k', '<i>Shur1k</i>', 1365814578.7168, 'enter', ''),
(2, '1', '', '', 0, 'Shur1k', '<i>Shur1k</i>', 1365814585.4869, 'msg', 'йоу'),
(3, '1', '', '', 0, 'Shur1k', '<i>Shur1k</i>', 1365814595.4713, 'msg', 'Ехууууууууууууу..... сделал =)');

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

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

CREATE TABLE IF NOT EXISTS `elfchat_rooms` (
  `id` varchar(255) NOT NULL,
  `name` text NOT NULL,
  `password` varchar(255) NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `elfchat_rooms` (`id`, `name`, `password`) VALUES
('main', 'ElfChat', ''),
('1', 'De_dust2_2x2', ''),
('2', 'ClanWar', ''),
('', 'Русский Спецназ', '');

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

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

CREATE TABLE IF NOT EXISTS `elfchat_users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `mid` char(32) NOT NULL DEFAULT '',
  `det` char(64) NOT NULL DEFAULT '',
  `ip` char(32) NOT NULL DEFAULT '',
  `room` char(255) NOT NULL DEFAULT 'main',
  `name` char(255) NOT NULL DEFAULT '',
  `htmlname` text NOT NULL,
  `status` char(255) NOT NULL DEFAULT '',
  `time` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `elfchat_users` (`id`, `mid`, `det`, `ip`, `room`, `name`, `htmlname`, `status`, `time`) VALUES
(1, '5ide1ndkriruf7clqov9mdf3r3', '8b33c9e', '176.121.3.8', '1', 'Shur1k', '<i>Shur1k</i>', '', 1365814730);

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