https://www.icyphoenix.com/viewtopic.php?f=35&t=9016&p=58812#p58812
-----------------------------------
Joshua203
Sat 27 Apr, 2013 23:45

Re: Problem Update To 2.0 Version
-----------------------------------
Well since we are making a mess already ... try running this

[code linenumbers=false]DROP TABLE `ip_3sessions`; 
 
CREATE TABLE `ip_3sessions` ( 
    `session_id` VARCHAR(32) NOT NULL DEFAULT '', 
    `session_user_id` MEDIUMINT(8) NOT NULL DEFAULT '0', 
    `session_start` INT(11) NOT NULL DEFAULT '0', 
    `session_time` INT(11) NOT NULL DEFAULT '0', 
    `session_ip` VARCHAR(40) NOT NULL DEFAULT '0', 
    `session_browser` VARCHAR(255) DEFAULT '' NOT NULL, 
    `session_page` VARCHAR(255) NOT NULL DEFAULT '', 
    `session_logged_in` TINYINT(1) NOT NULL DEFAULT '0', 
    `session_forum_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL, 
    `session_topic_id` MEDIUMINT(8) UNSIGNED DEFAULT '0' NOT NULL, 
    `session_last_visit` INT(11) UNSIGNED DEFAULT '0' NOT NULL, 
    `session_forwarded_for` VARCHAR(255) DEFAULT '' NOT NULL, 
    `session_viewonline` TINYINT(1) UNSIGNED DEFAULT '1' NOT NULL, 
    `session_autologin` TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL, 
    `session_admin` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', 
    PRIMARY KEY (`session_id`), 
    KEY `session_user_id` (`session_user_id`), 
    KEY `session_fid` (`session_forum_id`) 
); 
 
DROP TABLE `ip_3sessions_keys`; 
 
CREATE TABLE `ip_3sessions_keys` ( 
    `key_id` VARCHAR(32) NOT NULL DEFAULT '0', 
    `user_id` MEDIUMINT(8) NOT NULL DEFAULT '0', 
    `last_ip` VARCHAR(40) NOT NULL DEFAULT '', 
    `last_login` INT(11) NOT NULL DEFAULT '0', 
    PRIMARY KEY (`key_id`,`user_id`), 
    KEY `last_login` (`last_login`) 
); 
 
## `ip_3sessions_keys`[/code]


