Table newsletters
From Zen Cart(tm) Wiki
Contents |
Database Version
- 1.3.5
Description
- Stores newsletters and information about them.
Table Details
Primary Key
Indexed Fields
- None.
Columns
newsletters_id 
- A unique, auto incremented value, to identify each newsletters record.
Type: int(11) Null: No Default: Extra: auto_increment
title
- The title of the newsletter.
Type: varchar(255) Null: No Default:
content
- The text-only content of the newsletter.
Type: text Null: No Default:
content_html
- The HTML content of the newsletter.
Type: text Null: No Default:
module
- The type of newsletter being sent. By default, valid options are newsletter and product_notification.
Type: varchar(255) Null: No Default:
date_added
- The date and time the newsletter was added.
Type: datetime Null: No Default: 0001-01-01 00:00:00
date_sent
- The date and time the newsletter was sent.
Type: datetime Null: Yes Default: NULL
status
- Indicates whether this newsletter has been sent or not. 0 = not sent, 1 = sent.
Type: int(1) Null: Yes Default: NULL
locked
- Is the newsletter locked or unlocked. Newsletter must be locked before being sent. Can be set to 0 (unlocked) or 1 (locked).
Type: int(1) Null: Yes Default: 0
Default Entries
- None.
