Persistent Login Table Schema (persistent_login)


Persistent user logins

persistent_login table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 null perslogi_use2_fk R
cookie VARCHAR 128

Permanent cookie used for automatic login

timecreated BIGINT 19 null
timeautologin BIGINT 19 null

Time of the last auto login

useragent LONGTEXT 2147483647 null

Browser info detected during initial login

sid VARCHAR 128

Last session id

lastaccess BIGINT 19 null

Value is copied from the sessions table on timeout

lastip VARCHAR 45 null

Value is copied from the sessions table at login time and on timeout

Table contained -1 rows

persistent_login table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
perslogi_coo_uix Must be unique Asc cookie
perslogi_sid_uix Must be unique Asc sid
perslogi_use_ix Performance Asc userid

persistent_login table relationships