View file visavi_top/TABLESSS.sql

CREATE TABLE `online` (
  `oid` int(255) NOT NULL auto_increment,
  `timestamp` int(11) default '0',
  `ip` varchar(40) NOT NULL default '',
  `brows` text NOT NULL,
  `id` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`oid`),
  KEY `ip` (`ip`),
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `unic` (
  `id` int(255) NOT NULL auto_increment,
  `ip` text NOT NULL,
  `browser` text NOT NULL,
  `sid` int(255) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `title` text NOT NULL,
  `pass` text NOT NULL,
  `email` text,
  `link` text NOT NULL,
  `about` text NOT NULL,
  `date` date NOT NULL default '0000-00-00',
  `today` int(11) NOT NULL default '0',
  `yesterday` int(11) NOT NULL default '0',
  `bef1yes` int(11) NOT NULL default '0',
  `bef2yes` int(11) NOT NULL default '0',
  `allday` int(11) NOT NULL default '0',
  `counthost` int(11) NOT NULL default '0',
  `1host` int(255) NOT NULL default '0',
  `2host` int(255) NOT NULL default '0',
  `3host` int(255) NOT NULL default '0',
  `ip1` text NOT NULL,
  `ip2` text NOT NULL,
  `ip3` text NOT NULL,
  `ip4` text NOT NULL,
  `cin` int(11) default '0',
  `out` int(11) default '0',
  `allin` int(11) default '0',
  `allout` int(11) default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
INSERT INTO `users` VALUES (1, 'Visavi.net', 'pass', '[email protected]', 'http://visavi.net', 'Все что нужно твоему сайту', '2006-26-05', 20, 2169, 3719, 3705, 0, 18, 1356, 2295, 2296, '217.10.38.52', '217.77.165.33', '195.239.153.251', '80.237.50.238','3','2','16','6');