Просмотр архива Движок masteram.us

-- phpMyAdmin SQL Dump
-- version 3.4.11.1deb2
--
http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время
создания: Май 24 2014 г., 04:59
-- Версия сервера:
5.5.31
-- Версия PHP: 5.4.4-14+deb7u8

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

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

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

--
--
Структура таблицы `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`),
  KEY
`user_id` (`user_id`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`avtoriz` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` int(20) NOT
NULL DEFAULT '0',
  `ruser` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin
NOT NULL DEFAULT '',
  `time` int(20) NOT NULL DEFAULT '0',
  `ip`
varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `br`
text NOT NULL,
  `kol` int(20) NOT NULL DEFAULT '0',
  `time2` int(20) NOT
NULL DEFAULT '0',
  `yes` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT EXISTS
`ban_ip` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ip`
varchar(20) NOT NULL,
  `ipl` varchar(20) NOT NULL,
  `user` varchar(20)
NOT NULL DEFAULT '',
  `time` int(11) unsigned NOT NULL DEFAULT '0',
 
`url` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `ip`
(`ip`),
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`ban_soft` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `soft`
varchar(200) NOT NULL,
  `user` varchar(20) NOT NULL DEFAULT '',
  `time`
int(11) unsigned NOT NULL DEFAULT '0',
  `url` varchar(20) NOT NULL DEFAULT
'',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `ban_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id`
int(11) NOT NULL,
  `ban_time` int(11) NOT NULL,
  `ban_while` int(11) NOT
NULL,
  `ban_type` tinyint(4) NOT NULL DEFAULT '1',
  `ban_who` varchar(30)
NOT NULL,
  `ban_ref` int(11) NOT NULL,
  `ban_reason` text NOT NULL,
 
`ban_raz` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id`
(`user_id`),
  KEY `ban_time` (`ban_time`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`billing` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id` int(12)
NOT NULL DEFAULT '0',
  `rur` int(12) NOT NULL DEFAULT '0',
  `mod` text
NOT NULL,
  `komm` text NOT NULL,
  `time` int(11) NOT NULL DEFAULT '0',
 
`yes` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `bill_hist` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id`
int(12) NOT NULL DEFAULT '0',
  `to_id` int(12) NOT NULL DEFAULT '0',
 
`rur` int(12) NOT NULL DEFAULT '0',
  `mod` text NOT NULL,
  `komm` text
NOT NULL,
  `time` int(11) NOT NULL DEFAULT '0',
  `yes` tinyint(1) NOT
NULL DEFAULT '0',
  `kod` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`bill_set` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `rekl` int(12) NOT
NULL DEFAULT '0',
  `bb` int(12) NOT NULL DEFAULT '0',
  `color` int(12)
NOT NULL DEFAULT '0',
  `tema` int(12) NOT NULL DEFAULT '0',
  `nik`
int(12) NOT NULL DEFAULT '0',
  `nik2` int(10) unsigned NOT NULL,
 
`status` int(12) NOT NULL DEFAULT '0',
  `colornick` int(11) NOT NULL
DEFAULT '20',
  `adres` int(11) NOT NULL DEFAULT '20',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`blogs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `refid` int(11) NOT
NULL,
  `refer` varchar(255) NOT NULL DEFAULT '',
  `tip` varchar(255) NOT
NULL DEFAULT '',
  `pos` int(11) NOT NULL,
  `adds` int(11) NOT NULL
DEFAULT '0',
  `user_id` varchar(255) NOT NULL DEFAULT '',
  `name` text
NOT NULL,
  `name_lat` varchar(100) DEFAULT NULL,
  `about` text NOT NULL,

 `msg` text NOT NULL,
  `time` int(11) NOT NULL DEFAULT '0',
  `chit`
int(11) NOT NULL DEFAULT '0',
  `html` int(11) NOT NULL DEFAULT '0',
 
`vote` int(11) NOT NULL DEFAULT '0',
  `ips` text NOT NULL,
  `yes` int(11)
NOT NULL DEFAULT '0',
  `no` int(11) NOT NULL DEFAULT '0',
  `klych` text
NOT NULL,
  PRIMARY KEY (`id`),
  KEY `refid` (`refid`),
  KEY `time`
(`time`),
  KEY `chit` (`chit`),
  KEY `user_id` (`user_id`),
  FULLTEXT
KEY `msg` (`msg`),
  FULLTEXT KEY `name` (`name`),
  FULLTEXT KEY `klych`
(`klych`),
  FULLTEXT KEY `about` (`about`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `blog_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `refid`
int(11) NOT NULL,
  `blog` int(11) NOT NULL,
  `user_id` int(11) NOT NULL
DEFAULT '0',
  `file` text NOT NULL,
  `fname` text NOT NULL,
  `fsize`
int(11) NOT NULL DEFAULT '0',
  `sfile` int(11) NOT NULL DEFAULT '0',
 
`privat` int(11) NOT NULL DEFAULT '0',
  `vip` int(11) NOT NULL DEFAULT
'0',
  PRIMARY KEY (`id`),
  KEY `refid` (`refid`),
  FULLTEXT KEY `file`
(`file`),
  FULLTEXT KEY `fname` (`fname`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `blog_komm` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `blog`
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
;

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

--
--
Структура таблицы `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 ;

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

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

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

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

INSERT INTO `bomj` (`klu4`,
`night_act`) VALUES
(1,
'&#x413;&#x43E;&#x440;&#x43E;&#x434;&#x441;&#x43A;&#x43E;&#x439;
&#x431;&#x43E;&#x43C;&#x436;,
&#x43E;&#x441;&#x442;&#x430;&#x432;&#x438;&#x432;
&#x43F;&#x43E;&#x43C;&#x43E;&#x439;&#x43A;&#x443;,
w&#x430;&#x440;&#x438;&#x442;
&#x441;&#x432;&#x43E;&#x438;&#x43C;&#x438;
&#x433;&#x440;&#x44F;&#x437;&#x43D;&#x44B;&#x43C;&#x438;
&#x440;&#x443;&#x43A;&#x430;&#x43C;&#x438;
&#x43F;&#x43E;
&#x43A;&#x430;&#x440;&#x43C;&#x430;&#x43D;&#x430;&#x43C;
&#x43F;&#x440;&#x43E;&#x445;&#x43E;&#x436;&#x438;&#x445;...'),
(2,
'&#x412;&#x43E;&#x43D;&#x44E;&#x447;&#x438;&#x439;
&#x431;&#x43E;&#x43C;&#x436;
w&#x43D;&#x44B;&#x440;&#x44F;&#x435;&#x442;
&#x43F;&#x43E;
&#x43F;&#x435;&#x440;&#x435;&#x443;&#x43B;&#x43A;&#x430;&#x43C;,
&#x438; &#x43C;&#x435;&#x436;&#x434;&#x443;
&#x43E;&#x447;&#x435;&#x440;&#x435;&#x434;&#x43D;&#x43E;&#x439;
&#x43C;&#x443;&#x441;&#x43E;&#x440;&#x43A;&#x43E;&#x439;
&#x43A;&#x43E;&#x43F;&#x430;&#x435;&#x442;&#x441;&#x44F;
&#x432;
&#x447;&#x44C;&#x438;&#x445;-&#x442;&#x43E;
&#x43A;&#x430;&#x440;&#x43C;&#x430;&#x43D;&#x430;&#x445;...'),
(3,
'&#x411;&#x43E;&#x43C;&#x436;,
&#x440;&#x430;&#x441;&#x43F;&#x440;&#x43E;&#x441;&#x442;&#x440;&#x430;&#x43D;&#x44F;&#x44F;
&#x43F;&#x43E;
&#x433;&#x43E;&#x440;&#x43E;&#x434;&#x443;
&#x447;&#x443;&#x434;&#x435;&#x441;&#x43D;&#x44B;&#x439;
&#x430;&#x440;&#x43E;&#x43C;&#x430;&#x442;
&#x441;&#x432;&#x43E;&#x438;&#x445;
&#x43F;&#x43E;&#x434;&#x43C;&#x44B;w&#x435;&#x43A;,
&#x443;&#x43C;&#x443;&#x434;&#x440;&#x44F;&#x435;&#x442;&#x441;&#x44F;
&#x435;&#x449;&#x435;
&#x43F;&#x440;&#x43E;&#x432;&#x435;&#x440;&#x44F;&#x442;&#x44C;
&#x43A;&#x430;&#x440;&#x43C;&#x430;&#x43D;&#x44B;
&#x433;&#x43E;&#x440;&#x43E;&#x436;&#x430;&#x43D;...');

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

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

CREATE TABLE IF NOT EXISTS
`codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `refid` int(11) NOT
NULL,
  `user_id` varchar(255) NOT NULL DEFAULT '',
  `name` text NOT
NULL,
  `about` text NOT NULL,
  `msg` text NOT NULL,
  `time` int(11) NOT
NULL DEFAULT '0',
  `chit` int(11) NOT NULL DEFAULT '0',
  `html` int(11)
NOT NULL DEFAULT '0',
  `vote` int(11) NOT NULL DEFAULT '0',
  `ips` text
NOT NULL,
  `yes` int(11) NOT NULL DEFAULT '0',
  `no` int(11) NOT NULL
DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `refid` (`refid`),
  KEY `time`
(`time`),
  KEY `chit` (`chit`),
  KEY `user_id` (`user_id`),
  FULLTEXT
KEY `msg` (`msg`),
  FULLTEXT KEY `name` (`name`),
  FULLTEXT KEY `about`
(`about`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `codes_komm` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `cod`
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
;

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

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

CREATE TABLE IF NOT EXISTS
`count_24` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid`
int(10) unsigned NOT NULL DEFAULT '0',
  `date` int(10) unsigned NOT NULL
DEFAULT '0',
  `hour` smallint(5) unsigned NOT NULL DEFAULT '0',
  `count`
int(10) unsigned NOT NULL DEFAULT '0',
  `host` int(10) unsigned NOT NULL
DEFAULT '0',
  `status` varchar(50) NOT NULL DEFAULT 'user',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `diaskomm2` (
  `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`),
  KEY `user_id` (`user_id`),
  KEY `mgs_id`
(`mgs_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

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

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

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

CREATE TABLE IF NOT EXISTS
`files` (
  `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',
  `size` bigint(20) NOT NULL,
  `about`
text NOT NULL,
  `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(4) NOT NULL DEFAULT '0',
 
`no` int(4) NOT NULL DEFAULT '0',
  `close` smallint(4) NOT NULL DEFAULT
'0',
  PRIMARY KEY (`id`),
  KEY `size` (`size`),
  KEY `timeupload`
(`timeupload`,`size`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT EXISTS
`forum_b` (
  `id_b` int(11) NOT NULL AUTO_INCREMENT,
  `t_id` int(11) NOT
NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `user_id`
int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_b`),
  KEY `t_id`
(`t_id`),
  KEY `user_id` (`user_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,
  `pos` int(11) NOT NULL DEFAULT '0',
  `topics` int(11) unsigned NOT
NULL DEFAULT '0',
  `posts` int(11) unsigned NOT NULL DEFAULT '0',
 
`last_id_r` int(11) unsigned NOT NULL DEFAULT '0',
  `last_name_r`
varchar(100) NOT NULL DEFAULT '',
  `last_id_t` int(11) unsigned NOT NULL
DEFAULT '0',
  `last_name_t` varchar(100) NOT NULL DEFAULT '',
 
`last_id_us` int(11) unsigned NOT NULL DEFAULT '0',
  `last_time` int(11)
unsigned NOT NULL DEFAULT '0',
  `levels` int(11) unsigned NOT NULL DEFAULT
'0',
  PRIMARY KEY (`id`,`pos`),
  KEY `pos` (`pos`),
  FULLTEXT KEY `name`
(`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `forum_file` (
  `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,
 
`m_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `file`
text NOT NULL,
  `fname` text NOT NULL,
  `fsize` int(11) NOT NULL DEFAULT
'0',
  `sfile` int(11) NOT NULL DEFAULT '0',
  `privat` int(11) NOT NULL
DEFAULT '0',
  `vip` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
 
KEY `m_id` (`m_id`),
  KEY `f_id` (`f_id`),
  KEY `r_id` (`r_id`),
  KEY
`t_id` (`t_id`),
  KEY `fsize` (`fsize`),
  KEY `sfile` (`sfile`),
  KEY
`privat` (`privat`),
  KEY `user_id` (`user_id`),
  KEY `vip` (`vip`),
 
FULLTEXT KEY `file` (`file`),
  FULLTEXT KEY `fname` (`fname`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `forum_msg` (
  `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` varchar(255) NOT NULL DEFAULT '',
  `from` varchar(100) NOT NULL
DEFAULT '',
  `msg` text NOT NULL,
  `time` int(11) NOT NULL DEFAULT '0',
 
`file` text NOT NULL,
  `fname` text NOT NULL,
  `fsize` int(11) NOT NULL
DEFAULT '0',
  `sfile` int(11) NOT NULL DEFAULT '0',
  `izm` text NOT
NULL,
  `izmk` int(11) NOT NULL DEFAULT '0',
  `cit` text NOT NULL,
 
`privat` int(11) NOT NULL DEFAULT '0',
  `del` tinyint(1) NOT NULL DEFAULT
'0',
  `del_id` int(11) NOT NULL DEFAULT '0',
  `vip` int(11) NOT NULL
DEFAULT '0',
  `smiles` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY
KEY (`id`),
  KEY `f_id` (`f_id`),
  KEY `r_id` (`r_id`),
  KEY `t_id`
(`t_id`),
  KEY `del` (`del`),
  KEY `time` (`time`),
  KEY `privat`
(`privat`),
  KEY `user_id` (`user_id`),
  KEY `vip` (`vip`),
  KEY
`privat_2` (`privat`,`del`),
  KEY `privat_3` (`privat`,`del`,`time`),
 
FULLTEXT KEY `msg` (`msg`)
) 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',
  `topics` int(11) unsigned NOT NULL DEFAULT '0',
  `posts` int(11)
unsigned NOT NULL DEFAULT '0',
  `last_id_t` int(11) unsigned NOT NULL
DEFAULT '0',
  `last_name_t` varchar(100) NOT NULL DEFAULT '',
 
`last_id_us` int(11) unsigned NOT NULL DEFAULT '0',
  `last_time` int(11)
unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`,`f_id`),
  KEY `pos`
(`pos`),
  KEY `f_id` (`f_id`),
  KEY `f_id_2` (`f_id`,`pos`),
  FULLTEXT
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT
EXISTS `forum_rdm` (
  `t_id` int(11) NOT NULL,
  `user_id` int(11) NOT
NULL,
  `time` int(11) NOT NULL,
  `page` int(20) NOT NULL DEFAULT '1',
 
`smotr` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`t_id`,`user_id`),
 
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

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

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

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

CREATE TABLE IF NOT
EXISTS `forum_sps` (
  `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` int(11) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT
'0',
  PRIMARY KEY (`id`),
  KEY `f_id` (`f_id`),
  KEY `r_id` (`r_id`),
 
KEY `t_id` (`t_id`),
  KEY `time` (`time`),
  KEY `user_id` (`user_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 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',
  `realid` int(11) NOT NULL DEFAULT '0',
  `sps`
int(11) NOT NULL DEFAULT '0',
  `del` int(11) NOT NULL DEFAULT '0',
 
`del_id` int(11) NOT NULL DEFAULT '0',
  `luch` int(11) NOT NULL DEFAULT
'0',
  `xud` int(11) NOT NULL DEFAULT '0',
  `posts` int(11) unsigned NOT
NULL DEFAULT '0',
  `last_id_us` int(11) unsigned NOT NULL DEFAULT '0',
 
`files` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY
`f_id` (`f_id`),
  KEY `del` (`del`),
  KEY `time` (`time`),
  KEY `close`
(`close`),
  KEY `r_id` (`r_id`),
  KEY `id` (`id`,`time`),
  KEY `zak`
(`zak`,`time`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `forum_vote` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type`
int(2) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
 
`t_id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `count` int(11)
NOT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`,`t_id`,`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `forum_vote_us` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`user_id` int(11) NOT NULL DEFAULT '0',
  `t_id` int(11) NOT NULL,
  `vote`
int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id`
(`user_id`,`t_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT
EXISTS `forum_who` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id`
int(20) NOT NULL DEFAULT '0',
  `time` int(20) NOT NULL DEFAULT '0',
 
`room` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT
'',
  `rm` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY
`user_id` (`user_id`),
  KEY `time` (`time`),
  KEY `room` (`room`,`rm`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 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 ;

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

--
--
Структура таблицы `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`),
  KEY `user_id` (`user_id`),
  KEY `fr_id` (`fr_id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`gazeta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idr` int(200) NOT
NULL DEFAULT '0',
  `user` int(200) NOT NULL DEFAULT '0',
  `name`
varchar(100) DEFAULT NULL,
  `text` blob NOT NULL,
  `time` varchar(100)
DEFAULT NULL,
  `tema` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`gazetar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100)
DEFAULT NULL,
  `pos` int(200) NOT NULL DEFAULT '0',
  `time` varchar(100)
DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `gazeta_rss` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `razd`
int(20) NOT NULL DEFAULT '0',
  `mail` varchar(100) DEFAULT NULL,
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`gbook` (
  `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`),
  KEY `user_id` (`user_id`),
  KEY `mgs_id`
(`mgs_id`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
PACK_KEYS=0 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`),
  KEY `time` (`time`),
  KEY `gid` (`gid`)
) 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`),
  KEY `gid` (`gid`)
) 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`),
  KEY `time` (`time`),
 
KEY `time_2` (`time`,`user_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`),
  KEY
`user_id_2` (`user_id`,`access`,`id`),
  KEY `level` (`level`,`gid`),
  KEY
`level_2` (`level`,`gid`,`time`),
  KEY `gid` (`gid`,`access`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`hits_ip` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `ip`
varchar(15) NOT NULL DEFAULT '',
  `ua` varchar(255) NOT NULL DEFAULT
'n/a',
  `time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY
(`ip`,`ua`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT
EXISTS `hits_time` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
 
`time` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
--
Структура таблицы `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`),
  KEY `user_id` (`user_id`),
  KEY `ig_id` (`ig_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',
  `img`
text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY
`mgs_id` (`mgs_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;

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

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

CREATE TABLE IF NOT EXISTS
`invite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT
NULL DEFAULT '0',
  `scode` char(8) NOT NULL,
  `inv_user` int(11) NOT NULL
DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `inv_user` (`inv_user`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `kik_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id`
int(11) NOT NULL,
  `ban_time` int(11) NOT NULL,
  `ban_while` int(11) NOT
NULL,
  `ban_type` tinyint(4) NOT NULL DEFAULT '1',
  `ban_who` varchar(30)
NOT NULL,
  `ban_ref` int(11) NOT NULL,
  `ban_reason` text NOT NULL,
 
`ban_raz` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id`
(`user_id`),
  KEY `ban_time` (`ban_time`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
--
Структура таблицы `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;

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

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

CREATE TABLE IF NOT EXISTS
`komments` (
  `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`),

 KEY `time` (`time`),
  KEY `time_2` (`time`,`user_id`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

--
--
Структура таблицы `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`),
  KEY
`user_id` (`user_id`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`lenta` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT
NULL DEFAULT '0',
  `news_id` int(11) NOT NULL DEFAULT '0',
  `news_razd`
varchar(30) DEFAULT NULL,
  `news_sort` varchar(30) DEFAULT NULL,
 
`news_col` int(20) NOT NULL DEFAULT '0',
  `news_time` int(20) NOT NULL
DEFAULT '0',
  `news_read` int(20) NOT NULL DEFAULT '0',
  `name` text NOT
NULL,
  `text` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id`
(`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`logini` (
  `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`),
  KEY `log` (`log`),
  KEY `time`
(`time`)
) 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`),
  KEY `log` (`log`),
  KEY `time` (`time`)
)
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`),
  KEY `id` (`id`)
) 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;

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

--
--
Структура таблицы `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;

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

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

CREATE TABLE IF NOT EXISTS
`messages` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id` int(12)
NOT NULL DEFAULT '0',
  `to_id` int(12) NOT NULL DEFAULT '0',
  `time`
int(11) NOT NULL DEFAULT '0',
  `dialog` int(20) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `mess_dialog` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id`
int(12) NOT NULL DEFAULT '0',
  `msg` blob NOT NULL,
  `to_id` int(12) NOT
NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `readin`
tinyint(1) NOT NULL DEFAULT '0',
  `spam` tinyint(1) NOT NULL DEFAULT '0',

 `kept` tinyint(1) NOT NULL DEFAULT '0',
  `fail` text NOT NULL,
  `fails`
text NOT NULL,
  `dialog` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY
(`id`),
  KEY `user_id` (`user_id`),
  KEY `to_id` (`to_id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`mess_in` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id` int(12)
NOT NULL DEFAULT '0',
  `msg` blob NOT NULL,
  `ot_id` int(12) NOT NULL
DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `readin` tinyint(1)
NOT NULL DEFAULT '0',
  `spam` tinyint(1) NOT NULL DEFAULT '0',
  `kept`
tinyint(1) NOT NULL DEFAULT '0',
  `fail` text NOT NULL,
  `fails` text NOT
NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `to_id`
(`ot_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `mess_kept` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id`
int(12) NOT NULL DEFAULT '0',
  `msg` blob NOT NULL,
  `ot_id` int(12) NOT
NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `readin`
tinyint(1) NOT NULL DEFAULT '0',
  `spam` tinyint(1) NOT NULL DEFAULT '0',

 `kept` tinyint(1) NOT NULL DEFAULT '0',
  `fail` text NOT NULL,
  `fails`
text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY
`to_id` (`ot_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT EXISTS
`mess_out` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id` int(12)
NOT NULL DEFAULT '0',
  `msg` blob NOT NULL,
  `to_id` int(12) NOT NULL
DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `readin` tinyint(1)
NOT NULL DEFAULT '0',
  `spam` tinyint(1) NOT NULL DEFAULT '0',
  `kept`
tinyint(1) NOT NULL DEFAULT '0',
  `fail` text NOT NULL,
  `fails` text NOT
NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `to_id`
(`to_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `models_data` (
  `ua` varchar(40) NOT NULL DEFAULT '',
  `vendor`
varchar(20) NOT NULL DEFAULT 'n/a',
  `model` varchar(20) NOT NULL DEFAULT
'n/a',
  `screensize` varchar(7) NOT NULL DEFAULT 'n/a',
  `bitsperpixel`
smallint(5) unsigned NOT NULL DEFAULT '0',
  `supportedbearers` varchar(50)
NOT NULL DEFAULT 'n/a',
  `javaplatform` varchar(50) NOT NULL DEFAULT
'n/a',
  `wapversion` varchar(30) NOT NULL DEFAULT 'n/a',
  `wmlversion`
varchar(30) NOT NULL DEFAULT 'n/a',
  `wmlscript` varchar(30) NOT NULL
DEFAULT 'n/a',
  `keyboard` varchar(40) NOT NULL DEFAULT 'n/a',
 
`numsoftkeys` varchar(5) NOT NULL DEFAULT 'n/a',
  `charset` varchar(50)
NOT NULL DEFAULT 'n/a',
  `emailschemes` varchar(30) NOT NULL DEFAULT
'n/a',
  `browserframes` varchar(10) NOT NULL DEFAULT 'n/a',
 
`browserjavaapplet` varchar(10) NOT NULL DEFAULT 'n/a',
  `html`
varchar(10) NOT NULL DEFAULT 'n/a',
  `xhtml` varchar(10) NOT NULL DEFAULT
'n/a',
  `browsertables` varchar(10) NOT NULL DEFAULT 'n/a',
  PRIMARY KEY
(`ua`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS
`months` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10)
unsigned NOT NULL DEFAULT '0',
  `date` int(10) unsigned NOT NULL DEFAULT
'0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `host` int(10)
unsigned NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL DEFAULT
'user',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
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,
  `theme` varchar(100) NOT NULL DEFAULT '',
  `razdel` int(11)
unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id`
(`user_id`),
  KEY `time` (`time`)
) 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`),

 KEY `new` (`new`),
  KEY `user_id` (`user_id`),
  KEY `time` (`time`)
)
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',
  `time` int(20) NOT NULL DEFAULT '0',
  `name` text NOT
NULL,
  `msg` text NOT NULL,
  `chit` int(20) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `time` (`time`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`oko` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` text NOT NULL,
 
`who` text NOT NULL,
  `what` text NOT NULL,
  `time` varchar(10) DEFAULT
NULL,
  PRIMARY KEY (`id`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

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

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

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

CREATE TABLE IF NOT
EXISTS `online_ip` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `ip`
varchar(15) NOT NULL DEFAULT '',
  `time` int(10) unsigned NOT NULL DEFAULT
'0',
  `browser` varchar(25) NOT NULL DEFAULT 'unknow',
  PRIMARY KEY
(`ip`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS
`payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `LMI_PAYMENT_AMOUNT`
int(11) NOT NULL DEFAULT '0',
  `LMI_SYS_INVS_NO` int(11) DEFAULT NULL,
 
`LMI_SYS_TRANS_NO` int(11) DEFAULT NULL,
  `LMI_SYS_TRANS_DATE` char(17)
DEFAULT NULL,
  `LMI_PAYER_PURSE` char(13) DEFAULT NULL,
  `LMI_PAYER_WM`
char(12) DEFAULT NULL,
  `RND` char(8) DEFAULT NULL,
  `item` int(11) NOT
NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `user_id`
int(12) NOT NULL DEFAULT '0',
  `yes` tinyint(1) NOT NULL DEFAULT '0',
 
`mod` char(17) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`podpiska` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11)
NOT NULL DEFAULT '0',
  `pod_id` int(11) NOT NULL DEFAULT '0',
  `pod_razd`
varchar(30) DEFAULT NULL,
  `name` text NOT NULL,
  PRIMARY KEY (`id`),
 
KEY `user_id` (`user_id`),
  KEY `pod_id`
(`pod_id`,`pod_razd`,`user_id`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `pom_users` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `pom_id`
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
;

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

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

CREATE TABLE IF NOT EXISTS
`pozor` (
  `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 ;

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

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

CREATE TABLE IF NOT EXISTS
`privat` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user` varchar(40)
CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `user_id`
int(12) NOT NULL DEFAULT '0',
  `msg` blob NOT NULL,
  `to_user`
varchar(40) CHARACTER SET utf8 COLLATE utf8_bin 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',
  `spam` tinyint(1) NOT
NULL DEFAULT '0',
  `kept` tinyint(1) NOT NULL DEFAULT '0',
  `fail` text
NOT NULL,
  `fails` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user`
(`user`),
  KEY `user_id` (`user_id`),
  KEY `to_id` (`to_id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `profession` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user`
int(11) NOT NULL DEFAULT '0',
  `who` int(11) NOT NULL DEFAULT '0',
 
`time` int(11) NOT NULL DEFAULT '0',
  `text` tinytext NOT NULL,
  `good`
tinyint(1) NOT NULL DEFAULT '0',
  `bad` tinyint(1) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `user_2` (`user`,`good`),

 KEY `user_3` (`user`,`bad`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`razdels` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT
NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`rekl` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `link` text NOT NULL,
 
`link_name` text NOT NULL,
  `bb` text NOT NULL,
  `color` text NOT NULL,
 
`ryad` int(11) NOT NULL DEFAULT '0',
  `time_on` int(11) NOT NULL DEFAULT
'0',
  `time_off` int(11) NOT NULL DEFAULT '0',
  `srok` int(11) NOT NULL
DEFAULT '0',
  `gde` int(20) NOT NULL DEFAULT '0',
  `v_n` int(20) NOT NULL
DEFAULT '0',
  `user_id` int(20) NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`report` (
  `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=cp1251
PACK_KEYS=0 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;

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

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

CREATE TABLE IF NOT
EXISTS `scripts_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path`
varchar(256) 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`),
  KEY `path` (`path`),
  KEY `pos` (`pos`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `scripts_files` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
 
`user_id` int(20) NOT NULL DEFAULT '0',
  `path` varchar(128) NOT NULL,
 
`infolder` varchar(128) 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,
  `who_yes` text NOT NULL,
  `who_no` text NOT NULL,
  `ips` text
NOT NULL,
  `yes` int(11) NOT NULL DEFAULT '0',
  `no` int(11) NOT NULL
DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `timeload` (`timeload`),
  KEY
`timeupload` (`timeupload`),
  KEY `user_id` (`user_id`),
  KEY `infolder`
(`infolder`),
  KEY `infolder_2` (`infolder`,`timeupload`),
  KEY `path`
(`path`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `scripts_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`),
  KEY `file` (`file`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

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

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

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

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

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

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

CREATE TABLE IF NOT
EXISTS `shop_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `refid`
int(11) NOT NULL,
  `refer` varchar(255) NOT NULL DEFAULT '',
  `tip`
varchar(255) NOT NULL DEFAULT '',
  `pos` int(11) NOT NULL,
  `adds`
int(11) NOT NULL DEFAULT '0',
  `user_id` varchar(255) NOT NULL DEFAULT
'',
  `name` text NOT NULL,
  `name_lat` varchar(100) DEFAULT NULL,
 
`about` text NOT NULL,
  `msg` text NOT NULL,
  `time` int(11) NOT NULL
DEFAULT '0',
  `chit` int(11) NOT NULL DEFAULT '0',
  `html` int(11) NOT
NULL DEFAULT '0',
  `vote` int(11) NOT NULL DEFAULT '0',
  `ips` text NOT
NULL,
  `yes` int(11) NOT NULL DEFAULT '0',
  `no` int(11) NOT NULL DEFAULT
'0',
  `path` text NOT NULL,
  `infolder` text NOT NULL,
  `priority`
tinyint(3) NOT NULL DEFAULT '0',
  `size` bigint(20) NOT NULL,
  `pass`
text NOT NULL,
  `price` int(11) NOT NULL DEFAULT '0',
  `fastabout` text
NOT NULL,
  `prodag` int(11) NOT NULL DEFAULT '0',
  `kopii` int(11) NOT
NULL DEFAULT '0',
  `timeload` int(11) unsigned NOT NULL,
  `timeupload`
int(11) NOT NULL,
  `del` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `shop_file_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
;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE IF NOT
EXISTS `shop_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',
  `time` int(20) NOT NULL DEFAULT
'1',
  `msg` blob NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id`
(`user_id`),
  KEY `vote_id` (`vote_id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`spam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mesto` varchar(255) NOT
NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `spam_id` int(11) NOT
NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT '0',
  `read` int(20)
NOT NULL DEFAULT '0',
  `komment` text NOT NULL,
  `msg` text NOT NULL,
 
`msg_t` text NOT NULL,
  `msg_id` int(11) NOT NULL DEFAULT '0',
 
`msg_razd_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY
`read` (`read`),
  KEY `msg_razd_id` (`msg_razd_id`),
  FULLTEXT KEY `msg`
(`msg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`spamer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT
NULL,
  `spam_m` varchar(30) NOT NULL,
  `post_time` int(11) NOT NULL,
 
`code` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`sps` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ot` int(11) NOT NULL,
 
`komu` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `comm` varchar(200)
DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `komu` (`komu`)
) ENGINE=MyISAM
DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `star_users` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `star_id`
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`),
  KEY `star_id` (`star_id`,`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 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`),
  KEY `user_id` (`user_id`),
  KEY `mgs_id`
(`mgs_id`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
PACK_KEYS=0 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `superadmin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
`login` varchar(20) NOT NULL DEFAULT '',
  `pass` varchar(50) NOT NULL
DEFAULT '',
  PRIMARY KEY (`id`,`login`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`tema` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tema` int(11) NOT NULL
DEFAULT '0',
  `time_on` int(11) NOT NULL DEFAULT '0',
  `time_off` int(11)
NOT NULL DEFAULT '0',
  `srok` int(11) NOT NULL DEFAULT '0',
  `user_id`
int(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`top_ip` (
  `id_operator` int(10) unsigned NOT NULL DEFAULT '0',
  `ip1`
int(10) unsigned NOT NULL DEFAULT '0',
  `ip2` int(10) unsigned NOT NULL
DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT
EXISTS `top_operators` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
 
`name` varchar(50) NOT NULL DEFAULT '',
  `label` varchar(25) NOT NULL
DEFAULT '',
  `tld` varchar(10) NOT NULL DEFAULT '',
  `country`
varchar(50) NOT NULL DEFAULT '',
  `publish` smallint(5) unsigned NOT NULL
DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF
NOT EXISTS `top_operators_stat` (
  `id` int(10) unsigned NOT NULL
AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `next_mon`
int(10) unsigned NOT NULL DEFAULT '0',
  `date` int(10) unsigned NOT NULL
DEFAULT '0',
  `day_week` smallint(5) unsigned NOT NULL DEFAULT '0',
 
`id_operator` int(10) unsigned NOT NULL DEFAULT '0',
  `count` int(10)
unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT
EXISTS `top_users` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
 
`site_name` varchar(50) NOT NULL DEFAULT '',
  `link` varchar(50) NOT NULL
DEFAULT '',
  `info` varchar(200) NOT NULL DEFAULT '',
  `razdel` int(2)
NOT NULL DEFAULT '1',
  `date` int(10) unsigned NOT NULL DEFAULT '0',
 
`type` int(1) unsigned NOT NULL DEFAULT '4',
  `typeStat` int(1) unsigned
NOT NULL DEFAULT '1',
  `regdate` int(11) unsigned DEFAULT '0',
  `status`
varchar(50) NOT NULL DEFAULT 'user',
  `user_id` int(11) unsigned DEFAULT
'0',
  `privatn` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`users` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user` varchar(50)
CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `pass`
varchar(500) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `name`
varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `sex`
int(1) NOT NULL DEFAULT '1',
  `city` varchar(50) CHARACTER SET utf8
COLLATE utf8_bin NOT NULL DEFAULT '',
  `country` varchar(50) CHARACTER SET
utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `mail` varchar(50) NOT NULL
DEFAULT '',
  `icq` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT
NULL,
  `skype` varchar(50) NOT NULL,
  `jabber` varchar(50) NOT NULL,
 
`day` int(2) NOT NULL DEFAULT '0',
  `month` int(2) NOT NULL DEFAULT '0',
 
`year` int(5) NOT NULL DEFAULT '0',
  `site` varchar(30) CHARACTER SET utf8
COLLATE utf8_bin DEFAULT NULL,
  `about` text NOT NULL,
  `xobbi` text NOT
NULL,
  `mobtel` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT
NULL,
  `umeniya` tinyint(1) NOT NULL DEFAULT '0',
  `umeniya2` varchar(50)
CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `hometel`
varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
 
`total_on_site` int(11) NOT NULL DEFAULT '0',
  `sestime` int(15) NOT NULL
DEFAULT '0',
  `url` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT
NULL DEFAULT '',
  `style` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin
NOT NULL DEFAULT 'shaxty',
  `xstatus` tinyint(1) NOT NULL DEFAULT '1',
 
`photo` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT
'',
  `vis` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
DEFAULT '',
  `vote_us` int(20) NOT NULL DEFAULT '0',
  `vote_photo`
int(200) 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) CHARACTER SET utf8 COLLATE
utf8_bin NOT NULL DEFAULT '',
  `onl` int(20) NOT NULL DEFAULT '0',
 
`posts` int(20) NOT NULL DEFAULT '0',
  `postsf` int(20) NOT NULL DEFAULT
'0',
  `postsk` int(20) NOT NULL DEFAULT '0',
  `postsg` int(20) NOT NULL
DEFAULT '0',
  `postsc` int(20) NOT NULL DEFAULT '0',
  `fo_files` int(20)
NOT NULL DEFAULT '0',
  `status` varchar(100) CHARACTER SET utf8 COLLATE
utf8_bin NOT NULL DEFAULT 'User',
  `date` varchar(50) CHARACTER SET utf8
COLLATE utf8_bin DEFAULT NULL,
  `timereg` varchar(50) CHARACTER SET utf8
COLLATE utf8_bin DEFAULT NULL,
  `max` int(2) NOT NULL DEFAULT '5',
 
`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)
CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `user_soft`
varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
 
`inv` tinyint(1) NOT NULL DEFAULT '0',
  `avtootvet` blob NOT NULL,
 
`dayp` int(11) NOT NULL DEFAULT '0',
  `myavatar` varchar(50) CHARACTER SET
utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `rur` int(20) NOT NULL DEFAULT
'0',
  `color_nik` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
DEFAULT '',
  `effnik` varchar(50) CHARACTER SET utf8 COLLATE utf8_bin NOT
NULL DEFAULT '',
  `odobr` int(2) NOT NULL DEFAULT '0',
  `odobr_who`
int(20) NOT NULL DEFAULT '0',
  `razd` tinyint(2) NOT NULL DEFAULT '1',
 
`upfp` tinyint(2) NOT NULL DEFAULT '0',
  `forma` tinyint(2) NOT NULL
DEFAULT '1',
  `redp` tinyint(2) NOT NULL DEFAULT '1',
  `formf` tinyint(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',
  `nahod` tinyint(1) NOT NULL
DEFAULT '0',
  `scripts_files` int(20) NOT NULL DEFAULT '0',
  `regday`
varchar(100) NOT NULL DEFAULT '',
  `rest_time` int(20) NOT NULL DEFAULT
'0',
  `rest_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT
NULL DEFAULT '',
  `gazeta` int(1) NOT NULL DEFAULT '0',
  `gazetas`
int(200) NOT NULL DEFAULT '0',
  `creditsingame` int(20) NOT NULL DEFAULT
'0',
  `mafcredits` int(20) NOT NULL DEFAULT '0',
  `forum_luch` int(11)
NOT NULL DEFAULT '0',
  `forum_xud` int(11) NOT NULL DEFAULT '0',
 
`forum_pr` int(11) unsigned NOT NULL DEFAULT '0',
  `forum_ava` int(11)
unsigned NOT NULL DEFAULT '0',
  `forum_pp` int(11) unsigned NOT NULL
DEFAULT '0',
  `users_bbpanel` int(11) unsigned NOT NULL DEFAULT '0',
 
`email_pass_yes` int(2) NOT NULL DEFAULT '0',
  `email_pass` varchar(30)
DEFAULT NULL,
  `email_session` varchar(100) DEFAULT NULL,
  `email_time`
varchar(50) DEFAULT NULL,
  `vopros_pass` varchar(30) DEFAULT NULL,
 
`otvet_pass` varchar(30) DEFAULT NULL,
  `mod_id` int(10) NOT NULL DEFAULT
'0',
  `moder_razd` varchar(30) DEFAULT NULL,
  `antispam` int(20) NOT
NULL,
  `colornick` text NOT NULL,
  `blogs` text NOT NULL,
  `adres`
varchar(250) NOT NULL DEFAULT '',
  `privatn` int(11) NOT NULL DEFAULT
'0',
  `sneg` varchar(32) NOT NULL,
  `forpage` varchar(30) NOT NULL,
 
PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `ruser` (`ruser`),
  KEY
`onl` (`onl`),
  KEY `regday` (`regday`),
  KEY `vis` (`vis`),
  KEY
`level` (`level`),
  KEY `moder_razd` (`moder_razd`,`mod_id`,`onl`),
  KEY
`odobr` (`odobr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT
EXISTS `user_agents` (
  `id_phone` int(11) NOT NULL AUTO_INCREMENT,
 
`vendor` varchar(64) NOT NULL DEFAULT '',
  `model` varchar(64) NOT NULL
DEFAULT '',
  `ua` varchar(255) NOT NULL DEFAULT '',
  `wap` tinyint(3)
unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_phone`),
  KEY `vendor`
(`vendor`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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


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

CREATE TABLE IF NOT EXISTS
`votes` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT
NULL DEFAULT '',
  `avtor` varchar(20) NOT NULL DEFAULT '',
  `date`
varchar(10) NOT NULL DEFAULT '',
  `vopros` varchar(200) DEFAULT NULL,
 
`v1` varchar(100) NOT NULL DEFAULT '',
  `v2` varchar(100) NOT NULL DEFAULT
'',
  `v3` varchar(100) NOT NULL DEFAULT '',
  `v4` varchar(100) NOT NULL
DEFAULT '',
  `v5` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 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',
  `time` int(20) NOT NULL DEFAULT '1',
 
`msg` blob NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
 
KEY `vote_id` (`vote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0
AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`voting` (
  `klu4` int(3) NOT NULL AUTO_INCREMENT,
  `vote` int(2) NOT
NULL DEFAULT '0',
  `date` varchar(10) NOT NULL DEFAULT '',
  `var`
smallint(1) NOT NULL DEFAULT '0',
  `who` int(5) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`klu4`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1
;

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

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

CREATE TABLE IF NOT EXISTS
`weeks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` int(10)
unsigned NOT NULL DEFAULT '0',
  `razdel` int(2) NOT NULL DEFAULT '1',
 
`next_mon` int(10) unsigned NOT NULL DEFAULT '0',
  `date` int(10) unsigned
NOT NULL DEFAULT '0',
  `day_week` smallint(5) unsigned NOT NULL DEFAULT
'0',
  `count` int(10) unsigned NOT NULL DEFAULT '0',
  `host` int(10)
unsigned NOT NULL DEFAULT '0',
  `in` int(10) unsigned NOT NULL DEFAULT
'0',
  `out` int(10) unsigned NOT NULL DEFAULT '0',
  `Siemens` int(10)
unsigned NOT NULL DEFAULT '0',
  `Nokia` int(10) unsigned NOT NULL DEFAULT
'0',
  `Samsung` int(10) unsigned NOT NULL DEFAULT '0',
  `Motorola`
int(10) unsigned NOT NULL DEFAULT '0',
  `LG` int(10) unsigned NOT NULL
DEFAULT '0',
  `Sagem` int(10) unsigned NOT NULL DEFAULT '0',
 
`SonyEricsson` int(10) unsigned NOT NULL DEFAULT '0',
  `Alcatel` int(10)
unsigned NOT NULL DEFAULT '0',
  `Sharp` int(10) unsigned NOT NULL DEFAULT
'0',
  `Pantech` int(10) unsigned NOT NULL DEFAULT '0',
  `Panasonic`
int(10) unsigned NOT NULL DEFAULT '0',
  `Other` int(10) unsigned NOT NULL
DEFAULT '0',
  `status` varchar(50) NOT NULL DEFAULT 'user',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
--
Структура таблицы `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;

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

INSERT INTO `wluha`
(`klu4`, `night_act`) VALUES
(1,
'W&#x43B;&#x44E;&#x445;&#x430;
&#x432;&#x44B;w&#x43B;&#x430; &#x438;&#x437;
&#x434;&#x43E;&#x43C;&#x430;,
&#x43A;&#x43E;&#x43C;&#x443;-&#x442;&#x43E;
&#x441;&#x435;&#x433;&#x43E;&#x434;&#x43D;&#x44F;
&#x43D;&#x435;
&#x443;&#x434;&#x430;&#x441;&#x442;&#x441;&#x44F;
&#x43F;&#x43E;&#x441;&#x43F;&#x430;&#x442;&#x44C;...'),
(2,
'&#x414;&#x435;&#x432;&#x43A;&#x430;,
&#x432;&#x438;&#x43B;&#x44F;&#x44F;
&#x431;&#x435;&#x434;&#x440;&#x430;&#x43C;&#x438;,
&#x445;&#x43E;&#x434;&#x438;&#x442;
&#x43D;&#x43E;&#x447;&#x44C;&#x44E;
&#x43F;&#x43E;
&#x433;&#x43E;&#x440;&#x43E;&#x434;&#x443;,
&#x43D;&#x435;
&#x43F;&#x440;&#x43E;&#x43F;&#x443;&#x441;&#x43A;&#x430;&#x44F;
&#x43D;&#x438;
&#x43E;&#x434;&#x43D;&#x43E;&#x433;&#x43E;
&#x43C;&#x443;&#x436;&#x447;&#x438;&#x43D;&#x44B;.'),
(3,
'&#x413;&#x43E;&#x440;&#x43E;&#x434;&#x441;&#x43A;&#x430;&#x44F;
w&#x43B;&#x44E;w&#x43A;&#x430; &#x432;
&#x43E;&#x442;&#x43A;&#x440;&#x43E;&#x432;&#x435;&#x43D;&#x43D;&#x43E;&#x43C;
&#x432;&#x438;&#x434;&#x435;
w&#x430;&#x441;&#x442;&#x430;&#x435;&#x442;
&#x43F;&#x43E;
&#x443;&#x43B;&#x438;&#x446;&#x430;&#x43C;,
&#x432;&#x44B;&#x431;&#x438;&#x440;&#x430;&#x44F;
&#x436;&#x435;&#x440;&#x442;&#x432;&#x443;...');

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

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

CREATE TABLE IF NOT EXISTS `wm`
(
  `id_us` int(11) NOT NULL DEFAULT '0',
  `wmid` varchar(13) NOT NULL
DEFAULT '0',
  `wmr` char(12) NOT NULL DEFAULT '0',
  `check` int(11) NOT
NULL DEFAULT '0',
  PRIMARY KEY (`id_us`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8 PACK_KEYS=0;

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

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

CREATE TABLE IF NOT EXISTS
`wmrout` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `user_id` int(12) NOT
NULL DEFAULT '0',
  `rur` int(12) NOT NULL DEFAULT '0',
  `time` int(11)
NOT NULL DEFAULT '0',
  `yes` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY
KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS
`wm_infa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `refid` int(11) NOT
NULL,
  `user_id` varchar(255) NOT NULL DEFAULT '',
  `name` text NOT
NULL,
  `about` text NOT NULL,
  `msg` text NOT NULL,
  `time` int(11) NOT
NULL DEFAULT '0',
  `chit` int(11) NOT NULL DEFAULT '0',
  `html`
tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `refid`
(`refid`),
  KEY `time` (`time`),
  KEY `chit` (`chit`),
  KEY `user_id`
(`user_id`),
  FULLTEXT KEY `msg` (`msg`),
  FULLTEXT KEY `name` (`name`),

 FULLTEXT KEY `about` (`about`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8
AUTO_INCREMENT=420 ;

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

CREATE TABLE IF NOT EXISTS `xstatus` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL DEFAULT '0',
  `stat`
int(11) NOT NULL DEFAULT '0',
  `name` text NOT NULL,
  `content` text NOT
NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `stat` (`stat`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 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 */;