|
this article last updated: June 30, 2009 Due to inevitable changes that will be made to the shopping cart software over time, the cart's variable and database structure may change from time to time without advanced notice. We will attempt to keep the information in this article up-to-date, but Modular Merchant makes no guarantee as to the accuracy of the information provided in this article. Use this information at your own risk.
This article outlines the database structure for the MMv4 ban_list database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- banned_value
The string the ban rule is checked against, e.g. the banned IP address, the banned email address, etc.
varchar(255) | indexed
- active
Ban's active status. An account with active banned status
int(10) | unsigned | Values: 0/timestamp | Default: 1 | indexed
- rule_type
The type of criteria that the ban rule is checked against, e.g. IP address, email address, etc.
varchar(255) | indexed
- description
Admin-only notes about the ban, normally used to record why the customer was banned.
varchar(255)
|
