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

--
-- Структура таблицы `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;

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

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

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

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

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

CREATE TABLE IF NOT EXISTS `book` (
  `id` int(9) NOT NULL auto_increment,
  `time` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `text` text NOT NULL,
  `reply` text NOT NULL,
  `ip` bigint(11) NOT NULL,
  `ua` text 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,
  `place` int(9) 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,
  `reply` varchar(255) 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;

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

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

CREATE TABLE IF NOT EXISTS `online` (
  `id` int(10) NOT NULL auto_increment,
  `ip` varchar(20) NOT NULL,
  `unix` varchar(60) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

CREATE TABLE IF NOT EXISTS `modules` (
  `name` varchar(255) NOT NULL,
  `set` text NOT NULL,
  `data` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `modules`
--

INSERT INTO `modules` (`name`, `set`, `data`) VALUES
('faq', '1', ''),
('system', '', 'Общие настройки системы'),
('logon', '', 'Вход в админ-панель'),
('about', '1', ''),
('book', 'a:7:{s:6:"status";i:1;s:6:"bbcode";i:1;s:7:"smileys";i:1;s:7:"captcha";i:1;s:9:"antiflood";i:20;s:11:"lenght_name";i:50;s:11:"lenght_text";i:1000;}', 'гостевая книга'),
('news', 'a:6:{s:4:"view";i:1;s:4:"komm";i:1;s:6:"bbcode";i:1;s:7:"smileys";i:1;s:9:"prew_news";i:1;s:9:"antiflood";i:20;}', 'новости'),
('theme', 'light', 'дизайн сайта'),
('url_allow', 'com|net|org|info|biz|mobi|jux\\.su|spb\\.ru|msk\\.ru|com\\.ru|org\\.ru|net\\.ru|ru|su|in|us|bz|ws|wen\\.ru|wen\\.su|wen9\\.com|wen9\\.net|wen9\\.org|dum\\.su|fiz\\.su|hak\\.su|kan\\.su|koz\\.su|muk\\.su|nab\\.su|puz\\.su|tep\\.su|zat\\.su|wml\\.su|wml\\.in|wml\\.kz|wml\\.uz|wm\\.tj|wo\\.su|eh2\\.ru|yyoo\\.ru|wapi\\.tv|wapi\\.ws|xwml\\.in|xwml\\.net|xwml\\.org|xwml\\.biz|wap1\\.mobi|wap3\\.us|kmx\\.ru|hih\\.ru|lya\\.ru|wup\\.su|pp\\.ua|org\\.ua|net\\.ua|ua|com\\.ua|if\\.ua|uz\\.ua', 'Разрешенные доменный зоны'),
('captcha', 'a:4:{s:5:"width";i:120;s:6:"height";i:30;s:4:"type";i:0;s:4:"size";i:20;}', ''),
('anti_spam', 'a:5:{s:14:"security_level";i:1;s:10:"type_level";i:1;s:11:"status_book";i:1;s:11:"status_news";i:1;s:13:"status_review";i:1;}', 'Анти-спам');


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

CREATE TABLE IF NOT EXISTS `logs` (
  `id` int(9) NOT NULL auto_increment,
  `id_site` int(9) NOT NULL,
  `ip` bigint(11) NOT NULL,
  `ua` text NOT NULL,
  `time` int(11) NOT NULL,
  `data` varchar(255) NOT NULL,
  `type` int(1) NOT NULL,
  PRIMARY KEY  (`id`)
) 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` int(11) NOT NULL,
  `ip` bigint(11) NOT NULL,
  `browser` tinytext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;