This website uses cookies. Accept Cookies Find out more

Table: visitor_session

Article Id:
21 Aug 2012, last updated 27 Nov 2013 16:01

Stores temporary visitor/user session data. This table should be cleared regularly to avoid unnecessary database bloat.

Field Type Null Key Default Description
session_id int(10) No Primary
session_webserversessionid varchar(255) Yes session_webserversessionid The Web server Session ID
user_id int(10) No 0 The ID of the user account to whom the session data belongs
session_ipaddress varchar(255) Yes The IPv4, or more typically, the IPv6 address of the client
session_data varchar(4000) Yes The encrypted session data
session_expirydate datetime No session_expirydate The MySQL timestamp after which the record is deemed to have been expired and may be deleted


Keyname Type Cardinality Field(s) Description
PRIMARY PRIMARY 0 session_id
session_webserversessionid Index session_webserversessionid Used to identity session
session_expirydate Index session_expirydate Used in expired session removal
 Loading ...
Copyright © 2011 - 2024 Calzada Media Limited. All Rights Reserved