This website uses cookies. Accept Cookies Find out more

Table: visitor_session

KB66 Last reviewed 27 November 2013
A description of the visitor_session table within the Camino CMS database schema.

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

Indexes

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 ...