sessions

sessions — Clustered. Stores web sessions data. Optionally tied to IPs and with expiration times. Whenever a session is okayed, expired ones or ones created over 30 days ago are deleted. A live session can't change e-mail address or password. Digest authentication will be required for that, or JavaScript MD5 challenge-response.

sessions

Column name Type Null Default Description
userid int unsigned   0  
sessid mediumint unsigned   0  
auth char(10)    
exptype enum('short','long','once')   short Session expiration type, the length a specific session should be defined for. 'short' is 36 hours, 'long' is 60 days, 'once' defaults to same length as 'short'; just doesn't renew.
timecreate int unsigned   0  
timeexpire int unsigned   0  
ipfixed char(15) YES  
Key name Type Column(s)
PRIMARY PRIMARY