View file topca/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',
`category` int(10), 
PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;