sessions

0 rows


Description

Database based session storage - now recommended

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
state BIGINT 19 0

0 means normal session

sid VARCHAR 128

Session id

userid BIGINT 19 null
user.id sess_use2_fkR
sessdata LONGTEXT 2147483647 null

session content

timecreated BIGINT 19 null
timemodified BIGINT 19 null
firstip VARCHAR 45 null
lastip VARCHAR 45 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
sess_sid_uix Must be unique Asc sid
sess_sta_ix Performance Asc state
sess_tim2_ix Performance Asc timemodified
sess_tim_ix Performance Asc timecreated
sess_use_ix Performance Asc userid

Relationships