View file install.sql

-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Окт 10 2010 г., 15:26
-- Версия сервера: 5.0.91
-- Версия PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

CREATE TABLE IF NOT EXISTS `ban_site` (
  `id` int(9) NOT NULL auto_increment,
  `url` varchar(255) character set utf8 NOT NULL,
  `why` varchar(255) character set utf8 NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `cat` (
  `id` int(9) NOT NULL auto_increment,
  `title` varchar(100) NOT NULL,
  `about` varchar(255) NOT NULL,
  `count` int(9) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `komm` (
  `id` int(9) NOT NULL auto_increment,
  `id_site` int(9) NOT NULL,
  `id_news` int(9) NOT NULL,
  `name` varchar(100) NOT NULL,
  `text` varchar(255) NOT NULL,
  `date` int(11) NOT NULL,
  `ip` bigint(11) NOT NULL,
  `browser` tinytext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `news` (
  `id` int(9) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `text` text NOT NULL,
  `date` int(11) NOT NULL,
  `count` int(9) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `set` (
  `reg` enum('open','mod','close') NOT NULL default 'mod',
  `url` varchar(100) NOT NULL,
  `admin` varchar(100) NOT NULL,
  `pass` varchar(100) NOT NULL,
  `on_page` varchar(100) NOT NULL default '5',
  `rate` enum('0','1') NOT NULL default '1',
  `review` enum('0','1') NOT NULL default '1',
  `search` enum('0','1') NOT NULL default '1',
  `news` enum('0','1') NOT NULL default '1' ,
  `captcha` enum('0','1') NOT NULL default '1'
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `set_news` (
  `view` enum('0','1') NOT NULL default '1',
  `komm` enum('0','1') NOT NULL default '1',
  `bbcode` enum('0','1') NOT NULL default '1',
  `smileys` enum('0','1') NOT NULL default '1',
  `antiflood` int(5) NOT NULL default '30'
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `sites` (
  `id` int(9) NOT NULL auto_increment,
  `id_cat` int(9) NOT NULL,
  `url` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `about` text NOT NULL,
  `type` enum('0','1') NOT NULL,
  `date` int(11) NOT NULL,
  `count` int(9) NOT NULL,
  `rate` varchar(255) NOT NULL default '0|0',
  `ip` BIGINT( 11 ) NOT NULL ,
  `browser` TINYTEXT NOT NULL ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

CREATE TABLE IF NOT EXISTS `ban_ip` (
  `id` int(9) NOT NULL auto_increment,
  `date` int(11) NOT NULL,
  `ip` bigint(11) NOT NULL,
  `reason` varchar(255) NOT NULL,
  `type` enum('1','2') NOT NULL,
  `url` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;