|
this article last updated: June 18, 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 category database table.
- id
Primary Key of the table.
int(10) | unsigned | auto increment | primary key | indexed
- name
The name of the category.
varchar(255) | indexed
- create_date
The date in which this category was created.
int(10) | unsigned | Values: 0/timestamp | indexed
- display_order
The order in which the category is displayed within lists in relation to other categories.
int(10) | unsigned | indexed
- parent_cat
The System ID (SID) of the category's parent category. If the category has no parent, enter 0 in this field.
int(10) | unsigned | indexed
- active
If this field contains a value greater than zero, then the category is inactive. Only active categories are displayed in the storefront.
int(10) | Values: 0/timestamp | Default: 1 | indexed
- image
The URL of an image associated with the category.
varchar(255) | indexed
- href_target
Specifies whether the links to the category store page should open in the same browser window or a new one.
varchar(255) | indexed
- seo_url_text
Any URL entered in this field will be used in the URL of the category's storefront page. If empty, the system will attempt to use thecategory's name instead.
varchar(255) | indexed
- store_page
Contains the URL of a web page to be used instead of the default category page created by the shopping cart. If left blank, the default category page in the storefront will be used for the category.
varchar(255) | indexed
- template
The template to be applied to the default category page in the storefront created by the shopping cart software for this category.
varchar(255) | indexed
- description
A text/HTML description of the category. QuickCode Tags may be used to display the category's description in the storefront.
text
|
