View file chat/install.php

<?php
include_once '../sys/inc/start.php';
mysql_query("
CREATE TABLE IF NOT EXISTS `chat_who` (
  `id_user` int(11) NOT NULL,
  `room` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  KEY `id_user` (`id_user`,`room`,`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
");
mysql_query("
CREATE TABLE IF NOT EXISTS `chat_post` (
  `id` int(11) NOT NULL auto_increment,
  `room` int(11) NOT NULL,
  `id_user` int(11) default NULL,
  `time` int(11) NOT NULL,
  `msg` varchar(1024) default NULL,
  PRIMARY KEY  (`id`),
  KEY `room` (`room`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
");
mysql_query("
CREATE TABLE IF NOT EXISTS `chat_rooms` (
  `id` int(11) NOT NULL auto_increment,
  `pos` int(11) NOT NULL,
  `name` varchar(32) NOT NULL,
  `opis` varchar(256) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `pos` (`pos`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
");
echo 'Success!';
@unlink('install.php');
header('refresh: 1; url=/chat/');
?>