Просмотр архива ВМ ПИТБУЛЯ

-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
--
Хост: 127.0.0.1
-- Время создания: Мар 26 2013 г.,
16:28
-- Версия сервера: 5.5.25
-- Версия PHP:
5.2.12

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

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

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

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

CREATE TABLE IF NOT
EXISTS `ad_avtoritet` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `kto`
int(20) NOT NULL,
  `komu` int(20) NOT NULL,
  `type` varchar(80) CHARACTER
SET cp1251 COLLATE cp1251_bin NOT NULL,
  `text` text CHARACTER SET cp1251
COLLATE cp1251_bin NOT NULL,
  `time` bigint(50) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`akcyi` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT
NULL DEFAULT '0',
  `time` int(20) NOT NULL DEFAULT '0',
  `msg` text NOT
NULL,
  `org` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`anekdot` (
  `ids` int(11) NOT NULL AUTO_INCREMENT,
  `message` blob NOT
NULL,
  `who` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ids`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`audio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` text NOT
NULL,
  `name` text NOT NULL,
  `kom` text NOT NULL,
  `prosm` int(20) NOT
NULL DEFAULT '0',
  `time` text NOT NULL,
  `adres` text NOT NULL,
 
`format` text NOT NULL,
  `razmer` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `audio_komm` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id`
int(20) NOT NULL DEFAULT '0',
  `mgs_id` int(20) NOT NULL DEFAULT '0',
 
`msg` blob NOT NULL,
  `time` int(20) NOT NULL DEFAULT '0',
  `audio`
int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `avtoritet` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `kto`
int(20) NOT NULL,
  `komu` int(20) NOT NULL,
  `type` varchar(80) CHARACTER
SET cp1251 COLLATE cp1251_bin NOT NULL,
  `text` text CHARACTER SET cp1251
COLLATE cp1251_bin NOT NULL,
  `time` bigint(50) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`bannip` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ip` varchar(20) NOT
NULL,
  `who_id` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`bannlist` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `ip` varchar(255)
NOT NULL DEFAULT '',
  `soft` varchar(255) NOT NULL DEFAULT '',
  `user_id`
varchar(255) NOT NULL DEFAULT '',
  `who_id` varchar(255) NOT NULL DEFAULT
'',
  `why` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`board` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
 
`who` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`books` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `kto` int(20) DEFAULT
'0',
  `komu` text CHARACTER SET cp1251,
  `time` int(20) NOT NULL DEFAULT
'0',
  `msg` text CHARACTER SET cp1251 NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`chislo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `chislo` varchar(100)
NOT NULL DEFAULT '',
  `ip` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=251 ;

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

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

CREATE TABLE IF NOT EXISTS
`codes` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `id_us` int(20) NOT
NULL,
  `time` varchar(40) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL
DEFAULT '',
  `text` longtext NOT NULL,
  `name` varchar(100) CHARACTER SET
cp1251 COLLATE cp1251_bin NOT NULL,
  `id_cat` int(20) NOT NULL,
  `kol`
int(20) NOT NULL,
  `op` text NOT NULL,
  `ips` text NOT NULL,
  `yes`
int(11) NOT NULL DEFAULT '0',
  `no` int(11) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `codes_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(50) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `codes_komm` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `file`
int(20) NOT NULL DEFAULT '0',
  `user_id` int(20) NOT NULL DEFAULT '0',
 
`time` int(20) NOT NULL DEFAULT '0',
  `msg` text CHARACTER SET cp1251 NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`dialog` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user` int(20) NOT
NULL,
  `to_id` int(20) NOT NULL,
  `time` bigint(50) NOT NULL DEFAULT
'0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`diaskomm` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `did` int(20) NOT
NULL DEFAULT '0',
  `user_id` int(20) NOT NULL DEFAULT '0',
  `time`
int(20) NOT NULL DEFAULT '0',
  `msg` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`dow_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` text NOT
NULL,
  `infolder` text NOT NULL,
  `name` varchar(255) NOT NULL,
 
`priority` tinyint(3) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL
DEFAULT '0',
  `pos` int(11) NOT NULL DEFAULT '0',
  `level` int(2) NOT
NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`dow_cat2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fid` int(11) NOT
NULL DEFAULT '0',
  `path` text NOT NULL,
  `infolder` text NOT NULL,
 
`name` varchar(255) NOT NULL,
  `priority` tinyint(3) NOT NULL DEFAULT
'0',
  `time` int(11) NOT NULL DEFAULT '0',
  `pos` int(11) NOT NULL
DEFAULT '0',
  `level` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `dow_files` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id`
int(20) NOT NULL DEFAULT '0',
  `path` text NOT NULL,
  `infolder` text NOT
NULL,
  `name` varchar(255) NOT NULL,
  `priority` tinyint(3) NOT NULL
DEFAULT '0',
  `size` bigint(20) NOT NULL,
  `about` text NOT NULL,
 
`pass` text NOT NULL,
  `price` int(11) NOT NULL DEFAULT '0',
  `fastabout`
text NOT NULL,
  `loads` int(11) NOT NULL DEFAULT '0',
  `timeload` int(11)
unsigned NOT NULL,
  `timeupload` int(11) NOT NULL,
  `ips` text NOT NULL,

 `yes` int(11) NOT NULL DEFAULT '0',
  `no` int(11) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT EXISTS
`dow_komm` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `file` int(20) NOT
NULL DEFAULT '0',
  `user_id` int(20) NOT NULL DEFAULT '0',
  `time`
int(20) NOT NULL DEFAULT '0',
  `msg` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`forum_b` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `t_id` text NOT
NULL,
  `time` text NOT NULL,
  `user_id` text NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`forum_f` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT
NULL,
  `time` int(11) NOT NULL DEFAULT '0',
  `pos` int(11) NOT NULL
DEFAULT '0',
  `md` int(20) NOT NULL DEFAULT '0',
  `level` int(1) NOT NULL
DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `forum_msg` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `del` int(1)
NOT NULL DEFAULT '0',
  `f_id` int(11) NOT NULL,
  `r_id` int(11) NOT
NULL,
  `t_id` int(11) NOT NULL,
  `user_id` text NOT NULL,
  `msg` text
NOT NULL,
  `time` text NOT NULL,
  `file` text NOT NULL,
  `fname` text
NOT NULL,
  `fsize` text NOT NULL,
  `sfile` int(11) NOT NULL DEFAULT '0',

 `izm` text CHARACTER SET cp1251 NOT NULL,
  `izmk` text NOT NULL,
  `cit`
text NOT NULL,
  `privat` text NOT NULL,
  `del_id` int(11) NOT NULL,
 
`luch` int(1) NOT NULL DEFAULT '0',
  `hudsh` int(1) NOT NULL DEFAULT '0',

 `level` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`forum_r` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `f_id` int(11) NOT
NULL DEFAULT '0',
  `name` text NOT NULL,
  `pos` int(11) NOT NULL DEFAULT
'0',
  `level` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`forum_s` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `search` text NOT
NULL,
  `time` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `forum_spam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `f_id`
int(11) NOT NULL,
  `r_id` int(11) NOT NULL,
  `t_id` int(11) NOT NULL,
 
`user_id` text NOT NULL,
  `msg` text CHARACTER SET cp1251 NOT NULL,
 
`time` text NOT NULL,
  `readin` tinyint(1) NOT NULL DEFAULT '0',
  `us_id`
int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`forum_t` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `f_id` int(11) NOT
NULL,
  `r_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name`
text CHARACTER SET cp1251 NOT NULL,
  `close` int(11) NOT NULL DEFAULT
'0',
  `time` int(11) NOT NULL DEFAULT '0',
  `zak` int(11) NOT NULL
DEFAULT '0',
  `privat` int(11) NOT NULL DEFAULT '0',
  `times` int(20) NOT
NULL DEFAULT '0',
  `level` int(1) NOT NULL DEFAULT '0',
  `vop` text
CHARACTER SET cp1251 NOT NULL,
  `on` int(1) NOT NULL DEFAULT '0',
  `otv`
text CHARACTER SET cp1251 NOT NULL,
  `otv2` text CHARACTER SET cp1251 NOT
NULL,
  `otv3` text CHARACTER SET cp1251 NOT NULL,
  `otv4` text CHARACTER
SET cp1251 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `forum_vote` (
  `id` int(99) NOT NULL AUTO_INCREMENT,
  `user_id`
int(99) NOT NULL,
  `var` int(2) NOT NULL,
  `t_id` int(99) NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT EXISTS
`foto_add` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` text NOT
NULL,
  `kom` text NOT NULL,
  `album` int(20) NOT NULL DEFAULT '0',
 
`prosm` int(20) NOT NULL DEFAULT '0',
  `time` text NOT NULL,
  `adres`
text NOT NULL,
  `format` text NOT NULL,
  `razmer` text NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT
EXISTS `foto_albom` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `name` text
NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `kom` text NOT NULL,

 `level` int(2) NOT NULL DEFAULT '0',
  `pp_al` int(2) NOT NULL DEFAULT
'0',
  `pp_al_k` int(2) NOT NULL DEFAULT '0',
  `time_s` int(20) NOT NULL
DEFAULT '0',
  `time_izm` int(20) NOT NULL DEFAULT '0',
  `prosm` int(20)
NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `foto_komm` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id`
int(20) NOT NULL DEFAULT '0',
  `mgs_id` int(20) NOT NULL DEFAULT '0',
 
`msg` blob NOT NULL,
  `time` int(20) NOT NULL DEFAULT '0',
  `foto`
int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`fo_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` text NOT NULL,

 `infolder` text NOT NULL,
  `name` varchar(255) NOT NULL,
  `priority`
tinyint(3) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
 
`pos` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`fo_cat2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fid` int(11) NOT
NULL DEFAULT '0',
  `path` text NOT NULL,
  `infolder` text NOT NULL,
 
`name` varchar(255) NOT NULL,
  `priority` tinyint(3) NOT NULL DEFAULT
'0',
  `time` int(11) NOT NULL DEFAULT '0',
  `pos` int(11) NOT NULL
DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`fo_files` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20)
NOT NULL DEFAULT '0',
  `path` text NOT NULL,
  `infolder` text NOT NULL,
 
`name` varchar(255) NOT NULL,
  `priority` tinyint(3) NOT NULL DEFAULT
'0',
  `size` bigint(20) NOT NULL,
  `about` text NOT NULL,
  `pass` text
NOT NULL,
  `price` int(11) NOT NULL DEFAULT '0',
  `fastabout` text NOT
NULL,
  `loads` int(11) NOT NULL DEFAULT '0',
  `timeload` int(11) unsigned
NOT NULL,
  `timeupload` int(11) NOT NULL,
  `ips` text NOT NULL,
  `yes`
int(11) NOT NULL DEFAULT '0',
  `no` int(11) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT EXISTS
`fo_komm` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `file` int(20) NOT
NULL DEFAULT '0',
  `user_id` int(20) NOT NULL DEFAULT '0',
  `time`
int(20) NOT NULL DEFAULT '0',
  `msg` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`frazi` (
  `ids` int(11) NOT NULL AUTO_INCREMENT,
  `message` blob NOT
NULL,
  PRIMARY KEY (`ids`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`friends` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT
NULL DEFAULT '0',
  `fr_id` int(20) NOT NULL DEFAULT '0',
  `yes` int(20)
NOT NULL DEFAULT '0',
  `no` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`f_votes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT
NULL DEFAULT '0',
  `them` int(11) NOT NULL DEFAULT '0',
  `var`
smallint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`gifts` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT
NULL DEFAULT '0',
  `gift_id` int(20) NOT NULL DEFAULT '0',
  `time`
int(20) NOT NULL DEFAULT '0',
  `kom` text NOT NULL,
  `gift` text NOT
NULL,
  `anonim` int(20) NOT NULL DEFAULT '0',
  `publ` int(20) NOT NULL
DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`golos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_1` int(16)
DEFAULT NULL,
  `user_2` int(16) DEFAULT NULL,
  `golos` int(1) DEFAULT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lider_id` int(20) NOT
NULL DEFAULT '0',
  `name` text NOT NULL,
  `opis` text NOT NULL,
  `time`
int(20) NOT NULL DEFAULT '0',
  `users` int(20) NOT NULL DEFAULT '0',
 
`logo` text NOT NULL,
  `icon` text NOT NULL,
  `tip` int(11) NOT NULL,
 
`infa` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `group_chat` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `gid`
int(20) NOT NULL DEFAULT '0',
  `user_id` int(20) NOT NULL DEFAULT '0',
 
`time` int(20) NOT NULL DEFAULT '0',
  `msg` text NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT
EXISTS `group_news` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `gid`
int(20) NOT NULL DEFAULT '0',
  `user_id` int(20) NOT NULL DEFAULT '0',
 
`time` int(20) NOT NULL DEFAULT '0',
  `msg` text NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT
EXISTS `group_newskom` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `gid`
int(20) NOT NULL DEFAULT '0',
  `new` int(20) NOT NULL DEFAULT '0',
 
`user_id` int(20) NOT NULL DEFAULT '0',
  `time` int(20) NOT NULL DEFAULT
'0',
  `msg` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `group_users` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `gid`
int(20) NOT NULL DEFAULT '0',
  `user_id` int(20) NOT NULL DEFAULT '0',
 
`access` int(1) NOT NULL DEFAULT '0',
  `time` int(20) NOT NULL DEFAULT
'0',
  `level` int(1) NOT NULL DEFAULT '0',
  `posts` int(20) NOT NULL
DEFAULT '0',
  `status` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`ignor` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT
NULL DEFAULT '0',
  `ig_id` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `infringements` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
 
`user_id` int(20) NOT NULL DEFAULT '0',
  `mgs_id` int(20) NOT NULL DEFAULT
'0',
  `msg` blob NOT NULL,
  `time` int(20) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`ingame1` (
  `gamer_id` int(11) NOT NULL DEFAULT '0',
  `role`
varchar(100) NOT NULL DEFAULT '',
  `gamer_act` varchar(50) NOT NULL
DEFAULT '',
  `id_in_game` int(11) NOT NULL DEFAULT '0',
  `dvote` int(11)
NOT NULL DEFAULT '0',
  `wholin` int(11) NOT NULL DEFAULT '0',
  `onl`
int(12) NOT NULL DEFAULT '0',
  `state` tinyint(1) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`gamer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS
`komissar` (
  `klu4` int(11) NOT NULL DEFAULT '0',
  `night_act` text NOT
NULL,
  PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS
`konkurs` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT
NULL DEFAULT '0',
  `time` int(20) NOT NULL DEFAULT '0',
  `msg` text NOT
NULL,
  `org` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`lenta` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user` varchar(40) NOT
NULL DEFAULT '',
  `user_id` int(12) NOT NULL DEFAULT '0',
  `msg` blob NOT
NULL,
  `to_user` varchar(40) NOT NULL DEFAULT '',
  `to_id` int(12) NOT
NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `readin`
tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`levels` (
  `level` int(5) NOT NULL DEFAULT '0',
  `name` blob,
  PRIMARY
KEY (`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `levels` (`level`,
`name`) VALUES
(0, 0xd09cd0b0d181d182d0b5d180),
(3,
0xd09cd0b0d181d182d0b5d180),
(4,
0xd0add0bbd0b8d182d0bdd18bd0b920d09cd0b0d181d182d0b5d180),
(5,
0xd09cd0bed0b4d0b5d180),
(6,
0xd0a1d182d0b0d180d188d0b8d0b920d0bcd0bed0b4d0b5d180),
(7,
0xd090d0b4d0bcd0b8d0bd),
(8,
0xd0a1d183d0bfd0b5d18020d090d0b4d0bcd0b8d0bd),
(9,
0xd090d0b2d182d0bed18020d0bfd180d0bed0b5d0bad182d0b0);

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

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

CREATE TABLE IF NOT EXISTS
`lib` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `id_us` int(20) NOT
NULL,
  `time` varchar(40) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL
DEFAULT '',
  `text` longtext NOT NULL,
  `name` varchar(100) CHARACTER SET
cp1251 COLLATE cp1251_bin NOT NULL,
  `id_cat` int(20) NOT NULL,
  `kol`
int(20) NOT NULL,
  `file` text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT EXISTS
`lib_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50)
CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`lib_vote` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `us_id` int(11) NOT
NULL DEFAULT '0',
  `like` smallint(1) NOT NULL DEFAULT '0',
  `dlike`
smallint(1) NOT NULL DEFAULT '0',
  `st` int(11) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT EXISTS
`logs` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `log` varchar(255) NOT
NULL DEFAULT '',
  `msg` text NOT NULL,
  `time` int(20) NOT NULL DEFAULT
'0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`maf1` (
  `klu4` int(8) NOT NULL DEFAULT '0',
  `time` varchar(5) NOT NULL
DEFAULT '',
  `who` varchar(100) NOT NULL DEFAULT '',
  `message` text NOT
NULL,
  `messagewosm` text NOT NULL,
  `messagewoasm` text NOT NULL,
  `id`
double NOT NULL DEFAULT '0',
  `towhom` varchar(12) NOT NULL DEFAULT '',
 
`hid` smallint(1) NOT NULL DEFAULT '0',
  `usid` int(12) NOT NULL DEFAULT
'0',
  `gamemes` tinyint(1) NOT NULL DEFAULT '0',
  `komu` varchar(40) NOT
NULL DEFAULT '',
  PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

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

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

CREATE TABLE IF NOT
EXISTS `mafaction1` (
  `klu4` tinyint(1) NOT NULL DEFAULT '0',
  `action`
varchar(100) NOT NULL DEFAULT '',
  `nexttime` int(11) NOT NULL DEFAULT
'0',
  `kiked` tinyint(1) NOT NULL DEFAULT '0',
  `prevprev` int(11) NOT
NULL DEFAULT '0',
  `prev` int(11) NOT NULL DEFAULT '0',
  `current`
int(11) NOT NULL DEFAULT '0',
  `cround` smallint(2) NOT NULL DEFAULT '0',

 PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS
`mafia` (
  `klu4` int(11) NOT NULL DEFAULT '0',
  `night_act` text NOT
NULL,
  PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS
`mail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT
NULL,
  `id_kont` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `msg` text
NOT NULL,
  `read` set('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY
(`id`),
  KEY `id_user` (`id_user`,`id_kont`),
  KEY `read` (`read`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`maniac` (
  `klu4` int(11) NOT NULL DEFAULT '0',
  `night_act` text NOT
NULL,
  PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS
`message` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user` varchar(40)
NOT NULL,
  `user_id` int(20) NOT NULL DEFAULT '0',
  `komu` varchar(40)
NOT NULL DEFAULT '0',
  `time` varchar(40) NOT NULL,
  `msg` blob,
  `rm`
int(20) NOT NULL DEFAULT '0',
  `emo` int(20) NOT NULL DEFAULT '0',
  `bb`
int(20) NOT NULL DEFAULT '0',
  `color` int(20) NOT NULL DEFAULT '0',
 
`privat` int(20) NOT NULL DEFAULT '0',
  `inps` int(20) NOT NULL DEFAULT
'0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`news` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT
NULL DEFAULT '0',
  `time` int(20) NOT NULL DEFAULT '0',
  `msg` text NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`newskom` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `new` int(20) NOT
NULL DEFAULT '0',
  `user_id` int(20) NOT NULL DEFAULT '0',
  `time`
int(20) NOT NULL DEFAULT '0',
  `msg` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`objavs` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT
NULL DEFAULT '0',
  `name` blob NOT NULL,
  `msg` blob NOT NULL,
  `time`
int(20) NOT NULL DEFAULT '0',
  `chit` int(20) NOT NULL DEFAULT '0',
 
`srok` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`odobr` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `adm_id` int(20) NOT
NULL,
  `user_id` int(20) NOT NULL,
  `yes` int(2) NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

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

CREATE TABLE IF NOT EXISTS
`oko` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT
NULL DEFAULT '0',
  `who_id` int(20) NOT NULL DEFAULT '0',
  `msg` blob NOT
NULL,
  `time` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`opinions` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20)
NOT NULL DEFAULT '0',
  `mgs_id` int(20) NOT NULL DEFAULT '0',
  `msg` blob
NOT NULL,
  `time` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`opsos` (
  `min` bigint(11) DEFAULT NULL,
  `max` bigint(11) DEFAULT
NULL,
  `opsos` varchar(64) DEFAULT NULL,
  KEY `min` (`min`,`max`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS
`perevod` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tip` varchar(100)
NOT NULL DEFAULT '',
  `user_id` int(20) NOT NULL DEFAULT '0',
  `to_id`
int(20) NOT NULL DEFAULT '0',
  `kol` int(20) NOT NULL DEFAULT '0',
 
`time` int(20) NOT NULL DEFAULT '0',
  `kom` text NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`privat` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user` varchar(40)
NOT NULL DEFAULT '',
  `user_id` int(12) NOT NULL DEFAULT '0',
  `msg` blob
NOT NULL,
  `to_user` varchar(40) NOT NULL DEFAULT '',
  `to_id` int(12)
NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `readin`
tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`question` (
  `number` int(5) NOT NULL DEFAULT '0',
  `vopros` blob NOT
NULL,
  `answer` varchar(100) NOT NULL DEFAULT '',
  `tran` varchar(60) NOT
NULL DEFAULT '',
  PRIMARY KEY (`number`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

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

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

CREATE TABLE IF NOT
EXISTS `questions` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id`
int(20) NOT NULL DEFAULT '0',
  `vote` blob NOT NULL,
  `vars` text NOT
NULL,
  `time` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`rekl` (
  `id` int(99) NOT NULL AUTO_INCREMENT,
  `gde` int(2) NOT NULL,
 
`url` text NOT NULL,
  `name` text NOT NULL,
  `time` text NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT EXISTS
`scores1` (
  `gamer_id` int(11) NOT NULL DEFAULT '0',
  `score` int(11)
NOT NULL DEFAULT '0',
  PRIMARY KEY (`gamer_id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS
`setting` (
  `ids` int(1) NOT NULL DEFAULT '1',
  `link` varchar(200) NOT
NULL DEFAULT 'masteram.us',
  `link_name` varchar(50) NOT NULL DEFAULT
'masteram.us',
  `rus` int(1) NOT NULL DEFAULT '1',
  `reg` int(1) NOT NULL
DEFAULT '1',
  `umnik` varchar(50) NOT NULL DEFAULT 'umnik',
  `shut`
varchar(50) NOT NULL DEFAULT 'shut',
  `anek` varchar(50) NOT NULL DEFAULT
'anek',
  `tupica` varchar(50) NOT NULL DEFAULT 'tupica',
  `svaisch`
varchar(50) NOT NULL DEFAULT 'svaisch',
  `system` varchar(50) NOT NULL
DEFAULT 'system',
  `baryga` varchar(50) NOT NULL DEFAULT 'baryga',
 
`znatok` varchar(50) NOT NULL DEFAULT 'znatok',
  `flyder` varchar(50) NOT
NULL DEFAULT 'flyder',
  `victint` int(20) NOT NULL DEFAULT '10',
 
`shuttime` int(20) NOT NULL DEFAULT '1800',
  `znatoktime` int(20) NOT NULL
DEFAULT '1800',
  `anektime` int(20) NOT NULL DEFAULT '1800',
  `vict`
int(1) NOT NULL DEFAULT '1',
  `cena_answ` int(20) NOT NULL DEFAULT '100',

 `timesdvig` int(20) NOT NULL DEFAULT '0',
  `time_aut` int(20) NOT NULL
DEFAULT '300',
  `head` text NOT NULL,
  `antir` text NOT NULL,
 
`avtorega` int(2) NOT NULL DEFAULT '0',
  `privat` int(2) NOT NULL DEFAULT
'9',
  `posts_pr` int(20) NOT NULL DEFAULT '0',
  `posts_vph` int(20) NOT
NULL DEFAULT '0',
  `posts_vus` int(20) NOT NULL DEFAULT '0',
  `posts_nik`
int(20) NOT NULL DEFAULT '150',
  `size_photo` int(20) NOT NULL DEFAULT
'250',
  `w_photo` int(20) NOT NULL DEFAULT '0',
  `h_photo` int(20) NOT
NULL DEFAULT '0',
  `size_foto` int(20) NOT NULL DEFAULT '0',
  `w_foto`
int(20) NOT NULL DEFAULT '0',
  `h_foto` int(20) NOT NULL DEFAULT '0',
 
`w_foto2` int(20) NOT NULL DEFAULT '0',
  `h_foto2` int(20) NOT NULL
DEFAULT '0',
  `size_img_sten` int(20) NOT NULL DEFAULT '0',
  `w_img_sten`
int(20) NOT NULL DEFAULT '0',
  `h_img_sten` int(20) NOT NULL DEFAULT '0',

 `kom_p_posts` int(20) NOT NULL DEFAULT '0',
  `min_p_posts` int(20) NOT
NULL DEFAULT '0',
  `max_p_posts` int(20) NOT NULL DEFAULT '0',
 
`kom_p_rur` int(20) NOT NULL DEFAULT '0',
  `min_p_rur` int(20) NOT NULL
DEFAULT '0',
  `max_p_rur` int(20) NOT NULL DEFAULT '0',
  `kurs_bank_ob`
int(20) NOT NULL DEFAULT '0',
  `size_lich` int(20) NOT NULL DEFAULT '20',

 `size_video` int(20) NOT NULL DEFAULT '0',
  `size_audio` int(20) NOT NULL
DEFAULT '0',
  `size_for` int(20) NOT NULL DEFAULT '0',
  `size_vvod_for`
int(20) NOT NULL DEFAULT '0',
  `for_time_p` int(20) NOT NULL DEFAULT '0',

 `for_time_t` int(20) NOT NULL DEFAULT '0',
  `for_cit` int(20) NOT NULL
DEFAULT '0',
  `for_privat` int(20) NOT NULL DEFAULT '0',
  `kik_notify`
int(20) NOT NULL DEFAULT '0',
  `ban_notify` int(20) NOT NULL DEFAULT '0',

 `ban2_notify` int(20) NOT NULL DEFAULT '0',
  `style` varchar(50) NOT NULL
DEFAULT 'sasisa',
  `alignpr` varchar(50) NOT NULL DEFAULT 'left',
 
`objavs_rur` int(20) NOT NULL DEFAULT '1',
  `name` varchar(50) NOT NULL
DEFAULT 'Вобля.ру',
  `mafiozi` varchar(50) NOT NULL DEFAULT
'mafiozi',
  `c_status` int(11) NOT NULL DEFAULT '0',
  `c_nick` int(11)
NOT NULL DEFAULT '0',
  `c_obiav` int(11) NOT NULL DEFAULT '0',
  `c_topic`
int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ids`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

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

INSERT INTO `setting` (`ids`, `link`, `link_name`, `rus`,
`reg`, `umnik`, `shut`, `anek`, `tupica`, `svaisch`, `system`, `baryga`,
`znatok`, `flyder`, `victint`, `shuttime`, `znatoktime`, `anektime`,
`vict`, `cena_answ`, `timesdvig`, `time_aut`, `head`, `antir`, `avtorega`,
`privat`, `posts_pr`, `posts_vph`, `posts_vus`, `posts_nik`, `size_photo`,
`w_photo`, `h_photo`, `size_foto`, `w_foto`, `h_foto`, `w_foto2`,
`h_foto2`, `size_img_sten`, `w_img_sten`, `h_img_sten`, `kom_p_posts`,
`min_p_posts`, `max_p_posts`, `kom_p_rur`, `min_p_rur`, `max_p_rur`,
`kurs_bank_ob`, `size_lich`, `size_video`, `size_audio`, `size_for`,
`size_vvod_for`, `for_time_p`, `for_time_t`, `for_cit`, `for_privat`,
`kik_notify`, `ban_notify`, `ban2_notify`, `style`, `alignpr`,
`objavs_rur`, `name`, `mafiozi`, `c_status`, `c_nick`, `c_obiav`,
`c_topic`) VALUES
(1, 'masteram.us', 'masteram.us', 1, 2, 'umnik', 'shut',
'anek', 'tupica', 'svaisch', 'system', 'baryga', 'znatok', 'flyder', 10,
1800, 1800, 1800, 1, 100, 0, 300, '', '', 0, 9, 0, 0, 0, 150, 2000, 200,
200, 2000, 50, 50, 0, 250, 50, 100, 100, 10, 20, 600, 10, 20, 600, 100, 20,
200000, 1024, 1024, 2147483647, 15, 1, 200, 9, 1, 1, 1, 'dizaine', 'left',
0, '', 'mafiozi', 1000, 3000, 5000, 1000);

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

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

CREATE TABLE IF NOT EXISTS
`shops` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author` int(11) NOT
NULL DEFAULT '0',
  `price` int(11) NOT NULL DEFAULT '0',
  `name`
varchar(50) NOT NULL DEFAULT '',
  `date` varchar(25) NOT NULL DEFAULT '',

 `type` varchar(1) NOT NULL DEFAULT '',
  `have` smallint(2) NOT NULL
DEFAULT '0',
  `have_user` int(11) NOT NULL DEFAULT '0',
  `cid` int(11)
NOT NULL DEFAULT '0',
  `path` varchar(50) NOT NULL DEFAULT '',
  `comment`
varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`shutki` (
  `ids` int(11) NOT NULL AUTO_INCREMENT,
  `message` blob NOT
NULL,
  PRIMARY KEY (`ids`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`spamus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT
NULL,
  `id_kont` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `msg`
varchar(1024) NOT NULL,
  `read` set('0','1') NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`),
  KEY `id_user` (`id_user`,`id_kont`),
  KEY `read`
(`read`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`sps` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `kto` int(20) NOT NULL,
 
`komu` int(20) NOT NULL,
  `type` varchar(80) CHARACTER SET cp1251 COLLATE
cp1251_bin NOT NULL,
  `text` text CHARACTER SET cp1251 COLLATE cp1251_bin
NOT NULL,
  `time` bigint(50) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`stena` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT
NULL DEFAULT '0',
  `mgs_id` int(20) NOT NULL DEFAULT '0',
  `msg` blob NOT
NULL,
  `time` int(20) NOT NULL DEFAULT '0',
  `img` text NOT NULL,
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`users` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user` varchar(50) NOT
NULL DEFAULT '',
  `pass` varchar(500) DEFAULT NULL,
  `name` varchar(30)
DEFAULT NULL,
  `surname` varchar(30) DEFAULT NULL,
  `sex` int(1) NOT NULL
DEFAULT '1',
  `semia` int(1) NOT NULL DEFAULT '0',
  `day` int(2) NOT NULL
DEFAULT '0',
  `month` int(2) NOT NULL DEFAULT '0',
  `year` int(5) NOT
NULL DEFAULT '0',
  `politic` int(1) NOT NULL DEFAULT '0',
  `city`
varchar(50) NOT NULL DEFAULT '',
  `country` varchar(50) NOT NULL DEFAULT
'',
  `religia` varchar(50) NOT NULL DEFAULT '',
  `mail` varchar(50) NOT
NULL DEFAULT '',
  `mobtel` varchar(30) DEFAULT NULL,
  `hometel`
varchar(30) DEFAULT NULL,
  `icq` varchar(30) DEFAULT NULL,
  `site`
varchar(30) DEFAULT NULL,
  `deiat` blob,
  `interes` blob,
  `likemuz`
blob,
  `likefil` blob,
  `liketel` blob,
  `likebook` blob,
  `likegames`
blob,
  `likecit` blob,
  `infa` blob,
  `obcoun` varchar(50) DEFAULT
NULL,
  `obcity` varchar(50) DEFAULT NULL,
  `school` varchar(50) DEFAULT
NULL,
  `vuz` varchar(50) DEFAULT NULL,
  `ptu` varchar(50) DEFAULT NULL,
 
`valcoun` varchar(50) DEFAULT NULL,
  `valcity` varchar(50) DEFAULT NULL,
 
`val` varchar(50) DEFAULT NULL,
  `valyear1` varchar(50) DEFAULT NULL,
 
`valyear2` varchar(50) DEFAULT NULL,
  `position` varchar(50) DEFAULT
NULL,
  `milcoun` varchar(50) DEFAULT NULL,
  `milcity` varchar(50) DEFAULT
NULL,
  `fsize` varchar(10) NOT NULL DEFAULT 'medium',
  `nastroi`
varchar(100) NOT NULL DEFAULT '',
  `ver` varchar(25) NOT NULL DEFAULT '',

 `daya` int(20) NOT NULL DEFAULT '0',
  `dayp` int(20) NOT NULL DEFAULT
'0',
  `style` varchar(50) NOT NULL DEFAULT 'shaxty-style',
  `photo`
varchar(200) NOT NULL DEFAULT '',
  `vote_photo` int(200) NOT NULL DEFAULT
'0',
  `credits` int(20) NOT NULL DEFAULT '0',
  `gposts` int(20) NOT NULL
DEFAULT '0',
  `translit` tinyint(1) NOT NULL DEFAULT '0',
  `visit`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 
`ruser` varchar(30) NOT NULL DEFAULT '',
  `onl` int(20) NOT NULL DEFAULT
'0',
  `posts` int(20) NOT NULL DEFAULT '0',
  `status` varchar(100) NOT
NULL DEFAULT 'User',
  `date` varchar(50) DEFAULT NULL,
  `timereg`
varchar(50) DEFAULT NULL,
  `max` int(2) NOT NULL DEFAULT '10',
  `max_pr`
int(2) NOT NULL DEFAULT '5',
  `pole1` int(2) NOT NULL DEFAULT '2',
 
`pole2` int(2) NOT NULL DEFAULT '20',
  `pic_stat` int(2) NOT NULL DEFAULT
'1',
  `level` int(6) NOT NULL DEFAULT '0',
  `user_ip` varchar(20) NOT
NULL DEFAULT '',
  `user_soft` varchar(200) NOT NULL DEFAULT '',
  `inv`
tinyint(1) NOT NULL DEFAULT '0',
  `kik` int(20) NOT NULL DEFAULT '0',
 
`whokik` varchar(20) NOT NULL DEFAULT '',
  `whykik` varchar(200) NOT NULL
DEFAULT '',
  `bann` int(20) NOT NULL DEFAULT '0',
  `whobann` varchar(20)
NOT NULL DEFAULT '',
  `whybann` varchar(200) NOT NULL DEFAULT '',
 
`byeotv` int(20) NOT NULL DEFAULT '0',
  `alltraf` varchar(255) NOT NULL
DEFAULT '0',
  `lasttraf` varchar(255) NOT NULL DEFAULT '0',
  `costtraf`
int(255) NOT NULL DEFAULT '0',
  `creditsingame` int(20) NOT NULL DEFAULT
'0',
  `mafcredits` int(20) NOT NULL DEFAULT '0',
  `avtootvet` blob NOT
NULL,
  `binds` varchar(255) NOT NULL DEFAULT '',
  `para` varchar(50) NOT
NULL DEFAULT '',
  `myavatar` varchar(50) NOT NULL DEFAULT '',
  `anketa`
varchar(255) NOT NULL DEFAULT '',
  `rur` int(20) NOT NULL DEFAULT '0',
 
`rurmag` int(20) NOT NULL DEFAULT '0',
  `postsf` int(20) NOT NULL DEFAULT
'0',
  `vote_us` int(20) NOT NULL DEFAULT '0',
  `pp_m_s` int(2) NOT NULL
DEFAULT '0',
  `pp_c_fr` int(2) NOT NULL DEFAULT '0',
  `pp_c_st` int(2)
NOT NULL DEFAULT '0',
  `pp_st_s` int(2) NOT NULL DEFAULT '0',
  `pp_f_s`
int(2) NOT NULL DEFAULT '0',
  `pp_al` int(2) NOT NULL DEFAULT '0',
 
`pp_al_k` int(2) NOT NULL DEFAULT '0',
  `pp_gifts` int(2) NOT NULL DEFAULT
'0',
  `fr_notify` int(2) NOT NULL DEFAULT '1',
  `pm_notify` int(2) NOT
NULL DEFAULT '1',
  `st_notify` int(2) NOT NULL DEFAULT '1',
  `ph_notify`
int(2) NOT NULL DEFAULT '1',
  `gr_notify` int(2) NOT NULL DEFAULT '1',
 
`gifts_notify` int(2) NOT NULL DEFAULT '1',
  `avr` int(20) NOT NULL
DEFAULT '0',
  `color_nik` varchar(50) NOT NULL DEFAULT '',
  `effnik`
varchar(50) NOT NULL DEFAULT '',
  `odobr` int(2) NOT NULL DEFAULT '0',
 
`razd` int(2) NOT NULL DEFAULT '1',
  `forma` int(2) NOT NULL DEFAULT '1',

 `redp` int(2) NOT NULL DEFAULT '1',
  `formf` int(2) NOT NULL DEFAULT
'1',
  `sizep` int(2) NOT NULL DEFAULT '512',
  `diaries` int(20) NOT NULL
DEFAULT '0',
  `viz` int(20) NOT NULL DEFAULT '0',
  `dd` int(20) NOT NULL
DEFAULT '1',
  `emo` int(20) NOT NULL DEFAULT '1',
  `color` int(20) NOT
NULL DEFAULT '1',
  `softk` int(20) NOT NULL DEFAULT '0',
  `polevv` int(2)
NOT NULL DEFAULT '2',
  `email` varchar(50) NOT NULL DEFAULT '',
 
`fo_files` int(20) NOT NULL DEFAULT '0',
  `us_files` int(20) NOT NULL
DEFAULT '0',
  `rest_time` int(20) NOT NULL DEFAULT '0',
  `rest_code`
varchar(200) NOT NULL DEFAULT '',
  `lvisit` int(11) NOT NULL,
  `alcohol`
int(11) NOT NULL DEFAULT '0',
  `bk_force` tinyint(3) unsigned NOT NULL
DEFAULT '0',
  `bk_endurance` tinyint(3) unsigned NOT NULL DEFAULT '0',
 
`bk_adroitness` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `bk_accuracy`
tinyint(3) unsigned NOT NULL DEFAULT '0',
  `bk_health` tinyint(3) unsigned
NOT NULL DEFAULT '0',
  `bk_victories` smallint(5) NOT NULL DEFAULT '0',
 
`bk_defeats` smallint(5) NOT NULL DEFAULT '0',
  `bk_weapons` text,
 
`bk_trauma` int(10) NOT NULL DEFAULT '0',
  `set_prev` int(11) NOT NULL
DEFAULT '20',
  `invite` int(11) NOT NULL DEFAULT '0',
  `lsmile`
varchar(30) NOT NULL,
  `lsmile2` varchar(30) NOT NULL,
  `lsmile3`
varchar(30) NOT NULL,
  `spgr` varchar(20) NOT NULL,
  `bonus_time` int(11)
NOT NULL DEFAULT '0',
  `location` text,
  `location_ref` text,
 
`jurnalist` tinyint(1) NOT NULL DEFAULT '0',
  `poias` varchar(50) NOT
NULL,
  `add_konts` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=3 ;

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

INSERT INTO `users` (`id`,
`user`, `pass`, `name`, `surname`, `sex`, `semia`, `day`, `month`, `year`,
`politic`, `city`, `country`, `religia`, `mail`, `mobtel`, `hometel`,
`icq`, `site`, `deiat`, `interes`, `likemuz`, `likefil`, `liketel`,
`likebook`, `likegames`, `likecit`, `infa`, `obcoun`, `obcity`, `school`,
`vuz`, `ptu`, `valcoun`, `valcity`, `val`, `valyear1`, `valyear2`,
`position`, `milcoun`, `milcity`, `fsize`, `nastroi`, `ver`, `daya`,
`dayp`, `style`, `photo`, `vote_photo`, `credits`, `gposts`, `translit`,
`visit`, `ruser`, `onl`, `posts`, `status`, `date`, `timereg`, `max`,
`max_pr`, `pole1`, `pole2`, `pic_stat`, `level`, `user_ip`, `user_soft`,
`inv`, `kik`, `whokik`, `whykik`, `bann`, `whobann`, `whybann`, `byeotv`,
`alltraf`, `lasttraf`, `costtraf`, `creditsingame`, `mafcredits`,
`avtootvet`, `binds`, `para`, `myavatar`, `anketa`, `rur`, `rurmag`,
`postsf`, `vote_us`, `pp_m_s`, `pp_c_fr`, `pp_c_st`, `pp_st_s`, `pp_f_s`,
`pp_al`, `pp_al_k`, `pp_gifts`, `fr_notify`, `pm_notify`, `st_notify`,
`ph_notify`, `gr_notify`, `gifts_notify`, `avr`, `color_nik`, `effnik`,
`odobr`, `razd`, `forma`, `redp`, `formf`, `sizep`, `diaries`, `viz`, `dd`,
`emo`, `color`, `softk`, `polevv`, `email`, `fo_files`, `us_files`,
`rest_time`, `rest_code`, `lvisit`, `alcohol`, `bk_force`, `bk_endurance`,
`bk_adroitness`, `bk_accuracy`, `bk_health`, `bk_victories`, `bk_defeats`,
`bk_weapons`, `bk_trauma`, `set_prev`, `invite`, `lsmile`, `lsmile2`,
`lsmile3`, `spgr`, `bonus_time`, `location`, `location_ref`, `jurnalist`,
`poias`, `add_konts`) VALUES
(2, 'admin',
'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, 1, 0, 0, 0, 0, 0, '', '',
'', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, 'medium', '', 'xhtml', 0, 0, 'dizaine', '', 0, 0, 0, 0,
'2013-03-26 14:27:52', 'admin', 1364308072, 0, 'РњР°СЃС‚РµСЂ',
'26-03-2013', '1364307999.41', 10, 5, 2, 20, 1, 9, '127.0.0.1', 'Opera/9.80
', 0, 0, '', '', 0, '', '', 0, '31.7', '3.6', 0, 0, 0, '',
'1|2|3|4|5|6|8|0', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1,
1, 1, 1, 0, '', '', 0, 1, 1, 1, 1, 512, 0, 26, 1, 1, 1, 0, 2, '', 0, 0, 0,
'', 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 20, 0, '', '', '', '', 0,
'|Анкета admin', '/info.php', 0, '180', 1);

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

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

CREATE TABLE IF NOT
EXISTS `users_konts` (
  `id_user` int(11) NOT NULL,
  `id_kont` int(11)
NOT NULL,
  `time` int(11) NOT NULL,
  UNIQUE KEY `id_user_2`
(`id_user`,`id_kont`),
  KEY `id_user` (`id_user`,`id_kont`,`time`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS
`us_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` text NOT NULL,

 `infolder` text NOT NULL,
  `name` varchar(255) NOT NULL,
  `priority`
tinyint(3) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
 
`pos` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`us_cat2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fid` int(11) NOT
NULL DEFAULT '0',
  `path` text NOT NULL,
  `infolder` text NOT NULL,
 
`name` varchar(255) NOT NULL,
  `priority` tinyint(3) NOT NULL DEFAULT
'0',
  `time` int(11) NOT NULL DEFAULT '0',
  `pos` int(11) NOT NULL
DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`us_files` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20)
NOT NULL DEFAULT '0',
  `path` text NOT NULL,
  `infolder` text NOT NULL,
 
`name` varchar(255) NOT NULL,
  `priority` tinyint(3) NOT NULL DEFAULT
'0',
  `size` bigint(20) NOT NULL,
  `about` text NOT NULL,
  `pass` text
NOT NULL,
  `price` int(11) NOT NULL DEFAULT '0',
  `fastabout` text NOT
NULL,
  `loads` int(11) NOT NULL DEFAULT '0',
  `timeload` int(11) unsigned
NOT NULL,
  `timeupload` int(11) NOT NULL,
  `ips` text NOT NULL,
  `yes`
int(11) NOT NULL DEFAULT '0',
  `no` int(11) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT EXISTS
`us_komm` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `file` int(20) NOT
NULL DEFAULT '0',
  `user_id` int(20) NOT NULL DEFAULT '0',
  `time`
int(20) NOT NULL DEFAULT '0',
  `msg` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`video` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` text NOT
NULL,
  `name` text NOT NULL,
  `kom` text NOT NULL,
  `prosm` int(20) NOT
NULL DEFAULT '0',
  `time` text NOT NULL,
  `adres` text NOT NULL,
 
`format` text NOT NULL,
  `razmer` text NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `video_komm` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id`
int(20) NOT NULL DEFAULT '0',
  `mgs_id` int(20) NOT NULL DEFAULT '0',
 
`msg` blob NOT NULL,
  `time` int(20) NOT NULL DEFAULT '0',
  `video`
int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`vklads` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT
NULL DEFAULT '0',
  `vklad` int(20) NOT NULL DEFAULT '0',
  `kol` int(20)
NOT NULL DEFAULT '0',
  `time` int(20) NOT NULL DEFAULT '0',
  `srok`
int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `vote_diaries` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `vote_id`
int(20) NOT NULL DEFAULT '0',
  `did` int(20) NOT NULL DEFAULT '0',
 
`znak` int(20) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `vote_photo` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id`
int(20) NOT NULL DEFAULT '0',
  `vote_id` int(20) NOT NULL DEFAULT '0',
 
`znak` int(20) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`vote_us` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT
NULL DEFAULT '0',
  `vote_id` int(20) NOT NULL DEFAULT '0',
  `znak`
int(20) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`vstr` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT
NULL DEFAULT '0',
  `time` int(20) NOT NULL DEFAULT '0',
  `msg` text NOT
NULL,
  `org` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`who` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user` int(20) NOT NULL
DEFAULT '0',
  `time` varchar(40) NOT NULL DEFAULT '',
  `room` varchar(40)
NOT NULL DEFAULT '',
  `rm` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=17
;

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

INSERT INTO `who`
(`id`, `user`, `time`, `room`, `rm`) VALUES
(1, 0, '1364307852.56',
'enter', 0),
(8, 1, '1364307947.66', 'enter', 0),
(16, 2, '1364308072.38',
'enter', 0);

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

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

CREATE TABLE IF NOT EXISTS
`wluha` (
  `klu4` int(11) NOT NULL DEFAULT '0',
  `night_act` text NOT
NULL,
  PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS
`wm_info` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `id_us` int(20) NOT
NULL,
  `time` varchar(40) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL
DEFAULT '',
  `text` longtext NOT NULL,
  `name` varchar(100) CHARACTER SET
cp1251 COLLATE cp1251_bin NOT NULL,
  `id_cat` int(20) NOT NULL,
  `kol`
int(20) NOT NULL,
  `op` text NOT NULL,
  `ips` text NOT NULL,
  `yes`
int(11) NOT NULL DEFAULT '0',
  `no` int(11) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `wm_info_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`
varchar(50) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
  `op`
varchar(50) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`xstatus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` text NOT
NULL,
  `stat` text NOT NULL,
  `name` text NOT NULL,
  `content` text NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`zvezda` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `komu` int(11) NOT
NULL,
  `kto` int(11) NOT NULL,
  `time` bigint(30) NOT NULL DEFAULT '0',
 
`text` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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