persistent_login table columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
||||
userid | BIGINT | 19 | null |
|
|
|||||
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 |