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_sid2_uix Must be unique Asc sid
sess_sta2_ix Performance Asc state
sess_tim3_ix Performance Asc timecreated
sess_tim4_ix Performance Asc timemodified
sess_use2_ix Performance Asc userid

Relationships