fud30_ses
Description of FUDforum table fud30_ses. This table is used to track users that are logged in to the forum.
| Column Name | Datatype | Can be Null? | Key? | Default | Description |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | - | auto_increment |
| ses_id | varchar(32) | NO | UNI | 0 | FUDforum's session id. |
| sys_id | varchar(32) | NO | - | 0 | System id to prevent multi-host logins (if enabled). |
| user_id | int(11) | NO | UNI | 0 | References fud30_users.id. Sessions > 2000000000 is anonymous users. |
| action | text | YES | - | - | iSpy action. For example: Browsing the forum list, Reading the Help and Snooping on other people, just like you. |
| forum_id | int(11) | NO | - | 0 | References fud30_forum.id. |
| time_sec | bigint(20) | NO | MUL | 0 | Time session was created or updated. |
| ip_addr | varchar(46) | YES | - | - | IP Address. |
| useragent | varchar(64) | YES | - | - | Browser user agent (was varchar(32) prior to 3.0.5). |
| data | text | YES | - | - | Store session data. See ses_putvar(). |
| returnto | varchar(255) | YES | - | - | User must be returned to a specific page. |
| Index Name | Uniqueness | Column Name | Seq in index | Comments |
|---|---|---|---|---|
| PRIMARY | UNIQUE | id | 1 | |
| fud30_ses_i_s | UNIQUE | ses_id | 1 | |
| fud30_ses_i_u | UNIQUE | user_id | 1 | |
| fud30_ses_i_tu | NOT UNIQUE | time_sec | 1 | |
| fud30_ses_i_tu | NOT UNIQUE | user_id | 2 |
