Table email archive

From Zen Cart(tm) Wiki
Revision as of 12:46, 8 September 2006 by Allcanadiansearch.ca (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Database Version

1.3.5


Description

Stores all the emails that have been sent from the installation.


Table Details

Primary Key

archive_id

Indexed Fields

email_to_address
module


Columns

archive_id Primary Key

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 Index

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 Index

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.