<?
$host = 'xxxxxx.h15.ru';
$login = 'xxxxxx';
$pass = 'xxxxxx';
$DBname = 'xxxxxx';
$mysql_connect=mysql_connect("$host","$login","$pass");
$Query="CREATE TABLE ip (id_ip int(32) NOT NULL auto_increment, ip tinytext NOT NULL, putdate datetime NOT NULL default '0000-00-00 00:00:00', id_page int(10) NOT NULL default '0', browsers enum('none','msie','opera','netscape') NOT NULL default 'none', systems enum('none','windows','unix','macintosh','robot_yandex','robot_google','robot_rambler','robot_aport') NOT NULL default 'none', searches enum('none','yandex','google','rambler','aport','own_site','mail','msn') NOT NULL default 'none', PRIMARY KEY (id_ip)) TYPE=MyISAM";
mysql_db_query ($DBname, $Query, $mysql_connect);
$Query="CREATE TABLE links (id_links int(8) NOT NULL auto_increment, name text, comment text, PRIMARY KEY (id_links)) TYPE=MyISAM";
mysql_db_query ($DBname, $Query, $mysql_connect);
$Query="CREATE TABLE pages (id_page int(10) NOT NULL auto_increment, name text, id_site int(4) default NULL, PRIMARY KEY (id_page)) TYPE=MyISAM";
mysql_db_query ($DBname, $Query, $mysql_connect);
$Query="CREATE TABLE refferer (id_refferer int(16) NOT NULL auto_increment, name tinytext NOT NULL, putdate datetime NOT NULL default '0000-00-00 00:00:00', ip tinytext NOT NULL, id_page int(8) NOT NULL default '0', searches enum('none','yandex','google','rambler','aport','own_site','mail','msn') NOT NULL default 'none', PRIMARY KEY (id_refferer), FULLTEXT KEY name (name)) TYPE=MyISAM";
mysql_db_query ($DBname, $Query, $mysql_connect);
?>
|