|
this article last updated: November 16, 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 em_template database table.
- id
Primary key of the em_template table.
int(10) | unsigned | auto increment | primary key| indexed
- active
Signifies if this email template is active or not.
int(10) | unsigned | indexed | 0/timestamp
- from_email
The email address in which the email template will be addressed from.
varchar(255) | indexed
- from_name
The name in which the email template will be addressed from.
varchar(255) | indexed
- subject
The subject that will be associated with all emails that use this email template.
varchar(255) | indexed
- text_msg
The text email message for this email template.
varchar(255) | indexed
- html_msg
The HTML rendered email message for this email template.
varchar(255) | indexed
- track_links
Specifies if html links will be tracked for this specific email template.
int(10) | unsigned | indexed | 0/timestamp
- track_reads
Specifies if the emails opened will be tracked for this specific email template.
int(10) | unsigned | indexed | 0/timestamp
- bcc_email
Email address that will be Blind Carbon Copied for this email template.
varchar(255) | indexed
|
