Файл: TABLES.sql
Строк: 153
-- 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');