Просмотр файла install/step3.php

Конкурс дизайнеров на 15000 рублей
Сервис интернет рекламы
Размер файла: 8.96Kb
<?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 `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 `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,
  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,
  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
");
echo mysql_error().'Данные залиты! Выше не должно быть ошибки.<br><a href="step4.php">Далее</a>';
?>
</div>
<div class="title">Шаг 3</div>
</body>
</html>