View file zagrcent/install.php

File size: 1.94Kb
<?php
include('db.php');
mysql_query("CREATE TABLE `send` (
`id` INT NOT NULL AUTO_INCREMENT ,
`mail` TEXT NOT NULL ,
`time` INT NOT NULL ,
`ip` INT NOT NULL ,
`user` TEXT NOT NULL ,
PRIMARY KEY ( `id` )
)") or die(mysql_error());
mysql_query("CREATE TABLE `file` (
  `id` int(11) NOT NULL auto_increment,
  `sd` text NOT NULL,
  `file` text NOT NULL,
  `rat` int(11) default '0',
  `date` int(11) NOT NULL default '0',
  `ldate` int(11) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1") or die(mysql_error());
mysql_query("CREATE TABLE `hits` (
  `id` int(11) NOT NULL auto_increment,
  `remote_addr` varchar(20) NOT NULL default '',
  `user_agent` varchar(100) NOT NULL default '',
  `date1` int(10) NOT NULL default '0',
  `date2` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1") or die(mysql_error());
mysql_query("CREATE TABLE `hosts` (
  `id` int(11) NOT NULL auto_increment,
  `remote_addr` varchar(20) NOT NULL default '',
  `user_agent` varchar(100) NOT NULL default '',
  `date1` int(10) NOT NULL default '0',
  `date2` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1") or die(mysql_error());
mysql_query("CREATE TABLE `online` (
  `id` int(11) NOT NULL auto_increment,
  `position` varchar(100) NOT NULL default '',
  `time` int(30) NOT NULL default '0',
  `user_agent` varchar(100) NOT NULL default '',
  `remote_addr` varchar(30) NOT NULL default '',
  `visit` int(30) NOT NULL default '0',
  `referer` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1") or die(mysql_error());
mysql_query("CREATE TABLE `online2` (
  `time` int(11) NOT NULL default '0',
  `ip` text NOT NULL,
  `user` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8") or die(mysql_error());

print 'Таблицы залиты';
?>