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 |
persistent_login table relationships
Close relationships within degrees of separation
