-- phpMyAdmin SQL Dump
-- version 2.11.5
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Сен 03 2008 г., 01:40
-- Версия сервера: 4.1.21
-- Версия PHP: 4.4.8
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- База данных: `xdomen_tes`
--
-- --------------------------------------------------------
--
-- Структура таблицы `forum_ban`
--
CREATE TABLE `forum_ban` (
`id` int(11) NOT NULL default '0',
`ip` text collate utf8_unicode_ci NOT NULL,
`time` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Дамп данных таблицы `forum_ban`
--
-- --------------------------------------------------------
--
-- Структура таблицы `forum_cat`
--
CREATE TABLE `forum_cat` (
`id` int(11) NOT NULL auto_increment,
`name` text character set cp1251 NOT NULL,
`pos` int(11) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `forum_cat`
--
-- --------------------------------------------------------
--
-- Структура таблицы `forum_files`
--
CREATE TABLE `forum_files` (
`id` int(11) NOT NULL auto_increment,
`fname` text NOT NULL,
`coment` text character set utf8 collate utf8_unicode_ci NOT NULL,
`msg_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `forum_files`
--
-- --------------------------------------------------------
--
-- Структура таблицы `forum_msgs`
--
CREATE TABLE `forum_msgs` (
`id` int(11) NOT NULL auto_increment,
`topic` int(11) NOT NULL default '0',
`aut` int(11) NOT NULL default '0',
`msg` text NOT NULL,
`time` int(11) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `forum_msgs`
--
-- --------------------------------------------------------
--
-- Структура таблицы `forum_themes`
--
CREATE TABLE `forum_themes` (
`id` int(11) NOT NULL auto_increment,
`cat` int(11) NOT NULL default '0',
`name` text NOT NULL,
`author` int(11) NOT NULL default '0',
`closed` int(11) default '0',
`pit` int(11) NOT NULL default '0',
`time` int(11) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `forum_themes`
--
-- --------------------------------------------------------
--
-- Структура таблицы `game`
--
CREATE TABLE `game` (
`id` int(11) NOT NULL auto_increment,
`gamer` int(11) NOT NULL default '0',
`win` int(11) NOT NULL default '0',
`sum` int(11) NOT NULL default '0',
`time` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `game`
--
-- --------------------------------------------------------
--
-- Структура таблицы `letters`
--
CREATE TABLE `letters` (
`id` int(11) NOT NULL auto_increment,
`who` varchar(255) character set cp1251 NOT NULL default '',
`komu` varchar(255) character set cp1251 NOT NULL default '',
`msg` text character set cp1251 NOT NULL,
`data` varchar(255) character set cp1251 NOT NULL default '',
`read` int(1) NOT NULL default '0',
`inout` varchar(255) character set cp1251 NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `letters`
--
-- --------------------------------------------------------
--
-- Структура таблицы `news`
--
CREATE TABLE `news` (
`id` int(11) NOT NULL auto_increment,
`date` varchar(255) character set cp1251 NOT NULL default '',
`msg` text character set cp1251 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `news`
--
-- --------------------------------------------------------
--
-- Структура таблицы `opl_mob`
--
CREATE TABLE `opl_mob` (
`id` int(11) NOT NULL auto_increment,
`id_part` int(11) NOT NULL default '0',
`oper` text NOT NULL,
`nomer` bigint(20) default NULL,
`sum` int(11) NOT NULL default '0',
`opl` text NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `opl_mob`
--
-- --------------------------------------------------------
--
-- Структура таблицы `statistika`
--
CREATE TABLE `statistika` (
`idka` int(11) NOT NULL auto_increment,
`id` text NOT NULL,
`agent` text NOT NULL,
`date` varchar(255) NOT NULL default '',
`time` text NOT NULL,
`type` text NOT NULL,
`ip` text NOT NULL,
`referer` text NOT NULL,
`oper` varchar(255) NOT NULL default '',
PRIMARY KEY (`idka`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `statistika`
--
-- --------------------------------------------------------
--
-- Структура таблицы `stats`
--
CREATE TABLE `stats` (
`id` int(11) NOT NULL auto_increment,
`OP` int(11) NOT NULL default '0',
`ALL` int(11) NOT NULL default '0',
`data` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `stats`
--
-- --------------------------------------------------------
--
-- Структура таблицы `support`
--
CREATE TABLE `support` (
`id` int(11) NOT NULL auto_increment,
`idc` int(11) NOT NULL default '0',
`date` varchar(255) character set cp1251 NOT NULL default '',
`msg` text character set cp1251 NOT NULL,
`ans` text character set cp1251 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `support`
--
-- --------------------------------------------------------
--
-- Структура таблицы `traf`
--
CREATE TABLE `traf` (
`id` int(11) NOT NULL auto_increment,
`id_user` int(11) NOT NULL default '0',
`link` text character set utf8 collate utf8_unicode_ci,
`oper` text character set utf8 collate utf8_unicode_ci,
`num` int(11) NOT NULL default '0',
`vkl` int(11) default NULL,
`zayavka` int(11) NOT NULL default '0',
`time` int(11) NOT NULL default '0',
`email` text character set utf8 collate utf8_unicode_ci,
`keeper` text character set utf8 collate utf8_unicode_ci,
`icq` int(11) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `traf`
--
-- --------------------------------------------------------
--
-- Структура таблицы `uzvers`
--
CREATE TABLE `uzvers` (
`id` bigint(20) NOT NULL auto_increment,
`log` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`psss` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`wm` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`email` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`site` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`posts` int(11) NOT NULL default '0',
`status_` text collate utf8_unicode_ci NOT NULL,
`level` int(11) NOT NULL default '2',
`mod` int(11) NOT NULL default '0',
`ip1` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`ip2` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`ip3` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`ip4` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`ip5` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`icq` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`all` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`opl` varchar(255) collate utf8_unicode_ci NOT NULL default '0',
`partid` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`agent` text collate utf8_unicode_ci NOT NULL,
`dates` text collate utf8_unicode_ci NOT NULL,
`ips` text collate utf8_unicode_ci NOT NULL,
`mes` int(11) NOT NULL default '0',
`d1` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d2` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d3` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d4` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d5` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d6` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d7` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d8` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d9` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d10` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d11` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d12` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d13` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d14` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d15` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d16` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d17` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d18` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d19` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d20` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d21` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d22` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d23` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d24` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d25` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d26` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d27` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d28` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d29` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d30` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d31` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d32` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`col` float(50,0) NOT NULL default '0',
`d33` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d34` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d35` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d36` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d37` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d38` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d39` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d40` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d41` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d42` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d43` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d44` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d45` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d46` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d47` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d48` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d49` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d50` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d51` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d52` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d53` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d54` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d55` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d56` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d57` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d58` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d59` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d60` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d61` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d62` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d63` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d64` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`d65` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`data` varchar(11) collate utf8_unicode_ci NOT NULL default '',
`allmonth` float(50,3) NOT NULL default '0.000',
`status` text collate utf8_unicode_ci NOT NULL,
`help` int(11) NOT NULL default '0',
`ban` int(11) NOT NULL default '0',
`cena` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`prod` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`upd` int(11) NOT NULL default '0',
`onl` int(11) NOT NULL default '0',
`clos` int(11) NOT NULL default '0',
`act` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
--
-- Дамп данных таблицы `uzvers`
--