this article last updated: January 19, 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 ptcs database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- display_order
The order in which the UpSell / DownSell chain will be displayed in the storefront.
int(10) | unsigned | indexed
- active
If this field contains a value greater than zero, then the UpSell/DownSell chain is active.
int(10) | unsigned | indexed
- name
This is the name of the UpSell/DownSell chain, this name is only visable to store admin; customers will never see this name.
varcahr(255) | indexed
- current_thread
The system ID (SID) of the current thread of rules to be used in the next order that trigger's this specific UpSell/DownSell chain.
int(10) | unsigned | indexed
|