Table email archive
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Stores all the emails that have been sent from the installation.
Table Details
Primary Key
Indexed Fields
Columns
archive_id 
- A unique, auto incremented value, to identify each email archive record.
Type: int(11) Null: No Default: Extra: auto_increment
email_to_name
- The name of the person the email was sent to.
Type: varchar(96) Null: No Default:
email_to_address 
- The email address the email was sent to.
Type: varchar(96) Null: No Default:
email_from_name
- The name the email was sent from.
Type: varchar(96) Null: No Default:
email_from_address
- The email address the email was sent from.
Type: varchar(96) Null: No Default:
email_subject
- The subject line of the email.
Type: varchar(255) Null: No Default:
email_html
- The body of the email message (used for HTML emails).
Type: text Null: No Default:
email_text
- The body of the email message (used for text emails).
Type: text Null: No Default:
date_sent
- The date and time the email was sent.
Type: datetime Null: No Default: 0001-01-01 00:00:00
module
- The module in the code from which the email was generated. Used in part to determine which email-template file to use (or was used) if an HTML message was produced.
Type: varchar(64) Null: No Default:
Default Entries
- None.
