|
this article last updated: May 24, 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 event_info database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- active
Whether this event is active or not.
int(10) | unsigned | indexed
- is_public
Whether this event will be visible in the storefront or not.
int(10) | unsigned | indexed
- display_order
The number of the order this event will be displayed in the storefront.
int(10) | unsigned | indexed
- name
The descriptive name of the event.
varchar(255) | indexed
- start_date
The date in which this event will start.
int(10) | unsigned | indexed
- end_date
The date in which this event will end.
int(10) | unsigned | indexed
- coupon_code
A comma separated list of all the coupon codes this event is associated with.
varchar(255) | indexed
- match_type
The match type for this event's rules. Any or All.
varchar(3) | indexed| default: all
- redeem_limit
The number of times this event can be used or redeemed.
int(10) | unsigned | indexed
- reusable
Whether this event is reusable or not, used for coupon codes.
int(10) | unsigned | indexed
- retain_balance
Whether this event will retain the balance remaining, or not.
int(10) | unsigned | indexed
- description
The description for this event.
text
|
