View file clan.sql

-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Хост: 127.0.0.1
-- Время создания: Апр 07 2013 г., 01:09
-- Версия сервера: 5.5.25
-- Версия PHP: 5.3.13

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

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

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

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

CREATE TABLE IF NOT EXISTS `clan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `about` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rules` varchar(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
  `all` int(11) NOT NULL DEFAULT '1',
  `user` int(11) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `level` int(11) NOT NULL DEFAULT '1',
  `bank` int(11) NOT NULL DEFAULT '0',
  `priz` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user`,`time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

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

INSERT INTO `clan` (`id`, `name`, `about`, `rules`, `all`, `user`, `time`, `level`, `bank`, `priz`) VALUES
(2, 'TurboWap.Ru', 'Клан нашего сайта!', NULL, 1, 1, 1365286007, 1, 0, 0);

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

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

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

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

INSERT INTO `clan_adm_chat` (`id`, `id_user`, `id_clan`, `msg`, `time`) VALUES
(1, 1, 1, 'echo \\"  </td>n\\";\r\necho \\"   </tr>n\\";', 1362271096);

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

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

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

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

INSERT INTO `clan_chat` (`id`, `id_user`, `id_clan`, `msg`, `time`) VALUES
(4, 1, 2, 'test', 1365286093);

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

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

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

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

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

CREATE TABLE IF NOT EXISTS `clan_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_clan` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `msg` varchar(1024) NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `clan_news` (`id`, `id_clan`, `title`, `msg`, `time`) VALUES
(1, 1, 'Графическая Обнова', 'AddDefaultCharset UTF-8', 1362153259);

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

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

CREATE TABLE IF NOT EXISTS `clan_prig` (
  `id_user` int(11) NOT NULL DEFAULT '0',
  `id_kont` int(11) NOT NULL DEFAULT '0',
  `id_clan` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `clan_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_clan` int(11) NOT NULL,
  `level` set('0','1','2') NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL,
  `activaty` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `clan_user` (`id`, `id_user`, `id_clan`, `level`, `time`, `activaty`) VALUES
(1, 1, 2, '2', 1365286007, 0);

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