MWX/SpamFerret/tables/sessions
< MWX | SpamFerret | tables
Jump to navigation
Jump to search
SQL
<mysql>CREATE TABLE `sessions` (
`ID` INT NOT NULL AUTO_INCREMENT, `Address` varchar(15) COMMENT "IP address", `Username` varchar(255) COMMENT "username", `Browser` varchar(255) NOT NULL COMMENT "browser client string", `ID_User` INT DEFAULT NULL COMMENT "MediaWiki user.user_id", `PageServer` varchar(63) NOT NULL COMMENT "identifier of site logged in to (usually domain)", `WhenStart` DATETIME NOT NULL COMMENT "when this session began (login)", `WhenFinish` DATETIME DEFAULT NULL COMMENT "when this session ended (logout, if any)", PRIMARY KEY(`ID`)
)</mysql>