Просмотр архива Кланы на dcms social

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