-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Хост: localhost
-- Время создания: Дек 28 2005 г., 15:49
-- Версия сервера: 4.1.8
-- Версия PHP: 5.0.2
-- 
-- БД: `cms_db`
-- 
-- --------------------------------------------------------
-- 
-- Структура таблицы `articles`
-- 
CREATE TABLE `articles` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `author` varchar(40) NOT NULL default '',
  `title` varchar(60) NOT NULL default '',
  `short` mediumtext NOT NULL,
  `body` text NOT NULL,
  `from` varchar(100) NOT NULL default '',
  `from_url` varchar(100) NOT NULL default '',
  `vol` varchar(100) NOT NULL default '',
  `views` int(11) NOT NULL default '0',
  `real_views` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `search` (`body`,`short`,`title`,`author`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=16 ;
-- --------------------------------------------------------
-- 
-- Структура таблицы `gallery`
-- 
CREATE TABLE `gallery` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `file_name` varchar(50) NOT NULL default '',
  `name` varchar(50) NOT NULL default '',
  `description` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `views` int(11) NOT NULL default '0',
  `real_views` int(11) NOT NULL default '0',
  `vol` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `name` (`name`),
  FULLTEXT KEY `search` (`name`,`description`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=13 ;
-- --------------------------------------------------------
-- 
-- Структура таблицы `guestbook`
-- 
CREATE TABLE `guestbook` (
  `id` int(11) NOT NULL auto_increment,
  `author` varchar(40) NOT NULL default '',
  `author_id` int(11) NOT NULL default '0',
  `msg` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `is_admin` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=18 ;
-- --------------------------------------------------------
-- 
-- Структура таблицы `news`
-- 
CREATE TABLE `news` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` varchar(100) NOT NULL default '',
  `body` text NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `search` (`body`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=8 ;
-- --------------------------------------------------------
-- 
-- Структура таблицы `online`
-- 
CREATE TABLE `online` (
  `id` int(10) NOT NULL auto_increment,
  `ip` varchar(20) NOT NULL default '',
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=318 ;
-- --------------------------------------------------------
-- 
-- Структура таблицы `settings`
-- 
CREATE TABLE `settings` (
  `id` int(7) NOT NULL auto_increment,
  `default` enum('0','1') NOT NULL default '0',
  `admin_email` varchar(50) NOT NULL default '',
  `mess_per_page` int(100) NOT NULL default '0',
  `avatar_dir` varchar(100) NOT NULL default '',
  `right_exts` mediumtext NOT NULL,
  `admin_list` mediumtext NOT NULL,
  `moder_list` mediumtext NOT NULL,
  `stat_flag` enum('0','1') NOT NULL default '0',
  `small_foto_width` int(10) NOT NULL default '0',
  `copyright` varchar(200) NOT NULL default '',
  `default_copyright` varchar(200) NOT NULL default '',
  `news_number` smallint(6) NOT NULL default '0',
  `news_per_page` smallint(6) NOT NULL default '0',
  `searches_per_page` smallint(6) NOT NULL default '0',
  `from_name` varchar(100) NOT NULL default '',
  `unban_subj` varchar(200) NOT NULL default '',
  `unban_message` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
-- 
-- Структура таблицы `users`
-- 
CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `nick` varchar(50) NOT NULL default '',
  `posts` int(11) NOT NULL default '0',
  `respect` int(11) NOT NULL default '0',
  `under` text NOT NULL,
  `about` text NOT NULL,
  `hide_email` int(1) NOT NULL default '0',
  `ban` int(1) NOT NULL default '0',
  `ban_reason` mediumtext NOT NULL,
  `ban_to` datetime NOT NULL default '0000-00-00 00:00:00',
  `ban_ip` varchar(20) NOT NULL default '',
  `ban_by` varchar(100) NOT NULL default '',
  `name` varchar(50) default NULL,
  `surname` varchar(50) default NULL,
  `pass` varchar(100) default NULL,
  `email` varchar(30) default NULL,
  `avatar` varchar(30) default NULL,
  `occupation` varchar(50) default NULL,
  `location` varchar(50) default NULL,
  `interests` text,
  `url` varchar(100) default NULL,
  `icq` int(11) default NULL,
  `car` varchar(50) NOT NULL default '',
  `last_visit` datetime default NULL,
  `reg_date` datetime default NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `search` (`nick`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=15 ;