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');