MWX/SpamFerret/tables/sessions

From Woozle Writes Code
< MWX‎ | SpamFerret‎ | tables
Revision as of 17:26, 5 August 2009 by Woozle (talk | contribs) (Created page with '==SQL== <mysql>CREATE TABLE `sessions` ( `ID` INT NOT NULL AUTO_INCREMENT, `Address` varchar(15) COMMENT "IP address", `Username` varchar(255) COMME…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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>