sysban — Global. Stores 'sysban' data - the mechanism for banning users from portions of the site based on certain criteria.
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| banid | mediumint unsigned auto_increment |
|
||
| status | enum('active','expired') |
active
|
||
| bandate | datetime | YES |
|
|
| banuntil | datetime | YES |
|
|
| what | varchar(20) |
|
Criterion being used to ban on: ip, emailnopay (site-specific example and means don't allow payments from that e-mail), email, etc. | |
| value | varchar(80) | YES |
|
|
| note | varchar(255) | YES |
|
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| status | INDEX |