Просмотр файла table.sql

Свежие Креативы и море позитива !!!
Размер файла: 13.14Kb
-- 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`
--