|
this article last updated: May 21, 2010 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 customer_group database table. This table contains a historical list of the IP addresses associated with customer accounts.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- name
The name of the customer group
varchar(255)
- active
The group's active status. Inactive groups are not applied in situations where they otherwise would be.
int(10) | unsigned | Values: 0/timestamp | Default: 1 | indexed
- description
The admin description of the customer group.
varchar(255)
- match_type
The type of match: any of the criteria, or all of the criteria. Valid values are 'any' and 'all'.
char(3) | Default: any
- only_active_cmrs
The group is active only for customers with customer.active > 0.
char(1) | Default: Y
|
