CREATE TABLE `" . PREFIX . "_online` (
`uid` int(10) unsigned NOT NULL default '0',
`session` char(32) NOT NULL,
`lastdate` int(10) unsigned NOT NULL default '0',
`location` varchar(255) NOT NULL,
`useragent` char(100) NOT NULL,
`ip` char(15) default NULL,
`proxy` char(15) default NULL,
PRIMARY KEY (`session`),
KEY `idx` (`uid`)
) TYPE=MyISAM /*!40101 DEFAULT CHARACTER SET {cp1251} COLLATE {cp1251_general_ci} */

ALTER TABLE `" . PREFIX . "_users`
ADD `country` VARCHAR( 50 ) NOT NULL AFTER `land` ,
ADD `city` VARCHAR( 50 ) NOT NULL AFTER `country`,
ADD `useragent` CHAR( 100 ) NOT NULL AFTER `hash`,
ADD `logged_proxy` CHAR( 15 ) NOT NULL AFTER `logged_ip`,
ADD `location` VARCHAR( 255 ) NOT NULL