fud30_poll_opt_track
Description of FUDforum table fud30_poll_opt_track. This table tracks users who have voted to ensure that they can only vote once per poll.
| Column Name | Datatype | Can be Null? | Key? | Default | Description |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | - | auto_increment |
| poll_id | int(11) | NO | MUL | 0 | References fud30_poll.id. |
| user_id | int(11) | NO | - | 0 | References fud30_users.id. |
| ip_addr | varchar(46) | YES | - | - | IP Address of anonymous voter. Added in FUDforum 3.0.3. |
| poll_opt | int(11) | NO | - | 0 | References fud30_poll_opt.id. |
| Index Name | Uniqueness | Column Name | Seq in index | Comments |
|---|---|---|---|---|
| PRIMARY | UNIQUE | id | 1 | |
| fud30_poll_opt_track_i_pu | UNIQUE | poll_id | 1 | |
| fud30_poll_opt_track_i_pu | UNIQUE | user_id | 2 | |
| fud30_poll_opt_track_i_pu | UNIQUE | ip_addr | 3 |
