<?php
include '../inc/db.php';
?>
<!DOCTYPE html PUBLIC "-//WAPFORUM//DTD HTML Mobile 1.0//EN" "http://www.wapforum.org/DTD/xhtml-mobile10.dtd">
<html lang="ru">
<head>
<meta http-equiv="content-Type" content="text/html; charset=UTF-8">
<title>Установка</title>
<link rel="shortcut icon" href="/favicon.ico">
<link rel="stylesheet" href="/style.css" type="text/css">
</head>
<body>
<div class="title">Мастер установки</div>
<div class="msg">
<?php
mysql_query("CREATE TABLE IF NOT EXISTS `friends` (
`id` int(255) NOT NULL auto_increment,
`user1` int(255) NOT NULL,
`user2` int(255) NOT NULL,
`timesend` int(255) NOT NULL,
`timeok` int(255) NOT NULL,
`ok` int(1) NOT NULL default '0',
`who` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `ban` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`why` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `chat` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
`room` int(12) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `forum` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`open` int(1) NOT NULL DEFAULT '1',
`up` int(1) NOT NULL,
`razdel` int(255) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `forum_komm` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`theme` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `forum_t` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`opis` text COLLATE utf8_unicode_ci NOT NULL,
`razdel` int(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `guestbook` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` varchar(512) COLLATE utf8_unicode_ci DEFAULT '-',
`time` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `guests` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`tel` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
`click` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `jurnal` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`time` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`read` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `lenta` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`time` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`read` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `log` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`text` text CHARACTER SET utf8 NOT NULL,
`time` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `mail` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`from` int(255) NOT NULL,
`to` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
`read` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `mnen` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `news` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `news_komm` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`user` int(255) NOT NULL,
`msg` text CHARACTER SET utf8 NOT NULL,
`time` int(255) NOT NULL,
`nid` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `obmen` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`ras` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
`razdel` int(255) NOT NULL DEFAULT '0',
`type` text COLLATE utf8_unicode_ci NOT NULL,
`nameras` text COLLATE utf8_unicode_ci NOT NULL,
`ds` int(255) NOT NULL,
`visible` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `obmen_komm` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL,
`time` int(255) NOT NULL,
`file` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `obmen_t` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`opis` text COLLATE utf8_unicode_ci NOT NULL,
`razdel` int(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `rekl` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`href` text COLLATE utf8_unicode_ci NOT NULL,
`img` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
`where` int(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `room` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `user` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`name` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`pass` text COLLATE utf8_unicode_ci NOT NULL,
`reg` int(255) NOT NULL,
`gorod` text COLLATE utf8_unicode_ci NOT NULL,
`email` text COLLATE utf8_unicode_ci NOT NULL,
`tel` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
`tsel` text COLLATE utf8_unicode_ci NOT NULL,
`zhel` text COLLATE utf8_unicode_ci NOT NULL,
`aname` text COLLATE utf8_unicode_ci NOT NULL,
`click` int(255) NOT NULL,
`admin` int(1) NOT NULL DEFAULT '0',
`pol` int(1) NOT NULL DEFAULT '1',
`news` int(1) NOT NULL DEFAULT '0',
`vote` int(255) NOT NULL,
`famous` double NOT NULL,
`rplus` int(255) NOT NULL,
`online` int(255) NOT NULL,
`time_theme` int(255) NOT NULL,
`time_komm` int(255) NOT NULL,
`time_obmen` int(255) NOT NULL,
`time_obmen_komm` int(255) NOT NULL,
`gname` text COLLATE utf8_unicode_ci NOT NULL,
`moder` int(1) NOT NULL,
`osebe` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`ICQ` int(9) NOT NULL,
`avatar` int(255) NOT NULL,
`reg_bot` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Приветствуем новичка: [url=/ank.php?id={id}]{nick}\\[/url\\] :)',
`ball` int(255) NOT NULL DEFAULT '0',
`ksort` int(1) NOT NULL DEFAULT '0',
`reply` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '[b]Автоответчик:[/b] Здравствуй, {name}! Меня сейчас нет на месте, я отвечу тебе, как только зайду на сайт. Спасибо за внимание :)',
`reply_on` int(1) NOT NULL DEFAULT '0',
`hier` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
`style` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `user_vote` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`msg` text COLLATE utf8_unicode_ci NOT NULL,
`name` text COLLATE utf8_unicode_ci NOT NULL,
`user` int(255) NOT NULL DEFAULT '1',
`v1` text COLLATE utf8_unicode_ci NOT NULL,
`v2` text COLLATE utf8_unicode_ci NOT NULL,
`v3` text COLLATE utf8_unicode_ci NOT NULL,
`v4` text COLLATE utf8_unicode_ci NOT NULL,
`v5` text COLLATE utf8_unicode_ci NOT NULL,
`v6` text COLLATE utf8_unicode_ci NOT NULL,
`time` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `user_votes` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`vote` int(255) NOT NULL,
`num` int(6) NOT NULL DEFAULT '1',
`user` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
mysql_query("CREATE TABLE IF NOT EXISTS `visits` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`ip` varchar(128) NOT NULL,
`time` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci");
echo mysql_error().'Данные залиты! Выше не должно быть ошибки.<br><a href="step4.php">Далее</a>';
?>
</div>
<div class="title">Шаг 3</div>
</body>
</html>