This website uses cookies We use cookies on this website to provide services, features and to analyze our traffic. You consent to our cookies if you continue to use our website. 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 ...
Copyright © 2018 . All Rights Reserved