sysban

sysban — Global. Stores 'sysban' data - the mechanism for banning users from portions of the site based on certain criteria.

sysban

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