Description of FUDforum table fud30_ses. This table is used to track users that are logged in to the forum.
Fields
| 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(32) | YES | | | Browser user agent.
|
| data | text | YES | | | Store session data. See ses_putvar().
|
| returnto | varchar(255) | YES | | | User must be returned to a specific page.
|
Keys
| 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 |
|