-- phpMyAdmin SQL Dump
-- version 2.11.8-rc1
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Сен 07 2008 г., 15:47
-- Версия сервера: 5.0.51
-- Версия PHP: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- База данных: `erolove`
--
-- --------------------------------------------------------
--
-- Структура таблицы `zn_actmail`
--
CREATE TABLE IF NOT EXISTS `zn_actmail` (
`login` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`code` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `zn_anket`
--
CREATE TABLE IF NOT EXISTS `zn_anket` (
`id` int(10) NOT NULL auto_increment,
`login` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
`pass` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
`lastdate` datetime NOT NULL default '0000-00-00 00:00:00',
`online` smallint(1) NOT NULL default '0',
`room` int(5) default NULL,
`photo` int(11) NOT NULL default '0',
`defphoto` int(11) NOT NULL default '1',
`loadcode` varchar(8) NOT NULL,
`regdate` datetime NOT NULL default '0000-00-00 00:00:00',
`loginmask` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
`emailactive` smallint(1) NOT NULL default '0',
`mesmail` smallint(1) NOT NULL default '0',
`caponpage` int(10) default NULL,
`mesonpage` int(10) default NULL,
`autoupdate` varchar(10) character set utf8 collate utf8_bin default NULL,
`best` tinyint(1) NOT NULL default '0',
`bestdate` datetime default NULL,
`ip` varchar(20) character set utf8 collate utf8_bin default NULL,
`ua` varchar(100) character set utf8 collate utf8_bin default NULL,
`banned` tinyint(1) NOT NULL default '0',
`bandate` datetime default NULL,
`email` varchar(100) character set utf8 collate utf8_bin default NULL,
`icq` varchar(100) character set utf8 collate utf8_bin default NULL,
`sex` varchar(10) character set utf8 collate utf8_bin default NULL,
`so` char(1) character set utf8 collate utf8_bin default NULL,
`name` varchar(70) character set utf8 collate utf8_bin default NULL,
`vozrast` varchar(2) character set utf8 collate utf8_bin default NULL,
`rost` varchar(10) character set utf8 collate utf8_bin default NULL,
`zodiak` varchar(50) character set utf8 collate utf8_bin default NULL,
`glaza` varchar(50) character set utf8 collate utf8_bin default NULL,
`tel` varchar(30) character set utf8 collate utf8_bin default NULL,
`site` varchar(100) character set utf8 collate utf8_bin default NULL,
`task` varchar(255) character set utf8 collate utf8_bin default NULL,
`info` text character set utf8 collate utf8_bin,
`region` int(5) NOT NULL default '0',
`rating` int(11) NOT NULL default '0',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `zn_antirep`
--
CREATE TABLE IF NOT EXISTS `zn_antirep` (
`repcode` varchar(5) character set utf8 collate utf8_bin NOT NULL default '',
`lastdate` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `zn_ban`
--
CREATE TABLE IF NOT EXISTS `zn_ban` (
`ip` varchar(20) character set utf8 collate utf8_bin NOT NULL default '',
`ua` varchar(100) character set utf8 collate utf8_bin NOT NULL default '',
`bandate` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `zn_chat`
--
CREATE TABLE IF NOT EXISTS `zn_chat` (
`id` int(10) NOT NULL auto_increment,
`fromn` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
`body` text character set utf8 collate utf8_bin NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`r` int(5) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `zn_fototop`
--
CREATE TABLE IF NOT EXISTS `zn_fototop` (
`aid` int(10) NOT NULL,
`fid` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `zn_friends`
--
CREATE TABLE IF NOT EXISTS `zn_friends` (
`alogin` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL default '',
`flogin` varchar(50) character set utf8 collate utf8_unicode_ci NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `zn_ignor`
--
CREATE TABLE IF NOT EXISTS `zn_ignor` (
`alogin` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
`ignlogin` varchar(50) character set utf8 collate utf8_bin NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `zn_messages`
--
CREATE TABLE IF NOT EXISTS `zn_messages` (
`id` int(10) NOT NULL auto_increment,
`komu` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
`ot` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
`body` text character set utf8 collate utf8_bin,
`new` smallint(1) NOT NULL default '1',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `zn_news`
--
CREATE TABLE IF NOT EXISTS `zn_news` (
`id` int(10) NOT NULL auto_increment,
`date` datetime NOT NULL,
`text` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Структура таблицы `zn_rooms`
--
CREATE TABLE IF NOT EXISTS `zn_rooms` (
`id` int(5) NOT NULL auto_increment,
`title` varchar(50) character set utf8 collate utf8_bin NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;