User login history

login_histories.sql

CREATE TABLE `login_histories` (
`history_id` INT(10) NOT NULL AUTO_INCREMENT,
`user_id` INT(10) NOT NULL DEFAULT '0',
`loged_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`timezone_offset` TIME,
`ip_isp` VARCHAR(255) NOT NULL DEFAULT '',
`ip_address` VARCHAR(255) NOT NULL DEFAULT '',
`ip_country` VARCHAR(255) NOT NULL DEFAULT '',
`ip_city` VARCHAR(255) NOT NULL DEFAULT '',
`client_browser` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`track_id`)
);