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

-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Янв 19 2010 г., 16:24
-- Версия сервера: 5.0.77
-- Версия PHP: 5.2.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

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

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

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

CREATE TABLE IF NOT EXISTS `ban` (
  `id` int(11) NOT NULL auto_increment,
  `ip` char(11) default NULL,
  `user` char(75) default NULL,
  `username` char(15) default NULL,
  `time` int(15) default NULL,
  `mess` varchar(600) default NULL,
  `moder` char(15) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `contact` (
  `id` mediumint(9) NOT NULL auto_increment,
  `uid` mediumint(9) NOT NULL,
  `contact_user` varchar(15) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `counter` (
  `id` int(15) NOT NULL auto_increment,
  `username` varchar(15) NOT NULL,
  `fid` int(11) NOT NULL,
  `time` int(15) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `forums` (
  `id` int(11) NOT NULL auto_increment,
  `name` text,
  `pos` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `ignore` (
  `id` mediumint(9) NOT NULL auto_increment,
  `uid` mediumint(9) NOT NULL,
  `ignore_user` varchar(15) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `mcounter` (
  `id` int(15) NOT NULL auto_increment,
  `username` varchar(15) NOT NULL,
  `fid` int(11) NOT NULL,
  `time` int(15) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `mforums` (
  `id` int(11) NOT NULL auto_increment,
  `name` text,
  `pos` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `mposts` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `post` text NOT NULL,
  `crc32` int(10) NOT NULL,
  `id_theme` int(11) NOT NULL,
  `time` int(15) NOT NULL,
  `useragent` text,
  `ip` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `mthemes` (
  `id` int(11) NOT NULL auto_increment,
  `tname` varchar(50) NOT NULL,
  `name` text,
  `close` text,
  `id_forum` int(11) NOT NULL,
  `time` int(15) NOT NULL,
  `pos` int(1) default '1',
  `del` int(1) default '0',
  `mdel` char(15) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `posts` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `post` text NOT NULL,
  `crc32` int(10) NOT NULL,
  `id_theme` int(11) NOT NULL,
  `time` int(15) NOT NULL,
  `useragent` text,
  `ip` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `private` (
  `id` int(11) NOT NULL auto_increment,
  `mess` text NOT NULL,
  `name` varchar(15) NOT NULL default '0',
  `mod` char(1) NOT NULL default '',
  `tname` varchar(15) NOT NULL default '0',
  `new` int(1) NOT NULL default '1',
  `time` int(14) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `rating` (
  `id` int(11) NOT NULL auto_increment,
  `moder` varchar(15) NOT NULL default '',
  `rat_user` varchar(15) NOT NULL default '',
  `descript` text NOT NULL,
  `time` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `session` (
  `sid` text NOT NULL,
  `nickname` text NOT NULL,
  `password` text NOT NULL,
  `time` int(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `stena` (
  `id` int(11) NOT NULL auto_increment,
  `mess` text NOT NULL,
  `stenid` text NOT NULL,
  `name` varchar(15) NOT NULL default '0',
  `time` int(14) NOT NULL default '0',
  `s` int(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `themes` (
  `id` int(11) NOT NULL auto_increment,
  `tname` varchar(50) NOT NULL,
  `name` text,
  `close` text,
  `id_forum` int(11) NOT NULL,
  `time` int(15) NOT NULL,
  `pos` int(1) default '1',
  `del` int(1) default '0',
  `mdel` char(15) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(15) NOT NULL,
  `password` varchar(15) NOT NULL,
  `regdate` int(15) default NULL,
  `status` varchar(10) default NULL,
  `last_time` int(22) default NULL,
  `realname` varchar(15) default NULL,
  `rdate` varchar(10) default NULL,
  `icq` int(15) default NULL,
  `site` varchar(20) default NULL,
  `mail` varchar(35) default NULL,
  `sex` varchar(1) default NULL,
  `about` varchar(1024) default NULL,
  `shrift` varchar(6) default NULL,
  `ps` int(11) NOT NULL,
  `style` varchar(15) default NULL,
  `transl` varchar(3) default NULL,
  `order` int(1) default NULL,
  `rating` int(15) default NULL,
  `antirating` int(15) unsigned NOT NULL default '0',
  `photo` varchar(50) NOT NULL,
  `upd` int(15) NOT NULL default '0',
  `private` varchar(7) default NULL,
  `pw` varchar(7) default NULL,
  `time_sess` int(11) NOT NULL,
  `sess` text NOT NULL,
  `ip` text NOT NULL,
  `ua` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

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

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

CREATE TABLE IF NOT EXISTS `wcab` (
  `id` int(11) NOT NULL auto_increment,
  `balans` float(100,2) NOT NULL default '0.00',
  `vsego` int(11) NOT NULL,
  `viplata` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `vdate` varchar(11) default NULL,
  `wmr` text,
  `telefon` text NOT NULL,
  `zakaz` int(11) NOT NULL,
  `kuda` text NOT NULL,
  `otvet` text NOT NULL,
  `status` int(1) NOT NULL,
  `operator` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=0 ;

INSERT INTO `users` (`id`, `username`, `password`, `regdate`, `status`, `last_time`, `realname`, `rdate`, `icq`, `site`, `mail`, `sex`, `about`, `shrift`, `ps`, `style`, `transl`, `order`, `rating`, `antirating`, `photo`, `upd`, `private`, `pw`, `time_sess`, `sess`, `ip`, `ua`) VALUES
(1, 'Admin', '1234', 0, 'admin', 1263821690, '', '--', 0, 'wmf.su', '@', 'm', 'WMF.SU', 'normal', 3000, '0', 'off', 0, 0, 0, 'wmf.su/smiles/6.gif', 1259179282, 'private', 'ce', 1261210229, '2dbte79s071c749b5f20be193336e3b2', '88.180.11.111', 'Mozilla');